MMPUR_SES_ITM_AC
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_SrvEntrySheetAcctAssgmtBasic | view | from | BASIC | Srv Entry Sheet Account Assignment Basic |
Fields (56)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| 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)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA