MARA_SLS_GOV_DFT

Transparent Table Application Table

Draft table for entity I_PRODUCTSALESGOVTP

MARA_SLS_GOV_DFT is an SAP database table in S/4HANA. Draft table for entity I_PRODUCTSALESGOVTP. It contains 30 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_ProductSalesGovDraft view_entity from BASIC

Fields (30)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY masterdatachangeprocess MDC_PROCESS_ID Process ID
KEY mdchgprocesssrcesystem MDC_BUSINESS_SYSTEM Source System
KEY mdchgprocesssrceobject MDC_SOURCE_ID Source ID
KEY draftuuid SDRAFT_UUID Draft Document ID
parentdraftuuid SDRAFT_UUID Draft Document ID
mdchgprocessstep MDC_PROCESS_STEP_NO Process Step Number
transportationgroup TRAGR Trans. Group
allowedpackagingweightqty ERGEW Allowed Pkg wt
allowedpackagingweightqtyunit ERGEI Unit of weight
allowedpackagingvolumeqty ERVOL Allowed Volume
allowedpackagingvolumeqtyunit ERVOE Volume unit
excessweighttolerance EXCESSWEIGHTTOLERANCE Excess Weight Tolerance
excessvolumetolerance EXCESSVOLUMETOLERANCE Excess Volume Tolerance
packagingmaterialtype PACKAGINGMATERIALTYPE Packaging Material Type
volumemaximumlevel FUELG Maximum level
stackingfactor STFAK Stacking factor
pricingreferenceproduct PMATN Pr. Ref. Matl
salesstatus MSTAV X-DChain Status
salesstatusvaliditydate MSTDV Valid from
taxclassification TAKLV Tax class.
variantspricingprofile SPROF Pricing profile
isclosedpackagingmaterial KZGVH Closed
isvariantpriceallowed WPM_ALLOW_PMAT_IGNO_MAT Var. Price Allowed
draftentitycreationdatetime SYCH_BDL_DRAFT_CREATED_AT Draft Created
draftentitylastchangedatetime SYCH_BDL_DRAFT_LAST_CHANGED_AT Draft Changed
draftadministrativedatauuid SYCH_BDL_DRAFT_ADMIN_UUID Admin. UUID
draftentityoperationcode SYCH_BDL_DRAFT_OPERATION_CODE Operation Code
hasactiveentity SYCH_BDL_DRAFT_HASACTIVE Has active
draftfieldchanges SYCH_BDL_DRAFT_FIELD_CHANGES Draft Changes

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.

-- Draft table for entity I_PRODUCTSALESGOVTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MARA_SLS_GOV_DFT (
    MANDT,                          -- Client [MANDT]
    MASTERDATACHANGEPROCESS,        -- Process ID [MDC_PROCESS_ID]
    MDCHGPROCESSSRCESYSTEM,         -- Source System [MDC_BUSINESS_SYSTEM]
    MDCHGPROCESSSRCEOBJECT,         -- Source ID [MDC_SOURCE_ID]
    DRAFTUUID,                      -- Draft Document ID [SDRAFT_UUID]
    PARENTDRAFTUUID,                -- Draft Document ID [SDRAFT_UUID]
    MDCHGPROCESSSTEP,               -- Process Step Number [MDC_PROCESS_STEP_NO]
    TRANSPORTATIONGROUP,            -- Trans. Group [TRAGR]
    ALLOWEDPACKAGINGWEIGHTQTY,      -- Allowed Pkg wt [ERGEW]
    ALLOWEDPACKAGINGWEIGHTQTYUNIT,  -- Unit of weight [ERGEI]
    ALLOWEDPACKAGINGVOLUMEQTY,      -- Allowed Volume [ERVOL]
    ALLOWEDPACKAGINGVOLUMEQTYUNIT,  -- Volume unit [ERVOE]
    EXCESSWEIGHTTOLERANCE,          -- Excess Weight Tolerance [EXCESSWEIGHTTOLERANCE]
    EXCESSVOLUMETOLERANCE,          -- Excess Volume Tolerance [EXCESSVOLUMETOLERANCE]
    PACKAGINGMATERIALTYPE,          -- Packaging Material Type [PACKAGINGMATERIALTYPE]
    VOLUMEMAXIMUMLEVEL,             -- Maximum level [FUELG]
    STACKINGFACTOR,                 -- Stacking factor [STFAK]
    PRICINGREFERENCEPRODUCT,        -- Pr. Ref. Matl [PMATN]
    SALESSTATUS,                    -- X-DChain Status [MSTAV]
    SALESSTATUSVALIDITYDATE,        -- Valid from [MSTDV]
    TAXCLASSIFICATION,              -- Tax class. [TAKLV]
    VARIANTSPRICINGPROFILE,         -- Pricing profile [SPROF]
    ISCLOSEDPACKAGINGMATERIAL,      -- Closed [KZGVH]
    ISVARIANTPRICEALLOWED,          -- Var. Price Allowed [WPM_ALLOW_PMAT_IGNO_MAT]
    DRAFTENTITYCREATIONDATETIME,    -- Draft Created [SYCH_BDL_DRAFT_CREATED_AT]
    DRAFTENTITYLASTCHANGEDATETIME,  -- Draft Changed [SYCH_BDL_DRAFT_LAST_CHANGED_AT]
    DRAFTADMINISTRATIVEDATAUUID,    -- Admin. UUID [SYCH_BDL_DRAFT_ADMIN_UUID]
    DRAFTENTITYOPERATIONCODE,       -- Operation Code [SYCH_BDL_DRAFT_OPERATION_CODE]
    HASACTIVEENTITY,                -- Has active [SYCH_BDL_DRAFT_HASACTIVE]
    DRAFTFIELDCHANGES,              -- Draft Changes [SYCH_BDL_DRAFT_FIELD_CHANGES]
    PRIMARY KEY (MANDT, MASTERDATACHANGEPROCESS, MDCHGPROCESSSRCESYSTEM, MDCHGPROCESSSRCEOBJECT, DRAFTUUID)
);