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

40 columns | Print definition?ERP 6.0  | ROLETYPE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPBasic Functions
1TPACHECKASSIGNChecking Module Assignments in SD Partner Processing2ROLETYPEFunction types in SD partner processingnvarchar40
TOPEnergy Data Management
2EPROFASSROLERoles for Profile Allocation4ROLETYPERole category for profile allocationnvarchar20
TOPEnvironment, Health and Safety
3/TDAG/RCSC_SROLEStakeholder Role2ROLETYPEType of Rolenvarchar20
4/TDAG/RCSC_SROLTText Table for Stakeholder Role2ROLETYPEType of Rolenvarchar20
TOPGeneral Object Relations
5MDOBLROModel Data: Permitted Object Roles1ROLETYPERole That an Object Takes in the Relationshipnvarchar100
6MDOBLROLModel Data: Role Types1ROLETYPERole That an Object Takes in the Relationshipnvarchar100
7MTOBLROLModel Data: Texts for Role Types1ROLETYPERole That an Object Takes in the Relationshipnvarchar100
8OROBJROLESObject relationship : valid role types of an object type2ROLETYPERole in Which the Object Occursnvarchar100
9ORROLETYPObject Relationship Service object role types1ROLETYPERole in Which the Object Occursnvarchar100
10ORTROLETYPObject relationship: role types text1ROLETYPERole in Which the Object Occursnvarchar100
11SROBLROLBPersistent Roles of BOR Objects5ROLETYPERole That an Object Takes in the Relationshipnvarchar100
12SROBLROLCPersistent Roles of Business Classes5ROLETYPERole That an Object Takes in the Relationshipnvarchar100
13SRRELROLESObject Relationship Service: Roles5ROLETYPERole in Which the Object Occursnvarchar100
TOPIncentive and Commission Management ICM
14CACS00_B_VAR_RELVariants for Participant Relations10ROLETYPEEntitlement Categorynvarchar10
15CACS00_DOCRELCommission Document: Relationships Between Participants5ROLETYPEEntitlement Categorynvarchar10
16CACS00_RELParticipant Relations in a Commission Participation6ROLETYPEEntitlement Categorynvarchar10
17CACS_CTRTPARIndividual Contract Participation6ROLETYPEEntitlement Categorynvarchar10
18TCACS_BUSCLAIMValid Entitlement Categories for Each Bus. Obj. Type/ Trans.5ROLETYPEEntitlement Categorynvarchar10
19TCACS_INVRELParticipant Determination for Commission Calculation3ROLETYPEEntitlement Category (Target)nvarchar10
20TCACS_PCINVParticipation Construction: Participants Template13ROLETYPEEntitlement Categorynvarchar10
21TCACS_ROLEPossible Roles of Commission Contract Partner in Comn Case5ROLETYPEEntitlement Categorynvarchar10
22YCRM01_B_VAR_RELVariants for Participant Relations10ROLETYPEEntitlement Categorynvarchar10
23YCRM01_DOCRELCommission Document: Relationships Between Participants5ROLETYPEEntitlement Categorynvarchar10
24YCRM01_RELParticipant Relations in a Commission Participation6ROLETYPEEntitlement Categorynvarchar10
25YHITEC_B_VAR_RELVariants for Participant Relations10ROLETYPEEntitlement Categorynvarchar10
26YHITEC_DOCRELCommission Document: Relationships Between Participants5ROLETYPEEntitlement Categorynvarchar10
27YHITEC_RELParticipant Relations in a Commission Participation6ROLETYPEEntitlement Categorynvarchar10
28YSVMA_B_VAR_RELVariants for Participant Relations10ROLETYPEEntitlement Categorynvarchar10
29YSVMA_DOCRELCommission Document: Relationships Between Participants5ROLETYPEEntitlement Categorynvarchar10
30YSVMA_RELParticipant Relations in a Commission Participation6ROLETYPEEntitlement Categorynvarchar10
31YTEL01_B_VAR_RELVariants for Participant Relations10ROLETYPEEntitlement Categorynvarchar10
32YTEL01_DOCRELCommission Document: Relationships Between Participants5ROLETYPEEntitlement Categorynvarchar10
33YTEL01_RELParticipant Relations in a Commission Participation6ROLETYPEEntitlement Categorynvarchar10
34YTEL05_B_VAR_RELVariants for Participant Relations10ROLETYPEEntitlement Categorynvarchar10
35YTEL05_DOCRELCommission Document: Relationships Between Participants5ROLETYPEEntitlement Categorynvarchar10
36YTEL05_RELParticipant Relations in a Commission Participation6ROLETYPEEntitlement Categorynvarchar10
37ZICMAG_B_VAR_RELVariants for Participant Relations10ROLETYPEEntitlement Categorynvarchar10
38ZICMAG_DOCRELCommission Document: Relationships Between Participants5ROLETYPEEntitlement Categorynvarchar10
39ZICMAG_RELParticipant Relations in a Commission Participation6ROLETYPEEntitlement Categorynvarchar10
TOPTransaction Management
40VTB_RULESET_PAFTR Rule Management: Business Partner Rules5ROLETYPEBP Role Categorynvarchar60