REXA_GUI_DOC_ITEM_L SAP (FI-CA: Document Item) Structure details
Description: FI-CA: Document Item
Related tables to REXA_GUI_DOC_ITEM_L
Access table REXA_GUI_DOC_ITEM_L
Structure field list including key, data, relationships and ABAP select examples
REXA_GUI_DOC_ITEM_L 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 "FI-CA: Document Item" 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_REXA_GUI_DOC_ITEM_L TYPE REXA_GUI_DOC_ITEM_L.
The REXA_GUI_DOC_ITEM_L table consists of various fields, each holding specific information or linking keys about FI-CA: Document Item data available in SAP. These include DOC_NO (Number of Contract Accts Rec. & Payable Doc.), REP_ITEM (Repetition Item in Contract Account Document), ITEM (Item number in contract account document), SUB_ITEM (Subitem for a Partial Clearing in Document).. 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 REXA_GUI_DOC_ITEM_L 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 |
DOCGUID | GUID: Unique Internal Key for RE Document | RERADOCGUID | RAW | 16 | RECAGUID | ||||
DOC_NO | Number of Contract Accts Rec. & Payable Doc. | OPBEL_KK | CHAR | 12 | Assigned to domain | ALPHA | OPBEL_KK | 80B | |
REP_ITEM | Repetition Item in Contract Account Document | OPUPW_KK | NUMC | 3 | OPUPW_KK | ||||
ITEM | Item number in contract account document | OPUPK_KK | NUMC | 4 | OPUPK_KK | ||||
SUB_ITEM | Subitem for a Partial Clearing in Document | OPUPZ_KK | NUMC | 3 | OPUPZ_KK | ||||
COMP_CODE | Company Code | BUKRS | CHAR | 4 | T001 | BUKRS | BUK | C_T001 | |
BUS_AREA | Business Area | GSBER | CHAR | 4 | TGSB | GSBER | GSB | ||
STATUS | Clearing status | AUGST_KK | CHAR | 1 | AUGST_KK | ||||
BUSPARTNER | Business Partner Number | GPART_KK | CHAR | 10 | BUT000 | ALPHA | BU_PARTNER | BPA | |
CONTRACT | Reference Specifications from Contract | VTREF_KK | CHAR | 20 | ALPHA | VTREF_KK | VTZ | ||
CONTRACT2 | Additional Reference Information | VTRE2_KK | CHAR | 20 | ALPHA | VTREF_KK | |||
CONT_ACCT | Contract Account Number | VKONT_KK | CHAR | 12 | FKKVK | ALPHA | VKONT_KK | KTO | FKKVKP_F4 |
SUB_DOC | Number of the substitute FI-CA document | ABWBL_KK | CHAR | 12 | ALPHA | ABWBL_KK | |||
DOC_CAT | Category of substitute document in FI-CA | ABWTP_KK | CHAR | 1 | ABWTP_KK | ||||
APPL_AREA | Application area | APPLK_KK | CHAR | 1 | APPLK_KK | ||||
MAIN_TRANS | Main Transaction for Line Item | HVORG_KK | CHAR | 4 | TFKHVO | HVORG_KK | 8HV | ||
SUB_TRANS | Subtransaction for Document Item | TVORG_KK | CHAR | 4 | TFKTVO | TVORG_KK | |||
ACTDETERID | Account Determination ID | KOFIZ_KK | CHAR | 2 | KOFIZ_KK | ||||
DIVISION | Division | SPART_KK | CHAR | 2 | TSPA | SPART | SPA | ||
G_L_ACCT | General ledger account | HKONT_KK | CHAR | 10 | SKA1 | ALPHA | SAKNR | SAKO | |
TAX_CODE | Tax on sales/purchases code | MWSKZ | CHAR | 2 | T007A | MWSKZ | |||
DOWN_PMNT | Item is a Down Payment/Down Payment Request | XANZA_KK | CHAR | 1 | XFELD | ||||
STAT_KEY | Type of statistical item | STAKZ_KK | CHAR | 1 | STAKZ_KK | ||||
DOC_DATE | Document Date in Document | BLDAT | DATS | 8 | DATUM | ||||
POST_DATE | Posting Date in the Document | BUDAT_KK | DATS | 8 | DATUM | ||||
TEXT | Item text | OPTXT_KK | CHAR | 50 | TEXT50 | ||||
NET_DATE | Due date for net payment | FAEDN_KK | DATS | 8 | DATUM | ||||
DISC_DUE | Due Date for Cash Discount | FAEDS_KK | DATS | 8 | DATUM | ||||
ONLY_OFF | Item Can Only Be Cleared | VERKZ_KK | CHAR | 1 | VERKZ_KK | ||||
DEFERRAL | Deferral to | STUDT_KK | DATS | 8 | DATUM | ||||
DISC_RATE | Cash discount rate | SKTPZ_KK | DEC | 5(3) | PRZ23 | ||||
NO_DUNNING | Exclude Item from Dunning Run | XMANL_KK | CHAR | 1 | XFELD | ||||
TRAN_RATE | Exchange rate | KURSF_KK | DEC | 9(5) | EXCRT | KURSF | |||
CURRENCY | Transaction Currency | BLWAE_KK | CUKY | 5 | TCURC | WAERS | FWS | ||
CURRENCY_ISO | ISO currency code | ISOCD | CHAR | 3 | ISOCD | ||||
AMOUNT_LOC_CURR | Amount in Local Currency with +/- Signs | BP_BETRH_KK | DEC | 23(4) | BAPICURR | ||||
AMOUNT | Amount in Transaction Currency with +/- Sign | BP_BETRW_KK | DEC | 23(4) | BAPICURR | ||||
AMOUNT_PAR2_CURR | Amount in second parallel currency with +/- sign | BP_BETR2_KK | DEC | 23(4) | BAPICURR | ||||
AMOUNT_PAR3_CURR | Amount in third parallel currency with +/- sign | BP_BETR3_KK | DEC | 23(4) | BAPICURR | ||||
DISCOUNT_BASE | Amount eligible for cash discount in document currency | BP_SKFBT_KK | DEC | 23(4) | BAPICURR | ||||
TAX_AMOUNT_LOC_CURR | Tax Amount in Local Currency with +/- Sign | BP_SBETH_KK | DEC | 23(4) | BAPICURR | ||||
TAX_AMOUNT | Tax amount in transaction currency with +/- sign | BP_SBETW_KK | DEC | 23(4) | BAPICURR | ||||
TAX_AMOUNT_PAR2_CURR | Tax amount in second parallel currency | BP_SBET2_KK | DEC | 23(4) | BAPICURR | ||||
TAX_AMOUNT_PAR3_CURR | Tax amount in third parallel currency | BP_SBET3_KK | DEC | 23(4) | BAPICURR | ||||
TAX_ACCT | Account for posting taxes for down payments | MWSKO_KK | CHAR | 10 | SKA1 | ALPHA | SAKNR | ||
OFFSET_TAX | Account for offsetting tax posting in down payments | MWVKO_KK | CHAR | 10 | SKA1 | ALPHA | SAKNR | ||
PMNT_BLOCK | Lock Reason for Automatic Payment | SPZAH_KK | CHAR | 1 | TFK008 | SPZAH_KK | |||
PMNT_METH | Payment Method | PYMET_KK | CHAR | 1 | TFK042Z | PYMET_KK | |||
PERSON_NO | Personnel Number | PERNR_D | NUMC | 8 | PERNR | PER | |||
GROUPING | Grouping Key for Displaying Open Items | GRKEY_KK | CHAR | 3 | CHAR3 | ||||
PERIOD_KEY | Key for Period Assignment | PERSL_KK | CHAR | 4 | TFK001P | PERSL_KK | |||
CHG_BLOCK | Printing - No Changes Possible | XAESP_KK | CHAR | 1 | XFELD | ||||
CLEARDATE | Clearing date | AUGDT_KK | DATS | 8 | DATUM | ||||
CLEARDOCNO | Clearing Document or Printed Document | AUGBL_KK | CHAR | 12 | ALPHA | AUGBL_KK | |||
CL_POSTDTE | Clearing document posting date | AUGBD_KK | DATS | 8 | DATUM | ||||
CLEAR_REAS | Clearing Reason | AUGRD_KK | CHAR | 2 | TFK001A | AUGRD_KK | |||
CLRG_CURR | Clearing currency | AUGWA_KK | CUKY | 5 | TCURC | WAERS | |||
CLRG_CURR_ISO | ISO currency code | ISOCD | CHAR | 3 | ISOCD | ||||
AMOUNT_CLEAR | Clearing amount in clearing currency | BP_AUGBT_KK | DEC | 23(4) | BAPICURR | ||||
TAX_AMOUNT_CLEAR | Tax Amount in Clearing Currency | BP_AUGBS_KK | DEC | 23(4) | BAPICURR | ||||
VAL_DATE | Value date for clearing | AUGVD_KK | DATS | 8 | DATUM | ||||
CANCELED | Item Canceled | AUGOB_KK | CHAR | 1 | XFELD | ||||
NO_REPS | Number of repetition items | WHANG_KK | NUMC | 3 | NUM03 | ||||
REPET_GRP | Repetition group | WHGRP_KK | NUMC | 3 | Assigned to domain | WHGRP_KK | |||
LINE_ITEM | Create Line Item in General Ledger | XEIPH_KK | CHAR | 1 | XFELD | ||||
DUNN_PROC | Dunning Procedure | MAHNV_KK | CHAR | 2 | TFK047A | MAHNV_KK | FKK_MAHNV | ||
DUNN_BLOCK | Dunning Lock Reason | MANSP_KK | CHAR | 1 | TFK047S | MANSP_KK | |||
CHECK_CLNG | Check Sample Record Clearing | XAUGP_KK | CHAR | 1 | XFELD | ||||
CALC_PERLO | Lower Limit of Settlement Period | ABRZU_KK | DATS | 8 | DATUM | ||||
CALC_PERHI | Upper Limit of the Billing Period | ABRZO_KK | DATS | 8 | DATUM | ||||
PLAN_GRP | Planning Group | FDGRP_KK | CHAR | 10 | T035 | ALPHA | FDGRP | FFG | |
PLAN_LEVEL | Planning level | FDLEV_KK | CHAR | 2 | T036 | FDLEV | FFE | ||
CM_EX_DAYS | Additional Days for Cash Management | FDZTG_KK | NUMC | 2 | NUM2 | ||||
AMOUNT_PLANNED | Currency amount in BAPI interfaces | BAPICURR_D | DEC | 23(4) | BAPICURR | ||||
PART_CLRG | Item Split | XTAUS_KK | CHAR | 1 | XFELD | ||||
RESTRICT | Clearing restriction | AUGRS_KK | CHAR | 1 | AUGRS_KK | ||||
PAYMNT_GRP | Grouping field for automatic payments | PYGRP_KK | CHAR | 10 | CHAR10 | ||||
INT_BLOCK | Interest Lock Reason | SPERZ_KK | CHAR | 1 | TFK056S | SPERZ_KK | |||
INT_INFO | Doubtful Item Entry/Individual Value Adjustment | INFOZ_KK | NUMC | 3 | INFOZ_KK | ||||
TAXJURCODE | Tax Jurisdiction | TXJCD | CHAR | 15 | TTXJ | TXJCD | TXJ | ||
TAX_DATE | Decisive Date for Calculating Taxes | TXDAT_KK | DATS | 8 | DATUM | ||||
TRADE_ID | Company ID of trading partner | RASSC | CHAR | 6 | T880 | ALPHA | RCOMP | PGS | |
ACCTASSCAT | Account Assignment Category | KONTT_KK | CHAR | 2 | TFK000K | KONTT_KK | |||
ACCT_ASSGT | Acct assnmnt string for industry-specific account assngments | KONTL_KK | CHAR | 50 | CHAR50 | ||||
DUN_INDIC | Dunning indicator | OPSTA_KK | CHAR | 3 | OPSTA_KK | ||||
DOC_TYPE | Document Type | BLART_KK | CHAR | 2 | TFK003 | BLART_KK | |||
PARTNER | Alternative Business Partner for Payments | EMGPA_KK | CHAR | 10 | BUT000 | ALPHA | BU_PARTNER | BUPA | |
BK_DETAILS | Bank Details ID of Payee | EMBVT_KK | CHAR | 4 | CHAR4 | ||||
ADDR_NO | Address number | AD_ADDRNUM | CHAR | 10 | Assigned to domain | ALPHA | AD_ADDRNUM | ADR | |
INT_KEY | Interest Key | IKEY_KK | CHAR | 2 | TFK056A | IKEY_KK | |||
EURO_STAT | Status of Euro Conversion | EUROU_KK | CHAR | 1 | EUROU_KK | ||||
REVERSECLG | Clearing posting reversed | XRAGL_KK | CHAR | 1 | XFELD | ||||
XREPETPOS | Expanded Repetition Item | XWHPO_KK | CHAR | 1 | XFELD | ||||
STAT_KEY_SRC | Statistical Key of the Initiating Item | ASTKZ_KK | CHAR | 1 | ASTKZ_KK | ||||
REF_DOC_NO | Reference document number | XBLNR_KK | CHAR | 16 | ALPHA | XBLNR_KK | |||
COLLECTION_POS | Collection Item | INKPS_KK | NUMC | 3 | NUM03 | ||||
REFERENCE_ITEM | Reference Item In FI-CA Document | RFUPK_KK | NUMC | 4 | OPUPK_KK | ||||
OTHER_TAX_CODE | Tax Code for Other Taxes | STRKZ_KK | CHAR | 2 | Assigned to domain | STRKZ_KK | |||
TAX_CATEGORY | Tax type | J_1AFITP_D | CHAR | 2 | Assigned to domain | J_1AFITP | |||
CRD_DETAILS | Alternative Payment Card ID in Document | EMCRD_KK | CHAR | 6 | CHAR6 | ||||
FM_CATEGORY | Update Method for FM - FI-CA Integration | FMTYP_KK | CHAR | 2 | FMTYP_KK | ||||
FM_ORIG_AREA | Original FM Area for FM Account Assignment | ORIGFIKRS_KK | CHAR | 4 | Assigned to domain | FIKRS | |||
CMMT_ITEM | Commitment Item | FM_FIPEX | CHAR | 24 | Assigned to domain | FM_FIPEX | FPS | ||
FUNDS_CTR | Funds Center | FISTL | CHAR | 16 | Assigned to domain | FISTL | FIS | ||
FUND | Fund | BP_GEBER | CHAR | 10 | Assigned to domain | BP_GEBER | FIC | ||
FUNC_AREA | Functional Area | FKBER | CHAR | 16 | Assigned to domain | FKBER | FBE | ||
W_TAX_CODE | Withholding Tax Code | QSSKZ | CHAR | 2 | Assigned to domain | QSSKZ | |||
W_TAX_SUPPL | Withholding Tax Supplement | QSSEW_KK | CHAR | 2 | Assigned to domain | QSSEW_KK | |||
W_TAX_LICAT | Line Item Category From Withholding Tax View | QSPTP_KK | CHAR | 1 | QSPTP_KK | ||||
W_TAX_BASE | Tax Base Amount | BP_QSSHB_KK | DEC | 23(4) | BAPICURR | ||||
W_TAX_AMOUNT | Withholding Tax Amount in Document Currency | BP_QBSHB_KK | DEC | 23(4) | BAPICURR | ||||
EXEMPT_NO | Certificate Number of the Withholding Tax Exemption | QSZNR | CHAR | 10 | CHAR10 | ||||
MEASURE | Funded Program | FM_MEASURE | CHAR | 24 | Assigned to domain | FM_MEASURE | FM_MEASURE | ||
GRANT_NBR | Grant | GM_GRANT_NBR | CHAR | 20 | ALPHA | GM_GRANT_NBR | GM_GRANT_NBR | GRANTS_GENERIC | |
FISC_YEAR | Fiscal Year | GJAHR | NUMC | 4 | GJAHR | GJAHR | GJR | ||
CLASS_KEY | Classification Key | OPORD_KK | CHAR | 35 | CHAR35 | ||||
SUB_APPLICATION | Subapplication in Contract Accounts Receivable and Payable | SUBAP_KK | CHAR | 1 | SUBAP_KK | 8SA | |||
AMOUNT_GL | Amount for Updating in General Ledger | BP_PSWBT_KK | DEC | 23(4) | BAPICURR | ||||
TAX_AMOUNT_GL | Tax Amount for Update in General Ledger | BP_PSWTX_KK | DEC | 23(4) | BAPICURR | ||||
CURRENCY_GL | Update Currency for General Ledger Transaction Figures | PSWSL_KK | CUKY | 5 | Assigned to domain | WAERS | |||
CURRENCY_GL_ISO | ISO currency code | ISOCD | CHAR | 3 | ISOCD | ||||
FINAL_RECIPIENT | Contract Account of Final Recipient | FINRE_KK | CHAR | 12 | Assigned to domain | ALPHA | VKONT_KK | FKKVKP_F4 | |
SENDER_ID | Sender ID of Systems Connected to FI-CA | SENDR_KK | CHAR | 3 | SENDR_KK | ||||
REFERENCE_POSITION | Reference Item for External Billing System | REFKY_KK | CHAR | 35 | CHAR35 | ||||
SEGMENT | Segment for Segmental Reporting | SEGMT_KK | CHAR | 10 | Assigned to domain | ALPHA | FB_SEGMENT | ||
STAT_TAX_AMOUNT | Tax Amount as Statistical Information in Document Currency | BP_STTAX_KK | DEC | 23(4) | BAPICURR | ||||
EXTERNAL_SYSTEM | ID of External System | REFSY_KK | CHAR | 3 | REFSY_KK | ||||
PORTION_TAX_AMOUNT_LOC | Tax Portion in FI-CA Local Currency | BP_SCTAX_KK | DEC | 23(4) | BAPICURR | ||||
PROFIT_CTR | Profit Center | PRCTR | CHAR | 10 | Assigned to domain | ALPHA | PRCTR | PRC | PRCTR_EMPTY |
BUDGET_PERIOD | FM: Budget Period | FM_BUDGET_PERIOD | CHAR | 10 | Assigned to domain | FM_BUDGET_PERIOD | BUDPER | ||
CONT_POSN | Numerical Character Field of Length 6 | NUM6 | NUMC | 6 | NUM06 | ||||
CONTRACT_POS | Contract: Item Number | VTPOS_KK | NUMC | 6 | VTPOS_KK | ||||
SEPA_MANDATE_ID | Unique Referene to Mandate per Payment Recipient | SEPA_MNDID | CHAR | 35 | ID035 | ||||
REFGUID | Reference GUID | RERAREFGUID | RAW | 16 | RECAGUID | ||||
FLOW_TYPE | Flow Type | RECDFLOWTYPE | CHAR | 4 | Assigned to domain | ALPHA | RECDFLOWTYPE | ||
SEPAMNDID | SEPA Mandate: Unique Reference to Mandate per Vendor | REXASEPAMNDID | CHAR | 35 | REXASEPAMNDID | ||||
SEPARECCRDID | SEPA Mandate: Creditor ID | REXASEPARECCRDID | CHAR | 35 | REXASEPACRDID |
Key field | Non-key field |
How do I retrieve data from SAP structure REXA_GUI_DOC_ITEM_L using ABAP code?
As REXA_GUI_DOC_ITEM_L 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 REXA_GUI_DOC_ITEM_L as there is no data to select.How to access SAP table REXA_GUI_DOC_ITEM_L
Within an ECC or HANA version of SAP you can also view further information about REXA_GUI_DOC_ITEM_L 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