J_7LMS SAP (REA Periodical Declaration Communication Structure) Structure details
Dictionary Type: Structure
Description: REA Periodical Declaration Communication Structure
Description: REA Periodical Declaration Communication Structure
Structure field list including key, data, relationships and ABAP select examples
J_7LMS 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 "REA Periodical Declaration Communication Structure" 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_J_7LMS TYPE J_7LMS.
The J_7LMS table consists of various fields, each holding specific information or linking keys about REA Periodical Declaration Communication Structure data available in SAP. These include ENTNR (Recycling Partner), FMGRP (Form Group), FMGRP_V1K (Form Group), ENTNA (Recycling Partner).. 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: Cannot Be Enhanced
SAP J_7LMS 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 |
| MANDT | Client | MANDT | CLNT | 3 | Assigned to domain | MANDT | |||
| ENTNR | Recycling Partner | J_7LRENT | CHAR | 10 | Assigned to domain | ALPHA | LIFNR | LIF | |
| FMGRP | Form Group | J_7LFMGRP | CHAR | 6 | Assigned to domain | J_7LFMGRP | |||
| FMGRP_V1K | Form Group | J_7LFMGRP | CHAR | 6 | Assigned to domain | J_7LFMGRP | |||
| ENTNA | Recycling Partner | J_7LENTNAM | CHAR | 6 | J_7LE00 | J_7LENTNAM | J_7LE01_F4 | ||
| BUKRS | Company Code | BUKRS | CHAR | 4 | J_7LC02 | BUKRS | BUK | C_T001 | |
| LAND1 | Country Key | LAND1 | CHAR | 3 | J_7LC10 | LAND1 | LND | ||
| BLART | Document Type for Recycling Partner | J_7LBLART | CHAR | 4 | Assigned to domain | J_7LBLART | J6P | ||
| BLTYP | REA Document Category | J_7LVBTYP | CHAR | 1 | J_7LRVBTYP | ||||
| BLTYP_KOPF | REA Document Category | J_7LVBTYP | CHAR | 1 | J_7LRVBTYP | ||||
| FBGRP | Consecutive Document Type Group | J_7LFBGRP | NUMC | 3 | J_7LE11 | J_7LFBGRP | |||
| PERIO | REA Declaration Periodicity | J_7LRPERIO | CHAR | 1 | J_7LRPERIO | ||||
| PERIO_GELD | REA Declaration Periodicity | J_7LRPERIO | CHAR | 1 | J_7LRPERIO | ||||
| DATAB | REA Settlement Period - Start | J_7LRDATAB | DATS | 8 | DATS | ||||
| DATBI | REA Settlement Period, End | J_7LRDATBI | DATS | 8 | DATS | ||||
| PERINR | Period Number | J_7LPERINR | NUMC | 2 | J_7LPERINR | ||||
| GJAHR | Fiscal Year | GJAHR | NUMC | 4 | GJAHR | GJAHR | GJR | ||
| PERIV | Fiscal Year Variant | PERIV | CHAR | 2 | Assigned to domain | PERIV | |||
| DATPE | Key Date for Periodical Declaration REA | J_7LRDATPE | DATS | 8 | DATUM | ||||
| TLKNZ | REA Indicator for Test Run | J_7LTLKNZ | CHAR | 1 | CHAR1_X | ||||
| WAERU | Recycling Partner Currency | J_7LREWAER | CUKY | 5 | TCURC | WAERS | |||
| KURST | Exchange Rate Type | KURST | CHAR | 4 | Assigned to domain | 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 | ||
| PLVRS | Price List Version | J_7LRPLVRS | CHAR | 6 | Assigned to domain | 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 | ||||
| KORWE | Adjustment Amount in Recycling Partner Crcy (REA Settlement) | J_7LRKORWE | CURR | 17(2) | J_7LWERTVX | ||||
| KORWR | Adjustment Amount in Document Currency (REA Settlement) | J_7LRKORWR | CURR | 17(2) | J_7LWERTVX | ||||
| KORWH | Adjustment Amount in Doc. Currency Calc. from Header Record | J_7LRKORWH | CURR | 17(2) | J_7LWERTVX | ||||
| MWSKR | Tax Adjustment Amount in Document Currency | J_7LMWSKB | CURR | 17(2) | J_7LWERTVX | ||||
| MWSKE | Tax Adjustment Amount in Recycling Partner Currency | J_7LMWSKE | CURR | 17(2) | J_7LWERTVX | ||||
| MWSKH | Tax Adjust. Amount in Doc.Currency Calculated fr.Header Rec. | J_7LMWSKH | CURR | 17(2) | J_7LWERTVX | ||||
| BUDAT | Posting Date in the Document | BUDAT | DATS | 8 | DATUM | ||||
| SPLD | Spool: Output device | RSPOPNAME | CHAR | 4 | TSP03 | SPDEV | RSPOPNAME | ||
| PROTKZ | Indicator: Single Record Log for Productive Declaration | J_7LPROTKZ | CHAR | 1 | XFELD | ||||
| PROT_FORMAT | REA Declaration: Format of Single Record Log (x= Multirow) | J_7LPROT_FORMAT | CHAR | 1 | XFELD | ||||
| DTAKZ | Indicator for Data Medium Exchange | J_7LDTAKZ | CHAR | 1 | CHAR1_X | ||||
| DTA_STKZ | Form Group | J_7LFMGRP | CHAR | 6 | Assigned to domain | J_7LFMGRP | |||
| PATHLOCAL | Local file for upload/download | LOCALFILE | CHAR | 128 | LOCALFILE | ||||
| PATHEXTERN | Physical path name | PATHEXTERN | CHAR | 200 | PATHEXTERN | ||||
| SUBRC | Return Code | SYSUBRC | INT4 | 10 | SYST_SHORT | ||||
| MSATZ | Tax rate | MSATZ_F05L | DEC | 7(3) | PRZ43V | ||||
| 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 | ||||
| ZART | Payment Type | J_7LZART | CHAR | 1 | J_7LZART | ||||
| EVENT | Time of Call | J_7LEVENT | CHAR | 4 | J_7LEVENT | ||||
| SAVKZ | Save Indicator | J_7LSAVKZ | CHAR | 1 | XFELD | ||||
| ANZKZ | Display Indicator | J_7LANZKZ | CHAR | 1 | XFELD | ||||
| SUNKZ | Save Impossible | J_7LSUNKZ | CHAR | 1 | CHAR1_X | ||||
| DUNKZ | Print and Display Impossible | J_7LDUNKZ | CHAR | 1 | CHAR1_X | ||||
| SAVEDKZ | Indicator that Declaration Has Already Been Saved | J_7LSAVEDKZ | CHAR | 1 | CHAR1_X | ||||
| FCODE | Function Code | SYUCOMM | CHAR | 70 | SYCHAR70 | ||||
| FONAM | REA Declaration system: Name of MDF file for Jetform | J_7LMSMDF | CHAR | 20 | CHAR020 | ||||
| KUNNR | Customer Numbers | KUNNR | CHAR | 10 | Assigned to domain | ALPHA | KUNNR | KUN | C_KUNNR |
| SMARTFORM_KZ | Indicator: User Smart Forms for Form Display | J_7LSMARTFORM_KZ | CHAR | 1 | XFELD | ||||
| SAPSCRIPT | Form Name | TDFORM | CHAR | 16 | TDFORM | ||||
| 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 | ||
| APPEND_MODUS | REA Declaration System: Spool Control | J_7LAPPEND_MODUS | CHAR | 1 | J_7LAPPEND_MODUS | ||||
| JET_TERMINAL_KZ | REA Indicator: Use of Terminal Name by Jetform Communication | J_7LTERMINAL_KZ | CHAR | 1 | CHAR1_X | ||||
| JET_DOM_SUFFIX | REA: Suffix of a Network Domain | J_7LDOMAIN_SUFFIX | CHAR | 80 | CHAR80 | ||||
| HITYP | Superior Object Type | HITYP | CHAR | 4 | CHAR4 | ||||
| HISTUNR | Level number within hierarchy | HISTUNR | NUMC | 2 | NUM2 | ||||
| HREKU | REA: Indicator that Customer Is Not in Hierarchy | J_7LHREKU | CHAR | 1 | XFELD | ||||
| VRSIO | Version number in the information structure | VRSIO | CHAR | 3 | Assigned to domain | VRSIO | MCV | ||
| .INCLU-BAL | 0 | ||||||||
| MSGTYBAL | Message Type | SYMSGTY | CHAR | 1 | SYCHAR01 | ||||
| MSGIDBAL | Message Class | SYMSGID | CHAR | 20 | Assigned to domain | ARBGB | |||
| MSGNOBAL | Message Number | SYMSGNO | NUMC | 3 | SYMSGNO | ||||
| MSGV1BAL | Message Variable | SYMSGV | CHAR | 50 | SYCHAR50 | ||||
| MSGV2BAL | Message Variable | SYMSGV | CHAR | 50 | SYCHAR50 | ||||
| MSGV3BAL | Message Variable | SYMSGV | CHAR | 50 | SYCHAR50 | ||||
| MSGV4BAL | Message Variable | SYMSGV | CHAR | 50 | SYCHAR50 | ||||
| ALTEXTBAL | Application log: Standard text | BALTEXT | CHAR | 28 | CHAR28 | ||||
| USEREXITPBAL | Application Log: Callback: Program name | BALUEP | CHAR | 40 | PROGNAME | ||||
| USEREXITFBAL | Application Log: Callback: Routine name | BALUEF | CHAR | 30 | CHAR30 | ||||
| DETLEVELBAL | Application Log: Level of detail | BALLEVEL | CHAR | 1 | BALLEVEL | ||||
| PROBCLASSBAL | Application log: Message problem class | BALPROBCL | CHAR | 1 | BALPROBCL | ||||
| ALSORTBAL | Application log: Sort criterion/grouping | BALSORT | CHAR | 3 | CHAR3 | ||||
| .INCLU-CAT | 0 | ||||||||
| LOESCHENCAT | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 |
| Key field | Non-key field |
How do I retrieve data from SAP structure J_7LMS using ABAP code?
As J_7LMS 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 J_7LMS as there is no data to select.How to access SAP table J_7LMS
Within an ECC or HANA version of SAP you can also view further information about J_7LMS 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