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  | HRP1890
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
1ERP EHP76.0HRP1890762DB Table for Infotype 1890
SQL:  selectupdate insert create

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

SELECT MANDT, PLVAR, OTYPE, OBJID, SUBTY, ISTAT, BEGDA, ENDDA, VARYF, SEQNR, INFTY, OTJID, AEDTM, UNAME, REASN, HISTO, ITXNR, SC_OBJID, ADM_AYEAR, ADM_PERID, PAIDBY, PAYMENTTYPE, PAYMENTNAME, FORMOFPAYBANKDUT, FORMOFPAYBANKFOR, BANK, BANKCOUNTRY, INSTALLMENTS, PAID, AMOUNTFEE, PROOFFEEPAID, FEE_WAIVER, INVOICE, NOOFINST, ADMINFEE, BARCODE, ORDERNUM, PAIDATBRIN, PAIDATINST, DOCNR, AUTHFEEAMT, AUTHSENT, AUTHSTACC, AUTHWTDRW, AUTHSENTDATE, AUTHSENTTIME, OPBEL, ADM_GUID, PAID_INBRIN, BRIN_SEQ, PAID_INSTNAME, INITAMT, VALUTA_INIT, INSTAMT, VALUTA_INST, PRF_INSTATUS, RECEIV_BY, RECEIPT_DATE, INCANCEL_BY, INCANCEL_ON, TOTAL_AMT, VALUTA_TOT, INST_BRIN, PRF_OUTSTATUS, REG_BY, REG_DATE, OUTCANCEL_BY, OUTCANCEL_ON, LEGAL_TUTFEE, VALUTA_LEGLFEE, INST_TUTFEE, VALUTA_INSTFEE, IBAN, MAND_REFID, BIC, TABNR FROM HRP1890
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2PLVARPlan Versionnvarchar20CHAR(N' ')NoT778PPLVAR Allow NULL? 
3OTYPEObject Typenvarchar20CHAR(N' ')NoT778OOTYPE Allow NULL? 
4OBJIDObject IDnvarchar80NUMC(N'00000000')NoPLOGIHROBJID Allow NULL? 
5SUBTYSubtypenvarchar40CHAR(N' ')No*SUBTYP Allow NULL? 
6ISTATPlanning Statuschar10CHAR(N' ')NoT778SISTAT_D Allow NULL? 
7BEGDAStart Datenvarchar80DATS(N'00000000')NoBEGDATUM Allow NULL? 
8ENDDAEnd Datenvarchar80DATS(N'00000000')NoENDDATUM Allow NULL? 
9VARYFVariation Field for File PLOGnvarchar100CHAR(N' ')NoVARYF Allow NULL? 
10SEQNRNumber of Infotype Record with Same Keynvarchar30NUMC(N'000')NoSEQNR Allow NULL? 
11INFTYInfotypenvarchar40CHAR(N' ')NoT778TINFOTYP Allow NULL? 
12OTJIDConcatenation of Object Type and Object IDnvarchar100CHAR(N' ')NoOTJID Allow NULL? 
13AEDTMChanged onnvarchar80DATS(N'00000000')NoAEDTM Allow NULL? 
14UNAMEUser Namenvarchar120CHAR(N' ')NoUSRNAME Allow NULL? 
15REASNReasonnvarchar20CHAR(N' ')NoREASN Allow NULL? 
16HISTOHistorical Record Flagchar10CHAR(N' ')NoHISTO Allow NULL? 
17ITXNRText Module for Infotypenvarchar80NUMC(N'00000000')NoITXNR Allow NULL? 
18SC_OBJIDProgram IDnvarchar80NUMC(N'00000000')Yes*PIQSCOBJID Allow NULL? 
19ADM_AYEARAcademic Yearnvarchar40NUMC(N'0000')Yes*PIQPERYR Allow NULL? 
20ADM_PERIDAcademic Sessionnvarchar30NUMC(N'000')Yes*PIQPERID Allow NULL? 
21PAIDBYPaid Bychar10CHAR(N' ')YesT7PIQ_NL_PAIDBYPIQ_NL_PAIDBY Allow NULL? 
22PAYMENTTYPEMode of Paymentchar10CHAR(N' ')YesT7PIQ_NL_PAYTYPIQ_NL_PAYMENTTYPE Allow NULL? 
23PAYMENTNAMEName of Payeenvarchar2200CHAR(N' ')YesPIQ_NL_PYMNTNAME Allow NULL? 
24FORMOFPAYBANKDUTAccount Number (Netherlands)nvarchar100NUMC(N'0000000000')YesPIQ_NL_PAYMENTBANKGBA Allow NULL? 
25FORMOFPAYBANKFORAccount Number (Foreign)nvarchar340CHAR(N' ')YesPIQ_NL_PAYMENTBANKFORE Allow NULL? 
26BANKName of Banknvarchar500CHAR(N' ')YesPIQ_NL_BANK Allow NULL? 
27BANKCOUNTRYCountry Keynvarchar30CHAR(N' ')YesT005LAND1 Allow NULL? 
28INSTALLMENTSInstallmentschar10CHAR(N' ')YesPIQ_NL_INSTL Allow NULL? 
29PAIDTuition Fee Refundablechar10CHAR(N' ')YesPIQ_NL_PAID Allow NULL? 
30AMOUNTFEETuition Feedecimal102DEC((0))YesPIQ_NL_AMOUNTFEE
31PROOFFEEPAIDTuition Fee Paidchar10CHAR(N' ')YesPIQ_NL_PROOFPD Allow NULL? 
32FEE_WAIVERFee Waiverchar10CHAR(N' ')YesPIQ_NL_FEEWVR Allow NULL? 
33INVOICEInvoicechar10CHAR(N' ')YesPIQ_NL_INVOICE Allow NULL? 
34NOOFINSTNo. of Installmentsnvarchar20NUMC(N'00')YesPIQ_NL_INSTALMENTS Allow NULL? 
35ADMINFEEAdministration Feedecimal62DEC((0))YesPIQ_NL_ADMINFEE
36BARCODEBarcodenvarchar120NUMC(N'000000000000')YesPIQ_NL_BARCODE Allow NULL? 
37ORDERNUMElectronic Payment Order Numbernvarchar300CHAR(N' ')YesPIQ_NL_ORDERNUMBER Allow NULL? 
38PAIDATBRINPaid at BRIN Numbernvarchar40CHAR(N' ')YesPIQ_NL_PAIDATBRIN Allow NULL? 
39PAIDATINSTPaid at Institutenvarchar700CHAR(N' ')YesPIQ_NL_PAIDATINST Allow NULL? 
40DOCNRNumber of Fee Calculation Documentnvarchar200CHAR(N' ')YesCMAC_FEE_DOCNR Allow NULL? 
41AUTHFEEAMTAuthorized Fee Amountdecimal102DEC((0))YesPIQ_NL_AUTHFEEAMT
42AUTHSENTPayment Authorization Sentchar10CHAR(N' ')YesPIQ_NL_AUTHSENT Allow NULL? 
43AUTHSTACCAuthorization Acceptedchar10CHAR(N' ')YesPIQ_NL_AUTHSTACC Allow NULL? 
44AUTHWTDRWAuthorization Withdrawnchar10CHAR(N' ')YesPIQ_NL_AUTHWTDRW Allow NULL? 
45AUTHSENTDATEAuthorization Sent Datenvarchar80DATS(N'00000000')YesPIQ_NL_AUTHSENTDATE Allow NULL? 
46AUTHSENTTIMEAuthorization Sent Timenvarchar60TIMS(N'000000')YesPIQ_NL_AUTHSENTTIME Allow NULL? 
47OPBELNumber of Contract Accts Rec. & Payable Doc.nvarchar120CHAR(N' ')Yes*OPBEL_KK Allow NULL? 
48ADM_GUIDUnique Key (GUID) of the Admissionnvarchar320CHAR(N' ')YesPIQADM_GUID Allow NULL? 
49PAID_INBRINPaid at BRIN Number for an Incoming Proof of Paymentnvarchar40CHAR(N' ')YesPIQ_NL_INBRIN Allow NULL? 
50BRIN_SEQBRIN Sequence Numbernvarchar20NUMC(N'00')YesPIQ_NL_BRINSEQ Allow NULL? 
51PAID_INSTNAMEPaid at Institute for an Incoming Proof of Paymentnvarchar700CHAR(N' ')YesPIQ_NL_INSTNAME Allow NULL? 
52INITAMTInitial Amountdecimal102CURR((0))YesPIQ_NL_INIAMOUNT
53VALUTA_INITCurrency Keynvarchar50CUKY(N' ')YesTCURCWAERS Allow NULL? 
54INSTAMTIncoming Proof of Payment Legal Tuition Feedecimal102CURR((0))YesPIQ_NL_LEGALTUTFEE
55VALUTA_INSTCurrency Keynvarchar50CUKY(N' ')YesTCURCWAERS Allow NULL? 
56PRF_INSTATUSIncoming Proof of Payment Statuschar10CHAR(N' ')YesPIQ_NL_PINSTATUS Allow NULL? 
57RECEIV_BYReceived By (User Name)nvarchar350CHAR(N' ')YesPIQ_NL_RECIEVBY Allow NULL? 
58RECEIPT_DATEReceipt Datenvarchar80DATS(N'00000000')YesPIQ_NL_RECEIPTDATE Allow NULL? 
59INCANCEL_BYIncoming Proof of Payment Cancelled By (User Name)nvarchar350CHAR(N' ')YesPIQ_NL_INCANCELLEDBY Allow NULL? 
60INCANCEL_ONIncoming Proof of Payment Cancellation Datenvarchar80DATS(N'00000000')YesPIQ_NL_INCANCELLEDDATE Allow NULL? 
61TOTAL_AMTAmountdecimal102CURR((0))YesPIQ_NL_AMOUNT
62VALUTA_TOTCurrency Keynvarchar50CUKY(N' ')YesTCURCWAERS Allow NULL? 
63INST_BRINInstitute BRIN Numbernvarchar40CHAR(N' ')YesPIQ_NL_BRIN Allow NULL? 
64PRF_OUTSTATUSOutgoing Proof of Payment Statuschar10CHAR(N' ')YesPIQ_NL_POUTSTATUS Allow NULL? 
65REG_BYRegistered By (User Name)nvarchar350CHAR(N' ')YesPIQ_NL_REGISTBY Allow NULL? 
66REG_DATERegistered Datenvarchar80DATS(N'00000000')YesPIQ_NL_REGISTDATE Allow NULL? 
67OUTCANCEL_BYOutgoing Proof of Payment Cancelled By (User Name)nvarchar350CHAR(N' ')YesPIQ_NL_OUTCANCELLEDBY Allow NULL? 
68OUTCANCEL_ONOutgoing Proof of Payment Cancellation Datenvarchar80DATS(N'00000000')YesPIQ_NL_OUTCANCELLEDDATE Allow NULL? 
69LEGAL_TUTFEEOutgoing Proof of Payment Legal Tuition Feedecimal102CURR((0))YesPIQ_NL_OUTLEGALTUTFEE
70VALUTA_LEGLFEECurrency Keynvarchar50CUKY(N' ')YesTCURCWAERS Allow NULL? 
71INST_TUTFEEInstitute Tuition Feedecimal102CURR((0))YesPIQ_NL_INSTTUTFEE
72VALUTA_INSTFEECurrency Keynvarchar50CUKY(N' ')YesTCURCWAERS Allow NULL? 
73IBANIBAN (International Bank Account Number)nvarchar340CHAR(N' ')YesIBAN Allow NULL? 
74MAND_REFIDUnique Referene to Mandate per Payment Recipientnvarchar350CHAR(N' ')YesSEPA_MNDID Allow NULL? 
75BICSWIFT Code/Bank Identifier Code (BIC)nvarchar110CHAR(N' ')YesBICSW_KK Allow NULL? 
76TABNRReference Number to Table Partnvarchar320CHAR(N' ')Yes*HRTABNR Allow NULL? 
NamePrimaryUniqueTypeColumns
HRP1890~0YesYesCLUSTEREDSEQNR, VARYF, ENDDA, BEGDA, ISTAT, SUBTY, OBJID, OTYPE, PLVAR, MANDT
HRP1890~1NoNoNONCLUSTEREDMANDT, PLVAR, OTJID

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