SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

www.saptables.net

Schema:
 Module:  Table: 
Column: 
Searchbeta 

icon of database logic symbol SAP  TABLESv1Made in Britain

JDETables.com - the webs number one JD Edwards Table Definition reference

ERP 6.0: Top 10 requests

TableColumnsDescription
1BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
2/ISDFPS/CHVW_E34External Batch Where-Used List
3FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
4FMARCPAR4Parallelization of FMARC_BATCH
5CEKRS5Movement type parameters for automatic ERS
6AUDLORIPR7KPro: Logical Information Object Attribute Values
7/OPT/Z1344Reporting table: Text table for exception definitions
8FCO_DOC_HEAD61Failure Cost Document Header
9FMIA65Actual Line Item Table for Funds Management
10PEG_TMTNS2Pegging: Movement Types Explicitly Not Supported

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7JDT1124Journal Entry - Rows
8OPOR386Purchase Order
9OACT114G/L Accounts
10OPCH386A/P Invoice

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2OINV268A/R Invoice
3OVPM154Outgoing Payments
4OIVL77Whse Journal
5ORCT154Incoming Payment
6OPCH268A/P Invoice
7OOCR9Loading Factors
8OSRN20Serial Numbers Master Data
9JDT1110Journal Entry - Rows
10OBOT10Bill Of Exchang Transaction
PHPRef.com - the webs number one PHP Function reference tool

