PROD_DC_SALES - I_PRODUCTWD I_PRODUCTSALESDELIVERYWD
I_PRODUCTWD I_PRODUCTSALESDELIVERYWD information is stored in SAP table PROD_DC_SALES.
It is part of development package VDM_MD_PRODUCT in software component LO-MD-MM. This development package consists of objects that can be grouped under "VDM Master Data Product".
It is part of development package VDM_MD_PRODUCT in software component LO-MD-MM. This development package consists of objects that can be grouped under "VDM Master Data Product".
Fields for table PROD_DC_SALES
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
---|---|---|---|---|---|---|
MANDT | Client | X | MANDT | CLNT | 6 | |
DRAFTUUID | UUID serving as key (parent key, root key) | X | /BOBF/UUID | RAW | 16 | |
PARENTDRAFTUUID | UUID serving as key (parent key, root key) | /BOBF/UUID | RAW | 16 | ||
PRODUCT | Product Number | PRODUCTNUMBER | CHAR | 80 | ||
PRODUCTSALESORG | Sales Organization | VKORG | CHAR | 8 | ||
PRODUCTDISTRIBUTIONCHNL | Distribution Channel | VTWEG | CHAR | 4 | ||
PRODUCTFOREDIT | Product Number | PRODUCTNUMBER | CHAR | 80 | ||
PRODUCTSALESORGFOREDIT | Sales Organization | VKORG | CHAR | 8 | ||
PRODUCTDISTRIBUTIONCHNLFOREDIT | Distribution Channel | VTWEG | CHAR | 4 | ||
MINIMUMORDERQUANTITY | Minimum order quantity in base unit of measure | MINAU | QUAN | 7 | ||
SUPPLYINGPLANT | Delivering Plant (Own or External) | DWERK_EXT | CHAR | 8 | ||
PRICESPECIFICATIONPRODUCTGROUP | Product Pricing Group | PRICESPECIFICATIONPRODUCTGROUP | CHAR | 4 | ||
ACCOUNTDETNPRODUCTGROUP | Account Assignment Group for Material | KTGRM | CHAR | 4 | ||
DELIVERYNOTEPROCMINDELIVQTY | Minimum Delivery Quantity in Delivery Note Processing | MINLF | QUAN | 7 | ||
ITEMCATEGORYGROUP | Item Category Group from Material Master | MTPOS | CHAR | 8 | ||
DELIVERYQUANTITYUNIT | Unit of measure of delivery unit | SCHME | UNIT | 6 | ||
DELIVERYQUANTITY | Delivery unit | SCHRT | QUAN | 7 | ||
PRODUCTSALESSTATUS | Distribution-chain-specific material status | VMSTA | CHAR | 4 | ||
PRODUCTSALESSTATUSVALIDITYDATE | Date from which distr.-chain-spec. material status is valid | VMSTD | DATS | 16 | ||
SALESMEASUREUNIT | Sales unit | VRKME | UNIT | 6 | ||
ISMARKEDFORDELETION | Ind.: Flag material for deletion at distribution chain level | LVOVK | CHAR | 2 | ||
PRODUCTHIERARCHY | Product hierarchy | PRODH_D | CHAR | 36 | ||
FIRSTSALESSPECPRODUCTGROUP | Product Group 1 | FIRSTSALESSPECPRODUCTGROUP | CHAR | 6 | ||
SECONDSALESSPECPRODUCTGROUP | Product Group 2 | SECONDSALESSPECPRODUCTGROUP | CHAR | 6 | ||
THIRDSALESSPECPRODUCTGROUP | Product Group 3 | THIRDSALESSPECPRODUCTGROUP | CHAR | 6 | ||
FOURTHSALESSPECPRODUCTGROUP | Product Group 4 | FOURTHSALESSPECPRODUCTGROUP | CHAR | 6 | ||
FIFTHSALESSPECPRODUCTGROUP | Product Group 5 | FIFTHSALESSPECPRODUCTGROUP | CHAR | 6 | ||
MINIMUMMAKETOORDERORDERQTY | Minimum make-to-order quantity | MINEF | QUAN | 7 | ||
LOGISTICSSTATISTICSGROUP | Material statistics group | STGMA | CHAR | 2 | ||
VOLUMEREBATEGROUP | Volume rebate group | BONUS | CHAR | 4 | ||
PRODUCTCOMMISSIONGROUP | Commission Group | PROVG | CHAR | 4 | ||
CASHDISCOUNTISDEDUCTIBLE | Cash Discount Indicator | SKTOF | CHAR | 2 | ||
PRICINGREFERENCEPRODUCT | Pricing Reference Material | PMATN | CHAR | 80 | ||
ASSORTMENTGRADE | Assortment grade | SSTUF | CHAR | 4 | ||
STORELISTINGPROCEDURE | Listing procedure for store or other assortment categories | LSTFL | CHAR | 4 | ||
DISTRCNTRLISTINGPROCEDURE | Listing procedure for distr. center assortment categories | LSTVZ | CHAR | 4 | ||
STORELISTINGSTARTDATE | Date from which listed in the store | STORELISTINGSTARTDATE | DATS | 16 | ||
STORELISTINGENDDATE | Date to which listed in the store | STORELISTINGENDDATE | DATS | 16 | ||
DISTRCNTRLISTINGSTARTDATE | Date from which listed in the distribution center | DISTRCNTRLISTINGSTARTDATE | DATS | 16 | ||
DISTRCNTRLISTINGENDDATE | Date to which listed in the central warehouse/distr. center | DISTRCNTRLISTINGENDDATE | DATS | 16 | ||
STORESALESTARTDATE | Date from which sold in the store | STORESALESTARTDATE | DATS | 16 | ||
STORESALEENDDATE | Date to which sold in the store | STORESALEENDDATE | DATS | 16 | ||
DISTRCNTRSALESTARTDATE | Date from which sold in the distribution center | DISTRCNTRSALESTARTDATE | DATS | 16 | ||
DISTRCNTRSALEENDDATE | Date to which sold in the distribution center | DISTRCNTRSALEENDDATE | DATS | 16 | ||
ROUNDINGPROFILE | Rounding Profile | RDPRF | CHAR | 8 | ||
PRODUCTUNITGROUP | Unit of Measure Group | MEGRU | CHAR | 8 | ||
MAXDELIVERYQTYSTOREORDER | Maximum delivery quantity in store order processing | MAXLF | QUAN | 7 | ||
PRICEFIXINGCATEGORY | Indicator for price fixing | PBIND | CHAR | 2 | ||
VARIABLESALESUNITISNOTALLOWED | Variable Sales Unit Not Allowed | VAVME | CHAR | 2 | ||
COMPETITIONPRESSURECATEGORY | Competition characterization of a material | MATKC | CHAR | 2 | ||
PRODEXTASSORTMENTPRIORITY | External assortment priority | PFLKS | CHAR | 2 | ||
BASEUNIT | Base Unit of Measure | MEINS | UNIT | 6 | ||
PRODISENTLMNTRLVT | Relevant for Entitlement Generation | CMD_PRD_IS_ENTLMNT_RLVT | CHAR | 2 | ||
HASACTIVEENTITY | Draft - Indicator - Has active document | SDRAFT_HAS_ACTIVE | CHAR | 2 | ||
.INCLUDE | SDRAFT_WRITE_DRAFT_ADMIN | 0 | ||||
DRAFTENTITYCREATIONDATETIME | Draft Created On | SDRAFT_CREATED_AT | DEC | 11 | ||
DRAFTENTITYLASTCHANGEDATETIME | Draft Last Changed On | SDRAFT_LAST_CHANGED_AT | DEC | 11 | ||
DRAFTADMINISTRATIVEDATAUUID | Technical ID for the Administrative Data of a Draft Document | SDRAFT_ADMIN_UUID | RAW | 16 | ||
DRAFTENTITYCONSISTENCYSTATUS | Draft - Consistency Status | SDRAFT_CONSISTENCY_STATUS | CHAR | 2 | ||
DRAFTENTITYOPERATIONCODE | Draft - Operation Code | SDRAFT_OPERATION_CODE | CHAR | 2 | ||
.INCLUDE | SALD_INCL_EEW_PS | 0 | ||||
DUMMY_SALD_INCL_EEW_PS | MD Product Sales Delivery | SALD_INCL_EEW | CHAR | 2 | ||
.INCLU--AP | CRMS4S_PRODSALESDEL_APPEND | 0 | ||||
.INCLUDE | CRMS4S_SOM_MVKE_VDM | 0 | ||||
SUBSCRPNCONTRDFLTDURATION | Default Contract Term | CRMS4_SOM_CTR_DUR_DEF | NUMC | 6 | ||
SUBSCRPNCONTRALTVDURATION1 | Alternative Contract Term 1 | CRMS4_SOM_CTR_DUR_1 | NUMC | 6 | ||
SUBSCRPNCONTRALTVDURATION2 | Alternative Contract Term 2 | CRMS4_SOM_CTR_DUR_2 | NUMC | 6 | ||
SUBSCRPNCONTRDURATIONUNIT | Unit for Contract Term | CRMS4_SOM_CTR_TERM_UNIT | CHAR | 2 | ||
SUBSCRPNCONTRDFLTEXTNDURN | Default Extension Period | CRMS4_SOM_CTR_TRM_EXT_DEF | NUMC | 6 | ||
SUBSCRPNCONTRALTVEXTNDURN1 | Alternative Extension Period 1 | CRMS4_SOM_CTR_TRM_EXT_1 | NUMC | 6 | ||
SUBSCRPNCONTRALTVEXTNDURN2 | Alternative Extension Period 2 | CRMS4_SOM_CTR_TRM_EXT_2 | NUMC | 6 | ||
SUBSCRPNCONTREXTNDURNUNIT | Unit for Extension Period | CRMS4_SOM_EXT_PERIOD_UNIT | CHAR | 2 | ||
.INCLU--AP | LMD_PRODSALES_APPEND | 0 | ||||
.INCLUDE | LMD_MVKE_VDM | 0 | ||||
LSTMIPRODUCTPACKAGETYPE | Package Type | LMD_MDE_PACKAGE_TYPE | CHAR | 6 | * | |
LSTMIPRODUCTPACKAGESIZECODE | Package Size | LMD_MDE_PACKAGE_SIZE | CHAR | 6 | * |