SAP CPLNSCPHDR Table in S/4 HANA - Generated Table for View
CPLNSCPHDR is a standard SAP Table which is used to store Generated Table for View data and is available within S/4 HANA SAP systems depending on the version and release level. Below is the technical details and the list of fields specifically relevant for an SAP S/4 HANA system
Even using an S/4 Hana system you can still view further information about the SAP CPLNSCPHDR table and the data within it using standard SAP GUI transactions such as SE11, SE80 or SE16. Or you can use the ADT (ABAP development tools within eclipse).
Delivery Class:
Display/Maintenance via SM30: Display/Maintenance Allowed but with Restrictions
Enhancement category: Not classified
Dictionary Type: Table view
Database Table: CPLNSCPHDR
CPLNSCPHDR table structure field list
Below is the full CPLNSCPHDR field list that makes up the SAP database table structure, including key fields, description, data type and other technical details of each field
| Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP | SHLP Field |
| MANDT | Client | MANDT | CLNT | 3(0) | MANDT | |||||
| DOCUMENTID | Planning Scope Document ID | VMP_PLNSCP_DOC_ID | CHAR | 33(0) | CHAR33 | |||||
| PLANNINGSCOPEALTERNATIVE | Planning Scope Alternative | VMP_PLNSCP_ALT | CHAR | 4(0) | ALPHA | VMP_PLNSCP_ALT | ||||
| SOURCEMATERIAL | Material Number | MATNR | CHAR | 40(0) | MATN1 | MATNR | MAT | S_MAT1 | MATNR | |
| SOURCEMATERIALFOREDIT | Material Number | MATNR | CHAR | 40(0) | MATN1 | MATNR | MAT | S_MAT1 | MATNR | |
| PLANNINGSCOPEDESCRIPTION | Planning Scope Alternative Description | VMP_PLNSCP_DES | CHAR | 40(0) | TEXT40 | |||||
| PLANT | Plant | WERKS_D | CHAR | 4(0) | WERKS | WRK | H_T001W_C | WERKS | ||
| LASTCHANGEDATETIME | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TIMESTAMP | DEC | 15(0) | TZNTSTMPS | |||||
| CHANGENUMBER | Change Number | AENNR | CHAR | 12(0) | AENNR | AENNR | AEN | |||
| MBOMUSAGE | BOM Usage | STLAN | CHAR | 1(0) | STLAN | CSV | ||||
| MATERIAL | Material Number | MATNR | CHAR | 40(0) | MATN1 | MATNR | MAT | S_MAT1 | MATNR | |
| MFGBILLOFMATERIALCATEGORY | MBOM Category | VMP_MBOM_TYPE | CHAR | 1(0) | VMP_MBOM_TYPE | |||||
| SOURCEPLANT | Source Plant | VMP_SOURCE_PLANT | CHAR | 4(0) | WERKS | |||||
| SOURCEBOMUSAGE | Source BOM Usage | VMP_SOURCE_STLAN | CHAR | 1(0) | STLAN | |||||
| SOURCEBOMALTERNATIVE | Source BOM Alternative | VMP_SOURCE_STALT | CHAR | 2(0) | ALPHA | ALTNR | ||||
| EBOMVALIDITY | Source Validity Date | VMP_SOURCE_DATUM | DATS | 8(0) | DATUM | |||||
| SOURCEBOMTYPE | Source BOM Category | VMP_EBOM_TYPE | CHAR | 1(0) | VMP_EBOM_TYPE | |||||
| CREATEDBYUSER | Created By | VMP_CREATED_BY | CHAR | 12(0) | XUBNAME | |||||
| CREATEDBYUSERNAME | User Description | VDM_USERDESCRIPTION | CHAR | 80(0) | SUIDTECHDESC | |||||
| LASTCHANGEDBYUSER | Check-out User for Planning Scope | VMP_CHECKOUT_USER | CHAR | 12(0) | USNAM | |||||
| LASTCHANGEDBYUSERNAME | User Description | VDM_USERDESCRIPTION | CHAR | 80(0) | SUIDTECHDESC | |||||
| PLANNINGSOURCETYPE | SSTR | 10(0) | ||||||||
| RECORDCREATIONDATE | Created On | VMP_CREATED_ON | DATS | 8(0) | DATS | |||||
| BOMISACTIVE | Bill of Material Status | STLST | NUMC | 2(0) | STLST | |||||
| MATERIALNAME | Material description | MAKTX | CHAR | 40(0) | TEXT40 | |||||
| PLANTNAME | Plant Name | WERKS_NAME | CHAR | 30(0) | TEXT30 | |||||
| TARGETPLANT | Plant Name | WERKS_NAME | CHAR | 30(0) | TEXT30 | |||||
| BILLOFMATERIALVARIANTUSAGEDESC | BOM usage text | ANTXT | CHAR | 30(0) | TEXT30 | |||||
| PRODUCTBOMUSAGE | BOM usage text | ANTXT | CHAR | 30(0) | TEXT30 | |||||
| PRODUCTSTRUCTURENODEUUID | Internal Number of iPPE Node | PVS_PNGUID | RAW | 16(0) | SYSUUID | |||||
| PRODUCTSTRUCTURENODENAME | iPPE Node Description | PVS_PNODE | CHAR | 40(0) | PVS_PNODE | PND | ||||
| PRODUCTSTRUCTURENODETYPE | iPPE Node Type | PVS_PNODE_TYPE | CHAR | 8(0) | CPNTYPE | PVS_PNODE_TYPE | PNTYPE | |||
| CLASS | Class number | KLASSE_D | CHAR | 18(0) | KLASSE | KLA | ||||
| CLASSTYPE | Class Type | KLASSENART | CHAR | 3(0) | TCLA | KLASSENART | KAR | |||
| PRODUCTSTRUCTUREUSAGE | Usage in iPPE | PPE_USE | CHAR | 3(0) | CPPE_HDR_USE | PPE_USE | PPE_USE | |||
| CONFIGURATIONSIMULATIONDATE | Date | DATUM | DATS | 8(0) | DATUM | |||||
| VALIDITYSTARTDATE | Source Validity Date | VMP_SOURCE_DATUM | DATS | 8(0) | DATUM | |||||
| VALIDITYENDDATE | Source Validity Date | VMP_SOURCE_DATUM | DATS | 8(0) | DATUM | |||||
| HEADERVALIDITYENDDATE | DATS | 8(0) | ||||||||
| SOURCECHANGENUMBER | Change Number | AENNR | CHAR | 12(0) | AENNR | AENNR | AEN | |||
| ALIGNMENTSTATUSVALUE | Source Alignment Status | HFE_ALIGNMENT_STATUS | CHAR | 20(0) | HFE_ALIGNMENT_STATUS | |||||
| ALIGNMENTSTATUSCRITICALITY | 1 Byte Unsigned Integer | INT1 | INT1 | 3(0) | INT1 |
Search for further information about these or an SAP related objects