EKKN

Transparent Table Application Table
58 Fields 18 CDS Views

Account Assignment in Purchasing Document

EKKN is an SAP database table in S/4HANA. Account Assignment in Purchasing Document. It contains 58 fields. 18 CDS views read from this table.

CDS Views using this table (18)

ViewTypeJoinVDMDescription
Atpc_Cds_Ekkn view from CDS View on EKKN Table for ATP
Atpc_Cds_Sto_10 view left_outer Helper CDS view for STOs in ATP BOP
e_mrp_purchase_docs view left_outer Fiori MRP App Purchase Documents CDS View
FAC_PURCHASE_ORDER view left_outer Purchase Order
Fclm_Mm_Ekkn view from Account Assignment
FINOC_MOCK_RT_POI_FILL view inner Orgl Change: Mock for FINOC_RT_POI_FILL
FINOC_RT_POI_ACC_ASGNMNT view from Orgl Change: Acc. Assg. PurchasingDocItm
I_ChgImpactPurDocAcctAssign view from BASIC Purchase Order acccount assignment details
I_PurDocAcctAssinment view from BASIC Purchasing Document Account Assignment
I_PurgDocAccountAssignmentBsc view_entity from BASIC Purchasing Document Account Assignment
I_SupDmndAllDocConfBsc view left_outer BASIC Basic View for Supplier Confirmations
I_SupDmndAllDocPOBsc view left_outer BASIC Basic View for Purchase Order
I_WhereUsdCostCtrPOAccrualObj view from BASIC Where Used Cost Centers - PO Accrual Obj
M_V_Outline_Agreement_Sos_B view left_outer MM-PUR: Basic CDS View for SOS
P_MaintOrderPurOrdLink view_entity from BASIC Maintenance Order and Purchase Order Link
pph_e_Ekkn view from read EKKN
PurgAccAssignment view from Proxy for Purchasig Account Assignment
V_WB2_EKKO_EKPO_2 view inner Business Volume Purchase Orders - EKKN

Fields (58)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY ebeln ebeln Purchasing Doc.
KEY ebelp ebelp Item
KEY zekkn dzekkn Account Assgmt No.
loekz kloek Deletion Ind.
aedat erdat Created On
kflag eflag Change flag: Purchasing (currently not used)
menge menge_d Quantity
vproz vproz Distribution
netwr bwert Net Value
sakto saknr G/L Account
gsber gsber Business Area
kostl kostl Cost Center
projn projn not in use
vbeln vbeln_co SD Document
vbelp posnr_co Item
veten etenr Schedule Line
kzbrb kzbrb Gross reqmts
anln1 anln1 Asset
anln2 anln2 Sub-number
aufnr aufnr Order
wempf wempf Recipient
ablad ablad Unloading Point
kokrs kokrs CO Area
xbkst xbkst Posting to cost cent
xbauf xbauf To order
xbpro xbpro To project
erekz erekz Final Invoice
kstrg kstrg Cost Object
paobjnr rkeobjnr Profit. segment
prctr prctr Profit Center
ps_psp_pnr ps_psp_pnr WBS Element
nplnr nplnr Network
aufpl co_aufpl Plan No.f.Oper.
imkey imkey Real Estate Key
aplzl cim_count Counter
vptnr jv_part Partner
fipos fipos Commitment item
recid jv_recind Recovery Ind.
service_doc_type fco_srvdoc_type Service Doc. Type
service_doc_id fco_srvdoc_id Service Document
service_doc_item_id fco_srvdoc_item_id Service Doc. Item
fistl fistl Funds Center
geber bp_geber Fund
fkber fkber Functional Area
dabrz dabrbez Reference date
aufpl_ord co_aufpl Plan No.f.Oper.
aplzl_ord co_aplzl Counter
mwskz mwskz Tax Code
txjcd txjcd Tax Jur.
navnw navnw Non-deductible
lstar lstar Activity Type
prznr co_prznr Business Process
grant_nbr gm_grant_nbr Grant
budget_pd fm_budget_period Budget Period
menge_f menge_f Qty (FP Number)
fmfgus_key fmfg_us_key US Govt
_dataaging data_temperature Data Aging

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.

