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

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
6/ISDFPS/CHVW_E34External Batch Where-Used List
7FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9BSEG345Accounting Document Segment
10FMARCPAR4Parallelization of FMARC_BATCH

B1 9.2: Top 10 requests

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

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OINM101Whse Journal
10OSRN20Serial Numbers Master Data

61 columns | Print definition?ERP 6.0  | CITCAT

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1DFKKBIXC8160CIT Class Configuration Version (Table TFK8160)1CITCATConsumption Item Classnvarchar40
2DFKKBIXC8160TCIT Class Configuration Version (Table TFK8160T)2CITCATConsumption Item Classnvarchar40
3DFKKBIXC8161CCIT Class Configuration Version (Table TFK8161C)1CITCATConsumption Item Classnvarchar40
4DFKKBIXC8162CIT Class Configuration Version (Table TFK8162)1CITCATConsumption Item Classnvarchar40
5DFKKBIXC8163CIT Class Configuration Version (Table TFK8163)1CITCATConsumption Item Classnvarchar40
6DFKKBIXC8163TCIT Class Configuration Version (Table TFK8163T)2CITCATConsumption Item Classnvarchar40
7DFKKBIXC8164CIT Class Configuration Version (Table TFK8164)1CITCATConsumption Item Classnvarchar40
8DFKKBIXC8164FCIT Class Configuration Version (Table TFK8164F)1CITCATConsumption Item Classnvarchar40
9DFKKBIXC8164TCIT Class Configuration Version (Table TFK8164T)2CITCATConsumption Item Classnvarchar40
10DFKKBIXCIT4_DELHHistory Table for Deletion of Billed Items2CITCATConsumption Item Classnvarchar40
11DFKKBIXCIT4_LOGLog of Data Storage for Consumption Items3CITCATConsumption Item Classnvarchar40
12DFKKBIXCITX_DELHHistory Table for Deletion of Excepted Items2CITCATConsumption Item Classnvarchar40
13DFKKBIXCIT_CHChange Sequence of Changed Consumption Items2CITCATConsumption Item Classnvarchar40
14DFKKBIXCIT_GENGeneration Info for Consumption Item Class1CITCATConsumption Item Classnvarchar40
15DFKKBIXCIT_GENHGeneration Info for Consumption Item Class (History)1CITCATConsumption Item Classnvarchar40
16DFKKBIXCIT_GENOBGenerated Objects for Consumption Item Class1CITCATConsumption Item Classnvarchar40
17DFKKBIXCIT_HISTHistory Table for Billable Item Exceptions2CITCATConsumption Item Classnvarchar40
18DFKKBIXCIT_LOGLog of Data Storage for Consumption Items3CITCATConsumption Item Classnvarchar40
19DFKKBIXE8160Working Version CIT Class Configuration (Table TFK8160)1CITCATConsumption Item Classnvarchar40
20DFKKBIXE8160TWorking Version CIT Class Configuration (Table TFK8160T)2CITCATConsumption Item Classnvarchar40
21DFKKBIXE8161CWorking Version Configuration CIT Class (Table TFK8161C)1CITCATConsumption Item Classnvarchar40
22DFKKBIXE8162Working Version CIT Class Configuration (Table TFK8162)1CITCATConsumption Item Classnvarchar40
23DFKKBIXE8163Working Version CIT Class Configuration (Table TFK8163)1CITCATConsumption Item Classnvarchar40
24DFKKBIXE8163TWorking Version CIT Class Configuration (Table TFK8163T)2CITCATConsumption Item Classnvarchar40
25DFKKBIXE8164Working Version CIT Class Configuration (Table TFK8164)1CITCATConsumption Item Classnvarchar40
26DFKKBIXE8164FWorking Version CIT Class Configuration (Table TFK8164F)1CITCATConsumption Item Classnvarchar40
27DFKKBIXE8164TWorking Version CIT Class Configuration (Table TFK8164T)2CITCATConsumption Item Classnvarchar40
28DFKKBIXG8160CIT Class Generation Version (Table TFK8160)1CITCATConsumption Item Classnvarchar40
29DFKKBIXG8160TCIT Class Generation Version (Table TFK8160T)2CITCATConsumption Item Classnvarchar40
30DFKKBIXG8161CCIT Class Generation Version (Table TFK8161C)1CITCATConsumption Item Classnvarchar40
31DFKKBIXG8162CIT Class Generation Version (Table TFK8162)1CITCATConsumption Item Classnvarchar40
32DFKKBIXG8163CIT Class Generation Version (Table TFK8163)1CITCATConsumption Item Classnvarchar40
33DFKKBIXG8163TCIT Class Generation Version (Table TFK8163T)2CITCATConsumption Item Classnvarchar40
34DFKKBIXG8164CIT Class Generation Version (Table TFK8164)1CITCATConsumption Item Classnvarchar40
35DFKKBIXG8164FCIT Class Generation Version (Table TFK8164F)1CITCATConsumption Item Classnvarchar40
36DFKKBIXG8164TCIT Class Generation Version (Table TFK8164T)2CITCATConsumption Item Classnvarchar40
37DFKKINVBILL_LOGLog of Billing Runs12CITCATConsumption Item Classnvarchar40
38DFKK_VT_CYCREQPeriodic Rating Request9CITCATConsumption Item Classnvarchar40
39TFK8160Consumption Item Classes1CITCATConsumption Item Classnvarchar40
40TFK8160ARCArchiving: Residence Time for Consumption Items2CITCATConsumption Item Classnvarchar40
41TFK8160CActive Classes of Client2CITCATConsumption Item Classnvarchar40
42TFK8160EClasses for Consumption Items (Client-Dependent)2CITCATConsumption Item Classnvarchar40
43TFK8160EVClasses for Consumption Items: Program Enhancements2CITCATConsumption Item Classnvarchar40
44TFK8160TClasses for Consumption Items (Texts)2CITCATConsumption Item Classnvarchar40
45TFK8161CActive Interface Components for Consumption Item Class1CITCATConsumption Item Classnvarchar40
46TFK8162Fields of a Consumption Item Class1CITCATConsumption Item Classnvarchar40
47TFK8162EField Attributes of a Consumption Item Class2CITCATConsumption Item Classnvarchar40
48TFK8163Management of CIT4 Tables1CITCATConsumption Item Classnvarchar40
49TFK8163TManagement of CIT4 Tables (Texts)2CITCATConsumption Item Classnvarchar40
50TFK8164Indexes of Tables for Consumption Items1CITCATConsumption Item Classnvarchar40
51TFK8164FFields of Indexes of Tables for Consumption Items1CITCATConsumption Item Classnvarchar40
52TFK8164TIndexes of Tables for Consumption Items (Texts)2CITCATConsumption Item Classnvarchar40
53TFK8176CRating: Assignment of Classes for Cons.Item/AggregationVar.3CITCATConsumption Item Classnvarchar40
54TFK8176RRating: Aggregation Rules of an Aggregation Variant3CITCATConsumption Item Classnvarchar40
55TFK8187RRating Request: Request Types3CITCATConsumption Item Classnvarchar40
56TFKPS2Consumption Item Class for Partner Settlement4CITCATConsumption Item Classnvarchar40
57TFK_CC_8162CAssignment of Consumption Item Class1CITCATConsumption Item Classnvarchar40
58TFK_CC_8162CFField Assignment from CI and CC for Each Cons. Item Class1CITCATConsumption Item Classnvarchar40
TOPBilling in Contract Accounts Receivable and Payable
59DFKKBIXBIT4_LOGLog of Data Store of Billed Items14CITCATConsumption Item Classnvarchar40
60DFKKBIXBIT_LOGLog of Data Storage of Billable Items12CITCATConsumption Item Classnvarchar40
TOPInvoicing in Contract Accounts Receivable and Payable
61DFKKINVBILL_SSource Items in Billing Document8CITCATConsumption Item Classnvarchar40