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

153 columns | Print definition?ERP 6.0  | CASE_ID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1DOST_CASE_HEADERDBOSC-ST: Test Case Header1CASE_IDDBOSC-CR: Generated ID (4)nvarchar40
2DOST_CASE_WORDDBOSC-ST: Test Case Key Words2CASE_IDDBOSC-CR: Generated ID (4)nvarchar40
TOPArchiving Connector ABAP
3LHM_LH_PGATE_ALLegal Hold Cases for ArchiveLink Attachments7CASE_IDTechnical Case Key (Case GUID)nvarchar320
4LHM_LH_PGATE_DLLegal Hold Cases for Print Lists7CASE_IDTechnical Case Key (Case GUID)nvarchar320
5LHM_PGATE_AL_RWLegal Hold Cases for ArchiveLink Attachments in RW7CASE_IDTechnical Case Key (Case GUID)nvarchar320
TOPIncentive and Commission Management ICM
6CACS00_ACTCommission Case Activities3CASE_IDID of Commission Casenvarchar100
7CACS00_BDLRebundling Order for Triggering Subobjects3CASE_IDID of Commission Casenvarchar100
8CACS00_B_VAR_ACTVariants for Commission Case Activities7CASE_IDID of Commission Casenvarchar100
9CACS00_B_VAR_BDLVariants for Bundling7CASE_IDID of Commission Casenvarchar100
10CACS00_B_VAR_CASVariants for Commission Case7CASE_IDID of Commission Casenvarchar100
11CACS00_B_VAR_INVVariants for Commission Case Participants7CASE_IDID of Commission Casenvarchar100
12CACS00_B_VAR_LINVariants for Alternative Commission7CASE_IDID of Commission Casenvarchar100
13CACS00_B_VAR_OBJVariants for Commission Case Object Data7CASE_IDID of Commission Casenvarchar100
14CACS00_B_VAR_PARVariants for Commission Case Participant7CASE_IDID of Commission Casenvarchar100
15CACS00_B_VAR_RELVariants for Participant Relations7CASE_IDID of Commission Casenvarchar100
16CACS00_CASCommission Case3CASE_IDID of Commission Casenvarchar100
17CACS00_INVCommission Case Participants3CASE_IDID of Commission Casenvarchar100
18CACS00_LINVariant Commissions3CASE_IDID of Commission Casenvarchar100
19CACS00_OBJCommission Case Object Data3CASE_IDID of Commission Casenvarchar100
20CACS00_OBJHISTChange History of Subobjects That Trigger Commission9CASE_IDID of Commission Casenvarchar100
21CACS00_PARCommission Case Participation3CASE_IDID of Commission Casenvarchar100
22CACS00_RELParticipant Relations in a Commission Participation3CASE_IDID of Commission Casenvarchar100
23CACSCP_RCP_BUFFRCP: Buffer Table for RCP Processing4CASE_IDID of Commission Casenvarchar100
24CACSCP_RCP_CASERCP: Initial Commission Cases3CASE_IDID of Commission Casenvarchar100
25CACSCP_RCP_WLRCP: Worklist5CASE_IDID of Commission Casenvarchar100
26CACS_COILOGRecording of the Keys of Records Processed with COI5CASE_IDID of Commission Casenvarchar100
27CACS_TGLOGObsolete (Target Agreements: Log)10CASE_IDID of Commission Casenvarchar100
28CACS_WFCASCommission Case: Workflow Characteristics for Pending Cases4CASE_IDID of Commission Casenvarchar100
29TCACS_CATT01Directory of Commission Cases to be Tested Automatically5CASE_IDID of Commission Casenvarchar100
30TCACS_CATT01TDirectory of Commission Cases to be Tested Automatically6CASE_IDID of Commission Casenvarchar100
31YCRM01_ACTCommission Case Activities3CASE_IDID of Commission Casenvarchar100
32YCRM01_BDLRebundling Order for Triggering Subobjects3CASE_IDID of Commission Casenvarchar100
33YCRM01_B_VAR_ACTVariants for Commission Case Activities8CASE_IDID of Commission Casenvarchar100
34YCRM01_B_VAR_BDLVariants for Bundling7CASE_IDID of Commission Casenvarchar100
35YCRM01_B_VAR_CASVariants for Commission Case15CASE_IDID of Commission Casenvarchar100
36YCRM01_B_VAR_INVVariants for Commission Case Participants7CASE_IDID of Commission Casenvarchar100
37YCRM01_B_VAR_LINVariants for Alternative Commission7CASE_IDID of Commission Casenvarchar100
38YCRM01_B_VAR_OBJVariants for Commission Case Object Data54CASE_IDID of Commission Casenvarchar100
39YCRM01_B_VAR_PARVariants for Commission Case Participant7CASE_IDID of Commission Casenvarchar100
40YCRM01_B_VAR_RELVariants for Participant Relations7CASE_IDID of Commission Casenvarchar100
41YCRM01_CASCommission Case3CASE_IDID of Commission Casenvarchar100
42YCRM01_INVCommission Case Participants3CASE_IDID of Commission Casenvarchar100
43YCRM01_LINVariant Commissions3CASE_IDID of Commission Casenvarchar100
44YCRM01_OBJCommission Case Object Data3CASE_IDID of Commission Casenvarchar100
45YCRM01_OBJHISTChange History of Subobjects That Trigger Commission9CASE_IDID of Commission Casenvarchar100
46YCRM01_PARCommission Case Participation3CASE_IDID of Commission Casenvarchar100
47YCRM01_RELParticipant Relations in a Commission Participation3CASE_IDID of Commission Casenvarchar100
48YHITEC_ACTCommission Case Activities3CASE_IDID of Commission Casenvarchar100
49YHITEC_BDLRebundling Order for Triggering Subobjects3CASE_IDID of Commission Casenvarchar100
50YHITEC_B_VAR_ACTVariants for Commission Case Activities7CASE_IDID of Commission Casenvarchar100
51YHITEC_B_VAR_BDLVariants for Bundling7CASE_IDID of Commission Casenvarchar100
52YHITEC_B_VAR_CASVariants for Commission Case7CASE_IDID of Commission Casenvarchar100
53YHITEC_B_VAR_INVVariants for Commission Case Participants7CASE_IDID of Commission Casenvarchar100
54YHITEC_B_VAR_LINVariants for Alternative Commission7CASE_IDID of Commission Casenvarchar100
55YHITEC_B_VAR_OBJVariants for Commission Case Object Data18CASE_IDID of Commission Casenvarchar100
56YHITEC_B_VAR_PARVariants for Commission Case Participant7CASE_IDID of Commission Casenvarchar100
57YHITEC_B_VAR_RELVariants for Participant Relations7CASE_IDID of Commission Casenvarchar100
58YHITEC_CASCommission Case3CASE_IDID of Commission Casenvarchar100
59YHITEC_INVCommission Case Participants3CASE_IDID of Commission Casenvarchar100
60YHITEC_LINVariant Commissions3CASE_IDID of Commission Casenvarchar100
61YHITEC_OBJCommission Case Object Data3CASE_IDID of Commission Casenvarchar100
62YHITEC_OBJHISTChange History of Subobjects That Trigger Commission9CASE_IDID of Commission Casenvarchar100
63YHITEC_PARCommission Case Participation3CASE_IDID of Commission Casenvarchar100
64YHITEC_RELParticipant Relations in a Commission Participation3CASE_IDID of Commission Casenvarchar100
65YSVMA_ACTCommission Case Activities3CASE_IDID of Commission Casenvarchar100
66YSVMA_BDLRebundling Order for Triggering Subobjects3CASE_IDID of Commission Casenvarchar100
67YSVMA_B_VAR_ACTVariants for Commission Case Activities7CASE_IDID of Commission Casenvarchar100
68YSVMA_B_VAR_BDLVariants for Bundling7CASE_IDID of Commission Casenvarchar100
69YSVMA_B_VAR_CASVariants for Commission Case15CASE_IDID of Commission Casenvarchar100
70YSVMA_B_VAR_INVVariants for Commission Case Participants7CASE_IDID of Commission Casenvarchar100
71YSVMA_B_VAR_LINVariants for Alternative Commission7CASE_IDID of Commission Casenvarchar100
72YSVMA_B_VAR_OBJVariants for Commission Case Object Data22CASE_IDID of Commission Casenvarchar100
73YSVMA_B_VAR_PARVariants for Commission Case Participant7CASE_IDID of Commission Casenvarchar100
74YSVMA_B_VAR_RELVariants for Participant Relations7CASE_IDID of Commission Casenvarchar100
75YSVMA_CASCommission Case3CASE_IDID of Commission Casenvarchar100
76YSVMA_INVCommission Case Participants3CASE_IDID of Commission Casenvarchar100
77YSVMA_LINVariant Commissions3CASE_IDID of Commission Casenvarchar100
78YSVMA_OBJCommission Case Object Data3CASE_IDID of Commission Casenvarchar100
79YSVMA_OBJHISTChange History of Subobjects That Trigger Commission9CASE_IDID of Commission Casenvarchar100
80YSVMA_PARCommission Case Participation3CASE_IDID of Commission Casenvarchar100
81YSVMA_RCP_BUFFRCP: Buffer Table for RCP Processing4CASE_IDID of Commission Casenvarchar100
82YSVMA_RCP_CASERCP: Initial Commission Cases3CASE_IDID of Commission Casenvarchar100
83YSVMA_RCP_WLRCP: Worklist5CASE_IDID of Commission Casenvarchar100
84YSVMA_RELParticipant Relations in a Commission Participation3CASE_IDID of Commission Casenvarchar100
85YTEL01_ACTCommission Case Activities3CASE_IDID of Commission Casenvarchar100
86YTEL01_BDLRebundling Order for Triggering Subobjects3CASE_IDID of Commission Casenvarchar100
87YTEL01_B_VAR_ACTVariants for Commission Case Activities7CASE_IDID of Commission Casenvarchar100
88YTEL01_B_VAR_BDLVariants for Bundling7CASE_IDID of Commission Casenvarchar100
89YTEL01_B_VAR_CASVariants for Commission Case7CASE_IDID of Commission Casenvarchar100
90YTEL01_B_VAR_INVVariants for Commission Case Participants7CASE_IDID of Commission Casenvarchar100
91YTEL01_B_VAR_LINVariants for Alternative Commission7CASE_IDID of Commission Casenvarchar100
92YTEL01_B_VAR_OBJVariants for Commission Case Object Data42CASE_IDID of Commission Casenvarchar100
93YTEL01_B_VAR_PARVariants for Commission Case Participant7CASE_IDID of Commission Casenvarchar100
94YTEL01_B_VAR_RELVariants for Participant Relations7CASE_IDID of Commission Casenvarchar100
95YTEL01_CASCommission Case3CASE_IDID of Commission Casenvarchar100
96YTEL01_INVCommission Case Participants3CASE_IDID of Commission Casenvarchar100
97YTEL01_LINVariant Commissions3CASE_IDID of Commission Casenvarchar100
98YTEL01_OBJCommission Case Object Data3CASE_IDID of Commission Casenvarchar100
99YTEL01_OBJHISTChange History of Subobjects That Trigger Commission9CASE_IDID of Commission Casenvarchar100
100YTEL01_PARCommission Case Participation3CASE_IDID of Commission Casenvarchar100
101YTEL01_RELParticipant Relations in a Commission Participation3CASE_IDID of Commission Casenvarchar100
102YTEL05_ACTCommission Case Activities3CASE_IDID of Commission Casenvarchar100
103YTEL05_BDLRebundling Order for Triggering Subobjects3CASE_IDID of Commission Casenvarchar100
104YTEL05_B_VAR_ACTVariants for Commission Case Activities7CASE_IDID of Commission Casenvarchar100
105YTEL05_B_VAR_BDLVariants for Bundling7CASE_IDID of Commission Casenvarchar100
106YTEL05_B_VAR_CASVariants for Commission Case15CASE_IDID of Commission Casenvarchar100
107YTEL05_B_VAR_INVVariants for Commission Case Participants9CASE_IDID of Commission Casenvarchar100
108YTEL05_B_VAR_LINVariants for Alternative Commission7CASE_IDID of Commission Casenvarchar100
109YTEL05_B_VAR_OBJVariants for Commission Case Object Data40CASE_IDID of Commission Casenvarchar100
110YTEL05_B_VAR_PARVariants for Commission Case Participant7CASE_IDID of Commission Casenvarchar100
111YTEL05_B_VAR_RELVariants for Participant Relations7CASE_IDID of Commission Casenvarchar100
112YTEL05_CASCommission Case3CASE_IDID of Commission Casenvarchar100
113YTEL05_INVCommission Case Participants3CASE_IDID of Commission Casenvarchar100
114YTEL05_LINVariant Commissions3CASE_IDID of Commission Casenvarchar100
115YTEL05_OBJCommission Case Object Data3CASE_IDID of Commission Casenvarchar100
116YTEL05_OBJHISTChange History of Subobjects That Trigger Commission9CASE_IDID of Commission Casenvarchar100
117YTEL05_PARCommission Case Participation3CASE_IDID of Commission Casenvarchar100
118YTEL05_RCP_BUFFRCP: Buffer Table for RCP Processing4CASE_IDID of Commission Casenvarchar100
119YTEL05_RCP_CASERCP: Initial Commission Cases3CASE_IDID of Commission Casenvarchar100
120YTEL05_RCP_WLRCP: Worklist5CASE_IDID of Commission Casenvarchar100
121YTEL05_RELParticipant Relations in a Commission Participation3CASE_IDID of Commission Casenvarchar100
122ZICMAG_ACTCommission Case Activities3CASE_IDID of Commission Casenvarchar100
123ZICMAG_BDLRebundling Order for Triggering Subobjects3CASE_IDID of Commission Casenvarchar100
124ZICMAG_B_VAR_ACTVariants for Commission Case Activities7CASE_IDID of Commission Casenvarchar100
125ZICMAG_B_VAR_BDLVariants for Bundling7CASE_IDID of Commission Casenvarchar100
126ZICMAG_B_VAR_CASVariants for Commission Case7CASE_IDID of Commission Casenvarchar100
127ZICMAG_B_VAR_INVVariants for Commission Case Participants7CASE_IDID of Commission Casenvarchar100
128ZICMAG_B_VAR_LINVariants for Alternative Commission7CASE_IDID of Commission Casenvarchar100
129ZICMAG_B_VAR_OBJVariants for Commission Case Object Data10CASE_IDID of Commission Casenvarchar100
130ZICMAG_B_VAR_PARVariants for Commission Case Participant7CASE_IDID of Commission Casenvarchar100
131ZICMAG_B_VAR_RELVariants for Participant Relations7CASE_IDID of Commission Casenvarchar100
132ZICMAG_CASCommission Case3CASE_IDID of Commission Casenvarchar100
133ZICMAG_INVCommission Case Participants3CASE_IDID of Commission Casenvarchar100
134ZICMAG_LINVariant Commissions3CASE_IDID of Commission Casenvarchar100
135ZICMAG_OBJCommission Case Object Data3CASE_IDID of Commission Casenvarchar100
136ZICMAG_OBJHISTChange History of Subobjects That Trigger Commission9CASE_IDID of Commission Casenvarchar100
137ZICMAG_PARCommission Case Participation3CASE_IDID of Commission Casenvarchar100
138ZICMAG_RELParticipant Relations in a Commission Participation3CASE_IDID of Commission Casenvarchar100
TOPNon Profit Organizations
139T7UNPAD_CASESEVE: Decision Cases4CASE_IDCase IDnvarchar50
140T7UNPAD_RANGESEVE: Range for decision validation4CASE_IDCase IDnvarchar50
TOPPatient Management
141N1TC_BUFFERTable for Saving Treatment Contract Checks4CASE_IDIS-H: Case Numbernvarchar100
142N1TC_REQUESTTemporary Treatment Contracts Applied for5CASE_IDIS-H: Case Numbernvarchar100
TOPProcess Controls
143GRPCAIFAIF information2CASE_IDTechnical Case Key (Case GUID)nvarchar320
144GRPCCRASSControl Risk Assessment2CASE_IDCase IDnvarchar320
145GRPCCRASSFACTORFactor for the control risk assessment2CASE_IDCase IDnvarchar320
146GRPCJOBCASECase Data for Job6CASE_IDGRPC ID of the individual objectnvarchar500
147GRPCJOBLOGJob Log from Scheduler35CASE_IDGRPC ID of the individual objectnvarchar500
148GRPCRISKASSRisk Data2CASE_IDUUID in character formnvarchar320
149GRPCTESTRESULTResults for test steps2CASE_IDUUID in character formnvarchar320
150GRPCTLLOGtestlog action logs3CASE_IDCase IDnvarchar320
TOPResourcen Management
151RMSTC_XCL12RMS-TLS: Excel Output: Cases for Formats1CASE_IDCase in Which the Format Is Appliednvarchar200
152RMSTC_XCL13RMS-TLS: Excel Output: Formats3CASE_IDCase in Which the Format Is Appliednvarchar200
153RMSTC_XCL14RMS-TLS: Excel Output: Case Descriptions2CASE_IDCase in Which the Format Is Appliednvarchar200