P_PRODUCTD

CDS View

P_PRODUCTD is a CDS View in S/4HANA. It contains 73 fields. 26 CDS views read from this table.

Used by 26 CDS view(s) 73 fields

CDS Views using this table (26)

ViewTypeJoinVDMDescription
P_ProductDescriptionWD view inner COMPOSITE
P_Productmlaccountwd view inner COMPOSITE
P_Productplantprocurementwd view inner COMPOSITE
P_Productplantqtmanagement view inner COMPOSITE
P_Productplantsaleswd view inner COMPOSITE
P_Productplantstoragewd view inner COMPOSITE
P_Productplanttextwd view inner COMPOSITE
P_Productprocurementwd view inner COMPOSITE
P_ProductPurchaseTaxWD view inner COMPOSITE
P_Productqmwd view inner COMPOSITE
P_Productsalesdeliveryposwd view inner COMPOSITE
P_ProductSalesDeliveryWD view inner COMPOSITE
P_ProductSalesWD view inner COMPOSITE
P_ProductStorageLocationWD view inner COMPOSITE
P_ProductStorageWD view inner COMPOSITE
P_Productsuppliereanwd view inner COMPOSITE
P_ProductSupplyPlanningWD view inner COMPOSITE
P_Producttextswd view inner COMPOSITE
P_Productunitofmeasuretextwd view inner COMPOSITE
P_Productunitomeasureeanwd view left_outer COMPOSITE
P_Productunitomeasureeanwd view inner COMPOSITE
P_ProductUnitsOfMeasureWD view inner COMPOSITE
P_ProductValuationWD view inner COMPOSITE
P_ProductWD view left_outer COMPOSITE
P_ProductWD view union_all COMPOSITE
P_ProductWorkSchedulingWD view inner COMPOSITE

Fields (73)

KeyField CDS FieldsUsed in Views
KEY Activeproduct Activeproduct 2
anpcode anpcode 1
articlecategory articlecategory 1
assortmentgrade assortmentgrade 1
assortmentlisttype assortmentlisttype 1
baseunit baseunit 1
baseunitspecificproductheight baseunitspecificproductheight 1
baseunitspecificproductlength baseunitspecificproductlength 1
baseunitspecificproductwidth baseunitspecificproductwidth 1
brand brand 1
commoditiycodenumberunit commoditiycodenumberunit 1
commoditycode commoditycode 1
comparisonpricequantity comparisonpricequantity 1
competitorid competitorid 1
consumptionvaluecategory consumptionvaluecategory 1
contentunit contentunit 1
countryoforigin countryoforigin 1
createdbyuser createdbyuser 1
creationdate creationdate 1
crossplantconfigurableproduct crossplantconfigurableproduct 1
crossplantstatus crossplantstatus 1
crossplantstatusvaliditydate crossplantstatusvaliditydate 1
distrcntrlistingenddate distrcntrlistingenddate 1
distrcntrlistingprocedure distrcntrlistingprocedure 1
distrcntrlistingstartdate distrcntrlistingstartdate 1
distrcntrsaleenddate distrcntrsaleenddate 1
distrcntrsalestartdate distrcntrsalestartdate 1
division division 1
externalproductgroup externalproductgroup 1
goodsissueunit goodsissueunit 1
grosscontent grosscontent 1
grossweight grossweight 1
hastextilepartswthanimalorigin hastextilepartswthanimalorigin 1
industrystandardname industrystandardname 1
internationalarticlenumbercat internationalarticlenumbercat 1
isbatchmanagementrequired isbatchmanagementrequired 1
itemcategorygroup itemcategorygroup 1
lastchangedate lastchangedate 1
lastchangedbyuser lastchangedbyuser 1
lowlevelcode lowlevelcode 1
manufacturerpartprofile manufacturerpartprofile 1
materialvolume materialvolume 1
netcontent netcontent 1
netweight netweight 1
prodnoingenprodinprepackprod prodnoingenprodinprepackprod 1
product product 21
productgroup productgroup 1
producthierarchy producthierarchy 1
productisconfigurable productisconfigurable 1
productmanufacturernumber productmanufacturernumber 1
productmeasurementunit productmeasurementunit 1
productoldid productoldid 1
productseasonusagecategory productseasonusagecategory 1
productstandardid productstandardid 1
producttype producttype 1
productvalidenddate productvalidenddate 1
productvalidstartdate productvalidstartdate 1
purchaseorderquantityunit purchaseorderquantityunit 1
regionoforigin regionoforigin 1
serialidentifierassgmtprofile serialidentifierassgmtprofile 1
serialnoexplicitnesslevel serialnoexplicitnesslevel 1
serviceagreement serviceagreement 1
sizeordimensiontext sizeordimensiontext 1
storelistingenddate storelistingenddate 1
storelistingprocedure storelistingprocedure 1
storelistingstartdate storelistingstartdate 1
storesaleenddate storesaleenddate 1
storesalestartdate storesalestartdate 1
validitystartdate validitystartdate 1
valuationclass valuationclass 1
valuationmargin valuationmargin 1
volumeunit volumeunit 1
weightunit weightunit 1 
// Product Root (draft)

