_PRODUCTSALESDELIVERY

_PRODUCTSALESDELIVERY is an SAP database table in S/4HANA. It contains 42 fields.

Fields (42)

KeyField CDS FieldsUsed in Views
_DistributionChannel _DistributionChannel 1
_ItemCategoryGroup _ItemCategoryGroup 1
_ItemCategoryGroupText _SalesItemCategoryGroupText 1
_MaterialStatisticsGroupText _MaterialStatisticsGroupText 1
_PriceFixingCategoryText _PriceFixingCategoryText 1
_ProductCommissionGroupText _ProductCommissionGroupText 1
_SalesUnitText _SalesUnitText 1
AssortmentGrade AssortmentGrade 1
CashDiscountIsDeductible CashDiscountIsDeductible 2
CompetitionPressureCategory CompetitionPressureCategory 2
DistrCntrListingEndDate DistrCntrListingEndDate 1
DistrCntrListingProcedure DistrCntrListingProcedure 1
DistrCntrListingStartDate DistrCntrListingStartDate 1
DistrCntrSaleEndDate DistrCntrSaleEndDate 1
DistrCntrSaleStartDate DistrCntrSaleStartDate 1
FifthSalesSpecProductGroup FifthSalesSpecProductGroup 2
FirstSalesSpecProductGroup FirstSalesSpecProductGroup 2
FourthSalesSpecProductGroup FourthSalesSpecProductGroup 2
ItemCategoryGroup ItemCategoryGroup,SalesItemCategoryGroup 4
LogisticsStatisticsGroup LogisticsStatisticsGroup 2
MaxDeliveryQtyStoreOrder MaxDeliveryQtyStoreOrder 1
MinimumMakeToOrderOrderQty MinimumMakeToOrderOrderQty 1
PriceFixingCategory PriceFixingCategory 2
PricingReferenceProduct PricingReferenceProduct 1
ProductCommissionGroup ProductCommissionGroup 2
ProductDistributionChnl DistributionChannel 2
ProductSalesOrg PRODUCTSALESORG,SalesOrganization 2
ProductSalesStatus ProductSalesStatus 1
ProductSalesStatusValidityDate ProductSalesStatusValidityDate 1
ProductUnitGroup ProductUnitGroup 2
RoundingProfile RoundingProfile 2
SalesMeasureUnit SalesMeasureUnit 2
SecondSalesSpecProductGroup SecondSalesSpecProductGroup 2
StoreListingEndDate StoreListingEndDate 1
StoreListingProcedure StoreListingProcedure 1
StoreListingStartDate StoreListingStartDate 1
StoreSaleEndDate StoreSaleEndDate 1
StoreSaleStartDate StoreSaleStartDate 1
SupplyingPlant SupplyingPlant 1
ThirdSalesSpecProductGroup ThirdSalesSpecProductGroup 2
VariableSalesUnitIsNotAllowed VariableSalesUnitIsNotAllowed 2
VolumeRebateGroup VolumeRebateGroup 2

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 _PRODUCTSALESDELIVERY (
    _DISTRIBUTIONCHANNEL,
    _ITEMCATEGORYGROUP,
    _ITEMCATEGORYGROUPTEXT,
    _MATERIALSTATISTICSGROUPTEXT,
    _PRICEFIXINGCATEGORYTEXT,
    _PRODUCTCOMMISSIONGROUPTEXT,
    _SALESUNITTEXT,
    ASSORTMENTGRADE,
    CASHDISCOUNTISDEDUCTIBLE,
    COMPETITIONPRESSURECATEGORY,
    DISTRCNTRLISTINGENDDATE,
    DISTRCNTRLISTINGPROCEDURE,
    DISTRCNTRLISTINGSTARTDATE,
    DISTRCNTRSALEENDDATE,
    DISTRCNTRSALESTARTDATE,
    FIFTHSALESSPECPRODUCTGROUP,
    FIRSTSALESSPECPRODUCTGROUP,
    FOURTHSALESSPECPRODUCTGROUP,
    ITEMCATEGORYGROUP,
    LOGISTICSSTATISTICSGROUP,
    MAXDELIVERYQTYSTOREORDER,
    MINIMUMMAKETOORDERORDERQTY,
    PRICEFIXINGCATEGORY,
    PRICINGREFERENCEPRODUCT,
    PRODUCTCOMMISSIONGROUP,
    PRODUCTDISTRIBUTIONCHNL,
    PRODUCTSALESORG,
    PRODUCTSALESSTATUS,
    PRODUCTSALESSTATUSVALIDITYDATE,
    PRODUCTUNITGROUP,
    ROUNDINGPROFILE,
    SALESMEASUREUNIT,
    SECONDSALESSPECPRODUCTGROUP,
    STORELISTINGENDDATE,
    STORELISTINGPROCEDURE,
    STORELISTINGSTARTDATE,
    STORESALEENDDATE,
    STORESALESTARTDATE,
    SUPPLYINGPLANT,
    THIRDSALESSPECPRODUCTGROUP,
    VARIABLESALESUNITISNOTALLOWED,
    VOLUMEREBATEGROUP
);