-- Account Assignment in Purchasing Document
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EKKN (
    MANDT,                -- Client [mandt]
    EBELN,                -- Purchasing Doc. [ebeln]
    EBELP,                -- Item [ebelp]
    ZEKKN,                -- Account Assgmt No. [dzekkn]
    LOEKZ,                -- Deletion Ind. [kloek]
    AEDAT,                -- Created On [erdat]
    KFLAG,                -- Change flag: Purchasing (currently not used) [eflag]
    MENGE,                -- Quantity [menge_d]
    VPROZ,                -- Distribution [vproz]
    NETWR,                -- Net Value [bwert]
    SAKTO,                -- G/L Account [saknr]
    GSBER,                -- Business Area [gsber]
    KOSTL,                -- Cost Center [kostl]
    PROJN,                -- not in use [projn]
    VBELN,                -- SD Document [vbeln_co]
    VBELP,                -- Item [posnr_co]
    VETEN,                -- Schedule Line [etenr]
    KZBRB,                -- Gross reqmts [kzbrb]
    ANLN1,                -- Asset [anln1]
    ANLN2,                -- Sub-number [anln2]
    AUFNR,                -- Order [aufnr]
    WEMPF,                -- Recipient [wempf]
    ABLAD,                -- Unloading Point [ablad]
    KOKRS,                -- CO Area [kokrs]
    XBKST,                -- Posting to cost cent [xbkst]
    XBAUF,                -- To order [xbauf]
    XBPRO,                -- To project [xbpro]
    EREKZ,                -- Final Invoice [erekz]
    KSTRG,                -- Cost Object [kstrg]
    PAOBJNR,              -- Profit. segment [rkeobjnr]
    PRCTR,                -- Profit Center [prctr]
    PS_PSP_PNR,           -- WBS Element [ps_psp_pnr]
    NPLNR,                -- Network [nplnr]
    AUFPL,                -- Plan No.f.Oper. [co_aufpl]
    IMKEY,                -- Real Estate Key [imkey]
    APLZL,                -- Counter [cim_count]
    VPTNR,                -- Partner [jv_part]
    FIPOS,                -- Commitment item [fipos]
    RECID,                -- Recovery Ind. [jv_recind]
    SERVICE_DOC_TYPE,     -- Service Doc. Type [fco_srvdoc_type]
    SERVICE_DOC_ID,       -- Service Document [fco_srvdoc_id]
    SERVICE_DOC_ITEM_ID,  -- Service Doc. Item [fco_srvdoc_item_id]
    FISTL,                -- Funds Center [fistl]
    GEBER,                -- Fund [bp_geber]
    FKBER,                -- Functional Area [fkber]
    DABRZ,                -- Reference date [dabrbez]
    AUFPL_ORD,            -- Plan No.f.Oper. [co_aufpl]
    APLZL_ORD,            -- Counter [co_aplzl]
    MWSKZ,                -- Tax Code [mwskz]
    TXJCD,                -- Tax Jur. [txjcd]
    NAVNW,                -- Non-deductible [navnw]
    LSTAR,                -- Activity Type [lstar]
    PRZNR,                -- Business Process [co_prznr]
    GRANT_NBR,            -- Grant [gm_grant_nbr]
    BUDGET_PD,            -- Budget Period [fm_budget_period]
    MENGE_F,              -- Qty (FP Number) [menge_f]
    FMFGUS_KEY,           -- US Govt [fmfg_us_key]
    _DATAAGING,           -- Data Aging [data_temperature]
    PRIMARY KEY (MANDT, EBELN, EBELP, ZEKKN)
);

Learn More