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  | RBKPB
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)
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9BSEG345Accounting Document Segment
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
Materials Management :: Invoice Verification
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0RBKPB941Invoice Document Header (Batch Invoice Verification)Invoice Verification
SQL:  selectupdate insert create

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

SELECT MANDT, BELNR, GJAHR, NUMPG, RPZIELN, RPZIELMW, DIFFN, DIFFMW, UBNKMW, ANZRPV, REPDAT, REPTIM, ANZUNF, ANZLIF, ANZRPO, XKORREKT, XNOTIZ, ANZLSM, LFDATABLI, LFDATBISLI, LFDATABRT, LFDATBISRT, XZUORDLI, XZUORDRT, XBNK, XWARE, TBTKZ, XBEST, XLIFS, XFRBR, XWERK, XERFB, SELIF, BNKSEL, XRECHL, XRECHR, XNEGDIFF, XTRAN, XTMTRAN, XCONTRACT, XTM, RET_DUE_PROP, REPART, RBSTAT, MAKZN, XRKUE, ESRNR, ESRPZ, ESRRE, QSSHB, QSFBT, QSSKZ, DIEKZ, LANDL, LZBKZ, TXKRS, XAVER, KZZUORDLI, KZZUORDRT, KZBNK, RCHGART, BNLIF, LIEFF, SMWSKZ1, SMWST1, LIEFF1, MWLIEFF1, MAKZMW1, MWDIFFB1, FWNAV1, MWBNK1, SMWSKZ2, SMWST2, LIEFF2, MWLIEFF2, MAKZMW2, MWDIFFB2, FWNAV2, MWBNK2, SOLLN, SOLLB, MAKZB, LIEFFN, DIFFB, ZFBDT, MONAT, ZLSCH, PREPAY_AREWR, PREPAY_HWAER, PREPAY_AREWW, PREPAY_WAERS, PREPAY_KURSF, PREPAY_KUFIX, PREPAY_LIFNR FROM RBKPB
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2BELNRDocument Number of an Invoice Documentnvarchar100CHAR(N' ')NoRE_BELNR Allow NULL? 
3GJAHRFiscal Yearnvarchar40NUMC(N'0000')NoGJAHR Allow NULL? 
4NUMPGNumber of pages of invoicenvarchar30NUMC(N'000')YesJ_1ANOPG Allow NULL? 
5RPZIELNTotal of Items Selecteddecimal132CURR((0))YesRPZIELN
6RPZIELMWVAT Portion of Target Invoice Amount in Document Currencydecimal132CURR((0))YesRPZIELMW
7DIFFNDocument Balancedecimal132CURR((0))YesRPDIFN
8DIFFMWSales Tax Portion of the Invoice Verification Differencedecimal132CURR((0))YesDIFFMW
9UBNKMWSales tax portion of unplanned delivery costsdecimal132CURR((0))YesUBNKMW
10ANZRPVNo. of invoice verification attemptsnvarchar30NUMC(N'000')YesANZRPV Allow NULL? 
11REPDATInvoice Verification datenvarchar80DATS(N'00000000')YesREPDAT Allow NULL? 
12REPTIMInvoice Verification timenvarchar60TIMS(N'000000')YesREPTIM Allow NULL? 
13ANZUNFNumber of unsolved errorsnvarchar60NUMC(N'000000')YesANZUNF Allow NULL? 
14ANZLIFNumber of vendor errorsnvarchar60NUMC(N'000000')YesANZLIF Allow NULL? 
15ANZRPONumber of selected invoice itemsnvarchar60NUMC(N'000000')YesANZRPO Allow NULL? 
16XKORREKTIndicates if the invoice is correctchar10CHAR(N' ')YesXKORREKT Allow NULL? 
17XNOTIZIndicates Whether a Note Existschar10CHAR(N' ')YesXNOTIZ Allow NULL? 
18ANZLSMIndicator: More Than One Item with Different Del. Note. Qtychar10CHAR(N' ')YesANZLSM Allow NULL? 
19LFDATABLIDelivery datenvarchar80DATS(N'00000000')YesLFDAT Allow NULL? 
20LFDATBISLIDelivery datenvarchar80DATS(N'00000000')YesLFDAT Allow NULL? 
21LFDATABRTDelivery date of returnnvarchar80DATS(N'00000000')YesLFDATRET Allow NULL? 
22LFDATBISRTDelivery date of returnnvarchar80DATS(N'00000000')YesLFDATRET Allow NULL? 
23XZUORDLIIndicates delivery item allocationchar10CHAR(N' ')YesXZUORDLI Allow NULL? 
24XZUORDRTIndicates returns allocationchar10CHAR(N' ')YesXZUORDRT Allow NULL? 
25XBNKPlanned Delivery Costs Indicatorchar10CHAR(N' ')YesXBNK Allow NULL? 
26XWAREGoods Invoice/Service Indicatorchar10CHAR(N' ')YesXWARE Allow NULL? 
27TBTKZIndicator: subsequent debit/creditchar10CHAR(N' ')YesTBTKZ Allow NULL? 
28XBESTCheckbox: Allocationschar10CHAR(N' ')YesXZUORD Allow NULL? 
29XLIFSCheckbox: Allocationschar10CHAR(N' ')YesXZUORD Allow NULL? 
30XFRBRCheckbox: Allocationschar10CHAR(N' ')YesXZUORD Allow NULL? 
31XWERKCheckbox: Allocationschar10CHAR(N' ')YesXZUORD Allow NULL? 
32XERFBCheckbox: Allocationschar10CHAR(N' ')YesXZUORD Allow NULL? 
33SELIFNumber of the selection vendornvarchar100CHAR(N' ')Yes*SELIF Allow NULL? 
34BNKSELType of delivery cost selectionchar10CHAR(N' ')YesBNKSEL Allow NULL? 
35XRECHLPosting logic for delivery items (invoice/credit memo)char10CHAR(N' ')YesXRECHL Allow NULL? 
36XRECHRPosting logic for returns items (invoice/credit memo)char10CHAR(N' ')YesXRECHR Allow NULL? 
37XNEGDIFFEDI: Indicator for Check for Negative Unclarified Errorschar10CHAR(N' ')YesEDINEGDIFF Allow NULL? 
38XTRANCheckbox: Allocationschar10CHAR(N' ')YesXZUORD Allow NULL? 
39XTMTRANCheckbox: Allocationschar10CHAR(N' ')YesXZUORD Allow NULL? 
40XCONTRACTContract Selection with SRM Contract Numberchar10CHAR(N' ')YesXSRMCONTRACT Allow NULL? 
41XTMCheckbox: Allocationschar10CHAR(N' ')YesXZUORD Allow NULL? 
42RET_DUE_PROPDue Date for Retention (Default)nvarchar80DATS(N'00000000')YesRET_DUE_PROP Allow NULL? 
43REPARTObsolete: indicator for inv. verification type: do NOT usechar10CHAR(N' ')YesREPARTO Allow NULL? 
44RBSTATObsolete: Invoice document status: do NOT usechar10CHAR(N' ')YesRBSTATO Allow NULL? 
45MAKZNObsolete: man.-accepted net invoice diff. amount: do NOT usedecimal132CURR((0))YesMAKZNO
46XRKUEObsolete: automatic invoice reduction: do NOT use!char10CHAR(N' ')YesXRKUE_O Allow NULL? 
47ESRNRObsolete: ISR subscriber number: do NOT usenvarchar110CHAR(N' ')YesESRNR_O Allow NULL? 
48ESRPZObsolete: ISR check digit: do NOT usenvarchar20CHAR(N' ')YesESRPZ_O Allow NULL? 
49ESRREObsolete: ISR reference number: do NOT usenvarchar270CHAR(N' ')YesESRRE_O Allow NULL? 
50QSSHBOld: Withholding tax base amount: do NOT usedecimal132CURR((0))YesQSSHB_O
51QSFBTObsolete: amount exempt of withholding tax: do NOT usedecimal132CURR((0))YesQSFBT_O
52QSSKZObsolete: Withholding tax indicator: do NOT usenvarchar20CHAR(N' ')YesT059QQSSKZ_O Allow NULL? 
53DIEKZObsolete: service indicator: do NOT usechar10CHAR(N' ')YesDIEKZ_O Allow NULL? 
54LANDLObsolete: supplying country: do NOT use!nvarchar30CHAR(N' ')YesT005LANDL_O Allow NULL? 
55LZBKZObsolete: state central bank indicator: do NOT usenvarchar30CHAR(N' ')YesT015LLZBKZ_O Allow NULL? 
56TXKRSObsolete: exchange rate for taxes: do NOT usedecimal95DEC((0))YesTXKRS_O
57XAVERObsolete, no longer usedchar10CHAR(N' ')YesXAVER Allow NULL? 
58KZZUORDLIObsolete: ID for delivery allocation: do NOT use!char10CHAR(N' ')YesKZZUORDLI Allow NULL? 
59KZZUORDRTObsolete: ID for returns allocation: do NOT use!char10CHAR(N' ')YesKZZUORDRT Allow NULL? 
60KZBNKObsolete: ID for planned delivery costs: do NOT use!char10CHAR(N' ')YesKZBNK Allow NULL? 
61RCHGARTObsolete: Invoice type for inv. verification: do NOT usenvarchar40CHAR(N' ')YesRCHGART Allow NULL? 
62BNLIFObsolete: No. of vendor invoicing del. costs: do NOT usenvarchar100CHAR(N' ')YesLFA1BNLIF Allow NULL? 
63LIEFFObsolete: vendor error incl. VAT: do NOT use!decimal132CURR((0))YesLIEFFB_O
64SMWSKZ1Obsolete: sales tax codenvarchar20CHAR(N' ')YesT007AMWSKZ_MRMO Allow NULL? 
65SMWST1Obsolete: tax amount in document currency - do NOT use!decimal132CURR((0))YesFWSTEV_OLD
66LIEFF1Obsolete: amount with +/- sign - do NOT usedecimal132CURR((0))YesBETRAG_OLD
67MWLIEFF1Obsolete: tax in vendor errordecimal132CURR((0))YesLMWST
68MAKZMW1Obsolete: amount with +/- sign - do NOT usedecimal132CURR((0))YesBETRAG_OLD
69MWDIFFB1Obsolete: amount with +/- sign - do NOT usedecimal132CURR((0))YesBETRAG_OLD
70FWNAV1Obsolete: tax amount in document currency - do NOT use!decimal132CURR((0))YesFWSTEV_OLD
71MWBNK1Obsolete: tax amount in document currency - do NOT use!decimal132CURR((0))YesFWSTEV_OLD
72SMWSKZ2Obsolete: sales tax codenvarchar20CHAR(N' ')YesT007AMWSKZ_MRMO Allow NULL? 
73SMWST2Obsolete: tax amount in document currency - do NOT use!decimal132CURR((0))YesFWSTEV_OLD
74LIEFF2Obsolete: amount with +/- sign - do NOT usedecimal132CURR((0))YesBETRAG_OLD
75MWLIEFF2Obsolete: tax in vendor errordecimal132CURR((0))YesLMWST
76MAKZMW2Obsolete: amount with +/- sign - do NOT usedecimal132CURR((0))YesBETRAG_OLD
77MWDIFFB2Obsolete: amount with +/- sign - do NOT usedecimal132CURR((0))YesBETRAG_OLD
78FWNAV2Obsolete: tax amount in document currency - do NOT use!decimal132CURR((0))YesFWSTEV_OLD
79MWBNK2Obsolete: tax amount in document currency - do NOT use!decimal132CURR((0))YesFWSTEV_OLD
80SOLLNObsolete: amount with +/- sign - do NOT usedecimal132CURR((0))YesBETRAG_OLD
81SOLLBObsolete: amount with +/- sign - do NOT usedecimal132CURR((0))YesBETRAG_OLD
82MAKZBObsolete: amount with +/- sign - do NOT usedecimal132CURR((0))YesBETRAG_OLD
83LIEFFNObsolete: amount with +/- sign - do NOT usedecimal132CURR((0))YesBETRAG_OLD
84DIFFBObsolete: amount with +/- sign - do NOT usedecimal132CURR((0))YesBETRAG_OLD
85ZFBDTNot used. Base date for due-date calculationnvarchar80DATS(N'00000000')YesBDFAE_OLD Allow NULL? 
86MONATOutdated: Fiscal period - do NOT use!!!nvarchar20NUMC(N'00')YesMONAT_OLD Allow NULL? 
87ZLSCHOutdated: Payment method - do NOT use!!!char10CHAR(N' ')Yes*WZLSC_OLD Allow NULL? 
88PREPAY_AREWRClearing Value to Prepayment Clearing Account in LCdecimal132CURR((0))YesWRF_PREPAY_AREWR
89PREPAY_HWAERLocal Currencynvarchar50CUKY(N' ')Yes*WRF_PREPAY_HWAER Allow NULL? 
90PREPAY_AREWWClearing Value to Prepayment Clearing Account in TCdecimal132CURR((0))YesWRF_PREPAY_AREWW
91PREPAY_WAERSDocument Currencynvarchar50CUKY(N' ')Yes*WRF_PREPAY_WAERS Allow NULL? 
92PREPAY_KURSFExchange Rate of Prepayment Documentdecimal95DEC((0))YesWRF_PREPAY_KURSF
93PREPAY_KUFIXFlag: Fixed Exchange Rate in Prepayment Documentchar10CHAR(N' ')YesWRF_PREPAY_KUFIX Allow NULL? 
94PREPAY_LIFNRVendor Account Number in Prepayment Documentnvarchar100CHAR(N' ')Yes*WRF_PREPAY_LIFNR Allow NULL? 
NamePrimaryUniqueTypeColumns
RBKPB~0YesYesCLUSTEREDGJAHR, BELNR, 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