Online Tutorials & Training Materials | STechies.com
Register Login
Advertisement

SAP Business One Tables

|| 4

SAP Business One Tables
Stechies

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

    Its Very Helpful....thanks


Advertisement
Advertisement
Advertisement