@AbapCatalog.sqlViewName: 'PPRODUCTD'
@VDM.private: true
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #NOT_REQUIRED
define view P_ProductD
  as select from prd_root as DraftDocument
{
  key DraftDocument.draftkey              as Draftkey,
      DraftDocument.activeproduct         as Activeproduct,
      DraftDocument.hasactiveentity       as HasActiveEntity,
      DraftDocument.product,
      DraftDocument.producttype,
      DraftDocument.crossplantstatus,
      DraftDocument.crossplantstatusvaliditydate,
      DraftDocument.creationdate,
      DraftDocument.createdbyuser,
      DraftDocument.lastchangedate,
      DraftDocument.lastchangedbyuser,
      DraftDocument.ismarkedfordeletion,
      DraftDocument.productoldid,
      DraftDocument.grossweight,
      DraftDocument.purchaseorderquantityunit,
      DraftDocument.sourceofsupply,
      DraftDocument.weightunit,
      DraftDocument.countryoforigin,
      DraftDocument.competitorid,
      DraftDocument.productgroup,
      DraftDocument.baseunit,
      DraftDocument.itemcategorygroup,
      DraftDocument.netweight,
      DraftDocument.producthierarchy,
      DraftDocument.division,
      DraftDocument.varblpurordunitisactive,
      DraftDocument.volumeunit,
      DraftDocument.materialvolume,
      DraftDocument.anpcode,
      //      DraftDocument.productcategory,

      DraftDocument.brand,
      DraftDocument.procurementrule,
      DraftDocument.validitystartdate,
      DraftDocument.lowlevelcode,
      DraftDocument.prodnoingenprodinprepackprod,
      DraftDocument.serialidentifierassgmtprofile,
      DraftDocument.sizeordimensiontext,
      DraftDocument.industrystandardname,
      DraftDocument.productstandardid,
      DraftDocument.internationalarticlenumbercat,
      DraftDocument.productisconfigurable,
      DraftDocument.isbatchmanagementrequired,
      DraftDocument.externalproductgroup,
      DraftDocument.crossplantconfigurableproduct,
      DraftDocument.serialnoexplicitnesslevel,
      DraftDocument.productmanufacturernumber,
      DraftDocument.manufacturerpartprofile,


      //      Retail Fields


      DraftDocument.baseunitspecificproductlength,
      DraftDocument.baseunitspecificproductwidth,
      DraftDocument.baseunitspecificproductheight,
      DraftDocument.productmeasurementunit,
      DraftDocument.productvalidstartdate,
      DraftDocument.articlecategory,
      DraftDocument.contentunit,
      DraftDocument.netcontent,
      DraftDocument.comparisonpricequantity,
      DraftDocument.grosscontent,
      DraftDocument.productvalidenddate,
      DraftDocument.assortmentlisttype,
      DraftDocument.hastextilepartswthanimalorigin,
      DraftDocument.productseasonusagecategory,
      DraftDocument.serviceagreement,
      DraftDocument.consumptionvaluecategory, // ref. handling for MARC

      DraftDocument.goodsissueunit, // ref. handling for MARC

      //      DraftDocument.countryoforigin,     // ref. handling for MARC

      DraftDocument.regionoforigin, // ref. handling for MARC

      DraftDocument.assortmentgrade,
      DraftDocument.storelistingprocedure,
      DraftDocument.distrcntrlistingprocedure,
      DraftDocument.storelistingstartdate,
      DraftDocument.storelistingenddate,
      DraftDocument.distrcntrlistingstartdate,
      DraftDocument.distrcntrlistingenddate,
      DraftDocument.storesalestartdate,
      DraftDocument.storesaleenddate,
      DraftDocument.distrcntrsalestartdate,
      DraftDocument.distrcntrsaleenddate,
      DraftDocument.valuationclass,  // ref. handling for MBEW

      DraftDocument.commoditycode,
      DraftDocument.valuationmargin, // ref. handling for MBEW

      DraftDocument.commoditiycodenumberunit





} 
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"PRD_ROOT"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More