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

44 columns | Print definition?ERP 6.0  | COMPID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/TDAG/GFWWIM_CDTGenifix: Binary data of a component2COMPIDGenifix: ID of the componetint100
2/TDAG/GFWWIM_CMPGenifix: Meta information of a component2COMPIDGenifix: ID for the table componentint100
3/XFT/MIG_TDOCPOSDocument head4COMPIDCompidnvarchar1320
4/XFT/MIG_TEMCCONLocation EMC Centera Documents4COMPIDCompidnvarchar1320
5RSDDSTATSLICESelektionskriterien6COMPIDName (ID) of a reporting componentnvarchar300
6RSDDSTATSLICEEXExtracted values9COMPIDName (ID) of a reporting componentnvarchar300
7RSRT_BOOKMARKBookmark for RSRT BICS13COMPIDName (ID) of a reporting componentnvarchar300
8RSSFMSSREPMSS-relevant reports3COMPIDName (ID) of a reporting componentnvarchar300
9RSZTECHNAMEUnique Technical Name for Query Component in SAP Content1COMPIDName (ID) of a reporting componentnvarchar300
TOPArchiveLink
10TOAXCFor Displaying Objects for Special Treatment1COMPID128 Lowercase and Uppercase Lettersnvarchar1280
TOPCAD Integration
11CDESK_BBOXCDESK: Table for Saving Bounding Boxes9COMPIDCDESK: Unique ID of Componentnvarchar400
TOPClinical System
12N1CMETHSTAIS-H*MED: Methods of Module - Status Change Assignment4COMPIDCORD/PREG: Component IDnvarchar320
13N1SCRMIS-H*MED: Status-Dependent Screen Modification6COMPIDCORD/PREG: Component IDnvarchar320
TOPContract Accounts Receivable and Payable
14DFKKDISPCCRM Dispute Case Number2COMPIDNumber of Dispute Case in CRMnvarchar100
TOPData Staging
15RSTRANCLUSTTable Cluster: Save Data Flow Comparisons2COMPIDBW Generation tool: GUID in compressed form (CHAR25)nvarchar250
16RSTRANCLUSTINFOInformation for a data flow comparison1COMPIDBW Generation tool: GUID in compressed form (CHAR25)nvarchar250
TOPEnd User Technology
17RRX_USRMENUUser-defined menu entries2COMPIDName (ID) of a reporting componentnvarchar300
18RRX_USRMENUTTexts for user-defined menu entries2COMPIDName (ID) of a reporting componentnvarchar300
19RSZCOMPDIRDirectory of reporting components3COMPIDName (ID) of a reporting componentnvarchar300
20RSZGLOBVGlobal Variables in Reporting19COMPIDName (ID) of a reporting componentnvarchar300
21RSZWVIEWHeader Table for BW Views5COMPIDName (ID) of a reporting componentnvarchar300
TOPEnvironment, Health and Safety
22/TDAG/CPC_COMPCP: Module or Component in CfP2COMPIDModule or Componentnvarchar20
23/TDAG/CPC_COMPDCP: Description of module or component in CfP3COMPIDModule or Componentnvarchar20
24/TDAG/CPC_TBPAGCP: Tab page2COMPIDModule or Componentnvarchar20
25/TDAG/CPC_TBPAGDCP: Description of tab page3COMPIDModule or Componentnvarchar20
26/TDAG/CPC_TBSTRCP: Tabstrip2COMPIDModule or Componentnvarchar20
27/TDAG/CPC_TBSTRDCP: Description of Tabstrip3COMPIDModule or Componentnvarchar20
28/TDAG/CPC_TMTPCXCP: Task management - customization context for tab pages2COMPIDModule or Componentnvarchar20
TOPMetadata Repository
29RSO_CNT_STATE_ATLOGO Framework Status of Active Content Objects7COMPIDName (ID) of a reporting componentnvarchar300
30RSO_CNT_STATE_DTLOGO Framework Status of Delivered Objects3COMPIDName (ID) of a reporting componentnvarchar300
TOPOLAP Technology
31RSRREPDIRDirectory of all reports6COMPIDName (ID) of a reporting componentnvarchar300
32RSUNIURLCOMPURL->IObj8COMPIDName (ID) of a reporting componentnvarchar300
TOPPatient Management
33N1COMPIS-H: Clinical Order - Module Master Data2COMPIDCORD/PREG: Component IDnvarchar320
34N1COMPAIS-H: Order Item to Module Information Assignment3COMPIDCORD/PREG: Component IDnvarchar320
35N1COMPCONIS-H: Component Configuration Data4COMPIDCORD/PREG: Component IDnvarchar320
36N1COMPDEFAIS-H: Module Definition - Object Type Connection2COMPIDCORD/PREG: Component IDnvarchar320
37N1COMPTIS-H: Component Texts2COMPIDCORD/PREG: Component IDnvarchar320
TOPPayroll General Parts
38T51AV_WComparison Rules for Calculating Averages6COMPIDComparison operators for calculation of averagesnvarchar10
TOPSolution Directory
39SDTSCOMPDTS: Components Referenced by Downtime Schedule2COMPIDDTS: Landscape Component IDvarbinary160
40SDTSCOMPSDTS: Components Referenced by Downtime Schedule1COMPIDDTS: Landscape Component IDvarbinary160
41SDTSCONNDTS: Connectivity for Distributing Downtime Information2COMPIDDTS: Landscape Component IDvarbinary160
42SDTSHDDTS: Downtime Schedule Header9COMPIDDTS: Landscape Component IDvarbinary160
TOPWithout Description
43RSRBPRINTPROPGlobal print settings for printing3COMPIDName (ID) of a reporting componentnvarchar300
44RSRPRVARGROUPVariant groups for batch printing3COMPIDName (ID) of a reporting componentnvarchar300