J_7LE01 SAP (REA Partner Master Record: General Data (Country-Dependent)) Table details
Dictionary Type: Table
Description: REA Partner Master Record: General Data (Country-Dependent)
Description: REA Partner Master Record: General Data (Country-Dependent)
Table field list including key, data, relationships and ABAP select examples
J_7LE01 is a standard SAP Table which is used to store REA Partner Master Record: General Data (Country-Dependent) data and is available within R/3 SAP systems depending on the version and release level.
The J_7LE01 table consists of various fields, each holding specific information or linking keys about REA Partner Master Record: General Data (Country-Dependent) data available in SAP. These include ENTNR (Recycling Partner), LAND1 (Country Key), ENTNA (Recycling Partner), NAME1 (Name 1).. 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_7LE01 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 | LFA1 | ALPHA | LIFNR | LIF | |
LAND1 | Country Key | LAND1 | CHAR | 3 | J_7LC10 | LAND1 | LND | ||
ENTNA | Recycling Partner | J_7LENTNAM | CHAR | 6 | J_7LE00 | J_7LENTNAM | J_7LE01_F4 | ||
NAME1 | Name 1 | NAME1_GP | CHAR | 35 | NAME | ||||
NAME2 | Name 2 | NAME2_GP | CHAR | 35 | NAME | ||||
NAME3 | Name 3 | NAME3_GP | CHAR | 35 | NAME | ||||
KUNNR | Customer Numbers | KUNNR | CHAR | 10 | KNA1 | ALPHA | KUNNR | KUN | C_KUNNR |
GGEWANTBAG | Weight Limit of Secondary Component for Petty Rule | J_7LGGEWBG | NUMC | 3 | PROZENT100 | ||||
KZBAGRG | Petty Rule for Weight-Dependent Fee Indicator | J_7LKZBGTR | CHAR | 1 | XFELD | ||||
FBAGRG | Petty Rule for Weight-Dependent Fee (Function Module) | J_7LFBAGRG | CHAR | 30 | TFDIR | FUNCNAME | |||
GGEWKLNVP | Weight Limit for Item-Dep.Measurement of Smallest Pack. | J_7LGGEWKL | QUAN | 13(3) | MENG13 | ||||
GEWEI | Weight Unit | GEWEI | UNIT | 3 | T006 | CUNIT | MEINS | ||
GFLKLNVP | Area Limit: Item-Dep.Fee Measurement for Minim.Package Size | J_7LGFLKL | QUAN | 13(3) | J_7LFLAECH | ||||
FLHEH | Area Unit | J_7LFLAEH | UNIT | 3 | T006 | CUNIT | MEINS | ||
GVOLKLNVP | Volume Limit: Item-Dependent Fee Calculation Smallest Pack. | J_7LGVOLKL | QUAN | 13(3) | MENG13 | ||||
VOLEH | Volume unit | VOLEH | UNIT | 3 | T006 | CUNIT | MEINS | ||
KZSTKENTG | Item-Dependent Fee Indicator | J_7LKZSTKE | CHAR | 1 | XFELD | ||||
KZSTKENTG_DEF | Indicator: Assign Default Value for Item-Dependent Fee | J_7LKZSTKE_DEF | CHAR | 1 | XFELD | ||||
KZGEWENTG | Weight-Dependent Fee Indicator | J_7LKZGEWE | CHAR | 1 | XFELD | ||||
KZGEWENTG_DEF | Indicator: Assign Default Value for Weight-Dependent Fee | J_7LKZGEWE_DEF | CHAR | 1 | XFELD | ||||
KZMLDS | Indicator for Declaration Key | J_7LKZMLDS | CHAR | 1 | XFELD | ||||
MLDCHAR | Allowed Characters in Declaration Key | J_7LMLDCHAR | CHAR | 60 | CHAR60 | ||||
KZMLDM | Indicator: Article Declaration Key | J_7LKZMLDM | CHAR | 1 | XFELD | ||||
NUMOBM | Name of number range object | NROBJ | CHAR | 10 | TNRO | NROBJ | |||
NUMKRM | Number range | NUMKR | CHAR | 2 | CHAR2 | ||||
MLDML | Length of Article Declaration Key | J_7LMLDML | INT2 | 5 | MATLEN | ||||
KZMMNR | Indicator: Article Declaration Key from Material Number | J_7LKZMMNR | CHAR | 1 | XFELD | ||||
KZMARM | Append Sales Unit Indicator to Article Declaration Key | J_7LKZMARM | CHAR | 1 | XFELD | ||||
KZMLDV | Indicator: Packaging Declaration Key | J_7LKZMLDV | CHAR | 1 | XFELD | ||||
NUMOBV | Name of number range object | NROBJ | CHAR | 10 | TNRO | NROBJ | |||
NUMKRV | Number range | NUMKR | CHAR | 2 | CHAR2 | ||||
MLDVL | Length Declaration Key Packaging | J_7LMLDVL | INT2 | 5 | MATLEN | ||||
KZVMNR | Indicator for Packaging Declaration Key from Material Number | J_7LKZVMNR | CHAR | 1 | XFELD | ||||
KZMLDG | Indicator: Packaging Group Declaration Key | J_7LKZMLDG | CHAR | 1 | XFELD | ||||
NUMOBG | Name of number range object | NROBJ | CHAR | 10 | TNRO | NROBJ | |||
NUMKRG | Number range | NUMKR | CHAR | 2 | CHAR2 | ||||
MLDGL | Length of Packaging Group Declaration Key | J_7LMLDGL | INT2 | 5 | MATLEN | ||||
KZVGRP | Indicator for Packaging Group Number Declaration Key | J_7LKZVGRP | CHAR | 1 | XFELD | ||||
KZGMNR | Ind. Declaration Key for Packaging Group from Matl Number | J_7LKZGMNR | CHAR | 1 | XFELD | ||||
KZGMRM | Indicator: Append SU to Declaration Key Packaging Group | J_7LKZGMRM | CHAR | 1 | XFELD | ||||
KZVGAG | Indicator: Always Create Declaration Key Packag. Grp Article | J_7LKZVGAG | CHAR | 1 | XFELD | ||||
KZMNRV | Indicator: Version-Dependent Admin. of Declaration Key | J_7LKZMNRV | CHAR | 1 | XFELD | ||||
KVEWE | Usage of the condition table | KVEWE | CHAR | 1 | T681V | KVEWE | KVW | ||
KAPPL | Application | KAPPL | CHAR | 2 | T681A | KAPPL | KAP | ||
KSCHL | Sales Condition Type for Recycling Partner | J_7LKSCHLE | CHAR | 4 | T685 | KSCHL | |||
KQUELLSCHL | Sales Conditions: Source for Access Key | J_7LKQUELLSCHL | CHAR | 1 | J_7LKQUELL | ||||
KVEWEZ | Usage of the condition table | KVEWE | CHAR | 1 | T681V | KVEWE | KVW | ||
KAPPLZ | Application | KAPPL | CHAR | 2 | T681A | KAPPL | KAP | ||
KSCHLZ | Purchasing Condition Type for Recycling Partner | J_7LSCHLZE | CHAR | 4 | T685 | KSCHL | |||
KQUELLSCHLZ | Purchase Conditions: Source for Access Keys | J_7LKQUELLSCHLZ | CHAR | 1 | J_7LKQUELL | ||||
ABLSKO | Derivation Rule for Special Condition Type | J_7LABLSKO | CHAR | 1 | J_7LABLSKO | ||||
KZABLSKO_AUT | Derive Special Condition Type Automatically | J_7LABLSKO_AUT | CHAR | 1 | XFELD | ||||
FMGRP | Form Group | J_7LFMGRP | CHAR | 6 | J_7LC25 | J_7LFMGRP | |||
RUNDG | Rounding Type for Item-Dependent Fee | J_7LRUNDG | CHAR | 1 | J_7LRUNDG | ||||
KZFRME | Indicator: Use Formulas for Fee Calculation | J_7LZKZFRME | CHAR | 1 | XFELD | ||||
KZFRMM | Indicator: Use Formulas on Single Packaging | J_7LZKZFRMM | CHAR | 1 | XFELD | ||||
FORMEL | Formula for Fee Calculation | J_7LFORMEL | CHAR | 4 | J_7LE15 | J_7LFORMEL | |||
KZSPLIT | Indicator: Use Splitting | J_7LKZSPLIT | CHAR | 1 | XFELD | ||||
KZREGIO | Indicator: Use Regional Processing/Splitting | J_7LKZREGIO | CHAR | 1 | XFELD | ||||
KZZENTR | Indicator: Use Additional Re.Partner/Additional Splitting | J_7LKZZENTR | CHAR | 1 | XFELD | ||||
ZSPLITV | Additional Splitting at Packaging Level | J_7LZSPLITV | CHAR | 1 | XFELD | ||||
ZSPLITG | Indicator: Activate Global Additional Splitting f. Packaging | J_7LZSPLITG | CHAR | 1 | XFELD | ||||
ZSPLITK | Ind.: Packaging Splitting Complementary for All Re.Partners | J_7LZSPLITK | CHAR | 1 | XFELD | ||||
KZLEVEL | Indicator: Differentiation of Quantity Flow at Pack. Level | J_7LKZLEVEL | CHAR | 1 | XFELD | ||||
KZVPAGE | Indicator: Differ. Quant.Flow for Pack.Type Weight-Dep.Fee | J_7LKZVPAGE | CHAR | 1 | XFELD | ||||
KZVPASE | Indicator: Differ. Quantity Flow for Pack.Type Item-Dep. Fee | J_7LKZVPASE | CHAR | 1 | XFELD | ||||
KZFUELG | Indicator: Differentiation of Quantity Flow for Content Key | J_7LKZFUELG | CHAR | 1 | XFELD | ||||
KZINFOK | Indicator: Differentiation of Quantity Flow Add. Info Key | J_7LKZINFOK | CHAR | 1 | XFELD | ||||
KZSTUFE | Indicator: Differentiation of Quantity Flow for Trade Levels | J_7LKZSTUFE | CHAR | 1 | XFELD | ||||
KZVRPKT | Indicator: Differentiation of Quantity Flow Packaging Ctgry | J_7LKZVRPKT | CHAR | 1 | XFELD | ||||
KZSTADD | Indicator: Trade Level Additive | J_7LKZSTADD | CHAR | 1 | XFELD | ||||
PRFSTUF | Checking Level | J_7LPRFSTUF | CHAR | 1 | J_7LPRFSTUF | ||||
KZPREIS | Indicator: Allow Price List Items Without Price | J_7LKZPREIS | CHAR | 1 | XFELD | ||||
KZMFUEL | Indicator: Maintain Content ID Key on Article Level | J_7LKZMFUEL | CHAR | 1 | XFELD | ||||
KZMINFK | Indicator: Maintain Additional Info Key on Article Level | J_7LKZMINFK | CHAR | 1 | XFELD | ||||
KZMHDST | Indicator: Maintain Trade Level at Article Level | J_7LKZMHDST | CHAR | 1 | XFELD | ||||
KZHNDSTV | Indicator - Use Transaction-Dependent Trade Level | J_7LKZHNDSTV | CHAR | 1 | XFELD | ||||
KZVPPRG | Indicator - Transfer Partner-Dep. Packaging Data to Article | J_7LKZVPPRG | CHAR | 1 | XFELD | ||||
KZEVPAG | Indicator: Packaging Type Weight-Dep. Fee for Re. Partner | J_7LKZEVPAG | CHAR | 1 | XFELD | ||||
KZEVPAS | Indicator: Packaging Type Item-Dependent-Fee for Re. Partner | J_7LKZEVPAS | CHAR | 1 | XFELD | ||||
KZEFVPE | Ind.: Maintain Packaging-Level for Fractions and Re. Partner | J_7LKZEFVPE | CHAR | 1 | XFELD | ||||
VEBENE_DEF | Packaging Level | J_7LVEBENE | NUMC | 2 | J_7LC20 | J_7LVEBENE | |||
KZEFVKT | Ind.: Maintain Packaging Category for Fraction and Re.Part. | J_7LKZEFVKT | CHAR | 1 | XFELD | ||||
KZHIDE_VPRT | REA Master Data Administration: Hide Non-Required Fields | J_7LKZHIDE_VPRT | CHAR | 1 | CHAR1_X | ||||
KZSTOFE_NEED | Cancel Partner Fraction Requirement | J_7LKZSTOFE_NEED | CHAR | 1 | XFELD | ||||
KZFRMFR | Indicator: Use Formulas for Fraction Explosion | J_7LKZFRMFR | CHAR | 1 | XFELD | ||||
KZEXITCHKA | Indicator: Exit for Article Consistency Check | J_7LKZEXITCHKA | CHAR | 1 | XFELD | ||||
EXITCHKA | Exit for Article Consistency Check (Function Module) | J_7LEXITCHKA | CHAR | 30 | Assigned to domain | FUNCNAME | |||
KZEXITCHKV | Indicator: Exit for Packaging Consistency Check | J_7LKZEXITCHKV | CHAR | 1 | XFELD | ||||
EXITCHKV | Exit Packaging Consistency Check (Function Module) | J_7LEXITCHKV | CHAR | 30 | Assigned to domain | FUNCNAME | |||
FRMFBGR | Indicator: Use Fraction Formula Before Petty Rule | J_7LFRMFBGR | CHAR | 1 | XFELD | ||||
FRMFRAK | Formula for Fraction Explosion (Function Module) | J_7LFRMFRAK | CHAR | 30 | TFDIR | FUNCNAME | |||
KZPRFM | Indicator: Use Price Formula | J_7LKZPRFM | CHAR | 1 | CHAR1_X | ||||
PFORMEL | Price Formula | J_7LPFORMEL | CHAR | 4 | J_7LE17 | J_7LPFORMEL | |||
KZPRFMA | Indicator: Use Price Formula for Article | J_7LKZPRFMA | CHAR | 1 | CHAR1_X | ||||
KZKARTK | Indicator: Use Customer-Specific Condition Types | J_7LKZKARTK | CHAR | 1 | XFELD | ||||
KARTKAB | Valid-From Date | DATAB | DATS | 8 | DATUM | ||||
KZKARTM | Indicator: Use Quantity Condition Types | J_7LKZKARTM | CHAR | 1 | XFELD | ||||
KARTMAB | Valid-From Date | DATAB | DATS | 8 | DATUM | ||||
KZKARTP | Indicator: Use Pricing Condition Type | J_7LKZKARTP | CHAR | 1 | XFELD | ||||
KARTPAB | Valid-From Date | DATAB | DATS | 8 | DATUM | ||||
.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_7LE01 using ABAP code
The following ABAP code Example will allow you to do a basic selection on J_7LE01 to SELECT all data from the tableDATA: WA_J_7LE01 TYPE J_7LE01.
SELECT SINGLE *
FROM J_7LE01
INTO CORRESPONDING FIELDS OF WA_J_7LE01
WHERE...
How to access SAP table J_7LE01
Within an ECC or HANA version of SAP you can also view further information about J_7LE01 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