PROD_SALES - I_PRODUCTWD I_PRODUCTSALESWD
I_PRODUCTWD I_PRODUCTSALESWD information is stored in SAP table PROD_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_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 | Material Number | MATNR | CHAR | 80 | ||
| SALESSTATUS | Cross-distribution-chain material status | MSTAV | CHAR | 4 | ||
| SALESSTATUSVALIDITYDATE | Date from which the X-distr.-chain material status is valid | MSTDV | DATS | 16 | ||
| TAXCLASSIFICATION | Tax classification of the material | TAKLV | CHAR | 2 | ||
| TRANSPORTATIONGROUP | Transportation Group | TRAGR | CHAR | 8 | ||
| ALLOWEDPACKAGINGWEIGHTQTY | Allowed packaging weight | ERGEW | QUAN | 7 | ||
| ALLOWEDPACKAGINGWEIGHTQTYUNIT | Unit of weight (allowed packaging weight) | ERGEI | UNIT | 6 | ||
| ALLOWEDPACKAGINGVOLUMEQTY | Allowed packaging volume | ERVOL | QUAN | 7 | ||
| ALLOWEDPACKAGINGVOLUMEQTYUNIT | Volume unit (allowed packaging volume) | ERVOE | UNIT | 6 | ||
| PRICINGREFERENCEPRODUCT | Pricing Reference Material | PMATN | CHAR | 80 | ||
| VARIANTSPRICINGPROFILE | Pricing profile for variants | SPROF | CHAR | 2 | ||
| ISVARIANTPRICEALLOWED | Variant Price Allowed (for Material Master) | WPM_ALLOW_PMAT_IGNO_MAT | CHAR | 2 | ||
| LOADINGGROUP | Loading Group | LADGR | CHAR | 8 | ||
| AUTHORIZATIONGROUP | Authorization Group | BEGRU | CHAR | 8 | ||
| EXCESSWEIGHTTOLERANCE | Excess Weight Tolerance for Handling unit | EXCESSWEIGHTTOLERANCE | DEC | 2 | ||
| EXCESSVOLUMETOLERANCE | Excess Volume Tolerance of the Handling Unit | EXCESSVOLUMETOLERANCE | DEC | 2 | ||
| STACKINGFACTOR | Stacking factor | STFAK | INT2 | 2 | ||
| ISCLOSEDPACKAGINGMATERIAL | Packaging Material is Closed Packaging | KZGVH | CHAR | 2 | ||
| VOLUMEMAXIMUMLEVEL | Maximum level (by volume) | FUELG | DEC | 2 | ||
| PACKAGINGMATERIALTYPE | Packaging Material Type | PACKAGINGMATERIALTYPE | CHAR | 8 | ||
| STORESALEENDDATE | Date to which sold in the store | STORESALEENDDATE | DATS | 16 | ||
| DISTRCNTRSALEENDDATE | Date to which sold in the distribution center | DISTRCNTRSALEENDDATE | DATS | 16 | ||
| STORESALESTARTDATE | Date from which sold in the store | STORESALESTARTDATE | DATS | 16 | ||
| DISTRCNTRSALESTARTDATE | Date from which sold in the distribution center | DISTRCNTRSALESTARTDATE | DATS | 16 | ||
| 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 | PRD_INCL_EEW_PS | 0 | ||||
| DUMMY_PRD_INCL_EEW_PS | Dummy Field | PRD_INCL_EEW | CHAR | 2 | ||
| .INCLU--AP | CRMS4S_PRODSALES_APPEND | 0 | ||||
| .INCLUDE | CRMS4S_SERVICE_PROF | 0 | ||||
| SERVICEDURATION | Duration of Work | CRMT_PR_DURATION | QUAN | 7 | ||
| SERVICEDURATIONUNIT | Unit for Duration of Work | CRMT_PR_DURATION_UOM | UNIT | 6 | T006 | |
| SERVICEPROFILE | Service Profile | SRV_SERWI | CHAR | 20 | CRMD_SERWI | |
| RESPONSEPROFILE | Response Profile | SRV_ESCAL | CHAR | 20 | CRMD_ESCAL | |
| .INCLUDE | CRMS4S_SOM_MARA_VDM | 0 | ||||
| CABILLGCYCLE | Billing Cycle | CYCLE_KK | CHAR | 8 | * | |
| SUBSCRPNPRODBILLGCYCDETN | Billing Cycle Determination Rule ID | CRM_ISX_CYCLE_RULE | CHAR | 8 | * | |
| SUBSCRPNPRODTECHRSCESCHEMA | Assignment Schema | CRMT_TC_SCHEMA | CHAR | 4 | * | |
| CONTRACTAUTORENEWALTYPE | Contract Auto Renewal Indicator | CRMS4_SOM_CTR_AUTORENEWAL | CHAR | 2 |