FI TABLES FOR LAY-OUT

[Former Member]

hi GUYS

i am working on FI Lay-out, and want to print product hierarchy, Sales organisation and country for Document number. plz help me to find these fields.

selection screen is document no, company code, fiscal year.

thanks,

sum

[Former Member]

Product hierarchy is maintained for a MATERIAL.you can check MARA-PRDHA field

Sales organization is VKORG

COUNTRY is LAND1.

i am not getting which doucument no you are taling about.

Regards

srikanth.

[Former Member]

Hi,

check tables bkpf,bseg,bsis,bsak.

regards

amole

[Former Member]

Hi,

Kindly check the following links:

http://www.erpgenie.com/sap/abap/tables_fi.htm

http://www.erpgenie.com/sap/abap/tables_sd.htm

http://www.erpgenie.com/sap/abap/tables_mm.htm

http://www.erpgenie.com/sap/abap/tables.htm

Check

Billing header table:

VBRK

Fields: VBELN - sales doc number, VKORG - sales Org.

Billing item table:

VBRP

Fields: PRODH - Product Hierarchy

Hope this helps!

Best regards,

Thangesh

[Former Member]

Hi

You have to select those data from bill document (VBRK and VBRP tables:

By selection-screen select BKPF records

• Header data: VBRK

VBRK-VBELN = BKPF-AWKEY

*----

---

> Sales org. VBRK-VKORG

• Item data: VBRP

VBRP-VBELN = VBRK-VBELN

*----

---

> Product hierarchy, VBRP-PRODH

• Country: I suppose is customer country so KNA1-LAND1

Max

[Former Member]

My documents no is bseg-belnr.

so for that i want to fatch all other fields

like sales organisation, product hierarchy, land.

i know the fields but not getting link to fetch these all fields for bseg-belnr.

Thanks

[andreas_mann3]

Hi,

land you get from :

a) vendor: select lfa1 with bseg-lifnr

b) customer select kna1 with bseg-kunnr.

A.

[Former Member]

Can you please tell,

1- How can we link BKPF and VBRK.

2- I WANT THAT PRODUCT HIERARCHY AT ITEM LABLE.