SAP ABAP Table CSORDER_MAT (Administration of generated materials per sales order)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ CRM-MD-PRO (Application Component) Products
⤷ CS (Package) R/3 Application development: PP Bills of Material
⤷ CRM-MD-PRO (Application Component) Products
⤷ CS (Package) R/3 Application development: PP Bills of Material
Basic Data
Table Category | TRANSP | Transparent table |
Transparent table | CSORDER_MAT | Table Relationship Diagram |
Short Description | Administration of generated materials per sales order |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | L | Table for storing temporary data, delivered empty |
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
2 | VBELN | CS_VBELN | VBELN | CHAR | 10 | 0 | Sales Order | VBUK | |
3 | VBPOS | CS_VBPOS | POSNR | NUMC | 6 | 0 | Sales order item | VBUP | |
4 | MATNR_OLD | O_MATNR_REF | MATNR | CHAR | 18 | 0 | Reference material number of a material replacement | MARA | |
5 | MATNR_NEW | O_MATNR_NEW | MATNR | CHAR | 18 | 0 | New material number of a material exchange | MARA | |
6 | MTART_OLD | O_MTART_REF | MTART | CHAR | 4 | 0 | Reference material type of a material replacement | T134 | |
7 | MTART_NEW | O_MTART_NEW | MTART | CHAR | 4 | 0 | New material type of a material replacement | T134 | |
8 | VPSTA_OLD | O_VPSTA_REF | PSTAT | CHAR | 15 | 0 | Complete maintenance status of ref. material | ||
9 | VPSTA_NEW | O_VPSTA_NEW | PSTAT | CHAR | 15 | 0 | Complete maintenance status of new material | ||
10 | WERKS | WERKS_D | WERKS | CHAR | 4 | 0 | Plant | T001W | |
11 | ANNAM | ANNAM | USNAM | CHAR | 12 | 0 | User Who Created Record | ||
12 | CREATE_VIA | O_VIA | CHAR0008 | CHAR | 8 | 0 | Source of material replacement | ||
13 | ANDAT | ANDAT | DATUM | DATS | 8 | 0 | Date Record Created on | ||
14 | DEL_DAT | AEDAT | DATUM | DATS | 8 | 0 | Last Changed On | ||
15 | LKENZ | LKENZ | XFELD | CHAR | 1 | 0 | Deletion Indicator |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | CSORDER_MAT | MANDT | T000 | MANDT | KEY | 1 | CN |
2 | CSORDER_MAT | MATNR_NEW | MARA | MATNR | KEY | 1 | CN |
3 | CSORDER_MAT | MATNR_OLD | MARA | MATNR | KEY | 1 | CN |
4 | CSORDER_MAT | MTART_NEW | T134 | MTART | REF | 1 | CN |
5 | CSORDER_MAT | MTART_OLD | T134 | MTART | REF | 1 | CN |
6 | CSORDER_MAT | VBELN | VBUK | VBELN | KEY | 1 | CN |
7 | CSORDER_MAT | VBPOS | VBUP | POSNR | KEY | 1 | CN |
8 | CSORDER_MAT | WERKS | T001W | WERKS | REF | 1 | CN |
History
Last changed by/on | SAP | 19991110 |
SAP Release Created in |