J_7LV1K SAP (REA Document: Header Data) Table details
Dictionary Type: Table
Description: REA Document: Header Data
Description: REA Document: Header Data
Table field list including key, data, relationships and ABAP select examples
J_7LV1K is a standard SAP Table which is used to store REA Document: Header Data data and is available within R/3 SAP systems depending on the version and release level.
The J_7LV1K table consists of various fields, each holding specific information or linking keys about REA Document: Header Data data available in SAP. These include VBELN (REA Declaration: Document Number), AUDAT (Document Date (Date Received/Sent)), BUDAT (Posting Date in the Document), BLTYP (REA Document Category).. 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: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced
SAP J_7LV1K table 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 |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
VBELN | REA Declaration: Document Number | J_7LVNR_A | CHAR | 10 | Assigned to domain | ALPHA | VBELN | VF | |
AUDAT | Document Date (Date Received/Sent) | AUDAT | DATS | 8 | DATUM | ||||
BUDAT | Posting Date in the Document | BUDAT | DATS | 8 | DATUM | ||||
BLTYP | REA Document Category | J_7LVBTYP | CHAR | 1 | J_7LRVBTYP | ||||
BLART | Document Type for Recycling Partner | J_7LBLART | CHAR | 4 | J_7LE09 | J_7LBLART | J6P | ||
TLKNZ | REA Indicator for Test Run | J_7LTLKNZ | CHAR | 1 | CHAR1_X | ||||
AUART | Sales Document Type | AUART | CHAR | 4 | TVAK | AUART | AUART | AAT | |
FKARA | Proposed billing type for an order-related billing document | FKARA | CHAR | 4 | TVFK | FKART | |||
RBELN | Sales Document | VBELN_VA | CHAR | 10 | VBUK | ALPHA | VBELN | AUN | |
MBELN | REA Declaration: Document Number of Article-Spec. Decl. Data | J_7LMBELN | CHAR | 10 | Assigned to domain | ALPHA | VBELN | ||
SVBLN | REA Declaration: Document of Canceled Declaration | J_7LSVBLN | CHAR | 10 | Assigned to domain | ALPHA | VBELN | ||
VBLNS | REA Declaration: Doc.Number of Cancelation Document | J_7LVBLNS | CHAR | 10 | Assigned to domain | ALPHA | VBELN | ||
VBLNX | REA Declaration: Document Number | J_7LVNR_A | CHAR | 10 | Assigned to domain | ALPHA | VBELN | VF | |
VBLN_PRE | REA Declaration: calculation-relevant previous document | J_7LVNR_PRE | CHAR | 10 | J_7LV1K | ALPHA | VBELN | ||
VBELNB | REA Declaration: Successor Document Relevant for Calculation | J_7LVNR_POST | CHAR | 10 | Assigned to domain | ALPHA | VBELN | ||
MWSKZ | Tax on sales/purchases code | MWSKZ | CHAR | 2 | Assigned to domain | MWSKZ | |||
RUNDG | Rounding Type for Item-Dependent Fee | J_7LRUNDG | CHAR | 1 | J_7LRUNDG | ||||
WAERU | Recycling Partner Currency | J_7LREWAER | CUKY | 5 | TCURC | WAERS | |||
NETWE | Net Value in Recycling Partner Currency | J_7LNETWE | CURR | 17(2) | J_7LWERTVX | ||||
NETSE | Net Value of Difference Amnt Splitting in R.Partner Currency | J_7LNETSE | CURR | 17(2) | J_7LWERTVX | ||||
KORWE | Adjustment Amount in Recycling Partner Crcy (REA Settlement) | J_7LRKORWE | CURR | 17(2) | J_7LWERTVX | ||||
MWSBE | Tax Amount in Recycling Partner Currency | J_7LMWSBE | CURR | 17(2) | J_7LWERTVX | ||||
MWSKE | Tax Adjustment Amount in Recycling Partner Currency | J_7LMWSKE | CURR | 17(2) | J_7LWERTVX | ||||
KURST | Exchange Rate Type | KURST | CHAR | 4 | TCURV | KURST | KUT | ||
KURSD | Exchange rate date | KURSD | DATS | 8 | DATUM | ||||
KURSF | Exchange rate | KURSF | DEC | 9(5) | EXCRT | KURSF | |||
WAERK | SD Document Currency | WAERK | CUKY | 5 | TCURC | WAERS | FWS | ||
NETWR | Net Value in Document Currency | J_7LNETWR | CURR | 17(2) | J_7LWERTVX | ||||
NETSR | Net Value Difference Amount Splitting in Document Currency | J_7LNETSR | CURR | 17(2) | J_7LWERTVX | ||||
KORWR | Adjustment Amount in Document Currency (REA Settlement) | J_7LRKORWR | CURR | 17(2) | J_7LWERTVX | ||||
MWSBR | Tax Amount in Document Currency | J_7LMWSBP | CURR | 17(2) | J_7LWERTVX | ||||
MWSKR | Tax Adjustment Amount in Document Currency | J_7LMWSKB | CURR | 17(2) | J_7LWERTVX | ||||
NETWH | Net Value in Doc.Currency Calculated from Header Record | J_7LNETWH | CURR | 17(2) | J_7LWERTVX | ||||
NETSH | Net Differ.Amount Splitting in Doc.Currency fr.Header Record | J_7LNETSH | CURR | 17(2) | J_7LWERTVX | ||||
KORWH | Adjustment Amount in Doc. Currency Calc. from Header Record | J_7LRKORWH | CURR | 17(2) | J_7LWERTVX | ||||
MWSBH | Tax Amount in Document Currency Calculated from Header Rec. | J_7LMWSBH | CURR | 17(2) | J_7LWERTVX | ||||
MWSKH | Tax Adjustment Amount in Document Currency | J_7LMWSKB | CURR | 17(2) | J_7LWERTVX | ||||
NETWB | Document Net Value Output on Document | J_7LNETWB | CURR | 17(2) | J_7LWERTVX | ||||
MWSBB | Tax Amount in Document Currency for Document Net Value | J_7LMWSBB | CURR | 17(2) | J_7LWERTVX | ||||
ENTNA | Recycling Partner | J_7LENTNAM | CHAR | 6 | Assigned to domain | J_7LENTNAM | J_7LE01_F4 | ||
ENTNR | Recycling Partner | J_7LRENT | CHAR | 10 | J_7LE02 | ALPHA | LIFNR | LIF | |
BUKRS | Company Code | BUKRS | CHAR | 4 | J_7LE02 | BUKRS | BUK | C_T001 | |
LAND1 | Country Key | LAND1 | CHAR | 3 | J_7LE02 | LAND1 | LND | ||
ZNEHM | Licensee, Customer Number with Recycling Partner REA | J_7LZNEHM | CHAR | 12 | J_7LZNEH | ||||
KUNNR | Customer Numbers | KUNNR | CHAR | 10 | Assigned to domain | ALPHA | KUNNR | KUN | C_KUNNR |
PLVRS | Price List Version | J_7LRPLVRS | CHAR | 6 | J_7LP01 | J_7LRPLVRS | J6N | ||
KPROZ | Percentage for Valuation Share (Price List Item/Trade Level) | J_7LKPROZ | DEC | 6(3) | DECV3_3 | ||||
KZPRAD | Indicator for Price List Discount on Line Item, Additive | J_7LKZPRAD | CHAR | 1 | XFELD | ||||
PERINR | Period Number | J_7LPERINR | NUMC | 2 | J_7LPERINR | ||||
PERID | REA Declaration Periodicity | J_7LRPERIO | CHAR | 1 | J_7LRPERIO | ||||
PERIO_GELD | REA Declaration Periodicity | J_7LRPERIO | CHAR | 1 | J_7LRPERIO | ||||
DATPE | Key Date for Periodical Declaration REA | J_7LRDATPE | DATS | 8 | DATUM | ||||
DATAB | REA Settlement Period - Start | J_7LRDATAB | DATS | 8 | DATS | ||||
DATBI | REA Settlement Period, End | J_7LRDATBI | DATS | 8 | DATS | ||||
GJAHR | Fiscal Year | GJAHR | NUMC | 4 | GJAHR | GJAHR | GJR | ||
XBLNR | Reference Document Number | XBLNR_V | CHAR | 16 | XBLNR | ||||
MODUSFI | Mode for FI Integration | J_7LMODUSFI | INT1 | 3 | J_7LMODUSFI | ||||
RVBLN | Assigned Sales Document | J_7LRVBLN | CHAR | 10 | VBUK | ALPHA | VBELN | ||
RSPOID_VK | Spool request number | RSPOID_C10 | NUMC | 10 | RSPOID_C10 | ||||
RSPOID_VB | Spool request number | RSPOID_C10 | NUMC | 10 | RSPOID_C10 | ||||
RSPOID_VX | Spool request number | RSPOID_C10 | NUMC | 10 | RSPOID_C10 | ||||
RSPOID_UT | Spool request number | RSPOID_C10 | NUMC | 10 | RSPOID_C10 | ||||
FMGRP | Form Group | J_7LFMGRP | CHAR | 6 | Assigned to domain | J_7LFMGRP | |||
FMGBA | Form Group | J_7LFMGRP | CHAR | 6 | Assigned to domain | J_7LFMGRP | |||
PGNAM | Program name | NA_PGNAM | CHAR | 40 | PROGNAME | ||||
RONAM | Name of routine to be called up in the processing program | NA_RONAM | CHAR | 30 | NA_RONAM | ||||
DTANAM | Name of routine to be called up in the processing program | NA_RONAM | CHAR | 30 | NA_RONAM | ||||
FONAM | REA Declaration system: Name of MDF file for Jetform | J_7LMSMDF | CHAR | 20 | CHAR020 | ||||
SMARTFONAM | Smart Forms: Form Name | TDSFNAME | CHAR | 30 | Assigned to domain | TDSFNAME | SSFNAME | ||
D_FORM_NAME | PDF-Based Forms: Form Name | FPWBFORMNAME | CHAR | 30 | FPNAME | FPWBFORM | HFPWBFORM | ||
DTAKZ | Indicator for Data Medium Exchange | J_7LDTAKZ | CHAR | 1 | CHAR1_X | ||||
VBART | Default Document Type for Subsequent Function REA | J_7LVBART | CHAR | 4 | Assigned to domain | J_7LBLART | |||
KZKUER | Indicator: Reduction for Partial Year Declaration | J_7LKZKUER | CHAR | 1 | XFELD | ||||
REFAKTOR | REA Recycling partner master data: Refunding factor | J_7LREFAKTOR | DEC | 4(1) | J_7LREFAKTOR | ||||
REFPREIS | Price in Reference Company Code Currency | J_7LSTPR | CURR | 17(2) | J_7LWERTVX | ||||
REFKPEIN | Condition pricing unit | KPEIN | DEC | 5 | KPEIN | ||||
REFKMEIN | Condition unit | KMEIN | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
EXPORTKZ | Indicator: Show Exports in Quantity Flow of Rec.Declaration | J_7LKZEXP | CHAR | 1 | XFELD | ||||
IMPORTKZ | Indicator: Show Imports in Quantity Flow of Recyc. Declarat. | J_7LKZIMP | CHAR | 1 | XFELD | ||||
INLANDKZ | Indicator: Filter Out Domestic Purchases in Declaration | J_7LKZINL | CHAR | 1 | XFELD | ||||
KUMSTKZ | Cumulation Mode for Number of Pieces in Declaration Item | J_7LKUMSTKZ | CHAR | 1 | J_7LKUMSTKZ | ||||
SDKZ | Indicator: Data Collector Billing Document Executed | J_7LSDKZ | CHAR | 1 | XFELD | ||||
MMKZ | Indicator: Data Collector for Material Documents Executed | J_7LMMKZ | CHAR | 1 | XFELD | ||||
VRSIO | Version number in the information structure | VRSIO | CHAR | 3 | Assigned to domain | VRSIO | MCV | ||
HISTUNR | Level number within hierarchy | HISTUNR | NUMC | 2 | NUM2 | ||||
HITYP | Customer hierarchy type | HITYP_KH | CHAR | 1 | Assigned to domain | HITYP | |||
HREKU | REA: Indicator that Customer Is Not in Hierarchy | J_7LHREKU | CHAR | 1 | XFELD | ||||
.INCLU-ADM | 0 | ||||||||
DATABADM | Valid-From Date | DATAB | DATS | 8 | DATUM | ||||
DATBIADM | Valid To Date | DATBI | DATS | 8 | DATUM | ||||
ERSDAADM | Created On | ERSDA | DATS | 8 | DATUM | ||||
ERZETADM | Time Created | J_7LERZET | TIMS | 6 | UZEIT | ||||
ERNAMADM | Name of Person who Created the Object | ERNAM | CHAR | 12 | USNAM | ||||
LAEDAADM | Date of Last Change | LAEDA | DATS | 8 | DATUM | ||||
AEZETADM | Time Last Change Was Made | J_7LAEZET | TIMS | 6 | UZEIT | ||||
AENAMADM | Name of Person Who Changed Object | AENAM | CHAR | 12 | USNAM | ||||
LVORMADM | Deletion Indicator | LVORM | CHAR | 1 | XFELD |
Key field | Non-key field |
How do I retrieve data from SAP table J_7LV1K using ABAP code
The following ABAP code Example will allow you to do a basic selection on J_7LV1K to SELECT all data from the tableDATA: WA_J_7LV1K TYPE J_7LV1K.
SELECT SINGLE *
FROM J_7LV1K
INTO CORRESPONDING FIELDS OF WA_J_7LV1K
WHERE...
How to access SAP table J_7LV1K
Within an ECC or HANA version of SAP you can also view further information about J_7LV1K 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