SDMCC_CHGITEM

Transparent Table Application Table
41 Fields 2 CDS Views

SD Mass Change Cockpit: Item

SDMCC_CHGITEM is an SAP database table in S/4HANA. SD Mass Change Cockpit: Item. It contains 41 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_SDMassChgCkptSlsDocItmChgBsc view from EXTENSION Extn View for Mass Chg of Sls Doc Item
I_SDMassChgCkptSlsDocItmChgBsc view from BASIC Mass Chg of Sls Doc Item Chg Basic

Fields (41)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY slsdocmasschangerequestuuid SD_MCC_JOB_UUID Job ID
slsdocmasschgactioncategory SD_MCC_ACTION_CATEGORY Action Category
slsdocmasschgactionid SD_MCC_ACTION Action
salesdocumentitemcategory PSTYV Item Category
product MATNR Material
salesdocumentitemtext ARKTX Item Descr.
producthierarchynode PRODH_D Prod. Hierarchy
batch CHARG_D Batch
division SPART Division
deliverypriority LPRIO Delivery Prior.
plant WERKS_EXT Plant
customerpaymentterms DZTERM Pyt Terms
unloadingpointname ABLAD Unloading Point
storagelocation LGORT_D Location
shippingpoint VSTEL Shipping Point
shippingtype VSARTTR Shipping Type
route ROUTE Route
billingdocumentdate FKDAT Billing Date
pricingdate PRSDT Pricing Date
requesteddeliverydate REQD_DELIVERY_DATE Requested Delivery Date
itembillingblockreason FAKSP_AP Billing Block
salesdocumentrjcnreason ABGRU_VA RejectionReason
expddelivquantitychangereason SD_ITEM_REASON_CODE Return/Change Reason
returnreason MSR_RETURNS_REASON Return Reason
custretitmfollowupactivity MSR_FU_CODE Follow-Up Act.
incotermsclassification INCO1 Incoterms
incotermstransferlocation INCO2 Incoterms 2
incotermslocation1 INCO2_L Inco. Location1
incotermslocation2 INCO3_L Inco. Location2
incotermsversion INCOV Inco. Version
deliveryblockreason LIFSP Delivery Block
wbselementinternalid PS_S4_PSPNR WBS Internal ID
purchaseorderbycustomer BSTKD Cust. Reference
customerpurchaseorderdate BSTDK Cust. Ref. Date
transactioncurrency WAERK Doc. Currency
materialbycustomer MATNR_KU Cust. Material
pricingtype KNPRS Pricing Type
profitcenter PRCTR Profit Center
wbselementexternalid PS_POSID_EDIT WBS Element
dummy_slsdocitem_incl_eew_ps DUMMY Dummy function in length 1

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.

-- SD Mass Change Cockpit: Item
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SDMCC_CHGITEM (
    MANDT,                          -- Client [MANDT]
    SLSDOCMASSCHANGEREQUESTUUID,    -- Job ID [SD_MCC_JOB_UUID]
    SLSDOCMASSCHGACTIONCATEGORY,    -- Action Category [SD_MCC_ACTION_CATEGORY]
    SLSDOCMASSCHGACTIONID,          -- Action [SD_MCC_ACTION]
    SALESDOCUMENTITEMCATEGORY,      -- Item Category [PSTYV]
    PRODUCT,                        -- Material [MATNR]
    SALESDOCUMENTITEMTEXT,          -- Item Descr. [ARKTX]
    PRODUCTHIERARCHYNODE,           -- Prod. Hierarchy [PRODH_D]
    BATCH,                          -- Batch [CHARG_D]
    DIVISION,                       -- Division [SPART]
    DELIVERYPRIORITY,               -- Delivery Prior. [LPRIO]
    PLANT,                          -- Plant [WERKS_EXT]
    CUSTOMERPAYMENTTERMS,           -- Pyt Terms [DZTERM]
    UNLOADINGPOINTNAME,             -- Unloading Point [ABLAD]
    STORAGELOCATION,                -- Location [LGORT_D]
    SHIPPINGPOINT,                  -- Shipping Point [VSTEL]
    SHIPPINGTYPE,                   -- Shipping Type [VSARTTR]
    ROUTE,                          -- Route [ROUTE]
    BILLINGDOCUMENTDATE,            -- Billing Date [FKDAT]
    PRICINGDATE,                    -- Pricing Date [PRSDT]
    REQUESTEDDELIVERYDATE,          -- Requested Delivery Date [REQD_DELIVERY_DATE]
    ITEMBILLINGBLOCKREASON,         -- Billing Block [FAKSP_AP]
    SALESDOCUMENTRJCNREASON,        -- RejectionReason [ABGRU_VA]
    EXPDDELIVQUANTITYCHANGEREASON,  -- Return/Change Reason [SD_ITEM_REASON_CODE]
    RETURNREASON,                   -- Return Reason [MSR_RETURNS_REASON]
    CUSTRETITMFOLLOWUPACTIVITY,     -- Follow-Up Act. [MSR_FU_CODE]
    INCOTERMSCLASSIFICATION,        -- Incoterms [INCO1]
    INCOTERMSTRANSFERLOCATION,      -- Incoterms 2 [INCO2]
    INCOTERMSLOCATION1,             -- Inco. Location1 [INCO2_L]
    INCOTERMSLOCATION2,             -- Inco. Location2 [INCO3_L]
    INCOTERMSVERSION,               -- Inco. Version [INCOV]
    DELIVERYBLOCKREASON,            -- Delivery Block [LIFSP]
    WBSELEMENTINTERNALID,           -- WBS Internal ID [PS_S4_PSPNR]
    PURCHASEORDERBYCUSTOMER,        -- Cust. Reference [BSTKD]
    CUSTOMERPURCHASEORDERDATE,      -- Cust. Ref. Date [BSTDK]
    TRANSACTIONCURRENCY,            -- Doc. Currency [WAERK]
    MATERIALBYCUSTOMER,             -- Cust. Material [MATNR_KU]
    PRICINGTYPE,                    -- Pricing Type [KNPRS]
    PROFITCENTER,                   -- Profit Center [PRCTR]
    WBSELEMENTEXTERNALID,           -- WBS Element [PS_POSID_EDIT]
    DUMMY_SLSDOCITEM_INCL_EEW_PS,   -- Dummy function in length 1 [DUMMY]
    PRIMARY KEY (MANDT, SLSDOCMASSCHANGEREQUESTUUID)
);

Learn More