EKKO_PO_D

Transparent Table Application Table
45 Fields 3 CDS Views

Header - #GENERATED#

EKKO_PO_D is an SAP database table in S/4HANA. Header - #GENERATED#. It contains 45 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
E_PurchasingDocumentDraft view from EXTENSION Extesnion view for Purchasing Document Draft
P_PurOrdMaintainHeaderDraft view from CONSUMPTION
P_PurOrdMaintainHeaderDrfCalFs view from CONSUMPTION

Fields (45)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY db_key /BOBF/CONF_KEY NodeID
guid CHAR32 Character field, length 32
ebeln EBELN Purchasing Doc.
bsart BSART Order Type
bukrs BUKRS Company Code
ekorg EKORG Purchasing Org.
ekgrp BKGRP Purch. Group
eknam EKNAM Description
lifnr ELIFN Supplier
waers WAERS Currency
zterm DZTERM Pyt Terms
zbd1t DZBDET Payment in
zbd2t DZBDET Payment in
zbd3t DZBDET Payment in
zbd1p DZBD1P CD Percentage 1
zbd2p DZBD2P CD Percentage 2
wkurs WKURS Exchange Rate
inco1 INCO1 Incoterms
inco2 INCO2 Incoterms 2
incov INCOV Inco. Version
inco2_l INCO2_L Inco. Location1
inco3_l INCO3_L Inco. Location2
lifre LIFRE Invoicing Party
memory MEMER Incomplete
adrnr AD_ADDRNUM Address Number
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
bedat EBDAT Document Date
knumv KNUMV Doc. Condition
kalsm KALSM_D Procedure
crea_date_time TIMESTAMPL Time Stamp
crea_uname UNAME User Name
lchg_date_time TIMESTAMPL Time Stamp
lchg_uname UNAME User Name
original_etag CHAR32 Character field, length 32
dummy_ekko_incl_eew_ps EKKO_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.

-- Header - #GENERATED#
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EKKO_PO_D (
    MANDT,                   -- Client [MANDT]
    DB_KEY,                  -- NodeID [/BOBF/CONF_KEY]
    GUID,                    -- Character field, length 32 [CHAR32]
    EBELN,                   -- Purchasing Doc. [EBELN]
    BSART,                   -- Order Type [BSART]
    BUKRS,                   -- Company Code [BUKRS]
    EKORG,                   -- Purchasing Org. [EKORG]
    EKGRP,                   -- Purch. Group [BKGRP]
    EKNAM,                   -- Description [EKNAM]
    LIFNR,                   -- Supplier [ELIFN]
    WAERS,                   -- Currency [WAERS]
    ZTERM,                   -- Pyt Terms [DZTERM]
    ZBD1T,                   -- Payment in [DZBDET]
    ZBD2T,                   -- Payment in [DZBDET]
    ZBD3T,                   -- Payment in [DZBDET]
    ZBD1P,                   -- CD Percentage 1 [DZBD1P]
    ZBD2P,                   -- CD Percentage 2 [DZBD2P]
    WKURS,                   -- Exchange Rate [WKURS]
    INCO1,                   -- Incoterms [INCO1]
    INCO2,                   -- Incoterms 2 [INCO2]
    INCOV,                   -- Inco. Version [INCOV]
    INCO2_L,                 -- Inco. Location1 [INCO2_L]
    INCO3_L,                 -- Inco. Location2 [INCO3_L]
    LIFRE,                   -- Invoicing Party [LIFRE]
    MEMORY,                  -- Incomplete [MEMER]
    ADRNR,                   -- Address Number [AD_ADDRNUM]
    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]
    BEDAT,                   -- Document Date [EBDAT]
    KNUMV,                   -- Doc. Condition [KNUMV]
    KALSM,                   -- Procedure [KALSM_D]
    CREA_DATE_TIME,          -- Time Stamp [TIMESTAMPL]
    CREA_UNAME,              -- User Name [UNAME]
    LCHG_DATE_TIME,          -- Time Stamp [TIMESTAMPL]
    LCHG_UNAME,              -- User Name [UNAME]
    ORIGINAL_ETAG,           -- Character field, length 32 [CHAR32]
    DUMMY_EKKO_INCL_EEW_PS,  -- Ext. Include [EKKO_INCL_EEW]
    PRIMARY KEY (MANDT, DB_KEY)
);

Learn More