Register Login

SAP Business One Tables

TABLE NAME DESCRIPTION
OCRG GroupCode Definition table
OITM Item table
ORDR Parent Order Record Table
RDR1 Child order record table
OCRD Customer record table
ITM1 Product Pricing
OWHS Warehouse code + name
OITW Stock levels of each product in each warehouse
OCTR Service Contracts Header
CTR1 Membership Item Detail
OCTT Contract Template
OINV invoice table
INV1 Invoice Line Table
OCRC Credit card type
Relationships
TABLE 1 TABLE 2 JOIN FIELD
ORDR RDR1 DocEntry
ORDR OCRD CardCode
RDR1 OITM ItemCode
OCRG OCRD GroupCode
OITM ITM1 ItemCode
OITM OITW ItemCode
OWHS OITW WhsCode
OCTR CTR1 ContractID
OINV INV1 DocEntry

Comments

  • 11 May 2010 12:46 pm Guest
    It is a very good and useful document.
    Sidhartha
  • 28 Nov 2010 12:35 pm Guest
    Simple and useful document
  • 16 Oct 2012 4:12 am Guest
    May I have the query to retrieve above information? I don't want to hard code it.
  • 03 Jun 2015 1:00 pm Sachin Gautam

    Its Very Helpful....thanks