J_7LE02 SAP (REA Partner Master Record: Company Code) Table details
Dictionary Type: Table
Description: REA Partner Master Record: Company Code
Description: REA Partner Master Record: Company Code
Table field list including key, data, relationships and ABAP select examples
J_7LE02 is a standard SAP Table which is used to store REA Partner Master Record: Company Code data and is available within R/3 SAP systems depending on the version and release level.
The J_7LE02 table consists of various fields, each holding specific information or linking keys about REA Partner Master Record: Company Code data available in SAP. These include ENTNR (Recycling Partner), BUKRS (Company Code), LAND1 (Country Key), WAERE (Recycling Partner Currency).. 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
SAP J_7LE02 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 | |
BUKRS | Company Code | BUKRS | CHAR | 4 | J_7LC01 | BUKRS | BUK | C_T001 | |
LAND1 | Country Key | LAND1 | CHAR | 3 | J_7LE01 | LAND1 | LND | ||
WAERE | Recycling Partner Currency | J_7LREWAER | CUKY | 5 | TCURC | WAERS | |||
DATPE | Key Date for Periodical Declaration REA | J_7LRDATPE | DATS | 8 | DATUM | ||||
DATZE | Date of License Usage Contract REA | J_7LDATZE | DATS | 8 | DATUM | ||||
DATSP | Start Date of Splitting Contract | J_7LDATSP | DATS | 8 | DATUM | ||||
KALSM | Procedure (Pricing, Output Control, Acct. Det., Costing,...) | KALSM_D | CHAR | 6 | T683 | KALSM | |||
MWSKZ | Tax on sales/purchases code | MWSKZ | CHAR | 2 | T007A | MWSKZ | |||
KURST | Rate Type: Price List Translation REA | J_7LKURST | CHAR | 4 | TCURV | KURST | |||
ZNEHM | Licensee, Customer Number with Recycling Partner REA | J_7LZNEHM | CHAR | 12 | J_7LZNEH | ||||
UNAME | Licensee Contact Person | J_7LZNAME | CHAR | 12 | USR02 | XUBNAME | |||
AUDITOR | Auditor with the Licensee | J_7LAUDITOR | CHAR | 12 | USR02 | XUBNAME | |||
KOOPN | Cooperation Number | J_7LKOOPN | CHAR | 5 | CHAR005 | ||||
HDLST | Trade Level | J_7LHDLST | NUMC | 5 | J_7LE13 | J_7LHDLST | |||
MAINE | Indicator: Recycling Part.Is Main Partner in Comp.Cd/Country | J_7LMAINE | CHAR | 1 | XFELD | ||||
ESTAT | Recycling Partner Status | J_7LRESTAT | CHAR | 1 | J_7LRESTAT | ||||
ZART | Payment Type | J_7LZART | CHAR | 1 | J_7LZART | ||||
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 | ||
AALKZ | Indicator: Automatically Create Article from Packaging | J_7LAALKZ | CHAR | 1 | CHAR1_X | ||||
LANDK | Create Conditions for Different Country | J_7LLANDK | CHAR | 3 | T005 | LAND1 | |||
NO_SDKONKZ | Do Not Create SD Conditions for Company Code | J_7LNO_SDKONKZ | CHAR | 1 | XFELD | ||||
NO_MMKONKZ | Do Not Create MM Conditions for Company Code | J_7LNO_MMKONKZ | CHAR | 1 | XFELD | ||||
BUKRSR | REA Address Data: Alternative Company Code | J_7LBUKRSR | CHAR | 4 | T001 | BUKRS | |||
.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_7LE02 using ABAP code
The following ABAP code Example will allow you to do a basic selection on J_7LE02 to SELECT all data from the tableDATA: WA_J_7LE02 TYPE J_7LE02.
SELECT SINGLE *
FROM J_7LE02
INTO CORRESPONDING FIELDS OF WA_J_7LE02
WHERE...
How to access SAP table J_7LE02
Within an ECC or HANA version of SAP you can also view further information about J_7LE02 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