MMPUR_SES_ITM_AC

Transparent Table Application Table

Service Entry Sheet Item Accounting Line

MMPUR_SES_ITM_AC is an SAP database table in S/4HANA. Service Entry Sheet Item Accounting Line. It contains 56 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_SrvEntrySheetAcctAssgmtBasic view from BASIC Srv Entry Sheet Account Assignment Basic

Fields (56)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY serviceentrysheet MMPUR_SES_SERVICEENTRYSHEET Service Entry Sheet
KEY serviceentrysheetitem MMPUR_SES_SERVICEENTRYSHEETITM Item Number of SES
KEY srvcentrshtitmacctglin DZEKKN Account Assgmt No.
serviceentrysheetuuid /BOBF/UUID Key
serviceentrysheetitemuuid /BOBF/UUID Key
accountassignmentuuid /BOBF/UUID Key
crea_date_time TIMESTAMPL Time Stamp
crea_uname UNAME User Name
lchg_date_time TIMESTAMPL Time Stamp
lchg_uname UNAME User Name
poitmaccassno MMPUR_SES_PO_ITM_ACCT_NO PO Item Acc Ass
loekz KLOEK Deletion Ind.
menge MENGE_D Quantity
netwr MMPUR_SES_NET_AMT_TRANS_CRCY Net Amount
vproz VPROZ Distribution
sakto SAKNR G/L Account
gsber GSBER Business Area
kostl KOSTL Cost Center
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
kokrs KOKRS CO Area
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
kblnr KBLNR Earmarked Funds
kblpos KBLPOS Document Item
budget_pd FM_BUDGET_PERIOD Budget Period
grant_nbr GM_GRANT_NBR Grant
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
dabrz DABRBEZ Reference date
wempf WEMPF Recipient
ablad ABLAD Unloading Point
aufpl_ord CO_AUFPL Plan No.f.Oper.
aplzl_ord CO_APLZL Counter
measure FM_MEASURE Funded Program

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.

-- Service Entry Sheet Item Accounting Line
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MMPUR_SES_ITM_AC (
    MANDT,                      -- Client [MANDT]
    SERVICEENTRYSHEET,          -- Service Entry Sheet [MMPUR_SES_SERVICEENTRYSHEET]
    SERVICEENTRYSHEETITEM,      -- Item Number of SES [MMPUR_SES_SERVICEENTRYSHEETITM]
    SRVCENTRSHTITMACCTGLIN,     -- Account Assgmt No. [DZEKKN]
    SERVICEENTRYSHEETUUID,      -- Key [/BOBF/UUID]
    SERVICEENTRYSHEETITEMUUID,  -- Key [/BOBF/UUID]
    ACCOUNTASSIGNMENTUUID,      -- Key [/BOBF/UUID]
    CREA_DATE_TIME,             -- Time Stamp [TIMESTAMPL]
    CREA_UNAME,                 -- User Name [UNAME]
    LCHG_DATE_TIME,             -- Time Stamp [TIMESTAMPL]
    LCHG_UNAME,                 -- User Name [UNAME]
    POITMACCASSNO,              -- PO Item Acc Ass [MMPUR_SES_PO_ITM_ACCT_NO]
    LOEKZ,                      -- Deletion Ind. [KLOEK]
    MENGE,                      -- Quantity [MENGE_D]
    NETWR,                      -- Net Amount [MMPUR_SES_NET_AMT_TRANS_CRCY]
    VPROZ,                      -- Distribution [VPROZ]
    SAKTO,                      -- G/L Account [SAKNR]
    GSBER,                      -- Business Area [GSBER]
    KOSTL,                      -- Cost Center [KOSTL]
    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]
    KOKRS,                      -- CO Area [KOKRS]
    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]
    KBLNR,                      -- Earmarked Funds [KBLNR]
    KBLPOS,                     -- Document Item [KBLPOS]
    BUDGET_PD,                  -- Budget Period [FM_BUDGET_PERIOD]
    GRANT_NBR,                  -- Grant [GM_GRANT_NBR]
    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]
    DABRZ,                      -- Reference date [DABRBEZ]
    WEMPF,                      -- Recipient [WEMPF]
    ABLAD,                      -- Unloading Point [ABLAD]
    AUFPL_ORD,                  -- Plan No.f.Oper. [CO_AUFPL]
    APLZL_ORD,                  -- Counter [CO_APLZL]
    MEASURE,                    -- Funded Program [FM_MEASURE]
    PRIMARY KEY (MANDT, SERVICEENTRYSHEET, SERVICEENTRYSHEETITEM, SRVCENTRSHTITMACCTGLIN)
);