R_ProductGovDraft

DDL: R_PRODUCTGOVDRAFT Type: view_entity BASIC
109 Fields 1 Data Sources

R_ProductGovDraft is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (mara_gov_dft) and exposes 109 fields with key fields MasterDataChangeProcess, MDChgProcessSrceSystem, MDChgProcessSrceObject, DraftUUID.

Data Sources (1)

SourceAliasJoin Type
mara_gov_dft mara_gov_dft from

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (109)

KeyFieldSource TableSource FieldDescription
KEY MasterDataChangeProcess masterdatachangeprocess Process ID
KEY MDChgProcessSrceSystem mdchgprocesssrcesystem Source System
KEY MDChgProcessSrceObject mdchgprocesssrceobject Source ID
KEY DraftUUID draftuuid UUID
MDChgProcessStep mdchgprocessstep Step Number
Product product Product Sold
PackingReferenceProduct packingreferenceproduct Ref. mat. for pckg
ProdNoInGenProdInPrepackProd prodnoingenprodinprepackprod License number
AssortmentListType assortmentlisttype Astmt List Type
ItemCategoryGroup itemcategorygroup Item Cat. Group
ProdEffctyParamValsAreAssigned prodeffctyparamvalsareassigned Assign.eff.vals
IsApprovedBatchRecordReqd isapprovedbatchrecordreqd Batch rec. req.
SerialNoExplicitnessLevel serialnoexplicitnesslevel SerializLevel
TransportIsInBulk transportisinbulk In bulk/liquid
ProductIsHighlyViscous productishighlyviscous Highly viscous
DangerousGoodsIndProfile dangerousgoodsindprofile DGIndProfile
ManufacturerPartProfile manufacturerpartprofile Mfr Part Profile
OwnInventoryManagedProduct owninventorymanagedproduct Int. material no.
ManufacturerNumber manufacturernumber Manufacturer No
ProductManufacturerNumber productmanufacturernumber Mfr Part Number
DiscountInKindEligibility discountinkindeligibility Disc. in kind
ProdAllocDetnProcedure prodallocdetnprocedure Prod.allocation
ProdIsEnvironmentallyRelevant prodisenvironmentallyrelevant Envt. relevant
GrossContent grosscontent Gross contents
NetContent netcontent Net contents
ContentUnit contentunit Content unit
CrossPlantStatusValidityDate crossplantstatusvaliditydate Valid From
CrossPlantStatus crossplantstatus X-Plant Status
CrossPlantConfigurableProduct crossplantconfigurableproduct Cross-plant CP
StandardHandlingUnitType standardhandlingunittype Stand. HU Type
Brand brand Fire-Cont.Sect.
ProductSeasonUsageCategory productseasonusagecategory Season Usage
ANPCode anpcode ANP Code
IsChemicalComplianceRelevant ischemicalcompliancerelevant Chemical Compliance Relevance Indicator
LastChangedByUser lastchangedbyuser User Name
LastChangeTime lastchangetime Time changed
HasTextilePartsWthAnimalOrigin hastextilepartswthanimalorigin Animal Origin
QualityInspectionGroup qualityinspectiongroup Qual.Insp.Grp
TimeUnitForQuarantinePeriod timeunitforquarantineperiod Time Unit
QuarantinePeriod quarantineperiod Quarant.Per.
CountryOfOrigin countryoforigin Country/Region of Origin
UnitForMaxPackagingDimensions unitformaxpackagingdimensions Unit of Measure
MaximumPackagingHeight maximumpackagingheight Max.Height
MaximumPackagingWidth maximumpackagingwidth Max. Pack Width
MaximumPackagingLength maximumpackaginglength Max.Length
OvercapacityTolerance overcapacitytolerance Overcapac. Tol.
MaximumCapacity maximumcapacity Max. Capacity
HasVariableTareWeight hasvariabletareweight Variable TW
HandlingUnitType handlingunittype HUTyp
IsRelevantForHzdsSubstances isrelevantforhzdssubstances Haz. Sub.
HandlingIndicator handlingindicator Handling Ind.
WarehouseProductGroup warehouseproductgroup WH Mat.Grp
WarehouseStorageCondition warehousestoragecondition Stor. Condition
IsPilferable ispilferable Pilferable
IndustryStandardName industrystandardname Ind. Std Desc.
BasicMaterial basicmaterial Basic Material
SizeOrDimensionText sizeordimensiontext Size/dimensions
ProductionMemoPageFormat productionmemopageformat Page format
ProductionOrInspectionMemoTxt productionorinspectionmemotxt Prod./insp.memo
ProductDocumentPageCount productdocumentpagecount No. Of Sheets
ProductDocumentPageNumber productdocumentpagenumber Page Number
ProductDocumentChangeNumber productdocumentchangenumber Doc. Change No.
ProductDocumentPageFormat productdocumentpageformat Page Format
ProductDocumentVersion productdocumentversion Doc. Version
ProductDocumentType productdocumenttype Document Type
ProductDocumentNumber productdocumentnumber Document
BaseUnit baseunit Unit of Measure
ProductOldID productoldid Old Prd Number
ProductGroup productgroup Product Sold Group
IndustrySector industrysector Industry
ProductType producttype Product Type Group
IsMarkedForDeletion ismarkedfordeletion Purch.org. data
LastChangeDate lastchangedate Time Stamp
CreatedByUser createdbyuser User Name
CreationTime creationtime Time of Change
CreationDate creationdate Time Stamp
LaboratoryOrDesignOffice laboratoryordesignoffice Lab/Office
ExternalProductGroup externalproductgroup Ext. prod group
HasEmptiesBOM hasemptiesbom W/ Empties BOM
ProductValidEndDate productvalidenddate Valid to
ValidityStartDate validitystartdate Validity Start Date
AuthorizationGroup authorizationgroup AuthorizGroup
PackagingMaterialGroup packagingmaterialgroup Matl Grp Pckmat
IsBatchManagementRequired isbatchmanagementrequired Batch Mgmt Rqt(Plnt)
ProductIsConfigurable productisconfigurable Configurable
DocumentIsCreatedByCAD documentiscreatedbycad CAD Indicator
ProductHierarchy producthierarchy Prod.hierarchy
ProductMeasurementUnit productmeasurementunit Unit
BaseUnitSpecificProductHeight baseunitspecificproductheight Height
BaseUnitSpecificProductWidth baseunitspecificproductwidth Width
BaseUnitSpecificProductLength baseunitspecificproductlength Length
InternationalArticleNumberCat internationalarticlenumbercat GTIN Category
ProductStandardID productstandardid GTIN
CompetitorID competitorid Customer Number
Division division Internal Division ID
VolumeUnit volumeunit Volume Unit
MaterialVolume materialvolume Volume
WeightUnit weightunit Weight unit
NetWeight netweight Net weight
GrossWeight grossweight Total Weight
LastChangeDateTime lastchangedatetime Timestamp
HasActiveEntity hasactiveentity TRUE
DraftEntityCreationDateTime draftentitycreationdatetime Draft Created On
DraftEntityLastChangeDateTime draftentitylastchangedatetime Draft Last Changed On
DraftAdministrativeDataUUID draftadministrativedatauuid UUID
DraftEntityOperationCode draftentityoperationcode Draft - Operation Code
DraftFieldChanges draftfieldchanges Field Changes
_ProductType _ProductType
_ProductGroup_2 _ProductGroup_2

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view R_ProductGovDraft.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW R_ProductGovDraft AS
SELECT
  MasterDataChangeProcess,
  MDChgProcessSrceSystem,
  MDChgProcessSrceObject,
  DraftUUID,
  MDChgProcessStep,
  Product,
  PackingReferenceProduct,
  ProdNoInGenProdInPrepackProd,
  AssortmentListType,
  ItemCategoryGroup,
  ProdEffctyParamValsAreAssigned,
  IsApprovedBatchRecordReqd,
  SerialNoExplicitnessLevel,
  TransportIsInBulk,
  ProductIsHighlyViscous,
  DangerousGoodsIndProfile,
  ManufacturerPartProfile,
  OwnInventoryManagedProduct,
  ManufacturerNumber,
  ProductManufacturerNumber,
  DiscountInKindEligibility,
  ProdAllocDetnProcedure,
  ProdIsEnvironmentallyRelevant,
  GrossContent,
  NetContent,
  ContentUnit,
  CrossPlantStatusValidityDate,
  CrossPlantStatus,
  CrossPlantConfigurableProduct,
  StandardHandlingUnitType,
  Brand,
  ProductSeasonUsageCategory,
  ANPCode,
  IsChemicalComplianceRelevant,
  LastChangedByUser,
  LastChangeTime,
  HasTextilePartsWthAnimalOrigin,
  QualityInspectionGroup,
  TimeUnitForQuarantinePeriod,
  QuarantinePeriod,
  CountryOfOrigin,
  UnitForMaxPackagingDimensions,
  MaximumPackagingHeight,
  MaximumPackagingWidth,
  MaximumPackagingLength,
  OvercapacityTolerance,
  MaximumCapacity,
  HasVariableTareWeight,
  HandlingUnitType,
  IsRelevantForHzdsSubstances,
  HandlingIndicator,
  WarehouseProductGroup,
  WarehouseStorageCondition,
  IsPilferable,
  IndustryStandardName,
  BasicMaterial,
  SizeOrDimensionText,
  ProductionMemoPageFormat,
  ProductionOrInspectionMemoTxt,
  ProductDocumentPageCount,
  ProductDocumentPageNumber,
  ProductDocumentChangeNumber,
  ProductDocumentPageFormat,
  ProductDocumentVersion,
  ProductDocumentType,
  ProductDocumentNumber,
  BaseUnit,
  ProductOldID,
  ProductGroup,
  IndustrySector,
  ProductType,
  IsMarkedForDeletion,
  LastChangeDate,
  CreatedByUser,
  CreationTime,
  CreationDate,
  LaboratoryOrDesignOffice,
  ExternalProductGroup,
  HasEmptiesBOM,
  ProductValidEndDate,
  ValidityStartDate,
  AuthorizationGroup,
  PackagingMaterialGroup,
  IsBatchManagementRequired,
  ProductIsConfigurable,
  DocumentIsCreatedByCAD,
  ProductHierarchy,
  ProductMeasurementUnit,
  BaseUnitSpecificProductHeight,
  BaseUnitSpecificProductWidth,
  BaseUnitSpecificProductLength,
  InternationalArticleNumberCat,
  ProductStandardID,
  CompetitorID,
  Division,
  VolumeUnit,
  MaterialVolume,
  WeightUnit,
  NetWeight,
  GrossWeight,
  LastChangeDateTime,
  HasActiveEntity,
  DraftEntityCreationDateTime,
  DraftEntityLastChangeDateTime,
  DraftAdministrativeDataUUID,
  DraftEntityOperationCode,
  DraftFieldChanges
FROM mara_gov_dft
;

Learn More