4
(1)

SAP Business One ( B1) Database table list with a brief description.

ODUN : Table for storing Dunning levels definition
AOB1 : Table for storing Message recipient list
OALR : Table for storing Messages
OCRN : Table for storing Currency codes
OUPT : Table for storing User authorizations for add-on forms
UPT1 : Table for storing User permission forms
OUSR : Table for storing Users of SAP Business One application
USR3 : Table for storing User authorizations
SARI : Table for storing Overall Addon Path Defining
OUQR : Table for storing User Queries
OBGT : Table for storing Budget management
BGT1 : Table for storing Budget item details of an account
OBGD : Table for storing Budget distribution methods
OBGS : Table for storing Budget scenarios
OACT : Table for storing G/L accounts
OBTD : Table for storing Journal vouchers
JDT1 : Table for storing Journal transaction – rows
OJDT : Table for storing Journal transaction
OSTA : Table for storing Sales tax jurisdictions
OSTT : Table for storing Sales tax authority types
OSTC : Table for storing Inclusive sales tax codes
DLN1 : Table for storing Delivery note rows
DLN2 : Table for storing Delivery note rows – expenses
DLN3 : Table for storing Delivery note – expenses
OEXD : Table for storing Defines additional expenses
DRF1 : Table for storing Draft – rows
DRF2 : Table for storing Draft rows – expenses
DRF3 : Table for storing Draft – expenses
INV1 : Table for storing Invoice – rows
INV2 : Table for storing Invoice rows – expenses
INV3 : Table for storing Invoice – expenses
ODLN : Table for storing Delivery – header
ODRF : Table for storing Drafts – header
OINV : Table for storing Invoice – header
OPCH : Table for storing AP invoice – header
OPDN : Table for storing Goods receipt purchase order – header
OPOR : Table for storing Purchase order – header
OQUT : Table for storing Quotation – header
ORDN : Table for storing Returns – header
ORDR : Table for storing Order – header
ORIN : Table for storing AR credit memo – header
ORPC : Table for storing AP credit memo – header
ORPD : Table for storing Goods return – header
PCH1 : Table for storing AP invoice – rows
PCH2 : Table for storing AP invoice rows – expenses
PCH3 : Table for storing AP invoice – expenses
PDN1 : Table for storing Goods receipt purchase order – row
PDN2 : Table for storing Goods receipt purchase order rows – expenses
PDN3 : Table for storing Goods receipt purchase order – expenses
POR1 : Table for storing Purchase order – rows
POR2 : Table for storing Purchase order rows – expenses
POR3 : Table for storing Purchase order – expenses
QUT1 : Table for storing Quotation – rows
QUT2 : Table for storing Quotation rows – expenses
QUT3 : Table for storing Quotation – expenses
RDN1 : Table for storing Returns – rows
RDN2 : Table for storing Return rows – expenses
RDN3 : Table for storing Returns – expenses
RDR1 : Table for storing Order – rows
RDR2 : Table for storing Order rows – expenses
RDR3 : Table for storing Order – expenses
RIN1 : Table for storing Credit memo – rows
RIN2 : Table for storing Credit memo rows -Expenses
RIN3 : Table for storing Credit memo – expenses
RPC1 : Table for storing AP credit memo – rows
RPC2 : Table for storing AP credit memo rows – expenses
RPC3 : Table for storing AP credit memo – expenses
RPD1 : Table for storing Goods return – rows
RPD2 : Table for storing Goods return rows – expenses
RPD3 : Table for storing Goods return – expenses
OIBT : Table for storing Batch number for item
OOND : Table for storing Industries list for sales opportunities
OORL : Table for storing Relationships for sales opportunities
OSRI : Table for storing Serial numbers for items
INV5 : Table for storing Withholding tax data
OTSI : Table for storing Master header data of a tax invoice of sales document
TSI1 : Table for storing Tax invoice of sales document – rows
OTPI : Table for storing Master header data of a tax invoice of purchase document
TPI1 : Table for storing Tax invoice of purchase document – rows
OTXD : Table for storing Master header data of a tax invoice of journal entry document
TXD1 : Table for storing Tax invoice of journal entry document – rows
OCLO : Table for storing Business partner activity locations
OCLA : Table for storing Statuses for Task type activities
OCLT : Table for storing Business partner activity types
OSCN : Table for storing Customer or vendor catalog number
OCRD : Table for storing Business partners
CRD1 : Table for storing Business partner addresses
CRD2 : Table for storing Business partner payment methods
CRD3 : Table for storing Business partner account receivable payable
CRD4 : Table for storing Business partner withholding tax
CRD5 : Table for storing Business partners payment dates
OCRB : Table for storing Business partners bank accounts
OCLG : Table for storing Contact customers and vendors
OCPR : Table for storing Contact persons
OOPR : Table for storing Sales opportunities
OPR1 : Table for storing Sales opportunity – rows
OPR2 : Table for storing Sales opportunity partners
OPR3 : Table for storing Sales opportunity competition
OPR4 : Table for storing Sales opportunity interests range
OPR5 : Table for storing Sales opportunity failure reasons
OTER : Table for storing Territory segmentations
IGE1 : Table for storing Goods issue – rows
IGE2 : Table for storing Goods issue rows – expenses
IGE3 : Table for storing Goods issue – expenses
IGN1 : Table for storing Goods receipt – rows
IGN2 : Table for storing Goods receipt rows – expenses
IGN3 : Table for storing Goods receipt – expenses
OIGE : Table for storing Goods issue
OIGN : Table for storing Goods receipt
OWTR : Table for storing Stock transfers
WTR1 : Table for storing Stock transfers – rows
ITT1 : Table for storing Product tree – child
OITT : Table for storing Product tree
OWKO : Table for storing Work instructions
WKO1 : Table for storing Work instructions – rows
ITM1 : Table for storing Items – prices
OITM : Table for storing Items
OITW : Table for storing Items – warehouse
OITB : Table for storing Item groups definition
OMRV : Table for storing Stock revaluation
MRV1 : Table for storing Stock revaluation – rows
OPKG : Table for storing Package types for deliveries
OPLN : Table for storing Price lists management
OITW : Table for storing Items – warehouse
OSPP : Table for storing Special prices
SPP1 : Table for storing Special prices for specified periods
SPP2 : Table for storing Special prices for specified quantities
OWHS : Table for storing Warehouses definition
OFCT : Table for storing Sales forecast
FCT1 : Table for storing Sales forecast – rows
ORCT : Table for storing Receipt
OVPM : Table for storing Vendor payment
RCT1 : Table for storing Receipt – checks
RCT2 : Table for storing Receipt – invoices
RCT3 : Table for storing Receipt – credit vouchers
RCT4 : Table for storing Receipt – account list
VPM1 : Table for storing Payments – check rows
VPM2 : Table for storing Payments – invoices
VPM3 : Table for storing Payments – credit memos
VPM4 : Table for storing Payments – list of accounts
CHO1 : Table for storing Checks for payment – rows
OBNK : Table for storing External bank statement
OCHO : Table for storing Check for payment
OCTG : Table for storing Payment term types
OPEX : Table for storing Payment results table
PEX1 : Table for storing Payment results table – rows
OBOE : Table for storing Bill of exchange table
OBOT : Table for storing Bill of exchange transactions table
BOT1 : Table for storing Bill of exchange transactions table – rows
OCTT : Table for storing Contract template (CRM)
OINS : Table for storing Customer equipment card
OSLT : Table for storing Knowledge base solution
OQUE : Table for storing Queues list for assigning to a service calls
QUE1 : Table for storing Queue member users
OCTR : Table for storing Service contract
CTR1 : Table for storing Service contract – rows
OSCL : Table for storing Service call
OCLG : Table for storing Service call activities
INV1 : Table for storing Service call inventory expenses
OHEM : Table for storing Employees information
HEM1 : Table for storing Employee absence information
HEM2 : Table for storing Employee education
HEM3 : Table for storing Employee reviews
HEM4 : Table for storing Employee previous employment information
HEM6 : Table for storing Employee rolls information
OHTM : Table for storing List of teams
HTM1 : Table for storing Employee membership role in a team

[category gist]

How useful was this post?

Click on a star to rate it!

Average rating 4 / 5. Vote count: 1

No votes so far! Be the first to rate this post.

As you found this post useful...

Share this post on social media!

We are sorry that this post was not useful for you!

Let us improve this post!

Tell us how we can improve this post?