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

69 columns | Print definition?ERP 6.0  | ATTR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/AIF/USERATTRUser specific attributes3ATTRUser Attributenvarchar10
2BBPC_CMS_ATTRContract Attribute Table2ATTRContract Attributenvarchar300
3BBPC_CMS_ATTRSTRStructure type for Attributes3ATTRContract Attributenvarchar300
4BBPC_CMS_ATTR_TText table associated with BBPC_CMS_ATTR2ATTRContract Attributenvarchar300
5GRFNBRAATTRAMF Business Rule Assignment: Object Attributes2ATTRAttribute Namenvarchar200
6GRFNBRAATTRTAMF Business Rule Assignment: Object Attributes - Text Table3ATTRAttribute Namenvarchar200
7GRFNBRAATTRVALAMF Business Rule Assignment: Object Attributes Values2ATTRAttribute Namenvarchar200
8GRFNBRAATTRVALTAMF Business Rule Assignment: Object Attributes Values -Text3ATTRAttribute Namenvarchar200
9GRFNDMOBJATTRDataMart: Object attributes (multivalue, CDF)6ATTRReport: Field IDnvarchar300
10GRFNDMOBJREGATTRDataMart: Object attributes (multivalue, CDF)5ATTRReport: Field IDnvarchar300
11GRFNDMRELATTRDataMart: Relational Attributes6ATTRReport: Field IDnvarchar300
12GRFNPLCADDATTRPolicy Additional attribute2ATTRCustomizing itemnvarchar200
13SLLS_STATS_ATTRVRaw Data From Worklist for Translation Stats (Attributes)3ATTRObject Attributenvarchar300
TOPArchiveLink
14TOAFSMAPTable for TOAFSMAP_S2ATTRAttribute of a Document or a Relationshipnvarchar250
TOPCanada
15PCERVAttributes for Posting Runs6ATTRAttribute of an evaluation run for NAnvarchar100
TOPData Transfer
16PEVATAttributes for Posting Runs4ATTRAttribute of a posting runnvarchar100
17T52E3Attributes of HR Evaluation Types2ATTRAttribute of a posting runnvarchar100
18T52E3TTexts on Attributes of HR Evaluation Types3ATTRAttribute of a posting runnvarchar100
TOPDirectory
19LDAPMAP3Mapping SAP Fields to LDAP Attributes - Attributes5ATTRAttribute Namenvarchar630
20LDAPPROP3Proposals for Mapping SAP Fields to LDAP Attributes5ATTRAttribute Namenvarchar630
TOPDocument Builder
21/IPRO/TATTRSTRStructure Type for Attributes Used in Duet3ATTRVariablenvarchar200
TOPInternationalization I18N
22TCPSATTRCode Page Segment Attributes4ATTRCharacter attributenvarchar720
23TCPUCATTRCharacter Attributes4ATTRCharacter Attributenvarchar1280
TOPManagement of Internal Controls
24FOPCATTRMIC: Object Attributes2ATTRAttributenvarchar200
25FOPCATTRSUBVALMIC: Object Attributes2ATTRAttributenvarchar200
26FOPCATTRSUBVALTMIC: Object Attributes - Text Table3ATTRAttributenvarchar200
27FOPCATTRTMIC: Object Attributes - Text Table3ATTRAttributenvarchar200
28FOPCATTRVALUEMIC: Object Attributes2ATTRAttributenvarchar200
29FOPCATTRVALUESMIC: Object Attributes2ATTRAttributenvarchar200
30FOPCATTRVALUESTMIC: Object Attributes - Text Table3ATTRAttributenvarchar200
31FOPCATTRVALUESVMIC: Object Attributes2ATTRAttributenvarchar200
32FOPCATTRVALUETMIC: Object Attributes - Text Table3ATTRAttributenvarchar200
33FOPCATTRVALUET2MIC: Object Attributes - Text Table3ATTRAttributenvarchar200
34FOPCTIMEFRAMETimeframe2ATTRAttributenvarchar200
35FOPCTIMEFRAMETTimeframe3ATTRAttributenvarchar200
TOPProcess Controls
36GRPCATTRPC: Object Attributes2ATTRAttributenvarchar200
37GRPCATTRSUBVALPC: Object Attributes2ATTRAttributenvarchar200
38GRPCATTRSUBVALTPC: Object Attributes - Text Table3ATTRAttributenvarchar200
39GRPCATTRTPC: Object Attributes - Text Table3ATTRAttributenvarchar200
40GRPCATTRVALUEPC: Object Attributes2ATTRAttributenvarchar200
41GRPCATTRVALUESPC: Object Attributes2ATTRAttributenvarchar200
42GRPCATTRVALUESTPC: Object Attributes - Text Table3ATTRAttributenvarchar200
43GRPCATTRVALUESVPC: Object Attributes2ATTRAttributenvarchar200
44GRPCATTRVALUETPC: Object Attributes - Text Table3ATTRAttributenvarchar200
45GRPCATTRVALUET2PC: Object Attributes - Text Table3ATTRAttributenvarchar200
46GRPCBPATTRBusiness Process Specific Attributes (e.g. CAPA attr.)3ATTRAttributenvarchar200
47GRPCBPATTRTBusiness Process Specific Attributes - Text Table4ATTRAttributenvarchar200
48GRPCBPATTRVALUEBusiness Process Specific Attribute Value (e.g. CAPA attr.)3ATTRAttributenvarchar200
49GRPCBPATTRVALUETText Table of GRPCBPATTRVALUE4ATTRAttributenvarchar200
50GRPCCOCATEPRIContorl Objective Category Migration Priority2ATTRAttributenvarchar200
51GRPCCOCATEPRITContorl Objective Category Migration Priority Text Table3ATTRAttributenvarchar200
52GRPCTIMEFRAMETimeframe2ATTRAttributenvarchar200
53GRPCTIMEFRAMETTimeframe3ATTRAttributenvarchar200
TOPRelationships Between Objects with GUID Identification
54COMC_IL_STRUCStructures and Table Types of Relationship Types2ATTRName of Structure with Relship-Type-Dependent Attributesnvarchar300
TOPSAP Records Management
55SRMUSERQUERYStored Search Query v. Users According to Element Type8ATTRAttribute of a document or a relationshipnvarchar250
TOPTechnical Objects
56EAML_D_EVT_ATVALEAML: Event Attribute Value3ATTRNetwork Attribute Propertynvarchar180
57EAML_EVT_ATT_RELEAML: Attribute - Event Object Type Assignment4ATTRNetwork Attribute Propertynvarchar180
58EAML_EVT_A_VALEAML Event Attribute Allowed Values3ATTRNetwork Attribute Propertynvarchar180
59EAML_EVT_A_VAL_TEAML Event Attribute Allowed Values Description3ATTRNetwork Attribute Propertynvarchar180
60EAML_EVT_O_ATTEAML Event Object Attribute3ATTRNetwork Attribute Propertynvarchar180
61EAML_EVT_O_ATT_TEAML: Event Object Attribute Text3ATTRNetwork Attribute Propertynvarchar180
TOPTraders and Schedulers Workbench
62TOI0_CP_GRATRAssign Compatibility group with compatibility attributes3ATTRCompatibility check Attributesnvarchar50
TOPTranslation Tools
63LXE_ATTR_DEFDefinition of Additional Object Attributes1ATTRObject Attributenvarchar300
64LXE_ATTR_PROPProperties of Additional Object Attributes1ATTRObject Attributenvarchar300
65LXE_COLOB_ATTRObject List: Additional Object Attributes5ATTRObject Attributenvarchar300
TOPTransport Organizer
66WBOATTRCTS: Request Attributes1ATTRRequest attributenvarchar300
67WBOATTRCCTS: Client-Specific Settings for Attributes2ATTRRequest attributenvarchar300
68WBOATTRTCTS: Attribute Texts2ATTRRequest attributenvarchar300
TOPWithout Description
69RSTT_ERRAttributes for Defects Found with BI ATR13ATTRTrace Tool: BLOB Field for Saving XML Stringimage21474836470