PRODUCT

79 Fields

PRODUCT is an SAP database table in S/4HANA. It contains 79 fields.

Fields (79)

KeyField CDS FieldsUsed in Views
KEY BusinessPartner BusinessPartner 2
KEY ChangeNumber ChangeNumber 2
KEY IndlSystProductIndividual IndlSystProductIndividual 1
KEY IndlSystUUID IndlSystUUID 1
KEY MasterDataChangeProcess MasterDataChangeProcess 1
KEY MDChgProcessSrceObject MDChgProcessSrceObject 1
KEY MDChgProcessSrceSystem MDChgProcessSrceSystem 1
KEY MDChgProcessStep MDChgProcessStep 1
KEY Plant Plant 2
KEY Product Product 23
KEY ProductDistributionChnl ProductDistributionChnl 2
KEY ProductSalesOrg ProductSalesOrg 2
KEY ValuationArea ValuationArea 2
KEY ValuationType ValuationType 2
_ChangeMaster _ChangeMaster 2
_CrossPlantConfigurableProduct _CrossPlantConfigurableProduct 1
_Product _Product 10
_ProductCategory _ProductCategory 2
_ProductGroup _ProductGroup 2
_ProductGroup_2 _ProductGroup_2 6
_ProductType _ProductType 6
_Text _Text 14
AlternativeUnit AlternativeUnit 2
AuthorizationGroup AuthorizationGroup 6
BaseUnit BaseUnit 4
brgew ProductGrossWeight 2
ChangeNumberValidFromDate ChangeNumberValidFromDate 2
ConversionFactor ConversionFactor 2
DfsAmmunitionGroupCode DfsAmmunitionGroupCode 1
DfsLogisticsLevel DfsLogisticsLevel 1
DfsManufacturerPartLongNumber DfsManufacturerPartLongNumber 1
DfsMatlConditionMgmt DfsMatlConditionMgmt 1
DfsNationalItemIdnNumber DfsNationalItemIdnNumber 1
DfsProductSensitivity DfsProductSensitivity 1
DfsReturnDelivery DfsReturnDelivery 1
DfsRICIdentifier DfsRICIdentifier 1
Division Division 4
ExternalProductGroup ExternalProductGroup 4
gewei WeightUnit 2
ii_quantity_emo ii_quantity_emo 1
ii_unit_emo ii_unit_emo 1
IndlSystProdIndivIsDeleted IndlSystProdIndivIsDeleted 1
IndlSystProductIndividualType IndlSystProductIndividualType 1
IndustrySector IndustrySector 4
LoadingGroup LoadingGroup 2
MaterialRevisionLevel MaterialRevisionLevel 2
MaterialType MaterialType 2
matkl ProductGroup 2
matnr Product 2
matnr_external ProductExternalID 2
measureUnit QuantityUnitCode 1
meins ProductBaseUnit 2
MRPResponsible MRPResponsible 2
MRPType MRPType 2
mtart ProductType 2
ntgew ProductNetWeight 2
ObjMgmtRecdObjectInternalID ObjMgmtRecdObjectInternalID 2
PlantCategory PlantCategory 2
ProductCategory ProductCategory 6
ProductExternalID ProductExternalID 4
ProductGroup ProductGroup 15
ProductHierarchy ProductHierarchy 4
ProductName ProductName 4
ProductStandardID ProductStandardID 5
ProductType MaterialType,ProductType 10
ProductUUID ProductUUID 2
PurchasingGroup PurchasingGroup 2
QuantityDenominator QuantityDenominator 1
QuantityNumerator QuantityNumerator 1
RO_SAFTGoodsService RO_SAFTGoodsService 2
SourceUnitOfMeasureFactor SourceUnitOfMeasureFactor 2
TrdClassfctnNmbrSchmCntnt TrdClassfctnNmbrSchmCntnt 4
TrdClassfctnRemark TrdClassfctnRemark 1
ValidityEndDate ValidityEndDate 4
ValidityStartDate ValidityStartDate 4
ValuationClass ValuationClass 4
voleh VolumeUnit 2
volum ProductVolume 2
weightUnit WeightUnitCode 1

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 (
    BUSINESSPARTNER,
    CHANGENUMBER,
    INDLSYSTPRODUCTINDIVIDUAL,
    INDLSYSTUUID,
    MASTERDATACHANGEPROCESS,
    MDCHGPROCESSSRCEOBJECT,
    MDCHGPROCESSSRCESYSTEM,
    MDCHGPROCESSSTEP,
    PLANT,
    PRODUCT,
    PRODUCTDISTRIBUTIONCHNL,
    PRODUCTSALESORG,
    VALUATIONAREA,
    VALUATIONTYPE,
    _CHANGEMASTER,
    _CROSSPLANTCONFIGURABLEPRODUCT,
    _PRODUCT,
    _PRODUCTCATEGORY,
    _PRODUCTGROUP,
    _PRODUCTGROUP_2,
    _PRODUCTTYPE,
    _TEXT,
    ALTERNATIVEUNIT,
    AUTHORIZATIONGROUP,
    BASEUNIT,
    BRGEW,
    CHANGENUMBERVALIDFROMDATE,
    CONVERSIONFACTOR,
    DFSAMMUNITIONGROUPCODE,
    DFSLOGISTICSLEVEL,
    DFSMANUFACTURERPARTLONGNUMBER,
    DFSMATLCONDITIONMGMT,
    DFSNATIONALITEMIDNNUMBER,
    DFSPRODUCTSENSITIVITY,
    DFSRETURNDELIVERY,
    DFSRICIDENTIFIER,
    DIVISION,
    EXTERNALPRODUCTGROUP,
    GEWEI,
    II_QUANTITY_EMO,
    II_UNIT_EMO,
    INDLSYSTPRODINDIVISDELETED,
    INDLSYSTPRODUCTINDIVIDUALTYPE,
    INDUSTRYSECTOR,
    LOADINGGROUP,
    MATERIALREVISIONLEVEL,
    MATERIALTYPE,
    MATKL,
    MATNR,
    MATNR_EXTERNAL,
    MEASUREUNIT,
    MEINS,
    MRPRESPONSIBLE,
    MRPTYPE,
    MTART,
    NTGEW,
    OBJMGMTRECDOBJECTINTERNALID,
    PLANTCATEGORY,
    PRODUCTCATEGORY,
    PRODUCTEXTERNALID,
    PRODUCTGROUP,
    PRODUCTHIERARCHY,
    PRODUCTNAME,
    PRODUCTSTANDARDID,
    PRODUCTTYPE,
    PRODUCTUUID,
    PURCHASINGGROUP,
    QUANTITYDENOMINATOR,
    QUANTITYNUMERATOR,
    RO_SAFTGOODSSERVICE,
    SOURCEUNITOFMEASUREFACTOR,
    TRDCLASSFCTNNMBRSCHMCNTNT,
    TRDCLASSFCTNREMARK,
    VALIDITYENDDATE,
    VALIDITYSTARTDATE,
    VALUATIONCLASS,
    VOLEH,
    VOLUM,
    WEIGHTUNIT,
    PRIMARY KEY (BUSINESSPARTNER, CHANGENUMBER, INDLSYSTPRODUCTINDIVIDUAL, INDLSYSTUUID, MASTERDATACHANGEPROCESS, MDCHGPROCESSSRCEOBJECT, MDCHGPROCESSSRCESYSTEM, MDCHGPROCESSSTEP, PLANT, PRODUCT, PRODUCTDISTRIBUTIONCHNL, PRODUCTSALESORG, VALUATIONAREA, VALUATIONTYPE)
);

Learn More