SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

Schema:
 Module:  Table: 
Column: 
Searchbeta 

icon of database logic symbol SAP  TABLESv1Made in Britain

Home | ERP 6.0  | J_7LE01
JDETables.com - the webs number one JD Edwards Table Definition reference

ERP 6.0: Top 10 requests

TableColumnsDescription
1TJKWE15IS-M/SD: WBZ, Order Data for Inbound Processing
2RSADMINC96Customizing Table General BW
3BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
4/OTX/RM_TELIB24Enterprise Library Server Settings
5UMV_TR1259Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6/ISDFPS/CHVW_E34External Batch Where-Used List
7FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
8BSEG345Accounting Document Segment
9/1RA/0SD010MI170Items for Class SD01 - Raw Data
10FMARCPAR4Parallelization of FMARC_BATCH

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5OJDT100Journal Entry
6INV1265A/R Invoice - Rows
7OPCH386A/P Invoice
8JDT1124Journal Entry - Rows
9OPOR386Purchase Order
10OVTG52Tax Definition

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OINM101Whse Journal
10OSRN20Serial Numbers Master Data
Industry Specific :: Recycling Administration :: Recycling Administration Core Functions
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0J_7LE011112REA Partner Master Record: General Data (Country-Dependent)Recycling Administration Core Functions
SQL:  selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT MANDT, ENTNR, LAND1, ENTNA, NAME1, NAME2, NAME3, KUNNR, GGEWANTBAG, KZBAGRG, FBAGRG, GGEWKLNVP, GEWEI, GFLKLNVP, FLHEH, GVOLKLNVP, VOLEH, KZSTKENTG, KZSTKENTG_DEF, KZGEWENTG, KZGEWENTG_DEF, KZMLDS, MLDCHAR, KZMLDM, NUMOBM, NUMKRM, MLDML, KZMMNR, KZMARM, KZMLDV, NUMOBV, NUMKRV, MLDVL, KZVMNR, KZMLDG, NUMOBG, NUMKRG, MLDGL, KZVGRP, KZGMNR, KZGMRM, KZVGAG, KZMNRV, KVEWE, KAPPL, KSCHL, KQUELLSCHL, KVEWEZ, KAPPLZ, KSCHLZ, KQUELLSCHLZ, ABLSKO, KZABLSKO_AUT, FMGRP, RUNDG, KZFRME, KZFRMM, FORMEL, KZSPLIT, KZREGIO, KZZENTR, ZSPLITV, ZSPLITG, ZSPLITK, KZLEVEL, KZVPAGE, KZVPASE, KZFUELG, KZINFOK, KZSTUFE, KZVRPKT, KZSTADD, PRFSTUF, KZPREIS, KZMFUEL, KZMINFK, KZMHDST, KZHNDSTV, KZVPPRG, KZEVPAG, KZEVPAS, KZEFVPE, VEBENE_DEF, KZEFVKT, KZHIDE_VPRT, KZSTOFE_NEED, KZFRMFR, KZEXITCHKA, EXITCHKA, KZEXITCHKV, EXITCHKV, FRMFBGR, FRMFRAK, KZPRFM, PFORMEL, KZPRFMA, KZKARTK, KARTKAB, KZKARTM, KARTMAB, KZKARTP, KARTPAB, DATABADM, DATBIADM, ERSDAADM, ERZETADM, ERNAMADM, LAEDAADM, AEZETADM, AENAMADM, LVORMADM FROM J_7LE01
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2ENTNRRecycling Partnernvarchar100CHAR(N' ')NoLFA1J_7LRENT Allow NULL? 
3LAND1Country Keynvarchar30CHAR(N' ')NoJ_7LC10LAND1 Allow NULL? 
4ENTNARecycling Partnernvarchar60CHAR(N' ')YesJ_7LE00J_7LENTNAM Allow NULL? 
5NAME1Name 1nvarchar350CHAR(N' ')YesNAME1_GP Allow NULL? 
6NAME2Name 2nvarchar350CHAR(N' ')YesNAME2_GP Allow NULL? 
7NAME3Name 3nvarchar350CHAR(N' ')YesNAME3_GP Allow NULL? 
8KUNNRCustomer Numbernvarchar100CHAR(N' ')YesKNA1KUNNR Allow NULL? 
9GGEWANTBAGWeight Limit of Secondary Component for Petty Rulenvarchar30NUMC(N'000')YesJ_7LGGEWBG Allow NULL? 
10KZBAGRGPetty Rule for Weight-Dependent Fee Indicatorchar10CHAR(N' ')YesJ_7LKZBGTR Allow NULL? 
11FBAGRGPetty Rule for Weight-Dependent Fee (Function Module)nvarchar300CHAR(N' ')YesTFDIRJ_7LFBAGRG Allow NULL? 
12GGEWKLNVPWeight Limit for Item-Dep.Measurement of Smallest Pack.decimal133QUAN((0))YesJ_7LGGEWKL
13GEWEIWeight Unitnvarchar30UNIT(N' ')YesT006GEWEI Allow NULL? 
14GFLKLNVPArea Limit: Item-Dep.Fee Measurement for Minim.Package Sizedecimal133QUAN((0))YesJ_7LGFLKL
15FLHEHArea Unitnvarchar30UNIT(N' ')YesT006J_7LFLAEH Allow NULL? 
16GVOLKLNVPVolume Limit: Item-Dependent Fee Calculation Smallest Pack.decimal133QUAN((0))YesJ_7LGVOLKL
17VOLEHVolume unitnvarchar30UNIT(N' ')YesT006VOLEH Allow NULL? 
18KZSTKENTGItem-Dependent Fee Indicatorchar10CHAR(N' ')YesJ_7LKZSTKE Allow NULL? 
19KZSTKENTG_DEFIndicator: Assign Default Value for Item-Dependent Feechar10CHAR(N' ')NoJ_7LKZSTKE_DEF Allow NULL? 
20KZGEWENTGWeight-Dependent Fee Indicatorchar10CHAR(N' ')YesJ_7LKZGEWE Allow NULL? 
21KZGEWENTG_DEFIndicator: Assign Default Value for Weight-Dependent Feechar10CHAR(N' ')NoJ_7LKZGEWE_DEF Allow NULL? 
22KZMLDSIndicator for Declaration Keychar10CHAR(N' ')YesJ_7LKZMLDS Allow NULL? 
23MLDCHARAllowed Characters in Declaration Keynvarchar600CHAR(N' ')YesJ_7LMLDCHAR Allow NULL? 
24KZMLDMIndicator: Article Declaration Keychar10CHAR(N' ')YesJ_7LKZMLDM Allow NULL? 
25NUMOBMName of number range objectnvarchar100CHAR(N' ')YesTNRONROBJ Allow NULL? 
26NUMKRMNumber rangenvarchar20CHAR(N' ')YesNUMKR Allow NULL? 
27MLDMLLength of Article Declaration Keysmallint50INT2((0))YesJ_7LMLDML
28KZMMNRIndicator: Article Declaration Key from Material Numberchar10CHAR(N' ')YesJ_7LKZMMNR Allow NULL? 
29KZMARMAppend Sales Unit Indicator to Article Declaration Keychar10CHAR(N' ')YesJ_7LKZMARM Allow NULL? 
30KZMLDVIndicator: Packaging Declaration Keychar10CHAR(N' ')YesJ_7LKZMLDV Allow NULL? 
31NUMOBVName of number range objectnvarchar100CHAR(N' ')YesTNRONROBJ Allow NULL? 
32NUMKRVNumber rangenvarchar20CHAR(N' ')YesNUMKR Allow NULL? 
33MLDVLLength Declaration Key Packagingsmallint50INT2((0))YesJ_7LMLDVL
34KZVMNRIndicator for Packaging Declaration Key from Material Numberchar10CHAR(N' ')YesJ_7LKZVMNR Allow NULL? 
35KZMLDGIndicator: Packaging Group Declaration Keychar10CHAR(N' ')YesJ_7LKZMLDG Allow NULL? 
36NUMOBGName of number range objectnvarchar100CHAR(N' ')YesTNRONROBJ Allow NULL? 
37NUMKRGNumber rangenvarchar20CHAR(N' ')YesNUMKR Allow NULL? 
38MLDGLLength of Packaging Group Declaration Keysmallint50INT2((0))YesJ_7LMLDGL
39KZVGRPIndicator for Packaging Group Number Declaration Keychar10CHAR(N' ')YesJ_7LKZVGRP Allow NULL? 
40KZGMNRInd. Declaration Key for Packaging Group from Matl Numberchar10CHAR(N' ')YesJ_7LKZGMNR Allow NULL? 
41KZGMRMIndicator: Append SU to Declaration Key Packaging Groupchar10CHAR(N' ')YesJ_7LKZGMRM Allow NULL? 
42KZVGAGIndicator: Always Create Declaration Key Packag. Grp Articlechar10CHAR(N' ')YesJ_7LKZVGAG Allow NULL? 
43KZMNRVIndicator: Version-Dependent Admin. of Declaration Keychar10CHAR(N' ')YesJ_7LKZMNRV Allow NULL? 
44KVEWEUsage of the condition tablechar10CHAR(N' ')YesT681VKVEWE Allow NULL? 
45KAPPLApplicationnvarchar20CHAR(N' ')YesT681AKAPPL Allow NULL? 
46KSCHLSales Condition Type for Recycling Partnernvarchar40CHAR(N' ')YesT685J_7LKSCHLE Allow NULL? 
47KQUELLSCHLSales Conditions: Source for Access Keychar10CHAR(N' ')YesJ_7LKQUELLSCHL Allow NULL? 
48KVEWEZUsage of the condition tablechar10CHAR(N' ')YesT681VKVEWE Allow NULL? 
49KAPPLZApplicationnvarchar20CHAR(N' ')YesT681AKAPPL Allow NULL? 
50KSCHLZPurchasing Condition Type for Recycling Partnernvarchar40CHAR(N' ')YesT685J_7LSCHLZE Allow NULL? 
51KQUELLSCHLZPurchase Conditions: Source for Access Keyschar10CHAR(N' ')YesJ_7LKQUELLSCHLZ Allow NULL? 
52ABLSKODerivation Rule for Special Condition Typechar10CHAR(N' ')YesJ_7LABLSKO Allow NULL? 
53KZABLSKO_AUTDerive Special Condition Type Automaticallychar10CHAR(N' ')YesJ_7LABLSKO_AUT Allow NULL? 
54FMGRPForm Groupnvarchar60CHAR(N' ')YesJ_7LC25J_7LFMGRP Allow NULL? 
55RUNDGRounding Type for Item-Dependent Feechar10CHAR(N' ')YesJ_7LRUNDG Allow NULL? 
56KZFRMEIndicator: Use Formulas for Fee Calculationchar10CHAR(N' ')YesJ_7LZKZFRME Allow NULL? 
57KZFRMMIndicator: Use Formulas on Single Packagingchar10CHAR(N' ')YesJ_7LZKZFRMM Allow NULL? 
58FORMELFormula for Fee Calculationnvarchar40CHAR(N' ')YesJ_7LE15J_7LFORMEL Allow NULL? 
59KZSPLITIndicator: Use Splittingchar10CHAR(N' ')YesJ_7LKZSPLIT Allow NULL? 
60KZREGIOIndicator: Use Regional Processing/Splittingchar10CHAR(N' ')YesJ_7LKZREGIO Allow NULL? 
61KZZENTRIndicator: Use Additional Re.Partner/Additional Splittingchar10CHAR(N' ')YesJ_7LKZZENTR Allow NULL? 
62ZSPLITVAdditional Splitting at Packaging Levelchar10CHAR(N' ')YesJ_7LZSPLITV Allow NULL? 
63ZSPLITGIndicator: Activate Global Additional Splitting f. Packagingchar10CHAR(N' ')YesJ_7LZSPLITG Allow NULL? 
64ZSPLITKInd.: Packaging Splitting Complementary for All Re.Partnerschar10CHAR(N' ')YesJ_7LZSPLITK Allow NULL? 
65KZLEVELIndicator: Differentiation of Quantity Flow at Pack. Levelchar10CHAR(N' ')YesJ_7LKZLEVEL Allow NULL? 
66KZVPAGEIndicator: Differ. Quant.Flow for Pack.Type Weight-Dep.Feechar10CHAR(N' ')YesJ_7LKZVPAGE Allow NULL? 
67KZVPASEIndicator: Differ. Quantity Flow for Pack.Type Item-Dep. Feechar10CHAR(N' ')YesJ_7LKZVPASE Allow NULL? 
68KZFUELGIndicator: Differentiation of Quantity Flow for Content Keychar10CHAR(N' ')YesJ_7LKZFUELG Allow NULL? 
69KZINFOKIndicator: Differentiation of Quantity Flow Add. Info Keychar10CHAR(N' ')YesJ_7LKZINFOK Allow NULL? 
70KZSTUFEIndicator: Differentiation of Quantity Flow for Trade Levelschar10CHAR(N' ')YesJ_7LKZSTUFE Allow NULL? 
71KZVRPKTIndicator: Differentiation of Quantity Flow Packaging Ctgrychar10CHAR(N' ')YesJ_7LKZVRPKT Allow NULL? 
72KZSTADDIndicator: Trade Level Additivechar10CHAR(N' ')YesJ_7LKZSTADD Allow NULL? 
73PRFSTUFChecking Levelchar10CHAR(N' ')YesJ_7LPRFSTUF Allow NULL? 
74KZPREISIndicator: Allow Price List Items Without Pricechar10CHAR(N' ')YesJ_7LKZPREIS Allow NULL? 
75KZMFUELIndicator: Maintain Content ID Key on Article Levelchar10CHAR(N' ')YesJ_7LKZMFUEL Allow NULL? 
76KZMINFKIndicator: Maintain Additional Info Key on Article Levelchar10CHAR(N' ')YesJ_7LKZMINFK Allow NULL? 
77KZMHDSTIndicator: Maintain Trade Level at Article Levelchar10CHAR(N' ')YesJ_7LKZMHDST Allow NULL? 
78KZHNDSTVIndicator - Use Transaction-Dependent Trade Levelchar10CHAR(N' ')YesJ_7LKZHNDSTV Allow NULL? 
79KZVPPRGIndicator - Transfer Partner-Dep. Packaging Data to Articlechar10CHAR(N' ')YesJ_7LKZVPPRG Allow NULL? 
80KZEVPAGIndicator: Packaging Type Weight-Dep. Fee for Re. Partnerchar10CHAR(N' ')YesJ_7LKZEVPAG Allow NULL? 
81KZEVPASIndicator: Packaging Type Item-Dependent-Fee for Re. Partnerchar10CHAR(N' ')YesJ_7LKZEVPAS Allow NULL? 
82KZEFVPEInd.: Maintain Packaging-Level for Fractions and Re. Partnerchar10CHAR(N' ')YesJ_7LKZEFVPE Allow NULL? 
83VEBENE_DEFPackaging Levelnvarchar20NUMC(N'00')YesJ_7LC20J_7LVEBENE Allow NULL? 
84KZEFVKTInd.: Maintain Packaging Category for Fraction and Re.Part.char10CHAR(N' ')YesJ_7LKZEFVKT Allow NULL? 
85KZHIDE_VPRTREA Master Data Administration: Hide Non-Required Fieldschar10CHAR(N' ')YesJ_7LKZHIDE_VPRT Allow NULL? 
86KZSTOFE_NEEDCancel Partner Fraction Requirementchar10CHAR(N' ')YesJ_7LKZSTOFE_NEED Allow NULL? 
87KZFRMFRIndicator: Use Formulas for Fraction Explosionchar10CHAR(N' ')YesJ_7LKZFRMFR Allow NULL? 
88KZEXITCHKAIndicator: Exit for Article Consistency Checkchar10CHAR(N' ')YesJ_7LKZEXITCHKA Allow NULL? 
89EXITCHKAExit for Article Consistency Check (Function Module)nvarchar300CHAR(N' ')Yes*J_7LEXITCHKA Allow NULL? 
90KZEXITCHKVIndicator: Exit for Packaging Consistency Checkchar10CHAR(N' ')YesJ_7LKZEXITCHKV Allow NULL? 
91EXITCHKVExit Packaging Consistency Check (Function Module)nvarchar300CHAR(N' ')Yes*J_7LEXITCHKV Allow NULL? 
92FRMFBGRIndicator: Use Fraction Formula Before Petty Rulechar10CHAR(N' ')YesJ_7LFRMFBGR Allow NULL? 
93FRMFRAKFormula for Fraction Explosion (Function Module)nvarchar300CHAR(N' ')YesTFDIRJ_7LFRMFRAK Allow NULL? 
94KZPRFMIndicator: Use Price Formulachar10CHAR(N' ')YesJ_7LKZPRFM Allow NULL? 
95PFORMELPrice Formulanvarchar40CHAR(N' ')YesJ_7LE17J_7LPFORMEL Allow NULL? 
96KZPRFMAIndicator: Use Price Formula for Articlechar10CHAR(N' ')YesJ_7LKZPRFMA Allow NULL? 
97KZKARTKIndicator: Use Customer-Specific Condition Typeschar10CHAR(N' ')YesJ_7LKZKARTK Allow NULL? 
98KARTKABValid-From Datenvarchar80DATS(N'00000000')YesDATAB Allow NULL? 
99KZKARTMIndicator: Use Quantity Condition Typeschar10CHAR(N' ')YesJ_7LKZKARTM Allow NULL? 
100KARTMABValid-From Datenvarchar80DATS(N'00000000')YesDATAB Allow NULL? 
101KZKARTPIndicator: Use Pricing Condition Typechar10CHAR(N' ')YesJ_7LKZKARTP Allow NULL? 
102KARTPABValid-From Datenvarchar80DATS(N'00000000')YesDATAB Allow NULL? 
103DATABADMValid-From Datenvarchar80DATS(N'00000000')YesDATAB Allow NULL? 
104DATBIADMValid To Datenvarchar80DATS(N'00000000')YesDATBI Allow NULL? 
105ERSDAADMCreated Onnvarchar80DATS(N'00000000')YesERSDA Allow NULL? 
106ERZETADMTime Creatednvarchar60TIMS(N'000000')YesJ_7LERZET Allow NULL? 
107ERNAMADMName of Person who Created the Objectnvarchar120CHAR(N' ')YesERNAM Allow NULL? 
108LAEDAADMDate of Last Changenvarchar80DATS(N'00000000')YesLAEDA Allow NULL? 
109AEZETADMTime Last Change Was Madenvarchar60TIMS(N'000000')YesJ_7LAEZET Allow NULL? 
110AENAMADMName of Person Who Changed Objectnvarchar120CHAR(N' ')YesAENAM Allow NULL? 
111LVORMADMDeletion Indicatorchar10CHAR(N' ')YesLVORM Allow NULL? 
NamePrimaryUniqueTypeColumns
J_7LE01~0YesYesCLUSTEREDLAND1, ENTNR, MANDT
J_7LE01~001NoNoNONCLUSTEREDENTNA, LAND1, MANDT

All references to SAP and SAP logo are trademarks of SAP AG in Germany, EU, USA and other territories.
No warranty is provided to data provided by this site. This website is not affiliated with, maintained, authorized, endorsed or sponsored by the SAP AG Company or any of its affiliates.
About :: Terms :: Privacy