MMPUR_SES_ITEM

Transparent Table Application Table
44 Fields 5 CDS Views

Service Entry Sheet Item

MMPUR_SES_ITEM is an SAP database table in S/4HANA. Service Entry Sheet Item. It contains 44 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
E_ServiceEntrySheetItem view from EXTENSION Extension view of Manage Service Entry Sheets without draft
FNDEI_MMPUR_SES_ITEM_BLOCKINGI view from Filter View for table mmpur_ses_item
FNDEI_mmpur_ses_ITEM_FILTER view from Filter View for table mmpur_ses_item
I_ServiceEntrySheetItemBasic view from BASIC Service Entry Sheet Item Basic
SERVICEENTRYSHEETLEANITEMS view from

Fields (44)

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
serviceentrysheetuuid /BOBF/UUID Key
serviceentrysheetitemuuid /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
referencepurchaseorder MMPUR_SES_REFERENCE_PURCHORD Reference PO
referencepurchaseorderitem MMPUR_SES_REFERENCE_PO_ITEM Ref. PO Item
deletioncode ELOEK Del. Indicator
service MMPUR_SES_PRODUCT Product
description MMPUR_SES_ITEM_DESCRIPTION Item Description
serviceperformer SERVICEPERFORMER Service Performer
accountassignmentcategory KNTTP Acct Assgmt Cat
accountassignmentdistribution VRTKZ Distribution
unit MMPUR_SES_CONFIRMATION_UOM Unit of Measure
quantity MMPUR_SES_CONFIRMEDQUANTITY Stated Quantity
orderpriceunit BBPRM Order Price Un.
orderpriceunittoorderunitnmrtr BPUMZ Qty Conversion
ordpriceunittoorderunitdnmntr BPUMN Qty Conversion
qtyinpurchaseorderpriceunit BPMNG Qty in OPUn
performancedate MMPUR_SES_SERV_PERF_DATE Performance Date
performanceenddate MMPUR_SES_SERV_PERF_END_DATE Performance End Date
originobject MMPUR_SES_EXTERNAL_REFERENCE Reference Document
workitem /CPD/PFP_WORKITEM_ID Work Item ID
netamount MMPUR_SES_CONFIRMEDVALUE Stated Amount
netprice MMPUR_SES_ITEM_NETPRICE Price per Unit
productgroup PRODUCTGROUP Product Group
plant EWERK Plant
externalreferenceid MMPUR_EXTERNALREFERENCEID Ext. Reference ID
contract CTR_FOR_LIMIT Contract For Limit
contractitem KTPNR_LL Purchase Contract Item
netpricequantity EPEIN Price Unit
nondeductibleinputtaxamount NAVNW Non-deductible
taxcode MWSKZ Tax Code
taxcountry FOT_TAX_COUNTRY Tax Ctry/Reg.
taxdeterminationdate TXDAT Tax Date
taxjurisdiction TXJCD Tax Jur.
taxcalculationprocedure KALSM_D Procedure
pricedate PREDT Price Date
sesitemisfinalentry MMPUR_SES_IS_FINAL_ENTRY Final Entry
dummy_mmpur_ses_incl_eew_ps MMPUR_SES_ITEM_INCL_EEW Ext. Include

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
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MMPUR_SES_ITEM (
    MANDT,                           -- Client [MANDT]
    SERVICEENTRYSHEET,               -- Service Entry Sheet [MMPUR_SES_SERVICEENTRYSHEET]
    SERVICEENTRYSHEETITEM,           -- Item Number of SES [MMPUR_SES_SERVICEENTRYSHEETITM]
    SERVICEENTRYSHEETUUID,           -- Key [/BOBF/UUID]
    SERVICEENTRYSHEETITEMUUID,       -- 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]
    REFERENCEPURCHASEORDER,          -- Reference PO [MMPUR_SES_REFERENCE_PURCHORD]
    REFERENCEPURCHASEORDERITEM,      -- Ref. PO Item [MMPUR_SES_REFERENCE_PO_ITEM]
    DELETIONCODE,                    -- Del. Indicator [ELOEK]
    SERVICE,                         -- Product [MMPUR_SES_PRODUCT]
    DESCRIPTION,                     -- Item Description [MMPUR_SES_ITEM_DESCRIPTION]
    SERVICEPERFORMER,                -- Service Performer [SERVICEPERFORMER]
    ACCOUNTASSIGNMENTCATEGORY,       -- Acct Assgmt Cat [KNTTP]
    ACCOUNTASSIGNMENTDISTRIBUTION,   -- Distribution [VRTKZ]
    UNIT,                            -- Unit of Measure [MMPUR_SES_CONFIRMATION_UOM]
    QUANTITY,                        -- Stated Quantity [MMPUR_SES_CONFIRMEDQUANTITY]
    ORDERPRICEUNIT,                  -- Order Price Un. [BBPRM]
    ORDERPRICEUNITTOORDERUNITNMRTR,  -- Qty Conversion [BPUMZ]
    ORDPRICEUNITTOORDERUNITDNMNTR,   -- Qty Conversion [BPUMN]
    QTYINPURCHASEORDERPRICEUNIT,     -- Qty in OPUn [BPMNG]
    PERFORMANCEDATE,                 -- Performance Date [MMPUR_SES_SERV_PERF_DATE]
    PERFORMANCEENDDATE,              -- Performance End Date [MMPUR_SES_SERV_PERF_END_DATE]
    ORIGINOBJECT,                    -- Reference Document [MMPUR_SES_EXTERNAL_REFERENCE]
    WORKITEM,                        -- Work Item ID [/CPD/PFP_WORKITEM_ID]
    NETAMOUNT,                       -- Stated Amount [MMPUR_SES_CONFIRMEDVALUE]
    NETPRICE,                        -- Price per Unit [MMPUR_SES_ITEM_NETPRICE]
    PRODUCTGROUP,                    -- Product Group [PRODUCTGROUP]
    PLANT,                           -- Plant [EWERK]
    EXTERNALREFERENCEID,             -- Ext. Reference ID [MMPUR_EXTERNALREFERENCEID]
    CONTRACT,                        -- Contract For Limit [CTR_FOR_LIMIT]
    CONTRACTITEM,                    -- Purchase Contract Item [KTPNR_LL]
    NETPRICEQUANTITY,                -- Price Unit [EPEIN]
    NONDEDUCTIBLEINPUTTAXAMOUNT,     -- Non-deductible [NAVNW]
    TAXCODE,                         -- Tax Code [MWSKZ]
    TAXCOUNTRY,                      -- Tax Ctry/Reg. [FOT_TAX_COUNTRY]
    TAXDETERMINATIONDATE,            -- Tax Date [TXDAT]
    TAXJURISDICTION,                 -- Tax Jur. [TXJCD]
    TAXCALCULATIONPROCEDURE,         -- Procedure [KALSM_D]
    PRICEDATE,                       -- Price Date [PREDT]
    SESITEMISFINALENTRY,             -- Final Entry [MMPUR_SES_IS_FINAL_ENTRY]
    DUMMY_MMPUR_SES_INCL_EEW_PS,     -- Ext. Include [MMPUR_SES_ITEM_INCL_EEW]
    PRIMARY KEY (MANDT, SERVICEENTRYSHEET, SERVICEENTRYSHEETITEM)
);

Learn More