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

34 columns | Print definition?ERP 6.0  | ATTRI

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1SFIAAttribute Table for SAPfind1ATTRIDocument class attributesnvarchar80
2SFIATAttribute Text Table2ATTRIDocument class attributesnvarchar80
3SFICDClass Description Table for SAPfind2ATTRIDocument class attributesnvarchar80
4TFIAAttribute Table for SAPfind1ATTRIDocument class attributesnvarchar80
5TFIATAttribute Text Table2ATTRIDocument class attributesnvarchar80
TOPActivity-Based Costing
6CBPRCO-ABC: Activity Master Table24ATTRIBusiness Process Attributes/CO Tasksnvarchar40
7CMDT_BPGeneric master record business process enhancements33ATTRIBusiness Process Attributes/CO Tasksnvarchar40
TOPConsolidation
8TF90QActive Attributes in Consolidation3ATTRIEC-EIS/EC-BP: Characteristic attributenvarchar300
9TF90QDConsolidation: Levels of Multilevel Attributes2ATTRIEC-EIS/EC-BP: Characteristic attributenvarchar300
10TF90QSAttributes Basis Field Catalog Consolidation (Fixed Fields)3ATTRIEC-EIS/EC-BP: Characteristic attributenvarchar300
11TF91QAttributes in Consolidation3ATTRIEC-EIS/EC-BP: Characteristic attributenvarchar300
TOPData Collection
12CF751MCBLUE74ATTRITotal attritiondecimal153
13TKAQGeneral accounting attributes4ATTRIEC-EIS/EC-BP: Characteristic attributenvarchar300
14TKCQAttributes SAP-EIS3ATTRIEC-EIS/EC-BP: Characteristic attributenvarchar300
15TKCQDSAP-EIS: levels of multilevel attributes2ATTRIEC-EIS/EC-BP: Characteristic attributenvarchar300
16TKCQSAttributes of basic field catalog SAP-EIS (fixed fields)3ATTRIEC-EIS/EC-BP: Characteristic attributenvarchar300
TOPGlobal Trade Services
17/SAPSLL/TCOATAGTS: Control of Gener. Attrib. Maint.: Assgmt of Attributes5ATTRIType of Product Attribute from Feeder Systemnvarchar100
18/SAPSLL/TCOATRGTS: Definition of Characteristics from Feeder System2ATTRIType of Product Attribute from Feeder Systemnvarchar100
19/SAPSLL/TCOATRTGTS: Definition of Characteristics from Feeder Syst. - Desc.3ATTRIType of Product Attribute from Feeder Systemnvarchar100
20/SAPSLL/TCOATT01GTS: Characteristics: Attribute Definition Lgth 01 - Descr.3ATTRIType of Product Attribute from Feeder Systemnvarchar100
21/SAPSLL/TCOATT02GTS: Characteristics: Attribute Definition Lgth 01 - Descr.3ATTRIType of Product Attribute from Feeder Systemnvarchar100
22/SAPSLL/TCOATT05GTS: Characteristics: Attribute Definition Lgth 05 - Descr.3ATTRIType of Product Attribute from Feeder Systemnvarchar100
23/SAPSLL/TCOATT10GTS: Characteristics: Attribute Definition Lgth 10 - Descr.3ATTRIType of Product Attribute from Feeder Systemnvarchar100
24/SAPSLL/TCOATT20GTS: Characteristics: Attribute Definition Lgth 20 - Descr.3ATTRIType of Product Attribute from Feeder Systemnvarchar100
25/SAPSLL/TCOATT40GTS: Characteristics: Attribute Definition Lgth 40 - Descr.3ATTRIType of Product Attribute from Feeder Systemnvarchar100
26/SAPSLL/TCOATV01GTS: Characteristics: Attribute Definition Length 012ATTRIType of Product Attribute from Feeder Systemnvarchar100
27/SAPSLL/TCOATV02GTS: Characteristics: Attribute Definition Length 022ATTRIType of Product Attribute from Feeder Systemnvarchar100
28/SAPSLL/TCOATV05GTS: Characteristics: Attribute Definition Length 052ATTRIType of Product Attribute from Feeder Systemnvarchar100
29/SAPSLL/TCOATV10GTS: Characteristics: Attribute Definition Length 102ATTRIType of Product Attribute from Feeder Systemnvarchar100
30/SAPSLL/TCOATV20GTS: Characteristics: Attribute Definition Length 202ATTRIType of Product Attribute from Feeder Systemnvarchar100
31/SAPSLL/TCOATV40GTS: Characteristics: Attribute Definition Length 402ATTRIType of Product Attribute from Feeder Systemnvarchar100
TOPSwitzerland
32T5CA0Employee Attributes5ATTRIHR-CH: EE Attributenvarchar20
33T5CA1Texts for EE Attributes6ATTRIHR-CH: EE Attributenvarchar20
TOPUnited Kingdom
34T5GMAP_XMLSchema info for parsing xml doc into abap structure9ATTRISingle-Character Indicatornvarchar10