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_7LV1K
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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

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

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OVPM154Outgoing Payments
5OIVL77Whse Journal
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction
Industry Specific :: Recycling Administration :: Recycling Administration Core Functions
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0J_7LV1K973REA Document: Header DataRecycling Administration Core Functions
SQL:  selectupdate insert create

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

SELECT MANDT, VBELN, AUDAT, BUDAT, BLTYP, BLART, TLKNZ, AUART, FKARA, RBELN, MBELN, SVBLN, VBLNS, VBLNX, VBLN_PRE, VBELNB, MWSKZ, RUNDG, WAERU, NETWE, NETSE, KORWE, MWSBE, MWSKE, KURST, KURSD, KURSF, WAERK, NETWR, NETSR, KORWR, MWSBR, MWSKR, NETWH, NETSH, KORWH, MWSBH, MWSKH, NETWB, MWSBB, ENTNA, ENTNR, BUKRS, LAND1, ZNEHM, KUNNR, PLVRS, KPROZ, KZPRAD, PERINR, PERID, PERIO_GELD, DATPE, DATAB, DATBI, GJAHR, XBLNR, MODUSFI, RVBLN, RSPOID_VK, RSPOID_VB, RSPOID_VX, RSPOID_UT, FMGRP, FMGBA, PGNAM, RONAM, DTANAM, FONAM, SMARTFONAM, D_FORM_NAME, DTAKZ, VBART, KZKUER, REFAKTOR, REFPREIS, REFKPEIN, REFKMEIN, EXPORTKZ, IMPORTKZ, INLANDKZ, KUMSTKZ, SDKZ, MMKZ, VRSIO, HISTUNR, HITYP, HREKU, DATABADM, DATBIADM, ERSDAADM, ERZETADM, ERNAMADM, LAEDAADM, AEZETADM, AENAMADM, LVORMADM FROM J_7LV1K
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2VBELNREA Declaration: Document Numbernvarchar100CHAR(N' ')No*J_7LVNR_A Allow NULL? 
3AUDATDocument Date (Date Received/Sent)nvarchar80DATS(N'00000000')YesAUDAT Allow NULL? 
4BUDATPosting Date in the Documentnvarchar80DATS(N'00000000')YesBUDAT Allow NULL? 
5BLTYPREA Document Categorychar10CHAR(N' ')YesJ_7LVBTYP Allow NULL? 
6BLARTDocument Type for Recycling Partnernvarchar40CHAR(N' ')YesJ_7LE09J_7LBLART Allow NULL? 
7TLKNZREA Indicator for Test Runchar10CHAR(N' ')NoJ_7LTLKNZ Allow NULL? 
8AUARTSales Document Typenvarchar40CHAR(N' ')YesTVAKAUART Allow NULL? 
9FKARAProposed billing type for an order-related billing documentnvarchar40CHAR(N' ')YesTVFKFKARA Allow NULL? 
10RBELNSales Documentnvarchar100CHAR(N' ')YesVBUKVBELN_VA Allow NULL? 
11MBELNREA Declaration: Document Number of Article-Spec. Decl. Datanvarchar100CHAR(N' ')Yes*J_7LMBELN Allow NULL? 
12SVBLNREA Declaration: Document of Canceled Declarationnvarchar100CHAR(N' ')Yes*J_7LSVBLN Allow NULL? 
13VBLNSREA Declaration: Doc.Number of Cancelation Documentnvarchar100CHAR(N' ')Yes*J_7LVBLNS Allow NULL? 
14VBLNXREA Declaration: Document Numbernvarchar100CHAR(N' ')Yes*J_7LVNR_A Allow NULL? 
15VBLN_PREREA Declaration: calculation-relevant previous documentnvarchar100CHAR(N' ')YesJ_7LV1KJ_7LVNR_PRE Allow NULL? 
16VBELNBREA Declaration: Successor Document Relevant for Calculationnvarchar100CHAR(N' ')No*J_7LVNR_POST Allow NULL? 
17MWSKZTax on sales/purchases codenvarchar20CHAR(N' ')Yes*MWSKZ Allow NULL? 
18RUNDGRounding Type for Item-Dependent Feechar10CHAR(N' ')YesJ_7LRUNDG Allow NULL? 
19WAERURecycling Partner Currencynvarchar50CUKY(N' ')YesTCURCJ_7LREWAER Allow NULL? 
20NETWENet Value in Recycling Partner Currencydecimal172CURR((0))YesJ_7LNETWE
21NETSENet Value of Difference Amnt Splitting in R.Partner Currencydecimal172CURR((0))YesJ_7LNETSE
22KORWEAdjustment Amount in Recycling Partner Crcy (REA Settlement)decimal172CURR((0))YesJ_7LRKORWE
23MWSBETax Amount in Recycling Partner Currencydecimal172CURR((0))YesJ_7LMWSBE
24MWSKETax Adjustment Amount in Recycling Partner Currencydecimal172CURR((0))YesJ_7LMWSKE
25KURSTExchange Rate Typenvarchar40CHAR(N' ')YesTCURVKURST Allow NULL? 
26KURSDExchange rate datenvarchar80DATS(N'00000000')YesKURSD Allow NULL? 
27KURSFExchange ratedecimal95DEC((0))YesKURSF
28WAERKSD Document Currencynvarchar50CUKY(N' ')YesTCURCWAERK Allow NULL? 
29NETWRNet Value in Document Currencydecimal172CURR((0))YesJ_7LNETWR
30NETSRNet Value Difference Amount Splitting in Document Currencydecimal172CURR((0))YesJ_7LNETSR
31KORWRAdjustment Amount in Document Currency (REA Settlement)decimal172CURR((0))YesJ_7LRKORWR
32MWSBRTax Amount in Document Currencydecimal172CURR((0))YesJ_7LMWSBP
33MWSKRTax Adjustment Amount in Document Currencydecimal172CURR((0))YesJ_7LMWSKB
34NETWHNet Value in Doc.Currency Calculated from Header Recorddecimal172CURR((0))YesJ_7LNETWH
35NETSHNet Differ.Amount Splitting in Doc.Currency fr.Header Recorddecimal172CURR((0))YesJ_7LNETSH
36KORWHAdjustment Amount in Doc. Currency Calc. from Header Recorddecimal172CURR((0))YesJ_7LRKORWH
37MWSBHTax Amount in Document Currency Calculated from Header Rec.decimal172CURR((0))YesJ_7LMWSBH
38MWSKHTax Adjustment Amount in Document Currencydecimal172CURR((0))YesJ_7LMWSKB
39NETWBDocument Net Value Output on Documentdecimal172CURR((0))YesJ_7LNETWB
40MWSBBTax Amount in Document Currency for Document Net Valuedecimal172CURR((0))YesJ_7LMWSBB
41ENTNARecycling Partnernvarchar60CHAR(N' ')Yes*J_7LENTNAM Allow NULL? 
42ENTNRRecycling Partnernvarchar100CHAR(N' ')YesJ_7LE02J_7LRENT Allow NULL? 
43BUKRSCompany Codenvarchar40CHAR(N' ')YesJ_7LE02BUKRS Allow NULL? 
44LAND1Country Keynvarchar30CHAR(N' ')YesJ_7LE02LAND1 Allow NULL? 
45ZNEHMLicensee, Customer Number with Recycling Partner REAnvarchar120CHAR(N' ')YesJ_7LZNEHM Allow NULL? 
46KUNNRCustomer Numbernvarchar100CHAR(N' ')Yes*KUNNR Allow NULL? 
47PLVRSPrice List Versionnvarchar60CHAR(N' ')YesJ_7LP01J_7LRPLVRS Allow NULL? 
48KPROZPercentage for Valuation Share (Price List Item/Trade Level)decimal63DEC((0))YesJ_7LKPROZ
49KZPRADIndicator for Price List Discount on Line Item, Additivechar10CHAR(N' ')YesJ_7LKZPRAD Allow NULL? 
50PERINRPeriod Numbernvarchar20NUMC(N'00')YesJ_7LPERINR Allow NULL? 
51PERIDREA Declaration Periodicitychar10CHAR(N' ')YesJ_7LRPERIO Allow NULL? 
52PERIO_GELDREA Declaration Periodicitychar10CHAR(N' ')YesJ_7LRPERIO Allow NULL? 
53DATPEKey Date for Periodical Declaration REAnvarchar80DATS(N'00000000')YesJ_7LRDATPE Allow NULL? 
54DATABREA Settlement Period - Startnvarchar80DATS(N'00000000')YesJ_7LRDATAB Allow NULL? 
55DATBIREA Settlement Period, Endnvarchar80DATS(N'00000000')YesJ_7LRDATBI Allow NULL? 
56GJAHRFiscal Yearnvarchar40NUMC(N'0000')YesGJAHR Allow NULL? 
57XBLNRReference Document Numbernvarchar160CHAR(N' ')NoXBLNR_V Allow NULL? 
58MODUSFIMode for FI Integrationtinyint30INT1((0))NoJ_7LMODUSFI
59RVBLNAssigned Sales Documentnvarchar100CHAR(N' ')YesVBUKJ_7LRVBLN Allow NULL? 
60RSPOID_VKSpool request numbernvarchar100NUMC(N'0000000000')YesRSPOID_C10 Allow NULL? 
61RSPOID_VBSpool request numbernvarchar100NUMC(N'0000000000')YesRSPOID_C10 Allow NULL? 
62RSPOID_VXSpool request numbernvarchar100NUMC(N'0000000000')YesRSPOID_C10 Allow NULL? 
63RSPOID_UTSpool request numbernvarchar100NUMC(N'0000000000')YesRSPOID_C10 Allow NULL? 
64FMGRPForm Groupnvarchar60CHAR(N' ')Yes*J_7LFMGRP Allow NULL? 
65FMGBAForm Groupnvarchar60CHAR(N' ')Yes*J_7LFMGRP Allow NULL? 
66PGNAMProgram namenvarchar400CHAR(N' ')YesNA_PGNAM Allow NULL? 
67RONAMName of routine to be called up in the processing programnvarchar300CHAR(N' ')YesNA_RONAM Allow NULL? 
68DTANAMName of routine to be called up in the processing programnvarchar300CHAR(N' ')YesNA_RONAM Allow NULL? 
69FONAMREA Declaration system: Name of MDF file for Jetformnvarchar200CHAR(N' ')YesJ_7LMSMDF Allow NULL? 
70SMARTFONAMSmart Forms: Form Namenvarchar300CHAR(N' ')Yes*TDSFNAME Allow NULL? 
71D_FORM_NAMEPDF-Based Forms: Form Namenvarchar300CHAR(N' ')YesFPWBFORMNAME Allow NULL? 
72DTAKZIndicator for Data Medium Exchangechar10CHAR(N' ')YesJ_7LDTAKZ Allow NULL? 
73VBARTDefault Document Type for Subsequent Function REAnvarchar40CHAR(N' ')Yes*J_7LVBART Allow NULL? 
74KZKUERIndicator: Reduction for Partial Year Declarationchar10CHAR(N' ')YesJ_7LKZKUER Allow NULL? 
75REFAKTORREA Recycling partner master data: Refunding factordecimal41DEC((0))YesJ_7LREFAKTOR
76REFPREISPrice in Reference Company Code Currencydecimal172CURR((0))YesJ_7LSTPR
77REFKPEINCondition pricing unitdecimal50DEC((0))YesKPEIN
78REFKMEINCondition unitnvarchar30UNIT(N' ')Yes*KMEIN Allow NULL? 
79EXPORTKZIndicator: Show Exports in Quantity Flow of Rec.Declarationchar10CHAR(N' ')YesJ_7LKZEXP Allow NULL? 
80IMPORTKZIndicator: Show Imports in Quantity Flow of Recyc. Declarat.char10CHAR(N' ')YesJ_7LKZIMP Allow NULL? 
81INLANDKZIndicator: Filter Out Domestic Purchases in Declarationchar10CHAR(N' ')YesJ_7LKZINL Allow NULL? 
82KUMSTKZCumulation Mode for Number of Pieces in Declaration Itemchar10CHAR(N' ')YesJ_7LKUMSTKZ Allow NULL? 
83SDKZIndicator: Data Collector Billing Document Executedchar10CHAR(N' ')YesJ_7LSDKZ Allow NULL? 
84MMKZIndicator: Data Collector for Material Documents Executedchar10CHAR(N' ')YesJ_7LMMKZ Allow NULL? 
85VRSIOVersion number in the information structurenvarchar30CHAR(N' ')Yes*VRSIO Allow NULL? 
86HISTUNRLevel number within hierarchynvarchar20NUMC(N'00')YesHISTUNR Allow NULL? 
87HITYPCustomer hierarchy typechar10CHAR(N' ')Yes*HITYP_KH Allow NULL? 
88HREKUREA: Indicator that Customer Is Not in Hierarchychar10CHAR(N' ')YesJ_7LHREKU Allow NULL? 
89DATABADMValid-From Datenvarchar80DATS(N'00000000')YesDATAB Allow NULL? 
90DATBIADMValid To Datenvarchar80DATS(N'00000000')YesDATBI Allow NULL? 
91ERSDAADMCreated Onnvarchar80DATS(N'00000000')YesERSDA Allow NULL? 
92ERZETADMTime Creatednvarchar60TIMS(N'000000')YesJ_7LERZET Allow NULL? 
93ERNAMADMName of Person who Created the Objectnvarchar120CHAR(N' ')YesERNAM Allow NULL? 
94LAEDAADMDate of Last Changenvarchar80DATS(N'00000000')YesLAEDA Allow NULL? 
95AEZETADMTime Last Change Was Madenvarchar60TIMS(N'000000')YesJ_7LAEZET Allow NULL? 
96AENAMADMName of Person Who Changed Objectnvarchar120CHAR(N' ')YesAENAM Allow NULL? 
97LVORMADMDeletion Indicatorchar10CHAR(N' ')YesLVORM Allow NULL? 
NamePrimaryUniqueTypeColumns
J_7LV1K~0YesYesCLUSTEREDVBELN, MANDT
J_7LV1K~001NoNoNONCLUSTEREDLAND1, BUKRS, ENTNR, MANDT
J_7LV1K~002NoNoNONCLUSTEREDLAND1, BUKRS, ENTNA

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