MMPUR_EXT_EKKN

Transparent Table Application Table
75 Fields 1 CDS Views

Account Assignment in Purchasing Document

MMPUR_EXT_EKKN is an SAP database table in S/4HANA. Account Assignment in Purchasing Document. It contains 75 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_CntrlPurOrderAcctAssgmt view from BASIC Purchase Order Acc Assignment

Fields (75)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY extsourcesystem MMPUR_D_SOURCE_SYS Connected System ID
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 MMPUR_WBS_ELEMENT_ID 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.
dummy_incl_eew_cobl CFD_DUMMY Dummy
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
kblnr KBLNR Earmarked Funds
kblpos KBLPOS Document Item
lstar LSTAR Activity Type
prznr CO_PRZNR Business Process
grant_nbr GM_GRANT_NBR Grant
budget_pd FM_BUDGET_PERIOD Budget Period
fm_split_batch FMSP_SPLIT_BATCH Dist.Batch No.
fm_split_begru FMSP_SPLIT_AUTG Auth.Group
aa_final_ind AA_FINAL_IND Final AA
aa_final_reason AA_FINAL_REASON Final AA Reason
aa_final_qty AA_FINAL_QTY Final AA Quantity
aa_final_qty_f AA_FINAL_QTY_F Final Qty (Fltg Pt)
menge_f MENGE_F Qty (FP Number)
fmfgus_key FMFG_US_KEY US Govt
_dataaging DATA_TEMPERATURE Data Aging
egrup JV_EGROUP Equity group
vname JV_NAME Joint venture
kblnr_cab REFPRECOM Precommitment
kblpos_cab REFPREPOS Precommt Item
tcobjnr J_OBJNR Object number
dateofservice VVBEACTDATE Date of Service
notaxcorr VVREITNOTAXCORR Do Not Correct
diffoptrate POPTSATZ Option Rate
hasdiffoptrate VVREITUSEDIFFOPTRATE Diff. Opt. Rate
chartofaccounts KTOPL Chart of Accts

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 MMPUR_EXT_EKKN (
    MANDT,                -- Client [MANDT]
    EXTSOURCESYSTEM,      -- Connected System ID [MMPUR_D_SOURCE_SYS]
    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 [MMPUR_WBS_ELEMENT_ID]
    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]
    DUMMY_INCL_EEW_COBL,  -- Dummy [CFD_DUMMY]
    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]
    KBLNR,                -- Earmarked Funds [KBLNR]
    KBLPOS,               -- Document Item [KBLPOS]
    LSTAR,                -- Activity Type [LSTAR]
    PRZNR,                -- Business Process [CO_PRZNR]
    GRANT_NBR,            -- Grant [GM_GRANT_NBR]
    BUDGET_PD,            -- Budget Period [FM_BUDGET_PERIOD]
    FM_SPLIT_BATCH,       -- Dist.Batch No. [FMSP_SPLIT_BATCH]
    FM_SPLIT_BEGRU,       -- Auth.Group [FMSP_SPLIT_AUTG]
    AA_FINAL_IND,         -- Final AA [AA_FINAL_IND]
    AA_FINAL_REASON,      -- Final AA Reason [AA_FINAL_REASON]
    AA_FINAL_QTY,         -- Final AA Quantity [AA_FINAL_QTY]
    AA_FINAL_QTY_F,       -- Final Qty (Fltg Pt) [AA_FINAL_QTY_F]
    MENGE_F,              -- Qty (FP Number) [MENGE_F]
    FMFGUS_KEY,           -- US Govt [FMFG_US_KEY]
    _DATAAGING,           -- Data Aging [DATA_TEMPERATURE]
    EGRUP,                -- Equity group [JV_EGROUP]
    VNAME,                -- Joint venture [JV_NAME]
    KBLNR_CAB,            -- Precommitment [REFPRECOM]
    KBLPOS_CAB,           -- Precommt Item [REFPREPOS]
    TCOBJNR,              -- Object number [J_OBJNR]
    DATEOFSERVICE,        -- Date of Service [VVBEACTDATE]
    NOTAXCORR,            -- Do Not Correct [VVREITNOTAXCORR]
    DIFFOPTRATE,          -- Option Rate [POPTSATZ]
    HASDIFFOPTRATE,       -- Diff. Opt. Rate [VVREITUSEDIFFOPTRATE]
    CHARTOFACCOUNTS,      -- Chart of Accts [KTOPL]
    PRIMARY KEY (MANDT, EXTSOURCESYSTEM, EBELN, EBELP, ZEKKN)
);

Learn More