ARRANG_ALV_GRID_DISP_ITEM_STY SAP (Display Structure of Item Data in ALV Grid) Structure details
Description: Display Structure of Item Data in ALV Grid
Related tables to ARRANG_ALV_GRID_DISP_ITEM_STY
Access table ARRANG_ALV_GRID_DISP_ITEM_STY
Structure field list including key, data, relationships and ABAP select examples
ARRANG_ALV_GRID_DISP_ITEM_STY 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 "Display Structure of Item Data in ALV Grid" 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_ARRANG_ALV_GRID_DISP_ITEM_STY TYPE ARRANG_ALV_GRID_DISP_ITEM_STY.
The ARRANG_ALV_GRID_DISP_ITEM_STY table consists of various fields, each holding specific information or linking keys about Display Structure of Item Data in ALV Grid data available in SAP. These include COUNTER_ITEM (Counter), KNUMA (Agreement (various conditions grouped together)), LINE_TYPE (Type of Displayed Line (for example, Billing Doc., Vendor)), SUM_LINE (Summary Line).. 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 ARRANG_ALV_GRID_DISP_ITEM_STY 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 |
COUNTER_ITEM | Counter | ARRANG_COUNTER | NUMC | 10 | NUMC10 | ||||
KNUMA | Agreement (various conditions grouped together) | KNUMA | CHAR | 10 | Assigned to domain | ALPHA | KNUMA | VMBO | |
LINE_TYPE | Type of Displayed Line (for example, Billing Doc., Vendor) | ARRANG_LINE_TYPE_ALV | CHAR | 1 | ARRANG_LINE_TYPE_ALV | ||||
SUM_LINE | Summary Line | DSUM_LINE | CHAR | 1 | XFLAG | ||||
SCALE_LINE | Scale Line | ARRANG_SCALE_LINE | CHAR | 1 | XFLAG | ||||
TAX_LINE | Tax Item | TAX_LINE_ARRANG | CHAR | 1 | CHAR1 | ||||
COMPARISON_LINE | Business Volume Comparison Line | ARRANG_COMPARISON_LINE | CHAR | 1 | XFLAG | ||||
DESCRIPTION_LINE | Description Line | ARRANG_DESCRIPTION_LINE | CHAR | 1 | XFLAG | ||||
NO_DATA_EXIST | No Data Exists | ARRANG_DATA_EXIST | CHAR | 1 | XFLAG | ||||
ADDITIONAL_TEXT | Additional Explanatory Text | ARRANG_ADD_TEXT | CHAR | 50 | TEXT50 | ||||
STATUS_TEXT | Text for Status of Condition Record | ARRANG_STATUS_TEXT | CHAR | 28 | TEXT28 | ||||
POSNR | Item number of the SD document | POSNR | NUMC | 6 | Assigned to domain | POSNR | |||
KNUMH | Condition record number | KNUMH | CHAR | 10 | KNUMB | ||||
KOPOS | Sequential number of the condition | KOPOS | NUMC | 2 | NUM02 | ||||
KAPPL | Application | KAPPL | CHAR | 2 | Assigned to domain | KAPPL | KAP | ||
KOTABNR | Condition table | KOTABNR | NUMC | 3 | Assigned to domain | KOTABNR | KON | ||
KSCHL | Condition type | KSCHA | CHAR | 4 | Assigned to domain | KSCHL | VKS | ||
KSCHL_VTEXT | Name of Condition Type | ARRANG_KSCHL_TEXT | CHAR | 20 | TEXT20 | ||||
VAKEY_HEADER | Literal for variable key | VAKEY1 | CHAR | 255 | TEXT255 | ||||
CR_DATAB | Valid-From Date | DATAB | DATS | 8 | DATUM | ||||
CR_DATBI | Valid To Date | DATBI | DATS | 8 | DATUM | ||||
KNUMH_VB | Number of Main Condition Record | ARRANG_KNUMH_VB | CHAR | 10 | KNUMB | ||||
KRECH | Calculation type for condition | KRECH | CHAR | 1 | KRECH | ||||
KRECH_VTEXT | Calculation Rule for Condition | ARRANG_KRECH_TEXT | CHAR | 20 | TEXT20 | ||||
KZBZG | Scale basis indicator | KZBZG | CHAR | 1 | KZBZG | ||||
KZBZG_VTEXT | Scale Basis | ARRANG_KZBZG_TEXT | CHAR | 20 | TEXT20 | ||||
BOSTA | Condition Record Status (Rebate) | BOSTA_CR | CHAR | 1 | BOSTA_CR | ||||
LOEVM_KO | Deletion Indicator for Condition Item | LOEVM_KO | CHAR | 1 | XFELD | ||||
BOVER | Rebate procedure | BOVER | CHAR | 1 | BOVER | ||||
STFKZ | Scale Type | STFKZ | CHAR | 1 | STFKZ | ||||
BOMAT | Material for rebate settlement | BOMAT | CHAR | 18 | Assigned to domain | MATN1 | MATNR | MAT | |
MATNR | Material Number | MATNR | CHAR | 18 | Assigned to domain | MATN1 | MATNR | MAT | S_MAT1 |
MAKTX | Material Description (Short Text) | MAKTX | CHAR | 40 | TEXT40 | ||||
MATKL | Material Group | MATKL | CHAR | 9 | Assigned to domain | MATKL | MKL | S_WBWG | |
BOLIF | Condition granter | BOGEW | CHAR | 10 | Assigned to domain | ALPHA | LIFNR | LIF | |
BONEM | Rebate recipient | BONEM | CHAR | 10 | Assigned to domain | ALPHA | KUNNR | VBE | |
LIFNR | Vendor (PO, vendor billing document, settlement request) | BELIF | CHAR | 10 | Assigned to domain | ALPHA | LIFNR | ||
WERKS | Plant | WERKS_D | CHAR | 4 | Assigned to domain | WERKS | WRK | H_T001W_C | |
MWSKZ | Tax on sales/purchases code | MWSKZ | CHAR | 2 | Assigned to domain | MWSKZ | |||
SPMON | Period to analyze - month | SPMON | NUMC | 6 | PERI | MCPERIOD | |||
LANDL | Supplying Country | LANDL | CHAR | 3 | Assigned to domain | LAND1 | |||
EKORG | Purchasing Organization | EKORG | CHAR | 4 | Assigned to domain | EKORG | EKO | ||
EKGRP | Purchasing Group | EKGRP | CHAR | 3 | Assigned to domain | EKGRP | EKG | ||
VKORG | Sales Organization | VKORG | CHAR | 4 | Assigned to domain | VKORG | VKO | C_VKORG | |
VTWEG | Distribution Channel | VTWEG | CHAR | 2 | Assigned to domain | VTWEG | VTW | C_VTWEG | |
SPART | Division | SPART | CHAR | 2 | Assigned to domain | SPART | SPA | C_SPART | |
BUKRS | Company Code | BUKRS | CHAR | 4 | Assigned to domain | BUKRS | BUK | C_T001 | |
LTSNR | Vendor Subrange | LTSNR | CHAR | 6 | Assigned to domain | LTSNR | |||
BSTYP | Purchasing Document Category | BSTYP | CHAR | 1 | BSTYP | ||||
BSART | Purchasing Document Type | ESART | CHAR | 4 | Assigned to domain | BSART | BSA | ||
LFTYP | Agency business: Billing category | WFTYP | CHAR | 2 | WFTYP | ||||
LFART | Agency business: Billing document type | WFART | CHAR | 4 | Assigned to domain | WFART | WFA | ||
WRART | Agency business: Payment type | WRART | CHAR | 4 | Assigned to domain | WRART | WRA | ||
WBTYP | Settlement request: Payment type | WBTYP | CHAR | 1 | WBTYP | ||||
DOCTYPE | Agency Business: Document Category | DOCTYPE | CHAR | 1 | DOCTYPE | ||||
KSPAEB | Indicator: subsequent updating of vendor business volume | KSPAEB | CHAR | 1 | XFELD | ||||
SCALE_ICON | Icon in Text Fields (substitute display, alias) | ARRANG_ICON | CHAR | 4 | Assigned to domain | ICON | |||
SCALE_ADD_TEXT | Text for Scale Type | ARRANG_SCALE_TEXT | CHAR | 6 | TEXT6 | ||||
KSTBW | Scale value | KSTBW | CURR | 15(2) | WERT8 | ||||
KONWS | Scale currency | KONWS | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
KONMS | Condition scale unit of measure | KONMS | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
KBETR | Rate (condition amount or percentage) where no scale exists | KBETR_KOND | CURR | 11(2) | WERTV6 | ||||
KONWA | Rate unit (currency or percentage) | KONWA | CUKY | 5 | Assigned to domain | WAERS | |||
KPEIN | Condition pricing unit | KPEIN | DEC | 5 | KPEIN | ||||
KMEIN | Condition Unit | ARRANG_KMEIN | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
KSTBW_TECH_REF | Rate unit (currency or percentage) | KONWA | CUKY | 5 | Assigned to domain | WAERS | |||
KBETR_TECH_REF | Rate unit (currency or percentage) | KONWA | CUKY | 5 | Assigned to domain | WAERS | |||
KBRUE | Accrual Amount | KBRUE | CURR | 11(2) | WERTV6 | ||||
KBRUE_KONWA | Provision Unit (Currency or Percentage) | KBRUE_KONWA | CUKY | 5 | Assigned to domain | WAERS | |||
KBRUE_KPEIN | Price Unit - Provision Amount | KBRUE_KPEIN | DEC | 5 | KPEIN | ||||
KBRUE_KMEIN | Unit of Measure - Provision Amount | KBRUE_KMEIN | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
KBRUE_TECH_REF | Rate unit (currency or percentage) | KONWA | CUKY | 5 | Assigned to domain | WAERS | |||
KWERT_SCALE | Revenue for Scale Line | KWERT_SCALE | CURR | 13(2) | WERTV7 | ||||
KWERT_KONWA | Currency of Income - Scale Line | KWERT_SCALE_KONWA | CUKY | 5 | Assigned to domain | WAERS | |||
TAX_MWSKZ | Tax on sales/purchases code | MWSKZ | CHAR | 2 | Assigned to domain | MWSKZ | |||
TAX_KSCHL | Tax Condition Type | TAX_KSCHL | CHAR | 4 | Assigned to domain | KSCHL | |||
TAX_KSCHL_TEXT | Text - Tax Condition Type | TAX_KSCHL_TEXT | CHAR | 20 | TEXT20 | ||||
TAX_KBETR | Tax Condition Percentage | TAX_KBETR | CURR | 11(2) | WERTV6 | ||||
TAX_KONWA | Unit of Tax Rate | TAX_KONWA_ARRANG | CUKY | 5 | Assigned to domain | WAERS | |||
TAX_KBETR_TECH_REF | Rate unit (currency or percentage) | KONWA | CUKY | 5 | Assigned to domain | WAERS | |||
TAX_KWERT | Tax Amount | TAX_KWERT | CURR | 13(2) | WERTV7 | ||||
TAX_KWERT_KONWA | Currency Tax Value | TAX_KWERT_KONWA | CUKY | 5 | Assigned to domain | WAERS | |||
KSTBS | Scale base value of the condition | KSTBS | CURR | 15(2) | WERTV8 | ||||
KSTBS_KONWS | Currency Scale Basis | KSTBS_KONWS | CUKY | 5 | Assigned to domain | WAERS | |||
KSTBS_KONMS | Unit of Measure Scale Basis | KSTBS_KONMS | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
KSTBS_TECH_REF | Rate unit (currency or percentage) | KONWA | CUKY | 5 | Assigned to domain | WAERS | |||
KAWRT | Condition base value | KAWRT | CURR | 15(2) | WERTV8 | ||||
KAWRT_KONWA | Currency Condition Basis | KAWRT_KONWA | CUKY | 5 | Assigned to domain | WAERS | |||
KAWRT_KMEIN | Unit of Measure - Condition Basis | KAWRT_KMEIN | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
KWART_TECH_REF | Rate unit (currency or percentage) | KONWA | CUKY | 5 | Assigned to domain | WAERS | |||
KSTBS_PE | Scale basis for final settlement | KSTBS_PE | CURR | 15(2) | WERTV8 | ||||
KSTBS_KONWS_PER | Currency - Scale Basis - Final Settlement | KSTBS_KONWS_PER | CUKY | 5 | Assigned to domain | WAERS | |||
KSTBS_KONMS_PER | Unit of Measure Scale Basis Final Settlement | KSTBS_KONMS_PER | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
KSTBS_PER_TECH_REF | Rate unit (currency or percentage) | KONWA | CUKY | 5 | Assigned to domain | WAERS | |||
KAWRT_PE | Condition basis for final settlement | KAWRT_PE | CURR | 15(2) | WERTV8 | ||||
KAWRT_PE_KONWA | Currency Condition Basis Final Settlement | KAWRT_PE_KONWA | CUKY | 5 | Assigned to domain | WAERS | |||
KAWRT_PE_KMEIN | Unit of Measure - Condition Basis - Final Settlement | KAWRT_PE_KMEIN | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
KAWRT_PE_TECH_REF | Rate unit (currency or percentage) | KONWA | CUKY | 5 | Assigned to domain | WAERS | |||
AUWRT_END | Income from condition record | MM_AUWRT | CURR | 19(2) | WERTV10 | ||||
AUWRT_END_KONWA | Currency Income of Condition Record | AGWRT_KONWA | CUKY | 5 | Assigned to domain | WAERS | |||
AGWRT_END | Rebate income from final settlement | MM_AGWRT | CURR | 19(2) | WERTV10 | ||||
AGWRT_END_KONWA | Currency Income Final Settlement | AGWRT_END_KONWA | CUKY | 5 | Assigned to domain | WAERS | |||
ASWRT | Total income for condition record | ASWRT | CURR | 19(2) | WERTV10 | ||||
ASWRT_KONWA | Currency - Total Income of Condition Record | ASWRT_KONWA | CUKY | 5 | Assigned to domain | WAERS | |||
AUWRT | Settled income from condition record | AAWRT | CURR | 19(2) | WERTV10 | ||||
AUWRT_KONWA | Currency - Settled Income | AUWRT_KONWA | CUKY | 5 | Assigned to domain | WAERS | |||
AZWRT | Offset income for condition record | AZWRT | CURR | 19(2) | WERTV10 | ||||
AZWRT_KONWA | Currency - Offset Income | AZWRT_KONWA | CUKY | 5 | Assigned to domain | WAERS | |||
ARRANG_AUWRT | Settled Income (Net) | ARRANG_AUWRT | CURR | 19(2) | WERTV10 | ||||
ARRANG_AUWRT_KONWA | Currency - Settled Income | AUWRT_KONWA | CUKY | 5 | Assigned to domain | WAERS | |||
ARRANG_ABWRT | Settled Income From Condition Record Including Taxes | ARRANG_ABWRT | CURR | 19(2) | WERTV10 | ||||
ABWRT_KONWA | Currency of Settled Income Including Taxes | ABWRT_KONWA | CUKY | 5 | Assigned to domain | WAERS | |||
RUWRT | Provision for accrued condition income | MM_RUWRT | CURR | 19(2) | WERTV10 | ||||
RUWRT_KONWA | Currency of Provision for Accrued Condition Income | RUWRT_KONWA | CUKY | 5 | Assigned to domain | WAERS | |||
RRWRT | Provision for condition income dissolved through settlement | MM_RRWRT | CURR | 19(2) | WERTV10 | ||||
RRWRT_KONWA | Currency for Dissolved Provision for Accrued Income | RAWRT_KONWA | CUKY | 5 | Assigned to domain | WAERS | |||
ROWRT | Non-dissolved provision for accrued income in settlement run | MM_ROWRT | CURR | 19(2) | WERTV10 | ||||
ROWRT_KONWA | Currency of Open Provision for Accrued Income | ROWRT_KONWA | CUKY | 5 | Assigned to domain | WAERS | |||
EBELN | Document Number Price-Determination-Relevant Document | BELNR_NTR_ALV | CHAR | 10 | Assigned to domain | ALPHA | EBELN | ||
EBELP | Item Number - Pricing-Relevant Document | POSNR_NTR_ALV | NUMC | 6 | NUMC6 | ||||
BLTYPN | Document category price determination (subseq. settlement) | BLTYPN | CHAR | 2 | BLTYPN | ||||
BLTYPNTXT | Short text: document category (subsequent settlement) | BLTYPTXTNS | CHAR | 4 | CHAR4 | ||||
BELNR | Number of a document (updating of business volumes) | FBLNR | CHAR | 10 | ALPHA | BELNR | |||
BUZEI | Document item (updating of cum. vendor business volumes) | FBLPO | NUMC | 6 | NUMC6 | ||||
BLTYPF | Doc. type: updating of vendor business volumes | BLTYPF | CHAR | 2 | BLTYPF | ||||
BLTYPFTXT | Short Text Document Category Subsequent Settlement (Update) | BLTYPTXTFS | CHAR | 4 | CHAR4 | ||||
BUDAT | Date of LIS update (subsequent settlement) | FODAT | DATS | 8 | DATUM | ||||
WKOPAR_LI | Assignment of business volumes, messages to condition level | WKOPAR_LI | CHAR | 1 | WKOPAR_LI | ||||
WKOPARTXT | Text for Condition Level | WKOPARTXT_ALV | CHAR | 25 | CHAR25 | ||||
GJAHR | Document year: updating of business volumes | FJAHR | NUMC | 4 | GJAHR | GJAHR | |||
BUKRS_EK | Company Code | BUKRS | CHAR | 4 | Assigned to domain | BUKRS | BUK | C_T001 | |
ETENR | Delivery Schedule Line Counter | FETEN | NUMC | 4 | Assigned to domain | EETEN | |||
ABRLF | Number of a settlement run (subsequent settlement) | ABRLF | CHAR | 10 | ALPHA | ABRLF | |||
SETTLE_ATYPE | Type of sett. re condition rec.: reb. arrangements (Purch.) | ATYPE | CHAR | 1 | ATYPE | ||||
SETTLE_TYPE_TEXT | Text on settlement type | ATYPETXT | CHAR | 28 | CHAR28 | ||||
SETTLE_BLTYPA | Category of settlement document (subsequent settlement) | BLTYPA | CHAR | 2 | BLTYPA | ||||
SETTLE_BLTYPA_TEXT_M | Text (mid) Document Type Subsequent Settlement | BLTYPTXTNM | CHAR | 10 | TEXT10 | ||||
SETTLE_VBELN | Number of settlement document | BELNR_ABR | CHAR | 10 | Assigned to domain | ALPHA | VBELN | ||
SETTLE_POSNR | Item number of settlement document (subsequent settlement) | POSNR_ABR | NUMC | 6 | Assigned to domain | POSNR | |||
SETTLE_BELNR | Accounting Document Number | BELNR_D | CHAR | 10 | ALPHA | BELNR | BLN | ||
SETTLE_BUKRS | Company Code | BUKRS | CHAR | 4 | Assigned to domain | BUKRS | BUK | C_T001 | |
SETTLE_GJAHR | Fiscal Year | GJAHR | NUMC | 4 | GJAHR | GJAHR | GJR | ||
FSTORNO | Indicator for Cancellation | ARRANG_FSTORNO | CHAR | 1 | XFELD | ||||
SETTLE_BLDAT | Document Date in Document | BLDAT | DATS | 8 | DATUM | ||||
SETTLE_MABRE | Indicator: multiple settlement, condition record | MABRE | CHAR | 1 | CHAR1 | ||||
ELIKZ | 'Delivery Completed' Indicator | ELIKZ | CHAR | 1 | XFELD | ||||
PURCH_EBELN | Purchasing Document Number | EBELN | CHAR | 10 | Assigned to domain | ALPHA | EBELN | BES | MEKK_C |
PURCH_EBELP | Item Number of Purchasing Document | EBELP | NUMC | 5 | Assigned to domain | EBELP | BSP | ||
PURCH_MATNR | Material Number | MATNR | CHAR | 18 | Assigned to domain | MATN1 | MATNR | MAT | S_MAT1 |
PURCH_BSTMG | Purchase Order Quantity | BSTMG | QUAN | 13(3) | MENG13 | ||||
PURCH_WEMNG | Quantity of Goods Received | WEEMG | QUAN | 13(3) | MENG13 | ||||
PURCH_OWEMG | Open goods receipt quantity | OWEMG | QUAN | 13(3) | MENG13 | ||||
PURCH_WE_MEINS | Purchase Order Unit of Measure | BSTME | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
PURCH_OWEPZ | Open goods receipt (percentage) | OWEPZ | DEC | 5(2) | DEC3_2 | ||||
PURCH_WE_KONWA | Unit - Open Goods Entry | OWEPZ_KONWA | CUKY | 5 | Assigned to domain | WAERS | |||
PURCH_REMNG | Quantity invoiced | REMNG | QUAN | 13(3) | MENG13 | ||||
PURCH_OREMG | Open invoice receipt quantity | OREMG | QUAN | 13(3) | MENG13 | ||||
PURCH_RE_MEINS | Purchase Order Unit of Measure | BSTME | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
PURCH_OREPZ | Open invoice receipt (percentage) | OREPZ | DEC | 5(2) | DEC3_2 | ||||
PURCH_RE_KONWA | Unit - Open Invoice Receipt | OREPZ_KONWA | CUKY | 5 | Assigned to domain | WAERS | |||
T_COLOR_ITEM | 0 |
Key field | Non-key field |
How do I retrieve data from SAP structure ARRANG_ALV_GRID_DISP_ITEM_STY using ABAP code?
As ARRANG_ALV_GRID_DISP_ITEM_STY 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 ARRANG_ALV_GRID_DISP_ITEM_STY as there is no data to select.How to access SAP table ARRANG_ALV_GRID_DISP_ITEM_STY
Within an ECC or HANA version of SAP you can also view further information about ARRANG_ALV_GRID_DISP_ITEM_STY 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