EKPO_PO_D
Item - #GENERATED#
EKPO_PO_D is an SAP database table in S/4HANA. Item - #GENERATED#. It contains 86 fields. 2 CDS views read from this table.
CDS Views using this table (2)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| E_PurchasingDocumentItemDraft | view | from | EXTENSION | Extension view for Purchasing Document Item Draft |
| P_PurOrdMaintainItemDraft | view | from | CONSUMPTION |
Fields (86)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | MANDT | Client | |||
| KEY | db_key | /BOBF/CONF_KEY | NodeID | |||
| parent_key | /BOBF/CONF_KEY | NodeID | ||||
| guid | CHAR32 | Character field, length 32 | ||||
| parent_guid | CHAR32 | Character field, length 32 | ||||
| ebeln | EBELN | Purchasing Doc. | ||||
| ebelp | EBELP | Item | ||||
| txz01 | TXZ01 | Short Text | ||||
| matnr | MATNR | Material | ||||
| mtart | MTART | Material Type | ||||
| matkl | MATKL | Material Group | ||||
| idnlf | IDNLF | Supp. Mat. No. | ||||
| werks | EWERK | Plant | ||||
| meins | BSTME | Order Unit | ||||
| menge | BSTMG | PO Quantity | ||||
| netpr | BPREI | Net Price | ||||
| netwr | BWERT | Net Value | ||||
| mmpo_netprice_is_derived | MMPO_NETPRICE_IS_DERIVED | Netprice is derived | ||||
| peinh | EPEIN | Price Unit | ||||
| bprme | BBPRM | Order Price Un. | ||||
| mwskz | MWSKZ | Tax Code | ||||
| txjcd | TXJCD | Tax Jur. | ||||
| kalsm_taxcode | KALSM_D | Procedure | ||||
| kalsm_taxjur | TAX_KALSM | Schema | ||||
| kunnr | EKUNNR | Customer | ||||
| adrnr | AD_ADDRNUM | Address Number | ||||
| adrn2 | ADRN2 | Address | ||||
| ad_name1 | AD_NAME1 | Name | ||||
| ad_street | AD_STREET | Street | ||||
| ad_hsnm1 | AD_HSNM1 | House Number | ||||
| ad_pstcd1 | AD_PSTCD1 | Postal Code | ||||
| ad_city1 | AD_CITY1 | City | ||||
| ad_tlnmbr1 | AD_TLNMBR1 | Telephone | ||||
| ad_fxnmbr1 | AD_FXNMBR1 | Fax | ||||
| regio | REGIO | Region | ||||
| land1 | LAND1 | Country/Reg. | ||||
| langu | SPRAS | Language | ||||
| wepos | WEPOS | Goods Receipt | ||||
| weunb | WEUNB | GR Non-Valuated | ||||
| repos | REPOS | Invoice Receipt | ||||
| webre | WEBRE | GR-Based IV | ||||
| uebto | UEBTO | Overdeliv. Tol. | ||||
| uebtk | UEBTK | Unlimited | ||||
| untto | UNTTO | Underdel. Tol. | ||||
| infnr | INFNR | Info Record | ||||
| konnr | KONNR | Agreement | ||||
| ktpnr | KTPNR | Agreement Item | ||||
| freetextinput | CHAR40 | Char | ||||
| loekz | ELOEK | Del. Indicator | ||||
| effwr | EFFWR | Effective value | ||||
| pstyp | PSTYP | Item Category | ||||
| epstp | EPSTP | Item Category | ||||
| knttp | KNTTP | Acct Assgmt Cat | ||||
| kokrs | KOKRS | CO Area | ||||
| kostl | KOSTL | Cost Center | ||||
| prctr | PRCTR | Profit Center | ||||
| ps_psp_pnr | PS_PSP_PNR | WBS Element | ||||
| fkber | FKBER | Functional Area | ||||
| vbeln | VBELN_CO | SD Document | ||||
| vbelp | POSNR_CO | Item | ||||
| lgort | LGORT_D | Location | ||||
| sakto | SAKNR | G/L Account | ||||
| eindt | EINDT | Delivery Date | ||||
| mmpur_servproc_period_start | MMPUR_SERVPROC_PERIOD_START | Start Date | ||||
| mmpur_servproc_period_end | MMPUR_SERVPROC_PERIOD_END | End Date | ||||
| umrez | UMBSZ | Equal To | ||||
| umren | UMBSN | Denominator | ||||
| bpumz | BPUMZ | Qty Conversion | ||||
| bpumn | BPUMN | Qty Conversion | ||||
| inco1 | INCO1 | Incoterms | ||||
| inco2 | INCO2 | Incoterms 2 | ||||
| inco2_l | INCO2_L | Inco. Location1 | ||||
| inco3_l | INCO3_L | Inco. Location2 | ||||
| elikz | ELIKZ | Deliv. Compl. | ||||
| erekz | EREKZ | Final Invoice | ||||
| serviceperformer | SERVICEPERFORMER | Service Performer | ||||
| producttype | PRODUCT_TYPE | Product Type Group | ||||
| packno | PACKNO | Package number | ||||
| sumlimit | SUMLIMIT | Overall Limit | ||||
| sumnolim | NOLIMIT | No Limit | ||||
| commitment | COMMITMENT | Expected Value | ||||
| crea_date_time | TIMESTAMPL | Time Stamp | ||||
| crea_uname | UNAME | User Name | ||||
| lchg_date_time | TIMESTAMPL | Time Stamp | ||||
| lchg_uname | UNAME | User Name | ||||
| dummy_ekpo_incl_eew_ps | EKPO_INCL_EEW | Ext. Include |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- Item - #GENERATED#
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EKPO_PO_D (
MANDT, -- Client [MANDT]
DB_KEY, -- NodeID [/BOBF/CONF_KEY]
PARENT_KEY, -- NodeID [/BOBF/CONF_KEY]
GUID, -- Character field, length 32 [CHAR32]
PARENT_GUID, -- Character field, length 32 [CHAR32]
EBELN, -- Purchasing Doc. [EBELN]
EBELP, -- Item [EBELP]
TXZ01, -- Short Text [TXZ01]
MATNR, -- Material [MATNR]
MTART, -- Material Type [MTART]
MATKL, -- Material Group [MATKL]
IDNLF, -- Supp. Mat. No. [IDNLF]
WERKS, -- Plant [EWERK]
MEINS, -- Order Unit [BSTME]
MENGE, -- PO Quantity [BSTMG]
NETPR, -- Net Price [BPREI]
NETWR, -- Net Value [BWERT]
MMPO_NETPRICE_IS_DERIVED, -- Netprice is derived [MMPO_NETPRICE_IS_DERIVED]
PEINH, -- Price Unit [EPEIN]
BPRME, -- Order Price Un. [BBPRM]
MWSKZ, -- Tax Code [MWSKZ]
TXJCD, -- Tax Jur. [TXJCD]
KALSM_TAXCODE, -- Procedure [KALSM_D]
KALSM_TAXJUR, -- Schema [TAX_KALSM]
KUNNR, -- Customer [EKUNNR]
ADRNR, -- Address Number [AD_ADDRNUM]
ADRN2, -- Address [ADRN2]
AD_NAME1, -- Name [AD_NAME1]
AD_STREET, -- Street [AD_STREET]
AD_HSNM1, -- House Number [AD_HSNM1]
AD_PSTCD1, -- Postal Code [AD_PSTCD1]
AD_CITY1, -- City [AD_CITY1]
AD_TLNMBR1, -- Telephone [AD_TLNMBR1]
AD_FXNMBR1, -- Fax [AD_FXNMBR1]
REGIO, -- Region [REGIO]
LAND1, -- Country/Reg. [LAND1]
LANGU, -- Language [SPRAS]
WEPOS, -- Goods Receipt [WEPOS]
WEUNB, -- GR Non-Valuated [WEUNB]
REPOS, -- Invoice Receipt [REPOS]
WEBRE, -- GR-Based IV [WEBRE]
UEBTO, -- Overdeliv. Tol. [UEBTO]
UEBTK, -- Unlimited [UEBTK]
UNTTO, -- Underdel. Tol. [UNTTO]
INFNR, -- Info Record [INFNR]
KONNR, -- Agreement [KONNR]
KTPNR, -- Agreement Item [KTPNR]
FREETEXTINPUT, -- Char [CHAR40]
LOEKZ, -- Del. Indicator [ELOEK]
EFFWR, -- Effective value [EFFWR]
PSTYP, -- Item Category [PSTYP]
EPSTP, -- Item Category [EPSTP]
KNTTP, -- Acct Assgmt Cat [KNTTP]
KOKRS, -- CO Area [KOKRS]
KOSTL, -- Cost Center [KOSTL]
PRCTR, -- Profit Center [PRCTR]
PS_PSP_PNR, -- WBS Element [PS_PSP_PNR]
FKBER, -- Functional Area [FKBER]
VBELN, -- SD Document [VBELN_CO]
VBELP, -- Item [POSNR_CO]
LGORT, -- Location [LGORT_D]
SAKTO, -- G/L Account [SAKNR]
EINDT, -- Delivery Date [EINDT]
MMPUR_SERVPROC_PERIOD_START, -- Start Date [MMPUR_SERVPROC_PERIOD_START]
MMPUR_SERVPROC_PERIOD_END, -- End Date [MMPUR_SERVPROC_PERIOD_END]
UMREZ, -- Equal To [UMBSZ]
UMREN, -- Denominator [UMBSN]
BPUMZ, -- Qty Conversion [BPUMZ]
BPUMN, -- Qty Conversion [BPUMN]
INCO1, -- Incoterms [INCO1]
INCO2, -- Incoterms 2 [INCO2]
INCO2_L, -- Inco. Location1 [INCO2_L]
INCO3_L, -- Inco. Location2 [INCO3_L]
ELIKZ, -- Deliv. Compl. [ELIKZ]
EREKZ, -- Final Invoice [EREKZ]
SERVICEPERFORMER, -- Service Performer [SERVICEPERFORMER]
PRODUCTTYPE, -- Product Type Group [PRODUCT_TYPE]
PACKNO, -- Package number [PACKNO]
SUMLIMIT, -- Overall Limit [SUMLIMIT]
SUMNOLIM, -- No Limit [NOLIMIT]
COMMITMENT, -- Expected Value [COMMITMENT]
CREA_DATE_TIME, -- Time Stamp [TIMESTAMPL]
CREA_UNAME, -- User Name [UNAME]
LCHG_DATE_TIME, -- Time Stamp [TIMESTAMPL]
LCHG_UNAME, -- User Name [UNAME]
DUMMY_EKPO_INCL_EEW_PS, -- Ext. Include [EKPO_INCL_EEW]
PRIMARY KEY (MANDT, DB_KEY)
);Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA