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".

Fields for table PROD_DC_SALES

Field Name
Description
Is Key
Data Element
Data Type
Length
Check Table
MANDTClientXMANDTCLNT6
DRAFTUUIDUUID serving as key (parent key, root key)X/BOBF/UUIDRAW16
PARENTDRAFTUUIDUUID serving as key (parent key, root key)/BOBF/UUIDRAW16
PRODUCTProduct NumberPRODUCTNUMBERCHAR80
PRODUCTSALESORGSales OrganizationVKORGCHAR8
PRODUCTDISTRIBUTIONCHNLDistribution ChannelVTWEGCHAR4
PRODUCTFOREDITProduct NumberPRODUCTNUMBERCHAR80
PRODUCTSALESORGFOREDITSales OrganizationVKORGCHAR8
PRODUCTDISTRIBUTIONCHNLFOREDITDistribution ChannelVTWEGCHAR4
MINIMUMORDERQUANTITYMinimum order quantity in base unit of measureMINAUQUAN7
SUPPLYINGPLANTDelivering Plant (Own or External)DWERK_EXTCHAR8
PRICESPECIFICATIONPRODUCTGROUPProduct Pricing GroupPRICESPECIFICATIONPRODUCTGROUPCHAR4
ACCOUNTDETNPRODUCTGROUPAccount Assignment Group for MaterialKTGRMCHAR4
DELIVERYNOTEPROCMINDELIVQTYMinimum Delivery Quantity in Delivery Note ProcessingMINLFQUAN7
ITEMCATEGORYGROUPItem Category Group from Material MasterMTPOSCHAR8
DELIVERYQUANTITYUNITUnit of measure of delivery unitSCHMEUNIT6
DELIVERYQUANTITYDelivery unitSCHRTQUAN7
PRODUCTSALESSTATUSDistribution-chain-specific material statusVMSTACHAR4
PRODUCTSALESSTATUSVALIDITYDATEDate from which distr.-chain-spec. material status is validVMSTDDATS16
SALESMEASUREUNITSales unitVRKMEUNIT6
ISMARKEDFORDELETIONInd.: Flag material for deletion at distribution chain levelLVOVKCHAR2
PRODUCTHIERARCHYProduct hierarchyPRODH_DCHAR36
FIRSTSALESSPECPRODUCTGROUPProduct Group 1FIRSTSALESSPECPRODUCTGROUPCHAR6
SECONDSALESSPECPRODUCTGROUPProduct Group 2SECONDSALESSPECPRODUCTGROUPCHAR6
THIRDSALESSPECPRODUCTGROUPProduct Group 3THIRDSALESSPECPRODUCTGROUPCHAR6
FOURTHSALESSPECPRODUCTGROUPProduct Group 4FOURTHSALESSPECPRODUCTGROUPCHAR6
FIFTHSALESSPECPRODUCTGROUPProduct Group 5FIFTHSALESSPECPRODUCTGROUPCHAR6
MINIMUMMAKETOORDERORDERQTYMinimum make-to-order quantityMINEFQUAN7
LOGISTICSSTATISTICSGROUPMaterial statistics groupSTGMACHAR2
VOLUMEREBATEGROUPVolume rebate groupBONUSCHAR4
PRODUCTCOMMISSIONGROUPCommission GroupPROVGCHAR4
CASHDISCOUNTISDEDUCTIBLECash Discount IndicatorSKTOFCHAR2
PRICINGREFERENCEPRODUCTPricing Reference MaterialPMATNCHAR80
ASSORTMENTGRADEAssortment gradeSSTUFCHAR4
STORELISTINGPROCEDUREListing procedure for store or other assortment categoriesLSTFLCHAR4
DISTRCNTRLISTINGPROCEDUREListing procedure for distr. center assortment categoriesLSTVZCHAR4
STORELISTINGSTARTDATEDate from which listed in the storeSTORELISTINGSTARTDATEDATS16
STORELISTINGENDDATEDate to which listed in the storeSTORELISTINGENDDATEDATS16
DISTRCNTRLISTINGSTARTDATEDate from which listed in the distribution centerDISTRCNTRLISTINGSTARTDATEDATS16
DISTRCNTRLISTINGENDDATEDate to which listed in the central warehouse/distr. centerDISTRCNTRLISTINGENDDATEDATS16
STORESALESTARTDATEDate from which sold in the storeSTORESALESTARTDATEDATS16
STORESALEENDDATEDate to which sold in the storeSTORESALEENDDATEDATS16
DISTRCNTRSALESTARTDATEDate from which sold in the distribution centerDISTRCNTRSALESTARTDATEDATS16
DISTRCNTRSALEENDDATEDate to which sold in the distribution centerDISTRCNTRSALEENDDATEDATS16
ROUNDINGPROFILERounding ProfileRDPRFCHAR8
PRODUCTUNITGROUPUnit of Measure GroupMEGRUCHAR8
MAXDELIVERYQTYSTOREORDERMaximum delivery quantity in store order processingMAXLFQUAN7
PRICEFIXINGCATEGORYIndicator for price fixingPBINDCHAR2
VARIABLESALESUNITISNOTALLOWEDVariable Sales Unit Not AllowedVAVMECHAR2
COMPETITIONPRESSURECATEGORYCompetition characterization of a materialMATKCCHAR2
PRODEXTASSORTMENTPRIORITYExternal assortment priorityPFLKSCHAR2
BASEUNITBase Unit of MeasureMEINSUNIT6
PRODISENTLMNTRLVTRelevant for Entitlement GenerationCMD_PRD_IS_ENTLMNT_RLVTCHAR2
HASACTIVEENTITYDraft - Indicator - Has active documentSDRAFT_HAS_ACTIVECHAR2
.INCLUDESDRAFT_WRITE_DRAFT_ADMIN0
DRAFTENTITYCREATIONDATETIMEDraft Created OnSDRAFT_CREATED_ATDEC11
DRAFTENTITYLASTCHANGEDATETIMEDraft Last Changed OnSDRAFT_LAST_CHANGED_ATDEC11
DRAFTADMINISTRATIVEDATAUUIDTechnical ID for the Administrative Data of a Draft DocumentSDRAFT_ADMIN_UUIDRAW16
DRAFTENTITYCONSISTENCYSTATUSDraft - Consistency StatusSDRAFT_CONSISTENCY_STATUSCHAR2
DRAFTENTITYOPERATIONCODEDraft - Operation CodeSDRAFT_OPERATION_CODECHAR2
.INCLUDESALD_INCL_EEW_PS0
DUMMY_SALD_INCL_EEW_PSMD Product Sales DeliverySALD_INCL_EEWCHAR2
.INCLU--APCRMS4S_PRODSALESDEL_APPEND0
.INCLUDECRMS4S_SOM_MVKE_VDM0
SUBSCRPNCONTRDFLTDURATIONDefault Contract TermCRMS4_SOM_CTR_DUR_DEFNUMC6
SUBSCRPNCONTRALTVDURATION1Alternative Contract Term 1CRMS4_SOM_CTR_DUR_1NUMC6
SUBSCRPNCONTRALTVDURATION2Alternative Contract Term 2CRMS4_SOM_CTR_DUR_2NUMC6
SUBSCRPNCONTRDURATIONUNITUnit for Contract TermCRMS4_SOM_CTR_TERM_UNITCHAR2
SUBSCRPNCONTRDFLTEXTNDURNDefault Extension PeriodCRMS4_SOM_CTR_TRM_EXT_DEFNUMC6
SUBSCRPNCONTRALTVEXTNDURN1Alternative Extension Period 1CRMS4_SOM_CTR_TRM_EXT_1NUMC6
SUBSCRPNCONTRALTVEXTNDURN2Alternative Extension Period 2CRMS4_SOM_CTR_TRM_EXT_2NUMC6
SUBSCRPNCONTREXTNDURNUNITUnit for Extension PeriodCRMS4_SOM_EXT_PERIOD_UNITCHAR2
.INCLU--APLMD_PRODSALES_APPEND0
.INCLUDELMD_MVKE_VDM0
LSTMIPRODUCTPACKAGETYPEPackage TypeLMD_MDE_PACKAGE_TYPECHAR6*
LSTMIPRODUCTPACKAGESIZECODEPackage SizeLMD_MDE_PACKAGE_SIZECHAR6*
Privacy Policy