MMPUR_EXT_EBKN

Transparent Table Application Table
35 Fields 2 CDS Views

Maintain Account Assignment Category for Back-end Requisitio

MMPUR_EXT_EBKN is an SAP database table in S/4HANA. Maintain Account Assignment Category for Back-end Requisitio. It contains 35 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_PrmtHbRpldPurReqnAcctAssgmt view from BASIC Basic View For ExtPrRqn Act Asgmt Rplctd
I_ProcmtHubPurReqnAcctAssgmt view from BASIC Basic View For Ext Pur Reqn Acct Assigmt

Fields (35)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY purchaserequisition banfn Purchase Req.
KEY purchaserequisitionitem bnfpo Requisn. item
KEY purreqnacctassgmtnmbr dzebkn Ser.no.acc.ass.
KEY extsourcesystem mmpur_d_source_sys Connected System ID
quantity bamng Quantity
multipleacctassgmtdistrpercent vproz Distribution
glaccount saknr G/L Account
costcenter kostl Cost Center
functionalarea fkber Functional Area
fund bp_geber Fund
fundscenter fistl Funds Center
controllingarea kokrs CO Area
unloadingpointname ablad Unloading Point
processorder aufnr Order
projectnetwork nplnr Network
projectnetworkinternalid co_aufpl Plan No.f.Oper.
wbselementinternalid mmpur_d_ps_psp_pnr WBS Element
salesorder vbeln SD Document
salesorderscheduleline etenr Schedule Line
salesdocumentitem posnr_va Item
masterfixedasset anln1 Asset
isdeleted loekz Deletion Indic.
creationdate erdat Created On
fixedasset anln2 Sub-number
goodsrecipientname wempf Recipient
profitcenter prctr Profit Center
commitmentitem fipos Commitment item
purreqnnetamount netwr Net Value
earmarkedfundsdocument kblnr Earmarked Funds
earmarkedfundsitem kblpos Document Item
profitabilitysegment rkeobjnr Profit. segment
settlementreferencedate dabrbez Reference date
chartofaccounts ktopl Chart of Accts
businessarea gsber Business Area

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.

-- Maintain Account Assignment Category for Back-end Requisitio
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MMPUR_EXT_EBKN (
    MANDT,                           -- Client [mandt]
    PURCHASEREQUISITION,             -- Purchase Req. [banfn]
    PURCHASEREQUISITIONITEM,         -- Requisn. item [bnfpo]
    PURREQNACCTASSGMTNMBR,           -- Ser.no.acc.ass. [dzebkn]
    EXTSOURCESYSTEM,                 -- Connected System ID [mmpur_d_source_sys]
    QUANTITY,                        -- Quantity [bamng]
    MULTIPLEACCTASSGMTDISTRPERCENT,  -- Distribution [vproz]
    GLACCOUNT,                       -- G/L Account [saknr]
    COSTCENTER,                      -- Cost Center [kostl]
    FUNCTIONALAREA,                  -- Functional Area [fkber]
    FUND,                            -- Fund [bp_geber]
    FUNDSCENTER,                     -- Funds Center [fistl]
    CONTROLLINGAREA,                 -- CO Area [kokrs]
    UNLOADINGPOINTNAME,              -- Unloading Point [ablad]
    PROCESSORDER,                    -- Order [aufnr]
    PROJECTNETWORK,                  -- Network [nplnr]
    PROJECTNETWORKINTERNALID,        -- Plan No.f.Oper. [co_aufpl]
    WBSELEMENTINTERNALID,            -- WBS Element [mmpur_d_ps_psp_pnr]
    SALESORDER,                      -- SD Document [vbeln]
    SALESORDERSCHEDULELINE,          -- Schedule Line [etenr]
    SALESDOCUMENTITEM,               -- Item [posnr_va]
    MASTERFIXEDASSET,                -- Asset [anln1]
    ISDELETED,                       -- Deletion Indic. [loekz]
    CREATIONDATE,                    -- Created On [erdat]
    FIXEDASSET,                      -- Sub-number [anln2]
    GOODSRECIPIENTNAME,              -- Recipient [wempf]
    PROFITCENTER,                    -- Profit Center [prctr]
    COMMITMENTITEM,                  -- Commitment item [fipos]
    PURREQNNETAMOUNT,                -- Net Value [netwr]
    EARMARKEDFUNDSDOCUMENT,          -- Earmarked Funds [kblnr]
    EARMARKEDFUNDSITEM,              -- Document Item [kblpos]
    PROFITABILITYSEGMENT,            -- Profit. segment [rkeobjnr]
    SETTLEMENTREFERENCEDATE,         -- Reference date [dabrbez]
    CHARTOFACCOUNTS,                 -- Chart of Accts [ktopl]
    BUSINESSAREA,                    -- Business Area [gsber]
    PRIMARY KEY (MANDT, PURCHASEREQUISITION, PURCHASEREQUISITIONITEM, PURREQNACCTASSGMTNMBR, EXTSOURCESYSTEM)
);

Learn More