SDMCC_CHGHDR
SD Mass Change Cockpit: Header
SDMCC_CHGHDR is an SAP database table in S/4HANA. SD Mass Change Cockpit: Header. It contains 31 fields. 2 CDS views read from this table.
CDS Views using this table (2)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| E_SDMassChgCkptSlsDocHdrChgBsc | view | from | EXTENSION | Extn View for Mass Chg of Sls Doc Hdr |
| I_SDMassChgCkptSlsDocHdrChgBsc | view | from | BASIC | Mass Chg of Sls Doc Header Chg Basic |
Fields (31)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | MANDT | Client | |||
| KEY | slsdocmasschangerequestuuid | SD_MCC_JOB_UUID | Job ID | |||
| slsdocmasschgactioncategory | SD_MCC_ACTION_CATEGORY | Action Category | ||||
| slsdocmasschgactionid | SD_MCC_ACTION | Action | ||||
| sddocumentreason | AUGRU | Order Reason | ||||
| salesoffice | VKBUR | Sales Office | ||||
| salesgroup | VKGRP | Sales Group | ||||
| salesdistrict | BZIRK | Sales District | ||||
| requesteddeliverydate | REQD_DELIV_DATE | Delivery Date | ||||
| shippingcondition | VSBED | Shipping Conditions | ||||
| shippingtype | VSARTTR | Shipping Type | ||||
| receivingpoint | EMPST | Recv. Point | ||||
| customerpaymentterms | DZTERM | Pyt Terms | ||||
| paymentmethod | SCHZW_BSEG | Payt Method | ||||
| transactioncurrency | WAERK | Doc. Currency | ||||
| pricingdate | PRSDT | Pricing Date | ||||
| billingdocumentdate | FKDAT | Billing Date | ||||
| salesdocumentdate | AUDAT | Document Date | ||||
| incotermsclassification | INCO1 | Incoterms | ||||
| incotermstransferlocation | INCO2 | Incoterms 2 | ||||
| incotermslocation1 | INCO2_L | Inco. Location1 | ||||
| incotermslocation2 | INCO3_L | Inco. Location2 | ||||
| incotermsversion | INCOV | Inco. Version | ||||
| deliveryblockreason | LIFSK | Delivery Block | ||||
| headerbillingblockreason | FAKSK | Billing Block | ||||
| salesdocumentrjcnreason | ABGRU_VA | RejectionReason | ||||
| purchaseorderbycustomer | BSTKD | Cust. Reference | ||||
| customerpurchaseorderdate | BSTDK | Cust. Ref. Date | ||||
| completedeliveryisdefined | AUTLF | Complete Dlv. | ||||
| pricingtype | KNPRS | Pricing Type | ||||
| dummy_salesdoc_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: Header
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SDMCC_CHGHDR (
MANDT, -- Client [MANDT]
SLSDOCMASSCHANGEREQUESTUUID, -- Job ID [SD_MCC_JOB_UUID]
SLSDOCMASSCHGACTIONCATEGORY, -- Action Category [SD_MCC_ACTION_CATEGORY]
SLSDOCMASSCHGACTIONID, -- Action [SD_MCC_ACTION]
SDDOCUMENTREASON, -- Order Reason [AUGRU]
SALESOFFICE, -- Sales Office [VKBUR]
SALESGROUP, -- Sales Group [VKGRP]
SALESDISTRICT, -- Sales District [BZIRK]
REQUESTEDDELIVERYDATE, -- Delivery Date [REQD_DELIV_DATE]
SHIPPINGCONDITION, -- Shipping Conditions [VSBED]
SHIPPINGTYPE, -- Shipping Type [VSARTTR]
RECEIVINGPOINT, -- Recv. Point [EMPST]
CUSTOMERPAYMENTTERMS, -- Pyt Terms [DZTERM]
PAYMENTMETHOD, -- Payt Method [SCHZW_BSEG]
TRANSACTIONCURRENCY, -- Doc. Currency [WAERK]
PRICINGDATE, -- Pricing Date [PRSDT]
BILLINGDOCUMENTDATE, -- Billing Date [FKDAT]
SALESDOCUMENTDATE, -- Document Date [AUDAT]
INCOTERMSCLASSIFICATION, -- Incoterms [INCO1]
INCOTERMSTRANSFERLOCATION, -- Incoterms 2 [INCO2]
INCOTERMSLOCATION1, -- Inco. Location1 [INCO2_L]
INCOTERMSLOCATION2, -- Inco. Location2 [INCO3_L]
INCOTERMSVERSION, -- Inco. Version [INCOV]
DELIVERYBLOCKREASON, -- Delivery Block [LIFSK]
HEADERBILLINGBLOCKREASON, -- Billing Block [FAKSK]
SALESDOCUMENTRJCNREASON, -- RejectionReason [ABGRU_VA]
PURCHASEORDERBYCUSTOMER, -- Cust. Reference [BSTKD]
CUSTOMERPURCHASEORDERDATE, -- Cust. Ref. Date [BSTDK]
COMPLETEDELIVERYISDEFINED, -- Complete Dlv. [AUTLF]
PRICINGTYPE, -- Pricing Type [KNPRS]
DUMMY_SALESDOC_INCL_EEW_PS, -- Dummy function in length 1 [DUMMY]
PRIMARY KEY (MANDT, SLSDOCMASSCHANGEREQUESTUUID)
);
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