_PRODUCTSALESDELIVERY
_PRODUCTSALESDELIVERY is an SAP database table in S/4HANA. It contains 42 fields.
Fields (42)
| Key | Field | CDS Fields | Used 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
);
Learn More
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA