Table & field for generating Landed Cost Zreport Imported Items

[Former Member]

Hi Experts,

We are in the process of creating Zreport based on PO for calculating Landed price of material especally imported

In import PO, we enter conditions like - Custom duty, Insurance, CVD, JECS, ZSAD but prices against them are only notional / tentative.

In our process, We do MIRO for custom duty & freight charges first & then GRN & MIRO for goods. Actual values for custom duty & other conditons are entered manually in the MIRO document on receipt of Bill of Entry.

Please guide me the tables & fields from where I will get data of actual amount that has been paid on the above conditions type along with material cost.

Suggestion / Solutions will be highly rewarded.

Regards,

( Rajneesh Gulati )

[Former Member]

Hi experts,

I did not get PO no, Material No in any of the tables suggested by you.

KONH - Conditions (Header)

- KONP - Conditions (Item)

- KONV - Conditions (Transaction Data)

BSEG

Please suggest some other tables.

Regards,

( Rajneesh Gulati )

[Former Member]

Hi ,

Once MIRO done u can see the values in BSEG table

[pankaj_singh9]

Hi,

Refer Tables;

- KONH - Conditions (Header)

- KONP - Conditions (Item)

- KONV - Conditions (Transaction Data)

[Former Member]

Dear,

Use structure KOMV field KSCHL for condition type value.

Also check below mention tables,

EBAN - Purchase requisition: items

EBKN - Purchase Requisition: account assignment

STXH - SAPScript Text Header

STXL - SAPScript Text Lines

EKKO - Purchasing document header

EKPO - Purchasing Document: Item

EKET - Purchasing Document: Delivery Schedules

MDBS - Material View of Order Item/Schedule Line (good to find open PO's)

EKKN - Account assignment in purchasing document

EORD - Purchasing Source List

EIPA - Order price history record

EKAB - Release documentation

EKBE - Purchasing document history

EKBZ - Purchasing document history: delivery costs

EKPB - "Material to be provided" item in purchasing document

ESKL - Account assignment specification for service line

ESKN - Account assignment in service package

ESLH - Service package header data

ESLL - Lines in service package

ESSR - Service entry sheet header data

ESUC - External services management: Unplanned limits for contract item

ESUH - External services management: unplanned service limits header data

ESUP - External services management: unplanned limits for service packages

ESUS - External services management: Unplanned limits for service types

EINA - Purchase Info Record: General

EINE - Purchasing info record: purchasing organization data

KONP - Condition Item

KONH - Condition Header

Regards,

Mahesh Wagh