P_PRODUCTSALESDELIVERYD

CDS View

P_PRODUCTSALESDELIVERYD is a CDS View in S/4HANA. It contains 45 fields. 3 CDS views read from this table.

Used by 3 CDS view(s) 45 fields

CDS Views using this table (3)

ViewTypeJoinVDMDescription
P_Productsalesdeliveryposwd view inner COMPOSITE
P_ProductSalesDeliveryWD view left_outer COMPOSITE
P_ProductSalesDeliveryWD view union_all COMPOSITE

Fields (45)

KeyField CDS FieldsUsed in Views
accountdetnproductgroup accountdetnproductgroup 1
ActiveProduct ActiveProduct 1
ActiveProductDistributionChnl ActiveProductDistributionChnl 1
ActiveProductSalesOrg ActiveProductSalesOrg 1
assortmentgrade assortmentgrade 1
cashdiscountisdeductible cashdiscountisdeductible 1
competitionpressurecategory competitionpressurecategory 1
deliverynoteprocmindelivqty deliverynoteprocmindelivqty 1
deliveryquantity deliveryquantity 1
deliveryquantityunit deliveryquantityunit 1
distrcntrlistingenddate distrcntrlistingenddate 1
distrcntrlistingprocedure distrcntrlistingprocedure 1
distrcntrlistingstartdate distrcntrlistingstartdate 1
distrcntrsaleenddate distrcntrsaleenddate 1
distrcntrsalestartdate distrcntrsalestartdate 1
fifthsalesspecproductgroup fifthsalesspecproductgroup 1
firstsalesspecproductgroup firstsalesspecproductgroup 1
fourthsalesspecproductgroup fourthsalesspecproductgroup 1
hasactiveentity HasActiveEntity 1
itemcategorygroup itemcategorygroup 1
logisticsstatisticsgroup logisticsstatisticsgroup 1
maxdeliveryqtystoreorder maxdeliveryqtystoreorder 1
minimummaketoorderorderqty minimummaketoorderorderqty 1
minimumorderquantity minimumorderquantity 1
ParentDraftKey ParentDraftKey 1
pricefixingcategory pricefixingcategory 1
pricespecificationproductgroup pricespecificationproductgroup 1
pricingreferenceproduct pricingreferenceproduct 1
productcommissiongroup productcommissiongroup 1
producthierarchy producthierarchy 1
productsalesstatus productsalesstatus 1
productsalesstatusvaliditydate productsalesstatusvaliditydate 1
productunitgroup productunitgroup 1
roundingprofile roundingprofile 1
salesmeasureunit salesmeasureunit 1
secondsalesspecproductgroup secondsalesspecproductgroup 1
storelistingenddate storelistingenddate 1
storelistingprocedure storelistingprocedure 1
storelistingstartdate storelistingstartdate 1
storesaleenddate storesaleenddate 1
storesalestartdate storesalestartdate 1
supplyingplant supplyingplant 1
thirdsalesspecproductgroup thirdsalesspecproductgroup 1
variablesalesunitisnotallowed variablesalesunitisnotallowed 1
volumerebategroup volumerebategroup 1 
// Product Sales Delivery (draft)

@AbapCatalog.sqlViewName: 'PPRDSALESDELIVD'
@VDM.private: true
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #NOT_REQUIRED
define view P_ProductSalesDeliveryD
  as select from prd_sales_del as DraftDocument
{
  key DraftDocument.draftkey                                                  as Draftkey,
      DraftDocument.activeproduct                                             as ActiveProduct,
      DraftDocument.activeproductsalesorg                                     as ActiveProductSalesOrg,
      DraftDocument.activeproductdistributionchnl                             as ActiveProductDistributionChnl,
      DraftDocument.parentdraftkey                                            as ParentDraftKey,
      DraftDocument.productsalesorganization,
      DraftDocument.productdistributionchannel,
      DraftDocument.minimumorderquantity,
      DraftDocument.supplyingplant,
      DraftDocument.pricespecificationproductgroup,
      DraftDocument.accountdetnproductgroup,
      DraftDocument.deliverynoteprocmindelivqty,
      DraftDocument.itemcategorygroup,
      DraftDocument.deliveryquantityunit,
      DraftDocument.deliveryquantity,
      DraftDocument.productsalesstatus,
      DraftDocument.productsalesstatusvaliditydate,
      DraftDocument.salesmeasureunit,
      DraftDocument.ismarkedfordeletion,
      DraftDocument.producthierarchy,
      DraftDocument.firstsalesspecproductgroup,
      DraftDocument.secondsalesspecproductgroup,
      DraftDocument.thirdsalesspecproductgroup,
      DraftDocument.fourthsalesspecproductgroup,
      DraftDocument.fifthsalesspecproductgroup,
      DraftDocument.minimummaketoorderorderqty,
      //retail fields added on 25.4.16

      DraftDocument.logisticsstatisticsgroup,
      DraftDocument.volumerebategroup,
      DraftDocument.productcommissiongroup,
      DraftDocument.cashdiscountisdeductible,
      DraftDocument.pricingreferenceproduct,
      DraftDocument.assortmentgrade,
      DraftDocument.storelistingprocedure,
      DraftDocument.distrcntrlistingprocedure,
      DraftDocument.storelistingstartdate,
      DraftDocument.storelistingenddate,
      DraftDocument.distrcntrlistingstartdate,
      DraftDocument.distrcntrlistingenddate,
      DraftDocument.storesalestartdate,
      DraftDocument.storesaleenddate,
      DraftDocument.distrcntrsalestartdate,
      DraftDocument.distrcntrsaleenddate,
      DraftDocument.roundingprofile,
      DraftDocument.productunitgroup,
      DraftDocument.maxdeliveryqtystoreorder,
      DraftDocument.pricefixingcategory,
      DraftDocument.variablesalesunitisnotallowed,
      DraftDocument.competitionpressurecategory,

      DraftDocument.hasactiveentity
}    
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"PRD_SALES_DEL"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0
}
}*/

Learn More