Create Hierarchy by Counter

[Anonymous]

Hier is my Data Source

Item	Item Key	I_IsAccount	Counter
P&L CONVOTIS Schema	0PLSTATE	FALSE	369
Profit/loss after tax	1000000002	FALSE	369
Profit from ordinary activities (POA)	1000000003	FALSE	365
Earnings after int. recharges before finan. result (EBIT)	1000000004	FALSE	328
EBITDA	1000000312	FALSE	283
Revenue incl. change in inventories and intercompany (ICO)	1000000319	FALSE	33
Revenue incl. intercompany (ICO)	1000000006	FALSE	27
Revenue service	1000000008	FALSE	9
400000	Net Sales Domestic	TRUE	1
400010	Revenue from recurring service business	TRUE	1
400020	Revenue from one-time service business	TRUE	1
400060	Revenue engineering	TRUE	1
400080	Revenue Hardware DE 19% - onlineshop	TRUE	1
410000	Revenue foreign countries	TRUE	1
420000	Revenue domestic - affiliated companies	TRUE	1
420150	Revenue from operating service provision ICO	TRUE	1
421000	Revenue foreign - affiliated companies	TRUE	1
Revenue hard and software	1000000021	FALSE	11
400030	Revenue merchandise - hardware	TRUE	1
400040	Revenue merchandise - software	TRUE	1
400050	Revenue merchandise - maintenance	TRUE	1
400070	Revenue VAT - Free (Hardware) §19	TRUE	1
400100	Reductions on Returns - Domestic	TRUE	1
410010	Revenue from intem. Deliveries - Hardware	TRUE	1
410020	Revenue from intern. Deliveries - Software Package	TRUE	1
410030	Revenue from intra-Group sales Services	TRUE	1
410040	Revenue export delivery	TRUE	1
410100	Reductions on Returns - Foreign	TRUE	1
420090	Sales Revenue - Domestic - Affiliated company group	TRUE	1
Revenue ICO direct costs (DC)	1000000313	FALSE	5
420100	Revenue from DC other expenses	TRUE	1
420120	Revenue from DC license expenses	TRUE	1
420130	Revenue from DC rent expenses	TRUE	1
420140	Revenue from DC vehicle fleet expenses	TRUE	1
420160	Revenue DC Leasing expenses	TRUE	1
Revenue ICO allocation level C1	1000000314	FALSE	1
420170	Revenue from allocation Consolidation level 1	TRUE	1
Revenue ICO allocation level C2	1000000315	FALSE	1
420180	Revenue from allocation Consolidation level 2	TRUE	1
Increase or decrease in inventories of finished goods and wo	1000000007	FALSE	6
441000	Revenue Adjustments	TRUE	1
450000	Changes in inventories of finished goods	TRUE	1
451000	Change in inventory	TRUE	1
452000	Change in inventory of services not yet billable	TRUE	1
458000	Capitalized Goods on Own Account	TRUE	1
492040	Revenue accruals	TRUE	1
Cost of materials	1000000020	FALSE	44
Cost of materials service	1000000018	FALSE	10
492080	Special savings material service	TRUE	1
570000	Expenses for other purchased manufacturing services	TRUE	1
570100	Expenses for other purchased manufacturing services	TRUE	1
570150	Expenses for other purchased services - Red Bull	TRUE	1
570200	Expenses for other purchased manufacturing services - f.Red	TRUE	1
590000	Expenses for operating services ICO - RO & SK	TRUE	1
751000	Expenses for Internal Services	TRUE	1
765080	Expenses from CONVOTIS own services	TRUE	1
765090	Expenses from CONVOTIS - other expenses	TRUE	1
765100	ICO services CONVOTIS group	TRUE	1
costs of materials hard and software	1000000034	FALSE	26
457099	Production - Adjustment Account for IS by Nature of Expense	TRUE	1
500000	Expenses for Finished Goods	TRUE	1
500010	Expenses for merchandise maintenance	TRUE	1
500020	Expenses for hardware	TRUE	1
500030	Expenses for software	TRUE	1
500050	Expenses for other merchandise goods	TRUE	1
510000	Expenses for Raw Materials	TRUE	1
520000	Expenses for Semi-Finished Goods	TRUE	1
520099	Material Consumption - Adjustment Account for IS by Nature o	TRUE	1
530000	Expenses for Supplies and Consumables	TRUE	1
550000	Acquisition of Tools and other Production Auxiliary Material	TRUE	1
560000	Consumption of combustibles and fuels	TRUE	1
582199	Price Differences Production - Adjustment Account for IS by	TRUE	1
582500	Other Differences	TRUE	1
582600	Gain or Loss from Physical Inventory	TRUE	1
582800	Expenses for Scrapping of Material	TRUE	1
582900	Gain or Loss from Revaluation of Material	TRUE	1
583000	Gain or Loss from Stock Transfer	TRUE	1
792000	Material Overhead	TRUE	1
792100	Labor Overhead	TRUE	1
792200	R&D Overhead	TRUE	1
792300	Sales Overhead	TRUE	1
792400	General Administration Overhead	TRUE	1
792599	Overhead - Adjustment Account for IS by Nature of Expense	TRUE	1
795000	Cost of Sales	TRUE	1
796000	Material Overhead - Cost of Sales	TRUE	1
ICO direct costs (DC)	1000000316	FALSE	5
590100	Cost of materials DC Vehicle fleet	TRUE	1
590200	Costs from DC rent expenses	TRUE	1
590300	Cost of materials DC License expenses	TRUE	1
590400	Cost of materials DC other expenses	TRUE	1
590500	Cost of materials DC Leasing expenses	TRUE	1
Costs ICO allocation level C1	1000000317	FALSE	2
765060	Expenses from allocation	TRUE	1
765070	Expenses from CONVOTIS allocation	TRUE	1
Costs ICO allocation level C2	1000000318	FALSE	1
590600	Cost of materials CONVOTIS allocation	TRUE	1

