J_7LE09 SAP (REA Partner Master: Document Types) Table details
Dictionary Type: Table
Description: REA Partner Master: Document Types
Description: REA Partner Master: Document Types
Table field list including key, data, relationships and ABAP select examples
J_7LE09 is a standard SAP Table which is used to store REA Partner Master: Document Types data and is available within R/3 SAP systems depending on the version and release level.
The J_7LE09 table consists of various fields, each holding specific information or linking keys about REA Partner Master: Document Types data available in SAP. These include ENTNR (Recycling Partner), LAND1 (Country Key), BLART (Document Type for Recycling Partner), 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: C - Customising table, maintenance only by custDisplay/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced
Text table = J_7LE09T
Text table = J_7LE09T
Text table = J_7LE09T
SAP J_7LE09 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 | |||
ENTNR | Recycling Partner | J_7LRENT | CHAR | 10 | J_7LE01 | ALPHA | LIFNR | LIF | |
LAND1 | Country Key | LAND1 | CHAR | 3 | J_7LE01 | LAND1 | LND | ||
BLART | Document Type for Recycling Partner | J_7LBLART | CHAR | 4 | J_7LBLART | J6P | |||
BLTYP | REA Document Category | J_7LVBTYP | CHAR | 1 | J_7LRVBTYP | ||||
RBART | Reference Document Type | J_7LRBART | CHAR | 4 | J_7LE09 | J_7LBLART | |||
VBART | Default Document Type for Subsequent Function REA | J_7LVBART | CHAR | 4 | J_7LE09 | J_7LBLART | |||
SBART | Cancellation/Adjustment Document Type | J_7LSBART | CHAR | 4 | J_7LE09 | J_7LBLART | |||
AUART | Assigned Sales Document Type | J_7LAUART | CHAR | 4 | TVAK | AUART | AUART | ||
PGNAM | Program name | NA_PGNAM | CHAR | 40 | TRDIR | 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 | ||
FMGRP | Form Group | J_7LFMGRP | CHAR | 6 | J_7LC25 | J_7LFMGRP | |||
HBAKZ | Main Document Type | J_7LHBAKZ | CHAR | 1 | XFELD | ||||
DBAKZ | Indicator for Default Document Type | J_7LDBAKZ | CHAR | 1 | XFELD | ||||
KONBAKZ | REA Declaration: Indicator for Consolidation Document Type | J_7LKONBAKZ | CHAR | 1 | XFELD | ||||
NOPERIOKZ | REA Declaration: No Period-Specific Settlement | J_7LNOPERIOKZ | CHAR | 1 | XFELD | ||||
V1MKZ | Indicator: Save Declar. of Quantity Flow at Article Level | J_7LV1MKZ | CHAR | 1 | XFELD | ||||
V1MKUKZ | Indicator: Save Article Quantity Flow at Customer Level | J_7LV1MKUKZ | CHAR | 1 | XFELD | ||||
V1MLFKZ | Indicator: Save Article Quantity Flow at Vendor Level | J_7LV1MLFKZ | CHAR | 1 | XFELD | ||||
EXPORTKZ | Indicator: Show Exports in Quantity Flow of Rec.Declaration | J_7LKZEXP | CHAR | 1 | XFELD | ||||
EXPORTLANDKZ | Export Differentiation according to Country of Destination | J_7LKZEXPLAND | 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 | ||||
KZMNRV | Indicator: Version-Dependent Admin. of Declaration Key | J_7LKZMNRV | CHAR | 1 | XFELD | ||||
KZKARTMP | Indicator: Use Quantity Condition Type as Item Type | J_7LKZKARTMP | CHAR | 1 | XFELD | ||||
KZVKORG | Indicator: Differentiation of Quantity Flow for Sales Org. | J_7LKZVKORG | CHAR | 1 | XFELD | ||||
KZVTWEG | Indicator: Differentiation of Quant.Flow for Distr.Channel | J_7LKZVTWEG | CHAR | 1 | XFELD | ||||
KZSPART | Indicator: Differentiation of Quantity Flow for Division | J_7LKZSPART | CHAR | 1 | XFELD | ||||
KZWERKS | Indicator: Differentiation of Quantity Flow for Plant | J_7LKZWERKS | CHAR | 1 | XFELD | ||||
KZGSBER | Indicator: Differentiation Quantity Flow for Business Area | J_7LKZGSBER | CHAR | 1 | XFELD | ||||
KZMTART | Indicator: Differentiation of Quantity Flow for Mater. Type | J_7LKZMTART | CHAR | 1 | XFELD | ||||
KZMBRSH | Indicator: Differentiation of Quantity Flow for Industry Key | J_7LKZMBRSH | CHAR | 1 | XFELD | ||||
KZMATKL | Indicator: Differentiation of Quantity Flow for Mat. Group | J_7LKZMATKL | CHAR | 1 | XFELD | ||||
KZPRDHA | Indicator: Differentiation of Quant.Flow for Product Hierar. | J_7LKZPRDHA | CHAR | 1 | XFELD | ||||
KZGRUPPE | Indicator: Different. of Quant.Flow Accd. to Group. Charact. | J_7LKZGRUPPE | CHAR | 1 | XFELD | ||||
KZHKUNNR | Ind.: Differentiation of Quantity Flow for Hier.Customer No. | J_7LKZHKUNNH | CHAR | 1 | XFELD | ||||
KZHVKORG | Ind.: Differentiation of Quantity Flow for Sales Org. Hier. | J_7LKZHVKORG | CHAR | 1 | XFELD | ||||
KZHVTWEG | Ind.: Differentiation of Quantity Flow for Dist. Chnl. Hier. | J_7LKZHVTWEG | CHAR | 1 | XFELD | ||||
KZHSPART | Ind.: Differentiation of Quantity Flow for Division Hier. | J_7LKZHSPART | CHAR | 1 | XFELD | ||||
KZHPARVW | Ind.: Differentiation of Qty Flow for Partner Function Hier. | J_7LKZHPARVW | CHAR | 1 | XFELD | ||||
KZMATNR | Indicator: Differentiation of Quantity Flow for Matl Number | J_7LKZMATNR | CHAR | 1 | XFELD | ||||
KZMEINS | Indicator: Differentiation of Quantity Flow for UoM | J_7LKZMEINS | CHAR | 1 | XFELD | ||||
KZMPVRS | Indicator: Version-Specific Save of Matl-Dep. Decl. Items | J_7LKZMPVRS | CHAR | 1 | XFELD | ||||
KZSTGEW | Indicator - Differentiate Qty Flow Acc.to Fraction Weight | J_7LKZSTGEW | CHAR | 1 | XFELD | ||||
KZVRPNR | Indicator: Differentiate Quantity Flow by Packaging | J_7LKZVRPNR | CHAR | 1 | XFELD | ||||
KUMSTKZ | Cumulation Mode for Number of Pieces in Declaration Item | J_7LKUMSTKZ | CHAR | 1 | J_7LKUMSTKZ | ||||
KUMKMPME | Component Unit of Measure for Cumulation Mode B | J_7LKUMKMPME | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
KUMBMEX | Indicator: Use Nondimensional Base Unit of M. for Cumulation | J_7LKUMBMEX | CHAR | 1 | XFELD | ||||
KUMARTKZ | Evaluate Additional Article Data for Cumulation | J_7LKUMARTKZ | CHAR | 1 | XFELD | ||||
HITYP | Customer hierarchy type | HITYP_KH | CHAR | 1 | THIT | HITYP | |||
HISTUNR | Level number within hierarchy | HISTUNR | NUMC | 2 | NUM2 | ||||
PERIV | Fiscal Year Variant | PERIV | CHAR | 2 | T009 | PERIV | |||
MCINF | Information Structure for Movement Data from Billing | J_7LMCINF | CHAR | 8 | TMC4 | MCINF | |||
MCIMM | Information Structure: Movement Data from Material Movements | J_7LMCIMM | CHAR | 8 | TMC4 | MCINF | |||
MCEXT | Info Structure: External Billing Data for Recycl.Declaration | J_7LMCEXT | CHAR | 30 | DD02L | AS4TAB | |||
SPERI | Period Grid Info Structure: External Document Data REA | J_7LSPERI | CHAR | 1 | J_7LSPERI | ||||
FILTKKZ | Log Indicator for Data Filter Header | J_7LFILTKKZ | CHAR | 1 | XFELD | ||||
FILTPKZ | Log Indicator for Data Filter Item | J_7LFILTPKZ | CHAR | 1 | XFELD | ||||
MMPROKZ | Indicator: Log Missing Articles for Declaration | J_7LMMPROKZ | CHAR | 1 | XFELD | ||||
BUKPROKZ | Log Missing Article for Company Code | J_7LBUKPROKZ | CHAR | 1 | XFELD | ||||
MEPROKZ | Indicator: Log Missing Units of Measure | J_7LMEPROKZ | CHAR | 1 | XFELD | ||||
REPROKZ | Indicator: Log Missing Recycling Partner Assignment | J_7LREPROKZ | CHAR | 1 | XFELD | ||||
STORNOFIKZ | Automatically Start FI Posting When Canceled | J_7LSTORNOFIKZ | CHAR | 1 | XFELD | ||||
MODUSFI | Mode for FI Integration | J_7LMODUSFI | INT1 | 3 | J_7LMODUSFI | ||||
BLARTFI | FI Document Type | J_7LBLARTFI | CHAR | 2 | T003 | BLART | BAR | ||
SAKRNFI | Accrual Account for Recycling Fees | J_7LSAKRNFI | CHAR | 10 | Assigned to domain | ALPHA | SAKNR | SAK | |
.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_7LE09 using ABAP code
The following ABAP code Example will allow you to do a basic selection on J_7LE09 to SELECT all data from the tableDATA: WA_J_7LE09 TYPE J_7LE09.
SELECT SINGLE *
FROM J_7LE09
INTO CORRESPONDING FIELDS OF WA_J_7LE09
WHERE...
How to access SAP table J_7LE09
Within an ECC or HANA version of SAP you can also view further information about J_7LE09 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