CPPER3E_EXPLOUT SAP (Attributes of Material and Component Variant) Append Structure details
Dictionary Type: Append Structure
Description: Attributes of Material and Component Variant
Description: Attributes of Material and Component Variant
ABAP Code to SELECT data from CPPER3E_EXPLOUT
Related tables to CPPER3E_EXPLOUT
Access table CPPER3E_EXPLOUT
Related tables to CPPER3E_EXPLOUT
Access table CPPER3E_EXPLOUT
Append Structure field list including key, data, relationships and ABAP select examples
CPPER3E_EXPLOUT is a standard SAP Append Structure which is used to store Attributes of Material and Component Variant data and is available within R/3 SAP systems depending on the version and release level.
The CPPER3E_EXPLOUT table consists of various fields, each holding specific information or linking keys about Attributes of Material and Component Variant data available in SAP. These include DATUV (Valid-From Date), DATUB (Valid-to date), TECHV (Technical status from), TECHB (Technical status to).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP CPPER3E_EXPLOUT append structure fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
STKZA | Internal counter | CIM_COUNT | NUMC | 8 | CIM_COUNT | ||||
DATUV | Valid-From Date | DATUV | DATS | 8 | DATUM | ||||
DATUB | Valid-to date | DATUB | DATS | 8 | DATUM | ||||
TECHV | Technical status from | TECHV | CHAR | 12 | TECHS | ||||
TECHB | Technical status to | TECHB | CHAR | 12 | TECHS | ||||
STSOR | Sort String | SORTP | CHAR | 10 | CHAR10 | ||||
POSNR | BOM Item Number | SPOSN | CHAR | 4 | NUMCV | SPOSN | |||
POSTP | Item Category (Bill of Material) | POSTP | CHAR | 1 | Assigned to domain | POSTP | |||
UPSKZ | Indicator: sub-items exist | UPSKZ | CHAR | 1 | XFELD | ||||
SCHGT | Indicator: Bulk Material | SCHGT | CHAR | 1 | XFELD | ||||
KMPFE | Indicator: item relevant to production | SANFE | CHAR | 1 | XFELD | ||||
KMPKA | Indicator for Relevancy to Costing | CK_SELKZ | CHAR | 1 | Assigned to domain | CK_SELKZ | |||
KMPMT | BOM component | IDNRK | CHAR | 18 | Assigned to domain | MATN1 | MATNR | ||
KMPME | Component unit of measure | KMPME | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
KMPMG | Component quantity | KMPMG | QUAN | 13(3) | MENGV13 | ||||
FMENG | Quantity is Fixed | FMENG | CHAR | 1 | XFELD | ||||
ALPOS | Indicator: alternative item | ALPOS | CHAR | 1 | XFELD | ||||
EWAHR | Usage probability in % (alternative item) | EWAHR | DEC | 3 | DEC3 | ||||
ALPGR | Alternative item: group | CS_ALPGR | CHAR | 2 | CHAR2 | ||||
ALPRF | Alternative item: ranking order | CS_ALPRF | NUMC | 2 | NUM2 | ||||
ALPST | Alternative item: strategy | CS_ALPST | CHAR | 1 | CS_ALPST | ||||
KMPAS | Component scrap in percent | KAUSF | DEC | 5(2) | DEC3_2 | ||||
AVOAS | Operation scrap | AVOAU | DEC | 5(2) | DEC3_2 | ||||
AVONT | Indicator: Net scrap | NETAU | CHAR | 1 | XFELD | ||||
BEIKZ | Material Provision Indicator | BEIKZ | CHAR | 1 | Assigned to domain | BEIKZ | |||
ERSKZ | Indicator: spare part | ERSKZ | CHAR | 1 | Assigned to domain | ERSKZ | |||
REKRI | Indicator: BOM is recursive | REKRI | CHAR | 1 | XFELD | ||||
REKRS | Indicator: recursiveness allowed | REKRS | CHAR | 1 | XFELD | ||||
KZDUM | Indicator: phantom assembly off | CS_KZDUM | CHAR | 1 | XFELD | ||||
KZMFG | Indicator: switch off direct production/direct procurement | CS_KZMFG | CHAR | 1 | XFELD | ||||
KZLFP | Indicator: switch off long-term planning | CS_KZLFP | CHAR | 1 | XFELD | ||||
NLFZT | Lead-time offset | NLFZT | DEC | 3 | NLFZT | ||||
KFPOS | Indicator: 'configurable item' | KFPOS | CHAR | 1 | XFLAG | ||||
KLPOS | Indicator: class item | KLPOS | CHAR | 1 | XFELD | ||||
KZCLB | Indicator: classification as selection condition | CS_KZCLB | CHAR | 1 | XFELD | ||||
KLART | Class Type | KLASSENART | CHAR | 3 | Assigned to domain | KLASSENART | KAR | ||
KFKLA | Class number | KLASSE_D | CHAR | 18 | KLASSE | KLA | |||
CLSZU | Classification number | CS_CLSZU | NUMC | 8 | NUM8 | ||||
ROMNG | Quantity of variable-size item | ROMEN | QUAN | 13(3) | MENG13 | ||||
ROMEI | Unit of measure for sizes 1 to 3 | ROMEI | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
ROANZ | Number of variable-size items | ROANZ | QUAN | 13(3) | MENG13 | ||||
ROMS1 | Size 1 | ROMS1 | QUAN | 13(3) | MENG13 | ||||
ROMS2 | Size 2 | ROMS2 | QUAN | 13(3) | MENG13 | ||||
ROMS3 | Size 3 | ROMS3 | QUAN | 13(3) | MENG13 | ||||
RFORM | Formula key | RFORM | CHAR | 2 | Assigned to domain | RFORM | |||
LGORT | Storage Location | LGORT_D | CHAR | 4 | Assigned to domain | LGORT | LAG | ||
NFPKZ | Indicator: Follow-Up Item | CS_KZNFP | CHAR | 1 | XFELD | ||||
NFEAG | Discontinuation group | CS_NFEAG | CHAR | 2 | CHAR2 | ||||
NFGRP | Follow-up group | CS_NFGRP | CHAR | 2 | CHAR2 | ||||
STLTX | Language: The long text was stored in this language | LTXSP | LANG | 1 | Assigned to domain | ISOLA | SPRAS | ||
STTX1 | Text, length 40 | TXT40 | CHAR | 40 | TEXT40 | ||||
STTX2 | Text, length 40 | TXT40 | CHAR | 40 | TEXT40 | ||||
EKGRP | Purchasing Group | EKGRP | CHAR | 3 | Assigned to domain | EKGRP | EKG | ||
LIFZT | Delivery time in days | LIFZT | DEC | 3 | DEC3 | ||||
WEBAZ | Goods Receipt Processing Time in Days | WEBAZ | DEC | 3 | DEC3 | ||||
LIFNR | Account Number of Vendor or Creditor | LIFNR | CHAR | 10 | Assigned to domain | ALPHA | LIFNR | LIF | KRED_C |
PREIS | Price | PREIS | CURR | 11(2) | WERT11 | ||||
PEINH | Price Unit | PEINH | DEC | 5 | PACK3 | ||||
VERTI | Distribution key for component consumption | SA_VERTI | CHAR | 4 | Assigned to domain | SA_VERTL | |||
WAERS | Currency Key | WAERS | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
SAKTO | Cost element | SAKTO | CHAR | 10 | Assigned to domain | ALPHA | SAKNR | ||
EKORG | Purchasing Organization | EKORG | CHAR | 4 | Assigned to domain | EKORG | EKO | ||
STVKN | Inherited node number of BOM item | STVKN | NUMC | 8 | KNTNR | ||||
STKNR | BOM item node number | STLKN | NUMC | 8 | KNTNR | ||||
TXPOS | Indicator: text item | TXPOS | CHAR | 1 | XFELD | ||||
RTPOS | Indicator: variable-size item | RTPOS | CHAR | 1 | XFELD | ||||
INPOS | Indicator: intra material | INPOS | CHAR | 1 | XFELD | ||||
KZKUP | Indicator: co-product | KZKUP | CHAR | 1 | XFELD | ||||
KZBSF | Inventory management indicator | KZBSF | CHAR | 1 | XFELD | ||||
MTMTA | Material Type | MTART | CHAR | 4 | Assigned to domain | MTART | MTA | ||
MATKL | Material Group | MATKL | CHAR | 9 | Assigned to domain | MATKL | MKL | S_WBWG | |
MTWRK | Plant | WERKS_D | CHAR | 4 | Assigned to domain | WERKS | WRK | H_T001W_C | |
MTLME | Base Unit of Measure | MEINS | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
MTAME | Unit of issue | AUSME | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
MTURZ | Numerator for Conversion to Base Units of Measure | UMREZ | DEC | 5 | UMBSZ | ||||
MTURN | Denominator for conversion to base units of measure | UMREN | DEC | 5 | UMBSN | ||||
MTDIM | MRP Type | DISMM | CHAR | 2 | Assigned to domain | DISMM | |||
MTMIS | Mixed MRP indicator | MISKZ | CHAR | 1 | MISKZ | ||||
MTDVF | MRP procedure | DISVF | CHAR | 1 | DISVF | ||||
MTDST | Low-Level Code | DISST | CHAR | 3 | DISST | ||||
MTBES | Procurement Type | BESKZ | CHAR | 1 | BESKZ | MBS | |||
MTSOB | Special procurement type | SOBSL | CHAR | 2 | Assigned to domain | SOBSL | |||
MTCHA | Batch management requirement indicator | XCHPF | CHAR | 1 | XFELD | ||||
MTSEK | Dependent requirements ind. for individual and coll. reqmts | SBDKZ | CHAR | 1 | SBDKZ | ||||
MTALT | Method for Selecting Alternative Bills of Material | ALTSL | CHAR | 1 | ALTSL | ||||
MTAUS | Assembly scrap in percent | AUSSS | DEC | 5(2) | DEC3_2 | ||||
MTKFM | Configurable Material | KZKFG | CHAR | 1 | XFELD | ||||
MTREV | Revision Level Has Been Assigned to the Material | KZREV | CHAR | 1 | XFELD | ||||
MTDZT | In-house production time | DZEIT | DEC | 3 | DEC3 | ||||
MTPZT | Planned Delivery Time in Days | PLIFZ | DEC | 3 | DEC3 | ||||
MTWZT | Goods Receipt Processing Time in Days | WEBAZ | DEC | 3 | DEC3 | ||||
MTBZT | Processing time | BEARZ | DEC | 5(2) | DEC3_2 | ||||
MTRZT | Setup and teardown time | RUEZT | DEC | 5(2) | DEC3_2 | ||||
MTTZT | Interoperation time | TRANZ | DEC | 5(2) | DEC3_2 | ||||
MTBMG | Base quantity | BASMG | QUAN | 13(3) | MENG13 | ||||
MTAKZ | Discontinuation indicator | KZAUS | CHAR | 1 | KZAUS | ||||
MTADT | Effective-Out Date | AUSDT | DATS | 8 | DATUM | ||||
MTNMT | Follow-Up Material | NFMAT | CHAR | 18 | Assigned to domain | MATN1 | MATNR | MAT | |
MTLPR | Issue Storage Location | LGPRO | CHAR | 4 | Assigned to domain | LGORT | |||
MTEPR | Withdrawal sequence group for stocks | EPRIO | CHAR | 4 | Assigned to domain | EPRIO | |||
MTSGT | Indicator: Bulk Material | SCHGT | CHAR | 1 | XFELD | ||||
MTMNG | Quantity Updating in Material Master Record | MENGU | CHAR | 1 | XFELD | ||||
MTWRT | Value Update in Material Master Record | WERTU | CHAR | 1 | XFELD | ||||
MTPIO | Pipeline Handling Mandatory | KZPIP | CHAR | 1 | XFELD | ||||
MTPIZ | Pipeline handling allowed | XPIZU | CHAR | 1 | XFELD | ||||
MTRCD | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
MTVFP | Checking Group for Availability Check | MTVFP | CHAR | 2 | Assigned to domain | MTVFP | |||
KZBED | Indicator for Requirements Grouping | KZBED | CHAR | 1 | KZBED | ||||
DSPST | Explosion type | CS_DISPO | CHAR | 2 | Assigned to domain | CS_DISPO | |||
MTPVB | Production Supply Area | PRVBE | CHAR | 10 | Assigned to domain | PRVBE | PVB | ||
APOKZ | Indicator: Is material relevant for APO | APOKZ | CHAR | 1 | APOKZ | ||||
NLFZV | Lead-time offset for operation | CS_NLFZV | DEC | 3 | NLFZT | ||||
NLFMV | Unit for lead-time offset for operation | CS_NLFMV | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
ITSOB | Special procurement type for BOM item | CS_SOBSL | CHAR | 2 | Assigned to domain | SOBSL |
Key field | Non-key field |
How do I retrieve data from SAP append structure CPPER3E_EXPLOUT using ABAP code?
As CPPER3E_EXPLOUT is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on CPPER3E_EXPLOUT as there is no data to select. You could however select data from any tables that this append structure has been assigned too.How to access SAP table CPPER3E_EXPLOUT
Within an ECC or HANA version of SAP you can also view further information about CPPER3E_EXPLOUT and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects