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_3RSL_BK_TABLE
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
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction
Financial Accounting :: Localization
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0J_3RSL_BK_TABLE1101Transparent table for SaleBook (ALV)Localization
SQL:  selectupdate insert create

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

SELECT MANDT, BUKRS, BELNR_TRN, GJAHR_TRN, BUZEI, MONAT_TRN, EX_INDEX, LAUFD, LAUFI, BUDAT_TRN, BLDAT_TRN, DMBTR_TRN, DMBTR_WRS_TRN, WRBTR_TRN, WRBTR_WRS_TRN, FLG_BELNR_TRN, GSBER, BELNR_PAY, GJAHR_PAY, BUDAT_PAY, BLDAT_PAY, DMBTR_PAY, DMBTR_WRS_PAY, WRBTR_PAY, WRBTR_WRS_PAY, FLG_BELNR_PAY, FLG_XRAGL_PAY, BELNR_INV, GJAHR_INV, BUDAT_INV, BLDAT_INV, DMBTR_INV, DMBTR_WRS_INV, WRBTR_INV, WRBTR_WRS_INV, MWSKZ, MWSKZ_INV, FLG_BELNR_INV, FLG_BELNR_ALL, BASGRUNO, HWBAS_TRN, HWBAS_WRS_TRN, FWBAS_TRN, FWBAS_WRS_TRN, HWBAS2_TRN, HWBAS2_WRS_TRN, FWBAS2_TRN, FWBAS2_WRS_TRN, HWBAS3_TRN, HWBAS3_WRS_TRN, FWBAS3_TRN, FWBAS3_WRS_TRN, HWBAS4_TRN, HWBAS4_WRS_TRN, FWBAS4_TRN, FWBAS4_WRS_TRN, FWBAS5_TRN, FWBAS5_WRS_TRN, HWBAS5_TRN, HWBAS5_WRS_TRN, STEGRUNO, HWSTE_TRN, HWSTE_WRS_TRN, FWSTE_TRN, FWSTE_WRS_TRN, HWSTE2_TRN, HWSTE2_WRS_TRN, FWSTE2_TRN, FWSTE2_WRS_TRN, HWSTE3_TRN, HWSTE3_WRS_TRN, FWSTE3_TRN, FWSTE3_WRS_TRN, HWSTE5_TRN, HWSTE5_WRS_TRN, FWSTE5_TRN, FWSTE5_WRS_TRN, BKTXT_TRN, LIFNR_CRED, NAME1_CRED, NAME2_CRED, STCD1_CRED, STCD3_CRED, XBLNR_INV, BKTXT_INV, XBLNR_PAY, BKTXT_PAY, MM_INV_BUDAT, MM_INV_EBELN, MM_INV_EBELP, MM_INV_VOISO, MM_INV_VORNU, LIGHTS, BOX, NUM_LINE, EBELN, EBELJ, ZUONR, SGTXT, XREF1_INV, XFER1_DAT, HKONT_INV, HKONT_TRN, HKONT_CLN, BELNR_ORIGPAY, GJAHR_ORIGPAY, BKTXT_ORIGPAY, XBLNR_ORIGPAY, BUDAT_ORIGPAY, BLDAT_ORIGPAY FROM J_3RSL_BK_TABLE
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2BUKRSCompany Codenvarchar40CHAR(N' ')No*BUKRS Allow NULL? 
3BELNR_TRNAccounting Document Numbernvarchar100CHAR(N' ')NoBELNR_D Allow NULL? 
4GJAHR_TRNFiscal Yearnvarchar40NUMC(N'0000')NoGJAHR Allow NULL? 
5BUZEINumber of Line Item Within Accounting Documentnvarchar30NUMC(N'000')NoBUZEI Allow NULL? 
6MONAT_TRNFiscal Periodnvarchar20NUMC(N'00')NoMONAT Allow NULL? 
7EX_INDEXDE for EX indexnvarchar100CHAR(N' ')NoJ_3RF_BUE_EXIND Allow NULL? 
8LAUFDDate on Which the Program Is to Be Runnvarchar80DATS(N'00000000')YesLAUFD Allow NULL? 
9LAUFIAdditional Identificationnvarchar60CHAR(N' ')YesLAUFI Allow NULL? 
10BUDAT_TRNPosting Date in the Documentnvarchar80DATS(N'00000000')YesBUDAT Allow NULL? 
11BLDAT_TRNDocument Date in Documentnvarchar80DATS(N'00000000')YesBLDAT Allow NULL? 
12DMBTR_TRNAmount in Local Currencydecimal132CURR((0))YesDMBTR
13DMBTR_WRS_TRNCurrency Keynvarchar50CUKY(N' ')Yes*WAERS Allow NULL? 
14WRBTR_TRNAmount in document currencydecimal132CURR((0))YesWRBTR
15WRBTR_WRS_TRNCurrency Keynvarchar50CUKY(N' ')Yes*WAERS Allow NULL? 
16FLG_BELNR_TRNReversal (Tax Transfer)char10CHAR(N' ')YesJ_3RF_BUE_F_D0 Allow NULL? 
17GSBERBusiness Areanvarchar40CHAR(N' ')Yes*GSBER Allow NULL? 
18BELNR_PAYAccounting Document Numbernvarchar100CHAR(N' ')YesBELNR_D Allow NULL? 
19GJAHR_PAYFiscal Yearnvarchar40NUMC(N'0000')YesGJAHR Allow NULL? 
20BUDAT_PAYPosting Date in the Documentnvarchar80DATS(N'00000000')YesBUDAT Allow NULL? 
21BLDAT_PAYDocument Date in Documentnvarchar80DATS(N'00000000')YesBLDAT Allow NULL? 
22DMBTR_PAYAmount Posted in Display Currencydecimal132CURR((0))YesANZBT_F05L
23DMBTR_WRS_PAYCurrency Keynvarchar50CUKY(N' ')Yes*WAERS Allow NULL? 
24WRBTR_PAYAmount Posted in Display Currencydecimal132CURR((0))YesANZBT_F05L
25WRBTR_WRS_PAYCurrency Keynvarchar50CUKY(N' ')Yes*WAERS Allow NULL? 
26FLG_BELNR_PAYReversal (Payment)char10CHAR(N' ')YesJ_3RF_BUE_F_D2 Allow NULL? 
27FLG_XRAGL_PAYIndicator: Clearing was Reversedchar10CHAR(N' ')YesXRAGL Allow NULL? 
28BELNR_INVAccounting Document Numbernvarchar100CHAR(N' ')YesBELNR_D Allow NULL? 
29GJAHR_INVFiscal Yearnvarchar40NUMC(N'0000')YesGJAHR Allow NULL? 
30BUDAT_INVPosting Date in the Documentnvarchar80DATS(N'00000000')YesBUDAT Allow NULL? 
31BLDAT_INVDocument Date in Documentnvarchar80DATS(N'00000000')YesBLDAT Allow NULL? 
32DMBTR_INVAmount in Local Currencydecimal132CURR((0))YesDMBTR
33DMBTR_WRS_INVCurrency Keynvarchar50CUKY(N' ')Yes*WAERS Allow NULL? 
34WRBTR_INVAmount in document currencydecimal132CURR((0))YesWRBTR
35WRBTR_WRS_INVCurrency Keynvarchar50CUKY(N' ')Yes*WAERS Allow NULL? 
36MWSKZTax on sales/purchases codenvarchar20CHAR(N' ')Yes*MWSKZ Allow NULL? 
37MWSKZ_INVTax on sales/purchases codenvarchar20CHAR(N' ')Yes*MWSKZ Allow NULL? 
38FLG_BELNR_INVReversal (Invoice)char10CHAR(N' ')YesJ_3RF_BUE_F_D1 Allow NULL? 
39FLG_BELNR_ALLReversal (Clearing)char10CHAR(N' ')YesJ_3RF_BUE_F_ALL Allow NULL? 
40BASGRUNOGroup Number for Tax Base Amountsnvarchar20NUMC(N'00')YesBASGRUNO Allow NULL? 
41HWBAS_TRNAmount Posted in Display Currencydecimal132CURR((0))YesANZBT_F05L
42HWBAS_WRS_TRNCurrency Keynvarchar50CUKY(N' ')Yes*WAERS Allow NULL? 
43FWBAS_TRNAmount Posted in Display Currencydecimal132CURR((0))YesANZBT_F05L
44FWBAS_WRS_TRNCurrency Keynvarchar50CUKY(N' ')Yes*WAERS Allow NULL? 
45HWBAS2_TRNAmount Posted in Display Currencydecimal132CURR((0))YesANZBT_F05L
46HWBAS2_WRS_TRNCurrency Keynvarchar50CUKY(N' ')Yes*WAERS Allow NULL? 
47FWBAS2_TRNAmount Posted in Display Currencydecimal132CURR((0))YesANZBT_F05L
48FWBAS2_WRS_TRNCurrency Keynvarchar50CUKY(N' ')Yes*WAERS Allow NULL? 
49HWBAS3_TRNAmount Posted in Display Currencydecimal132CURR((0))YesANZBT_F05L
50HWBAS3_WRS_TRNCurrency Keynvarchar50CUKY(N' ')Yes*WAERS Allow NULL? 
51FWBAS3_TRNAmount Posted in Display Currencydecimal132CURR((0))YesANZBT_F05L
52FWBAS3_WRS_TRNCurrency Keynvarchar50CUKY(N' ')Yes*WAERS Allow NULL? 
53HWBAS4_TRNAmount Posted in Display Currencydecimal132CURR((0))YesANZBT_F05L
54HWBAS4_WRS_TRNCurrency Keynvarchar50CUKY(N' ')Yes*WAERS Allow NULL? 
55FWBAS4_TRNAmount Posted in Display Currencydecimal132CURR((0))YesANZBT_F05L
56FWBAS4_WRS_TRNCurrency Keynvarchar50CUKY(N' ')Yes*WAERS Allow NULL? 
57FWBAS5_TRNAmount Posted in Display Currencydecimal132CURR((0))YesANZBT_F05L
58FWBAS5_WRS_TRNCurrency Keynvarchar50CUKY(N' ')Yes*WAERS Allow NULL? 
59HWBAS5_TRNAmount Posted in Display Currencydecimal132CURR((0))YesANZBT_F05L
60HWBAS5_WRS_TRNCurrency Keynvarchar50CUKY(N' ')Yes*WAERS Allow NULL? 
61STEGRUNOGroup Number for Tax Amountsnvarchar20NUMC(N'00')YesSTEGRUNO Allow NULL? 
62HWSTE_TRNAmount Posted in Display Currencydecimal132CURR((0))YesANZBT_F05L
63HWSTE_WRS_TRNCurrency Keynvarchar50CUKY(N' ')Yes*WAERS Allow NULL? 
64FWSTE_TRNAmount Posted in Display Currencydecimal132CURR((0))YesANZBT_F05L
65FWSTE_WRS_TRNCurrency Keynvarchar50CUKY(N' ')Yes*WAERS Allow NULL? 
66HWSTE2_TRNAmount Posted in Display Currencydecimal132CURR((0))YesANZBT_F05L
67HWSTE2_WRS_TRNCurrency Keynvarchar50CUKY(N' ')Yes*WAERS Allow NULL? 
68FWSTE2_TRNAmount Posted in Display Currencydecimal132CURR((0))YesANZBT_F05L
69FWSTE2_WRS_TRNCurrency Keynvarchar50CUKY(N' ')Yes*WAERS Allow NULL? 
70HWSTE3_TRNAmount Posted in Display Currencydecimal132CURR((0))YesANZBT_F05L
71HWSTE3_WRS_TRNCurrency Keynvarchar50CUKY(N' ')Yes*WAERS Allow NULL? 
72FWSTE3_TRNAmount Posted in Display Currencydecimal132CURR((0))YesANZBT_F05L
73FWSTE3_WRS_TRNCurrency Keynvarchar50CUKY(N' ')Yes*WAERS Allow NULL? 
74HWSTE5_TRNAmount Posted in Display Currencydecimal132CURR((0))YesANZBT_F05L
75HWSTE5_WRS_TRNCurrency Keynvarchar50CUKY(N' ')Yes*WAERS Allow NULL? 
76FWSTE5_TRNAmount Posted in Display Currencydecimal132CURR((0))YesANZBT_F05L
77FWSTE5_WRS_TRNCurrency Keynvarchar50CUKY(N' ')Yes*WAERS Allow NULL? 
78BKTXT_TRNDocument Header Textnvarchar250CHAR(N' ')YesBKTXT Allow NULL? 
79LIFNR_CREDAccount Number of Vendor or Creditornvarchar100CHAR(N' ')Yes*LIFNR Allow NULL? 
80NAME1_CREDName 1nvarchar350CHAR(N' ')YesNAME1_GP Allow NULL? 
81NAME2_CREDName 2nvarchar350CHAR(N' ')YesNAME2_GP Allow NULL? 
82STCD1_CREDTax Number 1nvarchar160CHAR(N' ')YesSTCD1 Allow NULL? 
83STCD3_CREDTax Number 3nvarchar180CHAR(N' ')YesSTCD3 Allow NULL? 
84XBLNR_INVReference Document Numbernvarchar160CHAR(N' ')YesXBLNR1 Allow NULL? 
85BKTXT_INVDocument Header Textnvarchar250CHAR(N' ')YesBKTXT Allow NULL? 
86XBLNR_PAYReference Document Numbernvarchar160CHAR(N' ')YesXBLNR1 Allow NULL? 
87BKTXT_PAYDocument Header Textnvarchar250CHAR(N' ')YesBKTXT Allow NULL? 
88MM_INV_BUDATDate of Goods Receiptnvarchar80DATS(N'00000000')YesJ_3RF_DE_RDAT Allow NULL? 
89MM_INV_EBELNPurchasing Document Numbernvarchar100CHAR(N' ')Yes*EBELN Allow NULL? 
90MM_INV_EBELPItem Number of Purchasing Documentnvarchar50NUMC(N'00000')Yes*EBELP Allow NULL? 
91MM_INV_VOISOPrelim. doc.: ISO code of ctry issuing the preliminary doc.nvarchar20CHAR(N' ')YesVOISO Allow NULL? 
92MM_INV_VORNUPreliminary document: No. of preliminary doc.f.import procgnvarchar250CHAR(N' ')YesVORNU Allow NULL? 
93LIGHTSIcon ID (incl. @)nvarchar40CHAR(N' ')YesSCRFICON Allow NULL? 
94BOXFlag for mark rec 01char10CHAR(N' ')YesJ_3RF_BUE_F_BOX Allow NULL? 
95NUM_LINEAccounting Document Numbernvarchar100CHAR(N' ')YesBELNR_D Allow NULL? 
96EBELNPurchasing Document Numbernvarchar100CHAR(N' ')Yes*EBELN Allow NULL? 
97EBELJFiscal Yearnvarchar40NUMC(N'0000')YesGJAHR Allow NULL? 
98ZUONRAssignment Numbernvarchar180CHAR(N' ')YesJ_3RFZUONR Allow NULL? 
99SGTXTItem Textnvarchar500CHAR(N' ')YesSGTXT Allow NULL? 
100XREF1_INVBusiness partner reference keynvarchar120CHAR(N' ')YesXREF1 Allow NULL? 
101XFER1_DATDocument Date in Documentnvarchar80DATS(N'00000000')YesBLDAT Allow NULL? 
102HKONT_INVGeneral Ledger Accountnvarchar100CHAR(N' ')Yes*HKONT Allow NULL? 
103HKONT_TRNGeneral Ledger Accountnvarchar100CHAR(N' ')Yes*HKONT Allow NULL? 
104HKONT_CLNGeneral Ledger Accountnvarchar100CHAR(N' ')Yes*HKONT Allow NULL? 
105BELNR_ORIGPAYAccounting Document Numbernvarchar100CHAR(N' ')YesBELNR_D Allow NULL? 
106GJAHR_ORIGPAYFiscal Yearnvarchar40NUMC(N'0000')YesGJAHR Allow NULL? 
107BKTXT_ORIGPAYDocument Header Textnvarchar250CHAR(N' ')YesBKTXT Allow NULL? 
108XBLNR_ORIGPAYReference Document Numbernvarchar160CHAR(N' ')YesXBLNR1 Allow NULL? 
109BUDAT_ORIGPAYPosting Date in the Documentnvarchar80DATS(N'00000000')YesBUDAT Allow NULL? 
110BLDAT_ORIGPAYDocument Date in Documentnvarchar80DATS(N'00000000')YesBLDAT Allow NULL? 
NamePrimaryUniqueTypeColumns
J_3RSL_BK_TABLE~0YesYesCLUSTEREDEX_INDEX, MONAT_TRN, BUZEI, GJAHR_TRN, BELNR_TRN, BUKRS, 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