MARA_GOV_DFT

Transparent Table Application Table

Draft table for entity I_PRODUCTGOVTP

MARA_GOV_DFT is an SAP database table in S/4HANA. Draft table for entity I_PRODUCTGOVTP. It contains 108 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_ProductGovDraft view_entity from BASIC

Fields (108)

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
mdchgprocessstep MDC_PROCESS_STEP_NO Process Step Number
product PRODUCTNUMBER Product
packingreferenceproduct PL_RMATP Ref. mat. for pckg
prodnoingenprodinprepackprod WSTR_SATNR_PP GenericMaterial
assortmentlisttype BBTYP Astmt List Type
itemcategorygroup MTPOS_MARA GenItemCatGroup
prodeffctyparamvalsareassigned CC_MTEFF Assign.eff.vals
isapprovedbatchrecordreqd XGCHP Batch rec. req.
serialnoexplicitnesslevel SERLV SerializLevel
transportisinbulk ADGE_ILOOS In bulk/liquid
productishighlyviscous ADGE_IHIVI Highly viscous
dangerousgoodsindprofile ADGE_PROFL DGIndProfile
manufacturerpartprofile MPROF Mfr Part Profile
owninventorymanagedproduct MPMAT Int. material no.
manufacturernumber MFRNR Manufacturer
productmanufacturernumber MFRPN Mfr Part Number
discountinkindeligibility NRFHG Disc. in kind
prodallocdetnprocedure KOSCH Prod.allocation
prodisenvironmentallyrelevant KZUMW Envt. relevant
grosscontent INHBR Gross Contents
netcontent INHAL Net Contents
contentunit INHME Content Unit
crossplantstatusvaliditydate MSTDE Valid from
crossplantstatus MSTAE X-Plant Status
crossplantconfigurableproduct CROSSPLANTCONFIGURABLEPRODUCT Cross-plant CP
standardhandlingunittype CIFHUTYPDF Stand. HU Type
brand WRF_BRAND_ID Brand
productseasonusagecategory FSH_SEALV Season Usage
anpcode J_1BANP ANP Code
ischemicalcompliancerelevant CHML_CMPLNC_RLVNCE_IND_PM Chemical Compliance Relevance Indicator
lastchangedbyuser AENAM Changed By
lastchangetime LAST_CHANGED_TIME Last Chgd. Time
hastextilepartswthanimalorigin WRF_ANIMAL_ORIGIN_FLAG Animal Origin
qualityinspectiongroup CIFQGRP Qual.Insp.Grp
timeunitforquarantineperiod CIFQQTIMEUOM Time Unit
quarantineperiod CIFQQTIME Quarant.Per.
countryoforigin HERKL C/R of Origin
unitformaxpackagingdimensions CIFMAXDUOM Unit of Measure
maximumpackagingheight CIFMAXH Max.Height
maximumpackagingwidth CIFMAXB Max. Pack Width
maximumpackaginglength CIFMAXL Max.Length
overcapacitytolerance CIFMAXCTOL Overcapac. Tol.
maximumcapacity CIFMAXC Max. Capacity
hasvariabletareweight CIFTAREVAR Variable TW
handlingunittype CIFHUTYP HUTyp
isrelevantforhzdssubstances CIFHAZMAT Haz. Sub.
handlingindicator CIFHDLCODE Handling Ind.
warehouseproductgroup CIFWHMATGR WH Mat.Grp
warehousestoragecondition CIFWHSTC Stor. Condition
ispilferable CIFPILFRBL Pilferable
industrystandardname NORMT Ind. Std Desc.
basicmaterial WRKST Basic material
sizeordimensiontext GROES Size/dimensions
productionmemopageformat FORMT Page format
productionorinspectionmemotxt FERTH Prod./insp.memo
productdocumentpagecount BLANZ No. Of Sheets
productdocumentpagenumber BLATT Page Number
productdocumentchangenumber AESZN Doc. Change No.
productdocumentpageformat DZEIFO Page Format
productdocumentversion DZEIVR Doc. Version
productdocumenttype DZEIAR Document Type
productdocumentnumber DZEINR Document
baseunit MEINS Base Unit
productoldid BISMT Old matl number
productgroup PRODUCTGROUP Product Group
industrysector MBRSH Industry
producttype PRODUCTTYPE Product Type
ismarkedfordeletion LVOMA DF client level
lastchangedate LAEDA Last Change
createdbyuser ERNAM Created By
creationtime CREATED_AT_TIME Created Time
creationdate ERSDA Created On
laboratoryordesignoffice LABOR Lab/Office
externalproductgroup EXTERNALPRODUCTGROUP Ext. prod group
hasemptiesbom W_MITLEERG W/ empties BOM
productvalidenddate LIQDT Valid To
validitystartdate DATAB Valid From
authorizationgroup BEGRU AuthorizGroup
packagingmaterialgroup MAGRV Matl Grp Pckmat
isbatchmanagementrequired XCHPF Batch Mgmt Rqt
productisconfigurable PRODUCTISCONFIGURABLE Configurable
documentiscreatedbycad CADKZ CAD Indicator
producthierarchy PRODH_D Prod. Hierarchy
productmeasurementunit MEABM Unit
baseunitspecificproductheight HOEHE Height
baseunitspecificproductwidth BREIT Width
baseunitspecificproductlength LAENG Length
internationalarticlenumbercat NUMTP EAN category
productstandardid EAN11 EAN/UPC
competitorid WETTB Competitor
division SPART Division
volumeunit VOLEH Volume Unit
materialvolume VOLUM Volume
weightunit GEWEI Unit of Weight
netweight NTGEW Net Weight
grossweight BRGEW Gross Weight
lastchangedatetime abap.dec
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_PRODUCTGOVTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MARA_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]
    MDCHGPROCESSSTEP,                -- Process Step Number [MDC_PROCESS_STEP_NO]
    PRODUCT,                         -- Product [PRODUCTNUMBER]
    PACKINGREFERENCEPRODUCT,         -- Ref. mat. for pckg [PL_RMATP]
    PRODNOINGENPRODINPREPACKPROD,    -- GenericMaterial [WSTR_SATNR_PP]
    ASSORTMENTLISTTYPE,              -- Astmt List Type [BBTYP]
    ITEMCATEGORYGROUP,               -- GenItemCatGroup [MTPOS_MARA]
    PRODEFFCTYPARAMVALSAREASSIGNED,  -- Assign.eff.vals [CC_MTEFF]
    ISAPPROVEDBATCHRECORDREQD,       -- Batch rec. req. [XGCHP]
    SERIALNOEXPLICITNESSLEVEL,       -- SerializLevel [SERLV]
    TRANSPORTISINBULK,               -- In bulk/liquid [ADGE_ILOOS]
    PRODUCTISHIGHLYVISCOUS,          -- Highly viscous [ADGE_IHIVI]
    DANGEROUSGOODSINDPROFILE,        -- DGIndProfile [ADGE_PROFL]
    MANUFACTURERPARTPROFILE,         -- Mfr Part Profile [MPROF]
    OWNINVENTORYMANAGEDPRODUCT,      -- Int. material no. [MPMAT]
    MANUFACTURERNUMBER,              -- Manufacturer [MFRNR]
    PRODUCTMANUFACTURERNUMBER,       -- Mfr Part Number [MFRPN]
    DISCOUNTINKINDELIGIBILITY,       -- Disc. in kind [NRFHG]
    PRODALLOCDETNPROCEDURE,          -- Prod.allocation [KOSCH]
    PRODISENVIRONMENTALLYRELEVANT,   -- Envt. relevant [KZUMW]
    GROSSCONTENT,                    -- Gross Contents [INHBR]
    NETCONTENT,                      -- Net Contents [INHAL]
    CONTENTUNIT,                     -- Content Unit [INHME]
    CROSSPLANTSTATUSVALIDITYDATE,    -- Valid from [MSTDE]
    CROSSPLANTSTATUS,                -- X-Plant Status [MSTAE]
    CROSSPLANTCONFIGURABLEPRODUCT,   -- Cross-plant CP [CROSSPLANTCONFIGURABLEPRODUCT]
    STANDARDHANDLINGUNITTYPE,        -- Stand. HU Type [CIFHUTYPDF]
    BRAND,                           -- Brand [WRF_BRAND_ID]
    PRODUCTSEASONUSAGECATEGORY,      -- Season Usage [FSH_SEALV]
    ANPCODE,                         -- ANP Code [J_1BANP]
    ISCHEMICALCOMPLIANCERELEVANT,    -- Chemical Compliance Relevance Indicator [CHML_CMPLNC_RLVNCE_IND_PM]
    LASTCHANGEDBYUSER,               -- Changed By [AENAM]
    LASTCHANGETIME,                  -- Last Chgd. Time [LAST_CHANGED_TIME]
    HASTEXTILEPARTSWTHANIMALORIGIN,  -- Animal Origin [WRF_ANIMAL_ORIGIN_FLAG]
    QUALITYINSPECTIONGROUP,          -- Qual.Insp.Grp [CIFQGRP]
    TIMEUNITFORQUARANTINEPERIOD,     -- Time Unit [CIFQQTIMEUOM]
    QUARANTINEPERIOD,                -- Quarant.Per. [CIFQQTIME]
    COUNTRYOFORIGIN,                 -- C/R of Origin [HERKL]
    UNITFORMAXPACKAGINGDIMENSIONS,   -- Unit of Measure [CIFMAXDUOM]
    MAXIMUMPACKAGINGHEIGHT,          -- Max.Height [CIFMAXH]
    MAXIMUMPACKAGINGWIDTH,           -- Max. Pack Width [CIFMAXB]
    MAXIMUMPACKAGINGLENGTH,          -- Max.Length [CIFMAXL]
    OVERCAPACITYTOLERANCE,           -- Overcapac. Tol. [CIFMAXCTOL]
    MAXIMUMCAPACITY,                 -- Max. Capacity [CIFMAXC]
    HASVARIABLETAREWEIGHT,           -- Variable TW [CIFTAREVAR]
    HANDLINGUNITTYPE,                -- HUTyp [CIFHUTYP]
    ISRELEVANTFORHZDSSUBSTANCES,     -- Haz. Sub. [CIFHAZMAT]
    HANDLINGINDICATOR,               -- Handling Ind. [CIFHDLCODE]
    WAREHOUSEPRODUCTGROUP,           -- WH Mat.Grp [CIFWHMATGR]
    WAREHOUSESTORAGECONDITION,       -- Stor. Condition [CIFWHSTC]
    ISPILFERABLE,                    -- Pilferable [CIFPILFRBL]
    INDUSTRYSTANDARDNAME,            -- Ind. Std Desc. [NORMT]
    BASICMATERIAL,                   -- Basic material [WRKST]
    SIZEORDIMENSIONTEXT,             -- Size/dimensions [GROES]
    PRODUCTIONMEMOPAGEFORMAT,        -- Page format [FORMT]
    PRODUCTIONORINSPECTIONMEMOTXT,   -- Prod./insp.memo [FERTH]
    PRODUCTDOCUMENTPAGECOUNT,        -- No. Of Sheets [BLANZ]
    PRODUCTDOCUMENTPAGENUMBER,       -- Page Number [BLATT]
    PRODUCTDOCUMENTCHANGENUMBER,     -- Doc. Change No. [AESZN]
    PRODUCTDOCUMENTPAGEFORMAT,       -- Page Format [DZEIFO]
    PRODUCTDOCUMENTVERSION,          -- Doc. Version [DZEIVR]
    PRODUCTDOCUMENTTYPE,             -- Document Type [DZEIAR]
    PRODUCTDOCUMENTNUMBER,           -- Document [DZEINR]
    BASEUNIT,                        -- Base Unit [MEINS]
    PRODUCTOLDID,                    -- Old matl number [BISMT]
    PRODUCTGROUP,                    -- Product Group [PRODUCTGROUP]
    INDUSTRYSECTOR,                  -- Industry [MBRSH]
    PRODUCTTYPE,                     -- Product Type [PRODUCTTYPE]
    ISMARKEDFORDELETION,             -- DF client level [LVOMA]
    LASTCHANGEDATE,                  -- Last Change [LAEDA]
    CREATEDBYUSER,                   -- Created By [ERNAM]
    CREATIONTIME,                    -- Created Time [CREATED_AT_TIME]
    CREATIONDATE,                    -- Created On [ERSDA]
    LABORATORYORDESIGNOFFICE,        -- Lab/Office [LABOR]
    EXTERNALPRODUCTGROUP,            -- Ext. prod group [EXTERNALPRODUCTGROUP]
    HASEMPTIESBOM,                   -- W/ empties BOM [W_MITLEERG]
    PRODUCTVALIDENDDATE,             -- Valid To [LIQDT]
    VALIDITYSTARTDATE,               -- Valid From [DATAB]
    AUTHORIZATIONGROUP,              -- AuthorizGroup [BEGRU]
    PACKAGINGMATERIALGROUP,          -- Matl Grp Pckmat [MAGRV]
    ISBATCHMANAGEMENTREQUIRED,       -- Batch Mgmt Rqt [XCHPF]
    PRODUCTISCONFIGURABLE,           -- Configurable [PRODUCTISCONFIGURABLE]
    DOCUMENTISCREATEDBYCAD,          -- CAD Indicator [CADKZ]
    PRODUCTHIERARCHY,                -- Prod. Hierarchy [PRODH_D]
    PRODUCTMEASUREMENTUNIT,          -- Unit [MEABM]
    BASEUNITSPECIFICPRODUCTHEIGHT,   -- Height [HOEHE]
    BASEUNITSPECIFICPRODUCTWIDTH,    -- Width [BREIT]
    BASEUNITSPECIFICPRODUCTLENGTH,   -- Length [LAENG]
    INTERNATIONALARTICLENUMBERCAT,   -- EAN category [NUMTP]
    PRODUCTSTANDARDID,               -- EAN/UPC [EAN11]
    COMPETITORID,                    -- Competitor [WETTB]
    DIVISION,                        -- Division [SPART]
    VOLUMEUNIT,                      -- Volume Unit [VOLEH]
    MATERIALVOLUME,                  -- Volume [VOLUM]
    WEIGHTUNIT,                      -- Unit of Weight [GEWEI]
    NETWEIGHT,                       -- Net Weight [NTGEW]
    GROSSWEIGHT,                     -- Gross Weight [BRGEW]
    LASTCHANGEDATETIME,              -- abap.dec
    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)
);