MARA_GOV_DFT
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| R_ProductGovDraft | view_entity | from | BASIC |
Fields (108)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| 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)
);
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