What is the difference between Ekko and Ekpo?

What is the difference between Ekko and Ekpo?

The purchasing documents are stored in tables EKKO (document header) and EKPO (document items), this means that information in table EKKO is valid for the total document (e.g. vendor, purchasing document type, purchasing document category) whereas table EKPO contains item specific information (e.g. quantity, material.

What is SAP ekko?

EKKO is a standard SAP Table which is used to store Purchasing Document Header data and is available within R/3 SAP systems depending on the version and release level. Below is the standard documentation available and a few details of the fields which make up this Table.

What is Bsart field in SAP?

BSART is a standard field within SAP Table ekko that stores Purchasing Doc. Type information. Identifier allowing differentiation between the various kinds of purchasing document in the SAP system.

What is Ebelp field in SAP?

EBELP is a standard field within SAP Table ekpo that stores Item information. Specifies the number that uniquely identifies an item in &BELEG&. Below is the list of attribute values for this field including its length, data type, description text, associated , search help etc…

What is Vgabe field in SAP?

VGABE is a standard field within SAP Table ekbe that stores Trans./event type information. Below is the list of attribute values for this field including its length, data type, description text, associated , search help etc…

What is SAP Ekorg?

EKORG is a standard field within SAP Table ekko that stores Purch. Organization information. Denotes the purchasing organization. Below is the list of attribute values for this field including its length, data type, description text, associated , search help etc…

What is the difference between Ekpo and Ekko?

EKPO contains multiple rows with the same values for EBELN. EKKO contains all distinct values for EBELN. I am trying to pick up all rows from both tables where EBELN in EKPO is the same as in EKKO. This is simple enough for a select statement to handle, without creating a view.

Can exnum be used to link Ekko eikp and Eipo?

I tried using EXNUM to link EKKO, EIKP and EIPO, but I’m not sure that EXNUM contains distinct values for all 3 tables. In the case of EIKP it doesn’t matter because the values for the fields I want (VORNU and VORNA) will be the same for the rows selected from EKKO and EKPO.

What is the difference between ekkn and Eket?

EKET– Scheduling Agreement Schedule Lines EKKN– Account Assignment in Purchasing Document EKBE– Purchasing Document History Accounting Documents Accounting forms a big part of the purchase process so there are a number of direct relationships between the PO tables and the accounting tables such as BKPF and BSEG. BKPF– Accounting Document Header

What does Ekko-ebeln and einkbeleg mean?

EKKO-EBELN = CDHDR-OBJECTID AND CDHDR-OBJECTCLAS = ‘EINKBELEG’. ekko-ebeln = nast-objky..