and i need this table:

Item	Hierarchy Level
P&L CONVOTIS Schema	1
Profit/loss after tax	2
Profit from ordinary activities (POA)	3
Earnings after int. recharges before finan. result (EBIT)	4
EBITDA	5
Revenue incl. change in inventories and intercompany (ICO)	6
Revenue incl. intercompany (ICO)	7
Revenue service	8
400000	9
400010	9
400020	9
400060	9
400080	9
410000	9
420000	9
420150	9
421000	9
Revenue hard and software	8
400030	9
400040	9
400050	9
400070	9
400100	9
410010	9
410020	9
410030	9
410040	9
410100	9
420090	9
Revenue ICO direct costs (DC)	8
420100	9
420120	9
420130	9
420140	9
420160	9
Revenue ICO allocation level C1	8
420170	9
Revenue ICO allocation level C2	8
420180	9
Increase or decrease in inventories of finished goods and work in progress	7
441000	8
450000	8
451000	8
452000	8
458000	8
492040	8
Cost of materials	6
Cost of materials service	7
492080	8
570000	8
570100	8
570150	8
570200	8
590000	8
765080	8
765090	8
765100	8
costs of materials hard and software	7
457099	8
500000	8
500010	8
500020	8
500030	8
500050	8
510000	8
520000	8
520099	8
530000	8
550000	8
560000	8
582199	8
582500	8
582600	8
582800	8
582900	8
583000	8
792000	8
792100	8
792200	8
792300	8
792400	8
792599	8
795000	8
796000	8
ICO direct costs (DC)	7
590100	8
590200	8
590300	8
590400	8
590500	8
Costs ICO allocation level C1	7
765060	8
765070	8
Costs ICO allocation level C2	7
590600	8

[lbendlin]

Can you please explain this part?

Why 7 and not 8 ?

[Anonymous]

because this is in same level as Revenue incl. intercompany (ICO)

thanx 🙂

 Updating Media

[Anonymous]

[lbendlin]

I don't see a way to infer this from your sample data. But since you already know the hierarchy - what is left to do?