_PRODUCT

_PRODUCT is an SAP database table in S/4HANA. It contains 212 fields.

Fields (212)

KeyField CDS FieldsUsed in Views
KEY CrossPlantConfigurableProduct CrossPlantConfigurableProduct 10
KEY MasterDataChangeProcess MasterDataChangeProcess 1
KEY MDChgProcessSrceObject MDChgProcessSrceObject 1
KEY MDChgProcessSrceSystem MDChgProcessSrceSystem 1
KEY MDChgProcessStep MDchgProcessStep 1
KEY ProdSupChnMgmtUUID22 AdvncdPlngProductID 1
KEY Product AdvancedPlanningProductName,Material,PackagingMaterial,Product,RecordIdentificationText 36
_AdjustmentProfile_2 _AdjustmentProfile_2 1
_AdjustmentProfileText_2 _AdjustmentProfileText_2 1
_ArticleCategoryText _ArticleCategoryText 1
_AssortmentListType _AssortmentListType 1
_AssortmentListTypeText _AssortmentListTypeText 1
_BaseUnitOfMeasure _BaseUnitOfMeasure 15
_BaseUnitOfMeasureText _BaseUnitOfMeasureText 8
_Brand _Brand 1
_BrandText _BrandText 1
_ConsumptionValueCategory _ConsumptionValueCategory 1
_ConsumptionValueCategoryText _ConsumptionValueCategoryText 1
_ContentUnit _ContentUnit 1
_CountryOfOriginText _CountryOfOriginText 1
_CrossPlantConfigurableProduct _CrossPlantConfigurableProduct 1
_Division _Division 4
_DivisionText _DivisionText 8
_ExternalProductGroup _ExternalProductGroup 1
_ExtProdGrpText _ExtProdGrpText 8
_GoodsIssueText _GoodsIssueText 1
_GoodsIssueUnit _GoodsIssueUnit 1
_HandlingIndicator _HandlingIndicator 1
_HandlingIndicatorText _HandlingIndicatorText 1
_IntArticleNumberText _IntArticleNumberText 8
_InternationalArticleNumberCat _InternationalArticleNumberCat 1
_ItemCategoryGroupText _ItemCategoryGroupText 7
_ManufacturerPartProfileText _ManufacturerPartProfileText 1
_MaterialCategory _MaterialCategory 1
_ProductCategory _ProductCategory 3
_ProductCategoryText _ProductCategoryText 1
_ProductGroup _MaterialGroup,_ProductGroup 8
_ProductGroup_2 _ProductGroup_2 9
_ProductGroupText _ProductGroupText 1
_ProductGroupText_2 _ProductGroupText_2 10
_ProductHierarchy _ProductHierarchy 2
_ProductHierarchyText _ProductHierarchyText 1
_ProductMeasurementUnit _ProductMeasurementUnit 1
_ProductStatus _ProductStatus 2
_ProductStatusText _ProductStatusText 8
_ProductType _MaterialType,_ProductType 14
_ProductTypeName _ProductTypeName 4
_ProductTypeName_2 _ProductTypeName_2 7
_ProductUnitOfMeasureVH _ProductUnitOfMeasureVH 1
_ProductValueAddedTax _ProductValueAddedTax 1
_QualityInspectionGroup _QualityInspectionGroup 1
_QualityInspectionGroupText _QualityInspectionGroupText 1
_QuantityUnitText _QuantityUnitText 1
_QuantityUnitValueHelp _QuantityUnitValueHelp 1
_RegionText _RegionText 1
_SerialNoText _SerialNoText 1
_SerialNumberProfile _SerialNumberProfile 1
_SerialNumberProfileText _SerialNumberProfileText 1
_StandardHandlingUnitType _StandardHandlingUnitType 1
_StandardHandlingUnitTypeText _StandardHandlingUnitTypeText 1
_Text _Text 3
_TimeUnitForQuarantinePeriod _TimeUnitForQuarantinePeriod 1
_TimeUnitQuarantinePeriodText _TimeUnitQuarantinePeriodText 1
_UnitForMaxPackaging _UnitForMaxPackaging 1
_UnitForMaxPackagingText _UnitForMaxPackagingText 1
_WarehouseProductGroup _WarehouseProductGroup 1
_WarehouseProductGroupText _WarehouseProductGroupText 1
_WarehouseStorageCondition _WarehouseStorageCondition 1
_WarehouseStorageConditionText _WarehouseStorageConditionText 1
_WeightUnitText _WeightUnitText 1
_WeightUnitValueHelp _WeightUnitValueHelp 1
AdjustmentProfile AdjustmentProfile 2
AdvancedPlanningMaterialGroup AdvancedPlanningMaterialGroup 1
AdvncdPlngAccountAssgmtObj AdvncdPlngAccountAssgmtObj 1
AdvncdPlngATPGroup AdvncdPlngATPGroup 1
AdvncdPlngLowLevelCode AdvncdPlngLowLevelCode 1
AdvncdPlngProcurementType AdvncdPlngProcurementType 1
AdvncdPlngProdGrossWeight AdvncdPlngProdGrossWeight 1
AdvncdPlngProdPurchasingGroup AdvncdPlngProdPurchasingGroup 1
AdvncdPlngProductVolume AdvncdPlngProductVolume 1
AdvncdPlngProductVolumeUoM AdvncdPlngProductVolumeUoM 1
AdvncdPlngProdWeightUoM AdvncdPlngProdWeightUoM 1
ANPCode ANPCode 2
ArticleCategory ArticleCategory 3
AssortmentListType AssortmentListType 2
AuthorizationGroup AuthorizationGroup,MaterialAuthorizationGroup,ProductAuthorizationGroup 33
BaseUnit BaseUnit,MaterialBaseUnit,meins,ProdHierNodeBaseUnit,QuantityUnit,VarConfignBundleCompUnit 68
BaseUnitSpecificProductHeight BaseUnitSpecificProductHeight 6
BaseUnitSpecificProductLength BaseUnitSpecificProductLength 6
BaseUnitSpecificProductWidth BaseUnitSpecificProductWidth 6
BasicMaterial BasicMaterial 1
Brand Brand 2
ChangeNumber ChangeNumber 2
ComparisonPriceQuantity ComparisonPriceQuantity 2
CompetitorID CompetitorID 2
ConsumptionValueCategory ConsumptionValueCategory 2
ContentUnit ContentUnit 2
CountryOfOrigin CountryOfOrigin 2
CreatedByUser CreatedByUser,ProdHierNodeCreatedByUser 12
CreatedByUserName CreatedByUserName 2
CreationDate CreationDate,ProdHierNodeCreationDate,productcreationdate 15
CrossPlantStatus CrossPlantStatus 10
CrossPlantStatusValidityDate CrossPlantStatusValidityDate 5
Currency Currency 1
DangerousGoodsIndProfile DangerousGoodsIndProfile 4
DDScopeProduct DDScopeProduct 1
DiscountInKindEligibility DiscountInKindEligibility 1
Division ActiveDivision,Division 17
effectivefrom productEffectivefrom 2
effectiveto productEffectiveTo 2
ExternalProductGroup ExternalProductGroup 12
FldLogsIsSinglePlant FldLogsIsSinglePlant 1
FldLogsRetOutbDelivIsCreated FldLogsRetOutbDelivIsCreated 1
GoodsIssueUnit GoodsIssueUnit 2
GrossContent GrossContent 2
GrossWeight GrossWeight 6
HandlingIndicator HandlingIndicator 3
HandlingUnitType HandlingUnitType 2
HasEmptiesBOM HasEmptiesBOM 10
HasTextilePartsWthAnimalOrigin HasTextilePartsWthAnimalOrigin 9
HasVariableTareWeight HasVariableTareWeight 9
IndustrySector IndustrySector 8
IndustryStandardName IndustryStandardName 9
InternationalArticleNumberCat InternationalArticleNumberCat 9
IsApprovedBatchRecordReqd IsApprovedBatchRecordReqd 1
IsBatchManagementRequired IsBatchManagementRequired 15
IsMarkedForDeletion IsMarkedForDeletion,IsMarkedForDeletionProduct,MaterialIsMarkedForDeletion 12
IsPilferable IsPilferable 10
IsRelevantForHzdsSubstances IsRelevantForHzdsSubstances 9
ItemCategoryGroup ItemCategoryGroup 10
LaboratoryOrDesignOffice LaboratoryOrDesignOffice 7
LastChangeDate LastChangeDate,ProdHierNodeLastChangeDate 11
LastChangeDateTime LastChangeDateTime 3
LastChangedByUser LastChangedByUser,ProdHierNodeLastChangedByUser 11
LastChangedByUserName LastChangedByUserName 2
LastChangeTime LastChangeTime 10
locationuuid productsLocationUuid 2
LowLevelCode LowLevelCode 9
MajorProduct MajorProduct 2
ManufacturerNumber ManufacturerNumber,MaterialManufacturerNumber 3
ManufacturerPartProfile ManufacturerPartProfile 2
MaterialGroup MaterialGroup 1
MaterialName MaterialName 1
MaterialRevisionLevel MaterialRevisionLevel 2
MaterialVolume MaterialVolume 7
MaximumCapacity MaximumCapacity 2
MaximumPackagingHeight MaximumPackagingHeight 2
MaximumPackagingLength MaximumPackagingLength 2
MaximumPackagingWidth MaximumPackagingWidth 2
MDChgProcessActivationTarget MDChgProcessActivationTarget 4
MDChgProcessReplicationStatus MDChgProcessReplicationStatus 4
MDChgProcessValidationStatus MDChgProcessValidationStatus 4
MinorProduct MinorProduct 2
MRPController MRPController 1
MRPProcedure MRPProcedure 1
NetContent NetContent 2
NetWeight NetWeight 5
OvercapacityTolerance OvercapacityTolerance 2
PackagingMaterialGroup PackagingMaterialGroup 1
Plant Plant 1
ProcurementType MaterialProcurementType 1
ProdEffctyParamValsAreAssigned BOMIsParamEffectivityRelevant 1
ProdNoInGenProdInPrepackProd ProdNoInGenProdInPrepackProd 9
ProductAuthorizationGroup ProductAuthorizationGroup 1
ProductCategory ArticleCategory,MaterialCategory,ProductCategory 10
ProductCharacteristic1 ProductCharacteristic1 5
ProductCharacteristic2 ProductCharacteristic2 5
ProductCharacteristic3 ProductCharacteristic3 5
ProductConfiguration ProductConfiguration 1
ProductDescription ProdHierNodeProductDesc,ProductDescription 8
ProductExternalID ProductExternalID 8
ProductGroup MaterialGroup,ProdHierNodeProductGroup,ProductGroup 57
ProductHierarchy ProdHierNodeProductHierarchy,ProductHierarchy 19
ProductInternalUUID ProductInternalUUID 1
ProductIsConfigurable IsConfiguredMaterial,MaterialIsConfigurable,ProductIsConfigurable 14
ProductIsLocked ProductIsLocked 1
ProductManufacturerNumber MaterialManufacturerPartNumber,ProductManufacturerNumber 3
ProductMeasurementUnit ProductMeasurementUnit 6
ProductName ProductName 3
ProductOldID ProductOldID 9
ProductSeasonUsageCategory ProductSeasonUsageCategory 10
ProductStandardID ProdHierNodeProductStdID,ProductStandardID 18
ProductType MaterialType,ProdHierNodeProductType,ProductType 43
ProductUUID product_key,ProductUUID 3
ProductValidEndDate ProductValidEndDate 2
ProductValueAddedTax ProductValueAddedTax 1
PurchaseOrderQuantityUnit PurchaseOrderQuantityUnit 4
QualityInspectionGroup QualityInspectionGroup 9
QuarantinePeriod QuarantinePeriod 2
RegionOfOrigin RegionOfOrigin 2
SalesProduct SalesProduct 1
SalesStatus SalesStatus 1
SalesStatusValidityDate SalesStatusValidityDate 4
SegmentationIsRelevant SegmentationIsRelevant 2
SegmentationStrategy SegmentationStrategy 2
SerialIdentifierAssgmtProfile SerialIdentifierAssgmtProfile 2
SerialNoExplicitnessLevel SerialNoExplicitnessLevel 9
SerialNumberProfile SerialNumberProfile 3
ServiceAgreement ServiceAgreement 2
SizeOrDimensionText SizeOrDimensionText 4
StandardHandlingUnitType StandardHandlingUnitType 2
TimeUnitForQuarantinePeriod TimeUnitForQuarantinePeriod 2
UnitForMaxPackagingDimensions UnitForMaxPackagingDimensions 2
UtilitiesProduct UtilitiesProduct 1
UtilsProductType UtilsProductType 1
ValidityStartDate ValidityStartDate 2
ValuationClass ValuationClass 2
ValuationMargin ValuationMargin 2
VolumeUnit VolumeUnit 7
WarehouseProductGroup WarehouseProductGroup 10
WarehouseStorageCondition WarehouseStorageCondition 10
WeightUnit WeightUnit 6

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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE _PRODUCT (
    CROSSPLANTCONFIGURABLEPRODUCT,
    MASTERDATACHANGEPROCESS,
    MDCHGPROCESSSRCEOBJECT,
    MDCHGPROCESSSRCESYSTEM,
    MDCHGPROCESSSTEP,
    PRODSUPCHNMGMTUUID22,
    PRODUCT,
    _ADJUSTMENTPROFILE_2,
    _ADJUSTMENTPROFILETEXT_2,
    _ARTICLECATEGORYTEXT,
    _ASSORTMENTLISTTYPE,
    _ASSORTMENTLISTTYPETEXT,
    _BASEUNITOFMEASURE,
    _BASEUNITOFMEASURETEXT,
    _BRAND,
    _BRANDTEXT,
    _CONSUMPTIONVALUECATEGORY,
    _CONSUMPTIONVALUECATEGORYTEXT,
    _CONTENTUNIT,
    _COUNTRYOFORIGINTEXT,
    _CROSSPLANTCONFIGURABLEPRODUCT,
    _DIVISION,
    _DIVISIONTEXT,
    _EXTERNALPRODUCTGROUP,
    _EXTPRODGRPTEXT,
    _GOODSISSUETEXT,
    _GOODSISSUEUNIT,
    _HANDLINGINDICATOR,
    _HANDLINGINDICATORTEXT,
    _INTARTICLENUMBERTEXT,
    _INTERNATIONALARTICLENUMBERCAT,
    _ITEMCATEGORYGROUPTEXT,
    _MANUFACTURERPARTPROFILETEXT,
    _MATERIALCATEGORY,
    _PRODUCTCATEGORY,
    _PRODUCTCATEGORYTEXT,
    _PRODUCTGROUP,
    _PRODUCTGROUP_2,
    _PRODUCTGROUPTEXT,
    _PRODUCTGROUPTEXT_2,
    _PRODUCTHIERARCHY,
    _PRODUCTHIERARCHYTEXT,
    _PRODUCTMEASUREMENTUNIT,
    _PRODUCTSTATUS,
    _PRODUCTSTATUSTEXT,
    _PRODUCTTYPE,
    _PRODUCTTYPENAME,
    _PRODUCTTYPENAME_2,
    _PRODUCTUNITOFMEASUREVH,
    _PRODUCTVALUEADDEDTAX,
    _QUALITYINSPECTIONGROUP,
    _QUALITYINSPECTIONGROUPTEXT,
    _QUANTITYUNITTEXT,
    _QUANTITYUNITVALUEHELP,
    _REGIONTEXT,
    _SERIALNOTEXT,
    _SERIALNUMBERPROFILE,
    _SERIALNUMBERPROFILETEXT,
    _STANDARDHANDLINGUNITTYPE,
    _STANDARDHANDLINGUNITTYPETEXT,
    _TEXT,
    _TIMEUNITFORQUARANTINEPERIOD,
    _TIMEUNITQUARANTINEPERIODTEXT,
    _UNITFORMAXPACKAGING,
    _UNITFORMAXPACKAGINGTEXT,
    _WAREHOUSEPRODUCTGROUP,
    _WAREHOUSEPRODUCTGROUPTEXT,
    _WAREHOUSESTORAGECONDITION,
    _WAREHOUSESTORAGECONDITIONTEXT,
    _WEIGHTUNITTEXT,
    _WEIGHTUNITVALUEHELP,
    ADJUSTMENTPROFILE,
    ADVANCEDPLANNINGMATERIALGROUP,
    ADVNCDPLNGACCOUNTASSGMTOBJ,
    ADVNCDPLNGATPGROUP,
    ADVNCDPLNGLOWLEVELCODE,
    ADVNCDPLNGPROCUREMENTTYPE,
    ADVNCDPLNGPRODGROSSWEIGHT,
    ADVNCDPLNGPRODPURCHASINGGROUP,
    ADVNCDPLNGPRODUCTVOLUME,
    ADVNCDPLNGPRODUCTVOLUMEUOM,
    ADVNCDPLNGPRODWEIGHTUOM,
    ANPCODE,
    ARTICLECATEGORY,
    ASSORTMENTLISTTYPE,
    AUTHORIZATIONGROUP,
    BASEUNIT,
    BASEUNITSPECIFICPRODUCTHEIGHT,
    BASEUNITSPECIFICPRODUCTLENGTH,
    BASEUNITSPECIFICPRODUCTWIDTH,
    BASICMATERIAL,
    BRAND,
    CHANGENUMBER,
    COMPARISONPRICEQUANTITY,
    COMPETITORID,
    CONSUMPTIONVALUECATEGORY,
    CONTENTUNIT,
    COUNTRYOFORIGIN,
    CREATEDBYUSER,
    CREATEDBYUSERNAME,
    CREATIONDATE,
    CROSSPLANTSTATUS,
    CROSSPLANTSTATUSVALIDITYDATE,
    CURRENCY,
    DANGEROUSGOODSINDPROFILE,
    DDSCOPEPRODUCT,
    DISCOUNTINKINDELIGIBILITY,
    DIVISION,
    EFFECTIVEFROM,
    EFFECTIVETO,
    EXTERNALPRODUCTGROUP,
    FLDLOGSISSINGLEPLANT,
    FLDLOGSRETOUTBDELIVISCREATED,
    GOODSISSUEUNIT,
    GROSSCONTENT,
    GROSSWEIGHT,
    HANDLINGINDICATOR,
    HANDLINGUNITTYPE,
    HASEMPTIESBOM,
    HASTEXTILEPARTSWTHANIMALORIGIN,
    HASVARIABLETAREWEIGHT,
    INDUSTRYSECTOR,
    INDUSTRYSTANDARDNAME,
    INTERNATIONALARTICLENUMBERCAT,
    ISAPPROVEDBATCHRECORDREQD,
    ISBATCHMANAGEMENTREQUIRED,
    ISMARKEDFORDELETION,
    ISPILFERABLE,
    ISRELEVANTFORHZDSSUBSTANCES,
    ITEMCATEGORYGROUP,
    LABORATORYORDESIGNOFFICE,
    LASTCHANGEDATE,
    LASTCHANGEDATETIME,
    LASTCHANGEDBYUSER,
    LASTCHANGEDBYUSERNAME,
    LASTCHANGETIME,
    LOCATIONUUID,
    LOWLEVELCODE,
    MAJORPRODUCT,
    MANUFACTURERNUMBER,
    MANUFACTURERPARTPROFILE,
    MATERIALGROUP,
    MATERIALNAME,
    MATERIALREVISIONLEVEL,
    MATERIALVOLUME,
    MAXIMUMCAPACITY,
    MAXIMUMPACKAGINGHEIGHT,
    MAXIMUMPACKAGINGLENGTH,
    MAXIMUMPACKAGINGWIDTH,
    MDCHGPROCESSACTIVATIONTARGET,
    MDCHGPROCESSREPLICATIONSTATUS,
    MDCHGPROCESSVALIDATIONSTATUS,
    MINORPRODUCT,
    MRPCONTROLLER,
    MRPPROCEDURE,
    NETCONTENT,
    NETWEIGHT,
    OVERCAPACITYTOLERANCE,
    PACKAGINGMATERIALGROUP,
    PLANT,
    PROCUREMENTTYPE,
    PRODEFFCTYPARAMVALSAREASSIGNED,
    PRODNOINGENPRODINPREPACKPROD,
    PRODUCTAUTHORIZATIONGROUP,
    PRODUCTCATEGORY,
    PRODUCTCHARACTERISTIC1,
    PRODUCTCHARACTERISTIC2,
    PRODUCTCHARACTERISTIC3,
    PRODUCTCONFIGURATION,
    PRODUCTDESCRIPTION,
    PRODUCTEXTERNALID,
    PRODUCTGROUP,
    PRODUCTHIERARCHY,
    PRODUCTINTERNALUUID,
    PRODUCTISCONFIGURABLE,
    PRODUCTISLOCKED,
    PRODUCTMANUFACTURERNUMBER,
    PRODUCTMEASUREMENTUNIT,
    PRODUCTNAME,
    PRODUCTOLDID,
    PRODUCTSEASONUSAGECATEGORY,
    PRODUCTSTANDARDID,
    PRODUCTTYPE,
    PRODUCTUUID,
    PRODUCTVALIDENDDATE,
    PRODUCTVALUEADDEDTAX,
    PURCHASEORDERQUANTITYUNIT,
    QUALITYINSPECTIONGROUP,
    QUARANTINEPERIOD,
    REGIONOFORIGIN,
    SALESPRODUCT,
    SALESSTATUS,
    SALESSTATUSVALIDITYDATE,
    SEGMENTATIONISRELEVANT,
    SEGMENTATIONSTRATEGY,
    SERIALIDENTIFIERASSGMTPROFILE,
    SERIALNOEXPLICITNESSLEVEL,
    SERIALNUMBERPROFILE,
    SERVICEAGREEMENT,
    SIZEORDIMENSIONTEXT,
    STANDARDHANDLINGUNITTYPE,
    TIMEUNITFORQUARANTINEPERIOD,
    UNITFORMAXPACKAGINGDIMENSIONS,
    UTILITIESPRODUCT,
    UTILSPRODUCTTYPE,
    VALIDITYSTARTDATE,
    VALUATIONCLASS,
    VALUATIONMARGIN,
    VOLUMEUNIT,
    WAREHOUSEPRODUCTGROUP,
    WAREHOUSESTORAGECONDITION,
    WEIGHTUNIT,
    PRIMARY KEY (CROSSPLANTCONFIGURABLEPRODUCT, MASTERDATACHANGEPROCESS, MDCHGPROCESSSRCEOBJECT, MDCHGPROCESSSRCESYSTEM, MDCHGPROCESSSTEP, PRODSUPCHNMGMTUUID22, PRODUCT)
);