CMP_ITEM_DATA_ALV SAP (Structure for ALV Display in Complaints Processing) Structure details
Description: Structure for ALV Display in Complaints Processing
Related tables to CMP_ITEM_DATA_ALV
Access table CMP_ITEM_DATA_ALV
Structure field list including key, data, relationships and ABAP select examples
CMP_ITEM_DATA_ALV is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Structure for ALV Display in Complaints Processing" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_CMP_ITEM_DATA_ALV TYPE CMP_ITEM_DATA_ALV.
The CMP_ITEM_DATA_ALV table consists of various fields, each holding specific information or linking keys about Structure for ALV Display in Complaints Processing data available in SAP. These include FKART (Billing Type), AUART (Sales Document Type), ITEM_TYPE (Sales document item category), DOCTYP (Document Category of Complaint).. 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 (Deep)
SAP CMP_ITEM_DATA_ALV 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 |
FKART | Billing Type | FKART | CHAR | 4 | Assigned to domain | FKART | |||
AUART | Sales Document Type | AUART | CHAR | 4 | Assigned to domain | AUART | AUART | AAT | |
ITEM_TYPE | Sales document item category | PSTYV | CHAR | 4 | Assigned to domain | PSTYV | |||
DOCTYP | Document Category of Complaint | CMP_COMPL_DOCTYP | CHAR | 6 | CMP_COMPLAINT_DOCTYP | ||||
CHGFLAG | Item in Complaints Processing Can Be Changed | CMP_CHANGE | CHAR | 1 | XFELD | ||||
CHKFLAG | Check Quantities in Complaints Processing | CMP_CHKFLAG | CHAR | 1 | XFELD | ||||
COMPREASTXT | Text for Complaints Reason | CMP_COMPREASTXT | CHAR | 50 | CHAR50 | ||||
SELFLAG | Selected Item | CMP_SELFLAG | CHAR | 1 | CHAR1 | ||||
DOCNR | Follow-On Document | CMPDOCNR | CHAR | 10 | ALPHA | BELNR | |||
LDOCNR | Reference Document | CMPVBLNR | CHAR | 10 | Assigned to domain | ALPHA | VBELN | ||
KUNNR | Customer Numbers | KUNNR | CHAR | 10 | Assigned to domain | ALPHA | KUNNR | KUN | C_KUNNR |
INTPOS | Subitem | CMPINTPOS | NUMC | 6 | Assigned to domain | POSNR | |||
LASTINTPOS | Item Number of the SD Document | LASTINTPOS | NUMC | 6 | Assigned to domain | POSNR | |||
UPOS | Item Number of the SD Document | UPOSNRCMP | NUMC | 6 | Assigned to domain | POSNR | |||
CREDITMNG | Cumulated Credit Memo Quantity | CMP_CREDITMNG | QUAN | 13(3) | MENG13 | ||||
CREDITMEINS | Cumulated Credit Memo Unit of Measure | CMP_CREDITMEINS | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
PRINTSTATUS | Complaints Processing: Document Already Printed? | CMP_PRINTSTATUS | CHAR | 1 | CHAR1 | ||||
RETURNSTATUS | Complaints Processing: Returns Completed? | CMP_RETURNSTATUS | CHAR | 1 | CHAR1 | ||||
CMP_PRICE1 | Complaints Processing: Price 1 | CMP_PRICE1 | CURR | 11(2) | WERTV6 | ||||
CMP_KPEIN1 | Condition Pricing Unit 1 | CMP_KPEIN1 | DEC | 5 | KPEIN | ||||
CMP_KMEIN1 | Condition Unit 1 | CMP_KMEIN1 | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
CMP_KWAEH1 | Condition Currency (for Cumulation Fields) | CMP_KWAEH1 | CUKY | 5 | Assigned to domain | WAERS | |||
CMP_KWAEH1_INT | Currency Key | WAERS | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
CMP_KOEIN1 | Rate unit (currency, sales unit, or %) | KOEIN | CUKY | 5 | KOEIN | ||||
CMP_PRICE2 | Complaints Processing: Price 2 | CMP_PRICE2 | CURR | 11(2) | WERTV6 | ||||
CMP_KPEIN2 | Condition Pricing Unit 2 | CMP_KPEIN2 | DEC | 5 | KPEIN | ||||
CMP_KMEIN2 | Condition Unit 2 | CMP_KMEIN2 | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
CMP_KWAEH2 | Condition Currency 2 | CMP_KWAEH2 | CUKY | 5 | Assigned to domain | WAERS | |||
CMP_KWAEH2_INT | Currency Key | WAERS | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
CMP_PRICE3 | Complaints Processing: Price 3 | CMP_PRICE3 | CURR | 11(2) | WERTV6 | ||||
CMP_KPEIN3 | Condition Pricing Unit 3 | CMP_KPEIN3 | DEC | 5 | KPEIN | ||||
CMP_KMEIN3 | Condition Unit 3 | CMP_KMEIN3 | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
CMP_KWAEH3 | Condition Currency 3 | CMP_KWAEH3 | CUKY | 5 | Assigned to domain | WAERS | |||
CMP_KWAEH3_INT | Currency Key | WAERS | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
CMP_PRICE4 | Complaints Processing: Price 4 | CMP_PRICE4 | CURR | 11(2) | WERTV6 | ||||
CMP_KPEIN4 | Condition Pricing Unit 4 | CMP_KPEIN4 | DEC | 5 | KPEIN | ||||
CMP_KMEIN4 | Unit of Measure 4 | CMP_KMEIN4 | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
CMP_KWAEH4 | Condition Currency 4 | CMP_KWAEH4 | CUKY | 5 | Assigned to domain | WAERS | |||
CMP_KWAEH4_INT | Currency Key | WAERS | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
CMP_PRICE5 | Complaints Processing: Price 5 | CMP_PRICE5 | CURR | 11(2) | WERTV6 | ||||
CMP_KPEIN5 | Condition Pricing Unit 5 | CMP_KPEIN5 | DEC | 5 | KPEIN | ||||
CMP_KMEIN5 | Condition Unit 5 | CMP_KMEIN5 | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
CMP_KWAEH5 | Condition Currency 5 | CMP_KWAEH5 | CUKY | 5 | Assigned to domain | WAERS | |||
CMP_KWAEH5_INT | Currency Key | WAERS | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
CMP_PRICE6 | Complaints Processing: Price 6 | CMP_PRICE6 | CURR | 11(2) | WERTV6 | ||||
CMP_KPEIN6 | Condition Pricing Unit 6 | CMP_KPEIN6 | DEC | 5 | KPEIN | ||||
CMP_KMEIN6 | Condition Unit 6 | CMP_KMEIN6 | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
CMP_KWAEH6 | Condition Currency 6 | CMP_KWAEH6 | CUKY | 5 | Assigned to domain | WAERS | |||
CMP_KWAEH6_INT | Currency Key | WAERS | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
CMP_MATNR_NEU | New Article Number Entered | CMP_MATNR_NEU | CHAR | 1 | XFELD | ||||
CMP_FKIMG_NEW | New Quantity Entered | CMP_FKIMG_NEW | CHAR | 1 | XFELD | ||||
CMP_VRKME_NEW | New Sales Unit Entered | CMP_VRKME_NEW | CHAR | 1 | XFELD | ||||
CMP_PRICE_NEW | New Price Entered | CMP_PRICE_NEW | CHAR | 1 | XFELD | ||||
VBELN | Billing Document | VBELN_VF | CHAR | 10 | Assigned to domain | ALPHA | VBELN | VF | |
POSNR | Billing item | POSNR_VF | NUMC | 6 | Assigned to domain | POSNR | |||
UEPOS | Higher-level item in bill of material structures | UEPOS | NUMC | 6 | VBUP | POSNR | |||
FKIMG | Actual Invoiced Quantity | FKIMG | QUAN | 13(3) | MENG13 | ||||
VRKME | Sales Unit | CMP_VRKME | UNIT | 3 | T006 | CUNIT | MEINS | ||
UMVKZ | Numerator (factor) for conversion of sales quantity into SKU | UMVKZ | DEC | 5 | UMBSZ | ||||
UMVKN | Denominator (Divisor) for Conversion of Sales Qty into SKU | UMVKN | DEC | 5 | UMBSN | ||||
MEINS | Base Unit of Measure | MEINS | UNIT | 3 | T006 | CUNIT | MEINS | ||
MATNR | Material Number | MATNR | CHAR | 18 | Assigned to domain | MATN1 | MATNR | MAT | S_MAT1 |
ARKTX | Short text for sales order item | ARKTX | CHAR | 40 | TEXT40 | ||||
MATKL | Material Group | MATKL | CHAR | 9 | T023 | MATKL | MKL | S_WBWG | |
PSTYV | Sales document item category | PSTYV | CHAR | 4 | Assigned to domain | PSTYV | |||
POSAR | Item type | POSAR | CHAR | 1 | POSAR | ||||
PRODH | Product hierarchy | PRODH_D | CHAR | 18 | T179 | PRODH | VPR | ||
WERKS | Plant | WERKS_D | CHAR | 4 | T001W | WERKS | WRK | H_T001W_C | |
NTGEW | Net weight | NTGEW_15 | QUAN | 15(3) | MENG15 | ||||
BRGEW | Gross weight | BRGEW_15 | QUAN | 15(3) | MENG15 | ||||
GEWEI | Weight Unit | GEWEI | UNIT | 3 | T006 | CUNIT | MEINS | ||
VOLUM | Volume | VOLUM_15 | QUAN | 15(3) | MENG15 | ||||
VOLEH | Volume unit | VOLEH | UNIT | 3 | T006 | CUNIT | MEINS | ||
NETWR | Net value of the billing item in document currency | NETWR_FP | CURR | 15(2) | WERTV8 | ||||
VBELV | Originating document | VBELV | CHAR | 10 | VBUK | ALPHA | VBELN | ||
POSNV | Originating item | POSNV | NUMC | 6 | VBUP | POSNR | |||
VGBEL | Document number of the reference document | VGBEL | CHAR | 10 | VBUK | ALPHA | VBELN | ||
VGPOS | Item number of the reference item | VGPOS | NUMC | 6 | VBUP | POSNR | |||
VGTYP | Document category of preceding SD document | VBTYP_V | CHAR | 1 | VBTYP | ||||
AUBEL | Sales Document | VBELN_VA | CHAR | 10 | VBUK | ALPHA | VBELN | AUN | |
AUPOS | Sales Document Item | POSNR_VA | NUMC | 6 | VBUP | POSNR | APO | ||
AUREF | Sales document was created from reference | AUREF | CHAR | 1 | XFELD | ||||
SHKZG | Debit/Credit Indicator | SHKZG | CHAR | 1 | SHKZG | ||||
LGORT | Storage Location | LGORT_D | CHAR | 4 | T001L | LGORT | LAG | ||
KZWI1 | Subtotal 1 from pricing procedure for condition | KZWI1 | CURR | 13(2) | WERTV7 | ||||
KZWI2 | Subtotal 2 from pricing procedure for condition | KZWI2 | CURR | 13(2) | WERTV7 | ||||
KZWI3 | Subtotal 3 from pricing procedure for condition | KZWI3 | CURR | 13(2) | WERTV7 | ||||
KZWI4 | Subtotal 4 from pricing procedure for condition | KZWI4 | CURR | 13(2) | WERTV7 | ||||
KZWI5 | Subtotal 5 from pricing procedure for condition | KZWI5 | CURR | 13(2) | WERTV7 | ||||
KZWI6 | Subtotal 6 from pricing procedure for condition | KZWI6 | CURR | 13(2) | WERTV7 | ||||
MATWA | Material entered | MATWA | CHAR | 18 | Assigned to domain | MATN1 | MATNR | MAT | |
FKLMG | Billing quantity in stockkeeping unit | FKLMG | QUAN | 13(3) | MENG13 | ||||
SPART | Division | SPART | CHAR | 2 | Assigned to domain | SPART | SPA | C_SPART | |
COMPREAS | Abbreviation for Complaints Reason | CMP_COMPREAS | CHAR | 4 | Assigned to domain | CMP_COMPREAS | |||
WAERK | SD Document Currency | WAERK | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
ETENR | Delivery Schedule Line Number | ETENR | NUMC | 4 | Assigned to domain | ETENR | |||
ZAEHL | Counter in control tables | DZAEHLER | NUMC | 2 | NUMC2 | ||||
MSGID | Message identification | MSGID | CHAR | 20 | Assigned to domain | ARBGB | |||
MSGNO | System Message Number | MSGNO | CHAR | 3 | Assigned to domain | MSGNR | |||
MSGTY | Message Type | MSGTY | CHAR | 1 | MSGAR | ||||
MSGV1 | Message variable 01 | MSGV1 | CHAR | 50 | CHAR50 | ||||
MSGV2 | Message variable 02 | MSGV2 | CHAR | 50 | CHAR50 | ||||
MSGV3 | Message variable 03 | MSGV3 | CHAR | 50 | CHAR50 | ||||
MSGV4 | Message variable 04 | MSGV4 | CHAR | 50 | CHAR50 | ||||
SMART | Group type | SMART | CHAR | 1 | Assigned to domain | SMART | GRA | ||
LOEKZ | Asset class marked for deletion | LOEKZ | CHAR | 1 | XFELD | ||||
UPOS_CHG | Subitem has already been processed | UPOS_CHG | CHAR | 1 | XCHAR | ||||
MERK_MENG | Actual Invoiced Quantity | FKIMG | QUAN | 13(3) | MENG13 | ||||
KDREF | Customer Reference Number | KDREF | CHAR | 20 | KDREF | ||||
CT | 0 |
Key field | Non-key field |
How do I retrieve data from SAP structure CMP_ITEM_DATA_ALV using ABAP code?
As CMP_ITEM_DATA_ALV 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 CMP_ITEM_DATA_ALV as there is no data to select.How to access SAP table CMP_ITEM_DATA_ALV
Within an ECC or HANA version of SAP you can also view further information about CMP_ITEM_DATA_ALV 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