EBKN

Transparent Table Application Table
53 Fields 18 CDS Views

Purchase Requisition Account Assignment

EBKN is an SAP database table in S/4HANA. Purchase Requisition Account Assignment. It contains 53 fields. 18 CDS views read from this table.

CDS Views using this table (18)

ViewTypeJoinVDMDescription
Atpc_Cds_Ebkn view from CDS View on EBKN Table for ATP
e_mrp_purchase_docs view left_outer Fiori MRP App Purchase Documents CDS View
E_Purreqnacctassgmt view from EXTENSION Purchase Requisition Account Assignment Extensibility View
Fclm_Mm_Ebkn view from Account Assignment
I_PurReqnAccountAssignment view from BASIC Purchase Requisition Account Assignment
I_PurReqnAcctAssgmtBasic view from BASIC Purchase Requisition Account Assignment Basic
I_SupDmndAllDocPurReqnBsc view left_outer BASIC Basic View for Purchase Requisition
I_SupDmndAllDocStkTransptReqn view left_outer BASIC View for Stock Transport Requisition
m_v_m2s_pr_itm view left_outer CDS View for Purchase Requisition
N_PurReqnAcctAssgmt view from Auxiliary view for PR Account Assignment
P_MaintOrderPurReqnLink view_entity from BASIC Maintenance Order and Purchase Requisition Link
pph_e_Ebkn view from read EBKN
SHSM_M_MBANA view inner DDL for Search Help MBANA
SHSM_M_MBANG view inner Purchase Requisitions per Order
SHSM_M_MBANK view inner Purchase Requisitions per Cost Center
SHSM_M_MBANN view inner Purchase Requisitions per Network
SHSM_M_MBANP view inner Purchase Requisitions for Project
SHSM_M_MBANV view inner Purchase Requisitions per Sales Document

Fields (53)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY banfn banfn Purchase Req.
KEY bnfpo bnfpo Requisn. item
KEY zebkn dzebkn Ser.no.acc.ass.
loekz eloek Del. Indicator
erdat erdat Created On
ernam ernam Created By
menge bamng Quantity
vproz vproz Distribution
sakto saknr G/L Account
gsber gsber Business Area
kostl kostl Cost Center
projn projn not in use
vbeln vbeln SD Document
vbelp posnr_va Item
veten etenr Schedule Line
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
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.
fistl fistl Funds Center
geber bp_geber Fund
fkber fkber Functional Area
dabrz dabrbez Reference date
netwr bwert Net Value
aufpl_ord co_aufpl Plan No.f.Oper.
aplzl_ord co_aplzl Counter
extwbselement ps_posid WBS Element
extvornr extvornr Network Activity
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
lstar lstar Activity Type
prznr co_prznr Business Process
grant_nbr gm_grant_nbr Grant
budget_pd fm_budget_period Budget Period
fmfgus_key fmfg_us_key US Govt

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.

-- Purchase Requisition Account Assignment
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EBKN (
    MANDT,                -- Client [mandt]
    BANFN,                -- Purchase Req. [banfn]
    BNFPO,                -- Requisn. item [bnfpo]
    ZEBKN,                -- Ser.no.acc.ass. [dzebkn]
    LOEKZ,                -- Del. Indicator [eloek]
    ERDAT,                -- Created On [erdat]
    ERNAM,                -- Created By [ernam]
    MENGE,                -- Quantity [bamng]
    VPROZ,                -- Distribution [vproz]
    SAKTO,                -- G/L Account [saknr]
    GSBER,                -- Business Area [gsber]
    KOSTL,                -- Cost Center [kostl]
    PROJN,                -- not in use [projn]
    VBELN,                -- SD Document [vbeln]
    VBELP,                -- Item [posnr_va]
    VETEN,                -- Schedule Line [etenr]
    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]
    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]
    FISTL,                -- Funds Center [fistl]
    GEBER,                -- Fund [bp_geber]
    FKBER,                -- Functional Area [fkber]
    DABRZ,                -- Reference date [dabrbez]
    NETWR,                -- Net Value [bwert]
    AUFPL_ORD,            -- Plan No.f.Oper. [co_aufpl]
    APLZL_ORD,            -- Counter [co_aplzl]
    EXTWBSELEMENT,        -- WBS Element [ps_posid]
    EXTVORNR,             -- Network Activity [extvornr]
    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]
    LSTAR,                -- Activity Type [lstar]
    PRZNR,                -- Business Process [co_prznr]
    GRANT_NBR,            -- Grant [gm_grant_nbr]
    BUDGET_PD,            -- Budget Period [fm_budget_period]
    FMFGUS_KEY,           -- US Govt [fmfg_us_key]
    PRIMARY KEY (MANDT, BANFN, BNFPO, ZEBKN)
);

Learn More