77 columns | Print definition?B1 9.3  | LOCKED

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPAdministration
1ACFPCFOP for Nota Fiscal5LockedLockedVarChar10NN=No, Y=Yes
2ACRCCredit Cards6LockedLockedVarChar10NN=No, Y=Yes
3ASTTSales Tax Authorities Type8LockedLockedVarChar10N
4ATSCCST Code for Nota Fiscal4LockedLockedVarChar10N
5AUSRUsers - History33LockedUser ConfirmationVarChar10NN=No, Y=Yes
6NFN1Not a Fiscal Sequence11LockedLockedVarChar10N
7NNM1Documents Numbering - Series11LockedLockedVarChar10NN=No, Y=Yes
8OCFPCFOP for Nota Fiscal5LockedLockedVarChar10NN=No, Y=Yes
9OCRCCredit Cards6LockedLockedVarChar10NN=No, Y=Yes
10OCRNCurrency Codes8LockedLockedVarChar10NN=No, Y=Yes
11OCRPPayment Methods9LockedLockedVarChar10NN=No, Y=Yes
12ODCRChecking Rule16LockedLockedVarChar10NN=No, Y=Yes
13OIDXCPI Codes3LockedLockedVarChar10NN=Changeable, Y=Locked
14OLNGUser Language Table5LockedLockedVarChar10NN=No, Y=Yes
15ONFTNota Fiscal Tax Category (Brazil)3LockedLockedVarChar10N
16OSTTSales Tax Authorities Type8LockedLockedVarChar10N
17OTNCTransaction Category3LockedLockedVarChar10N
18OTNN1099 Forms4LockedLockedVarChar10NN=Changeable, Y=Locked
19OTPATax Parameter Attributes6LockedLockedVarChar10NN=Changeable, Y=Yes
20OTPRTax Return Values6LockedLockedVarChar10NN=Changeable, Y=Yes
21OTSCCST Code for Nota Fiscal4LockedLockedVarChar10N
22OUSGUsage of Nota Fiscal3LockedLockedVarChar10NN=No, Y=Yes
23OUSRUsers33LockedUser LockedVarChar10NN=No, Y=Yes
24TNN11099 Boxes5LockedLockedVarChar10NN=Changeable, Y=Locked
TOPBanking
25ODSCBank Codes6LockedLockedVarChar10NN=Changeable, Y=Locked
TOPBusiness Partners
26OCLAActivity Status4LockedLockedVarChar10NN=No, Y=Yes
27OCLOMeetings Location5LockedLockedVarChar10NN=No, Y=Yes
28OCOGCommission Groups5LockedLockedVarChar10NN=No, Y=Yes
29OCRGCard Groups4LockedLockedVarChar10NN=No, Y=Yes
30OEGPE-Mail Group3LockedLockedVarChar10NN=No, Y=Yes
31OSLPSales Employee6LockedLockedVarChar10NN=No, Y=Yes
32OVTPVendor Type4LockedLockedVarChar10N
TOPFinance
33AMDRManual Distribution Rule5LockedLockedVarChar10NN=No, Y=Yes
34APRJProject Codes3LockedLockedVarChar10NN=No, Y=Yes
35AVTGTax Definition7LockedLockedVarChar10NN=No, Y=Yes
36OACGAccount Category4LockedLockedVarChar10NN=No, Y=Yes
37OACRAccrual Type6LockedLockedVarChar10NN=No, Y=Yes
38OBGSBudget Scenario5LockedLockedVarChar10NN=No, Y=Yes
39OFAAAsset Attributes9LockedLockedVarChar10NN=No, Y=Yes
40OJETJE Document Type2LockedLockedVarChar10NN=No, Y=Yes
41OMDRManual Distribution Rule5LockedLockedVarChar10NN=No, Y=Yes
42OPRJProject Codes3LockedLockedVarChar10NN=No, Y=Yes
43OTRCJournal Entry Codes3LockedLockedVarChar10NN=No, Y=Yes
44OVTGTax Definition7LockedLockedVarChar10NN=No, Y=Yes
TOPGeneral
45ARSBResource Groups - History3LockedLockedVarChar10NN=Changeable, Y=Locked
46ARSC1Resources - Warehouses - Log3LockedLockedVarChar10NN=No, Y=Yes
47OFNSFolio Numbering - Series11LockedLockedVarChar10NN=No, Y=Yes
48ORSBResource Groups3LockedLockedVarChar10NN=Changeable, Y=Locked
49RSC1Resources - Warehouses3LockedLockedVarChar10NN=No, Y=Yes
TOPHuman Resources
50OHEDEducation Types4LockedLockedVarChar10NN=No, Y=Yes
51OHTYEmployee Types4lockedLockedVarChar10NN=No, Y=Yes
52OIDTEmployee ID Type2LockedLockedVarChar10NN=No, Y=Yes
TOPInventory and Production
53AITBItem Groups - History3LockedLockedVarChar10NN=Changeable, Y=Locked
54AITWItems - Warehouse - History14LockedLockedVarChar10NN=No, Y=Yes
55AUGPUoM Group11LockedLockedVarChar10NN=No, Y=Yes
56AUOMUoM Master Data4LockedLockedVarChar10NN=No, Y=Yes
57AWHSWarehouses - History8LockedLockedVarChar10NN=Changeable, Y=Locked
58IPF1Landed Costs - Rows38LockedLockedVarChar10NN=No, Y=Yes
59IPF2Landed Costs - Costs9LockedLockedVarChar10NN=No, Y=Yes
60OARGCustoms Groups8LockedLockedVarChar10NN=Changeable, Y=Locked
61OITBItem Groups3LockedLockedVarChar10NN=Changeable, Y=Locked
62OITWItems - Warehouse14LockedLockedVarChar10NN=No, Y=Yes
63OLGTLength Units6LockedLockedVarChar10NN=Changeable, Y=Locked
64ORCNRetail Chains5LockedLockedVarChar10NN=No, Y=Yes
65OUGPUoM Group11LockedLockedVarChar10NN=No, Y=Yes
66OUOMUoM Master Data4LockedLockedVarChar10NN=No, Y=Yes
67OWGTWeight Units5LockedLockedVarChar10NN=No, Y=Yes
68OWHSWarehouses8LockedLockedVarChar10NN=Changeable, Y=Locked
69SITWItems - Warehouse14LockedLockedVarChar10NN=No, Y=Yes
70UITWItems - Warehouse14LockedLockedVarChar10NN=No, Y=Yes
TOPSales Opportunities
71AOCRDistribution Rule5LockedLockedVarChar10NN=No, Y=Yes
72APRCCost Center5LockedLockedVarChar10NN=No, Y=Yes
73OOCRDistribution Rule5LockedLockedVarChar10NN=No, Y=Yes
74OPRCCost Center5LockedLockedVarChar10NN=No, Y=Yes
TOPService
75OAGPAgent Name4LockedLockedVarChar10
76OSCOService Call Origins4LockedLockedVarChar10
77OSCSService Call Statuses4LockedLockedVarChar10