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

118 columns | Print definition?ERP 6.0  | CTRTBU_ID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPConditions
1A904Appl./AgreemntNo/Divis./Contr. no./RemBusTrCt/Version/Status7CTRTBU_IDCommission Contract Numbernvarchar200
2A905Appl./AgreemntNo/Contr. no./RemBusTrCt/Version/Status6CTRTBU_IDCommission Contract Numbernvarchar200
TOPIncentive and Commission Management ICM
3CACS00_B_VAR_INVVariants for Commission Case Participants15CTRTBU_IDCommission Contract Numbernvarchar200
4CACS00_B_VAR_LINVariants for Alternative Commission18CTRTBU_IDCommission Contract Numbernvarchar200
5CACS00_DOCINVParticipant in Commission Document9CTRTBU_IDCommission Contract Numbernvarchar200
6CACS00_DOCRECommission Document, Remuneration and Liability11CTRTBU_IDCommission Contract Numbernvarchar200
7CACS00_DOCSECommission Document, Settlement8CTRTBU_IDCommission Contract Numbernvarchar200
8CACS00_INVCommission Case Participants11CTRTBU_IDCommission Contract Numbernvarchar200
9CACS00_LINVariant Commissions14CTRTBU_IDCommission Contract Numbernvarchar200
10CACS00_SUMRETotals Table for Remuneration2CTRTBU_IDCommission Contract Numbernvarchar200
11CACS00_SUMSETotals Table for Settlement2CTRTBU_IDCommission Contract Numbernvarchar200
12CACS25_SESHDSettlement Schedule Header16CTRTBU_IDCommission Contract Numbernvarchar200
13CACS25_SESITSettlement Schedule Item11CTRTBU_IDCommission Contract Numbernvarchar200
14CACSCS_DFKKCOHAggregation Container7CTRTBU_IDCommission Contract Numbernvarchar200
15CACS_BUCAGRCommission: Agreement Bundle3CTRTBU_IDCommission Contract Numbernvarchar200
16CACS_CTBU_WAWork Regions for Commission Contract3CTRTBU_IDCommission Contract Numbernvarchar200
17CACS_CTCOREXCorrespondence Enhancement3CTRTBU_IDCommission Contract Numbernvarchar200
18CACS_CTRTBUCommission Contract3CTRTBU_IDCommission Contract Numbernvarchar200
19CACS_CTRTCORRICM: Assignment of Correspondence Types to Contract3CTRTBU_IDCommission Contract Numbernvarchar200
20CACS_DET_VARIANTCharacteristics of Determination Variant21CTRTBU_IDCommission Contract Numbernvarchar200
21CACS_DOCREExpected Commission (Remuneration)9CTRTBU_IDCommission Contract Numbernvarchar200
22CACS_EMCLJOCalculation Information for Clerk3CTRTBU_IDCommission Contract Numbernvarchar200
23CACS_EMSTMJOSettlement Information for Clerk3CTRTBU_IDCommission Contract Numbernvarchar200
24CACS_PRAGRIndiv. Payment Release Agreement for Commission Contract3CTRTBU_IDCommission Contract Numbernvarchar200
25CACS_PS_GRPAssignment of Group Contract to Partnership4CTRTBU_IDCommission Contract Numbernvarchar200
26CACS_REMAJOFlat-Rate Remuneration: Calculation Log3CTRTBU_IDCommission Contract Numbernvarchar200
27CACS_REMARUFlat-Rate Remuneration Rule3CTRTBU_IDCommission Contract Numbernvarchar200
28CACS_RESRULEReserves Rule3CTRTBU_IDCommission Contract Numbernvarchar200
29CACS_RETAGRIndividual Retention Agreement in Commission Contract3CTRTBU_IDCommission Contract Numbernvarchar200
30CACS_RET_ATIMERetention: Last access time-spot in process3CTRTBU_IDCommission Contract Numbernvarchar200
31CACS_RI_ITRun Administration Items6CTRTBU_IDCommission Contract Numbernvarchar200
32CACS_RI_IT_PRDRun Administration Detail with Period6CTRTBU_IDCommission Contract Numbernvarchar200
33CACS_SEGAGRAgreement for The Assignment of Segments8CTRTBU_IDCommission Contract Numbernvarchar200
34CACS_SESAGR(Individual) Settlement Schedule Agreement in CommnContract3CTRTBU_IDCommission Contract Numbernvarchar200
35CACS_SESJOSettlement Schedule Run Log3CTRTBU_IDCommission Contract Numbernvarchar200
36CACS_SETTL_LOCKLocked Business Partners for Contracts3CTRTBU_IDCommission Contract Numbernvarchar200
37CACS_SETT_LCKIndividual Contract for Settlement Locks for FT Approval3CTRTBU_IDCommission Contract Numbernvarchar200
38CACS_STL_CLSNext Open Period3CTRTBU_IDCommission Contract Numbernvarchar200
39CACS_STMAGRIndividual Settlement Agreement (Obsolete)3CTRTBU_IDCommission Contract Numbernvarchar200
40CACS_STMRUIndividual Settlement Rule3CTRTBU_IDCommission Contract Numbernvarchar200
41CACS_STMTJOSettlement run log3CTRTBU_IDCommission Contract Numbernvarchar200
42CACS_TGACVTarget Agreements: Indiv. Actual/Correction/Target Values3CTRTBU_IDCommission Contract Numbernvarchar200
43CACS_TGAGRTarget Agreements: Individual Rules for Target Agreements3CTRTBU_IDCommission Contract Numbernvarchar200
44CACS_TGLOGObsolete (Target Agreements: Log)3CTRTBU_IDCommission Contract Numbernvarchar200
45CACS_TGRINDTarget Agreements: Individual Target Rules4CTRTBU_IDCommission Contract Numbernvarchar200
46CACS_TGRIND_AESTarget Agreements: Individual Target Rules for AES4CTRTBU_IDCommission Contract Numbernvarchar200
47CACS_TRICAJOCommission Case Trigger: Log3CTRTBU_IDCommission Contract Numbernvarchar200
48CACS_TRIGCASRule for Cause of Additional Commission Case3CTRTBU_IDCommission Contract Numbernvarchar200
49CACS_WARAGRIndividual Guarantee Agreement (Obsolete)3CTRTBU_IDCommission Contract Numbernvarchar200
50CACS_WARJOGuarantee Calculation Log3CTRTBU_IDCommission Contract Numbernvarchar200
51CACS_WARRUIndividual Guarantee Agreement3CTRTBU_IDCommission Contract Numbernvarchar200
52TCACS_PCINVParticipation Construction: Participants Template7CTRTBU_IDCommission Contract Numbernvarchar200
53YCRM01_B_VAR_INVVariants for Commission Case Participants15CTRTBU_IDCommission Contract Numbernvarchar200
54YCRM01_B_VAR_LINVariants for Alternative Commission18CTRTBU_IDCommission Contract Numbernvarchar200
55YCRM01_DOCINVParticipant in Commission Document9CTRTBU_IDCommission Contract Numbernvarchar200
56YCRM01_DOCRECommission Document, Remuneration and Liability38CTRTBU_IDCommission Contract Numbernvarchar200
57YCRM01_DOCSECommission Document: Due Dates8CTRTBU_IDCommission Contract Numbernvarchar200
58YCRM01_INVCommission Case Participants11CTRTBU_IDCommission Contract Numbernvarchar200
59YCRM01_LINVariant Commissions14CTRTBU_IDCommission Contract Numbernvarchar200
60YCRM01_SESHDSettlement Schedule Header16CTRTBU_IDCommission Contract Numbernvarchar200
61YCRM01_SESITSettlement Schedule Item11CTRTBU_IDCommission Contract Numbernvarchar200
62YCRM01_SUMRERemuneration Totals for Contract Account Display2CTRTBU_IDCommission Contract Numbernvarchar200
63YCRM01_SUMRE02Commissions: Reference Totals Table for Compensation2CTRTBU_IDCommission Contract Numbernvarchar200
64YCRM01_SUMRE92Commissions: Total Commission Basis7CTRTBU_IDCommission Contract Numbernvarchar200
65YCRM01_SUMSEDue Date Totals for Contract Account Display2CTRTBU_IDCommission Contract Numbernvarchar200
66YHITEC_B_VAR_INVVariants for Commission Case Participants15CTRTBU_IDCommission Contract Numbernvarchar200
67YHITEC_B_VAR_LINVariants for Alternative Commission18CTRTBU_IDCommission Contract Numbernvarchar200
68YHITEC_DOCINVParticipant in Commission Document9CTRTBU_IDCommission Contract Numbernvarchar200
69YHITEC_DOCRECommission Document, Remuneration and Liability21CTRTBU_IDCommission Contract Numbernvarchar200
70YHITEC_DOCSECommission Document: Due Dates8CTRTBU_IDCommission Contract Numbernvarchar200
71YHITEC_INVCommission Case Participants11CTRTBU_IDCommission Contract Numbernvarchar200
72YHITEC_LINVariant Commissions14CTRTBU_IDCommission Contract Numbernvarchar200
73YHITEC_SUMRERemuneration Totals for Contract Account Display2CTRTBU_IDCommission Contract Numbernvarchar200
74YHITEC_SUMSEDue Date Totals for Contract Account Display2CTRTBU_IDCommission Contract Numbernvarchar200
75YSVMA_B_VAR_INVVariants for Commission Case Participants15CTRTBU_IDCommission Contract Numbernvarchar200
76YSVMA_B_VAR_LINVariants for Alternative Commission18CTRTBU_IDCommission Contract Numbernvarchar200
77YSVMA_DOCINVParticipant in Commission Document9CTRTBU_IDCommission Contract Numbernvarchar200
78YSVMA_DOCRECommission Document, Remuneration and Liability15CTRTBU_IDCommission Contract Numbernvarchar200
79YSVMA_DOCSECommission Document: Due Dates8CTRTBU_IDCommission Contract Numbernvarchar200
80YSVMA_INVCommission Case Participants11CTRTBU_IDCommission Contract Numbernvarchar200
81YSVMA_LINVariant Commissions14CTRTBU_IDCommission Contract Numbernvarchar200
82YSVMA_SESHDSettlement Schedule Header16CTRTBU_IDCommission Contract Numbernvarchar200
83YSVMA_SESITSettlement Schedule Item11CTRTBU_IDCommission Contract Numbernvarchar200
84YSVMA_SUMRERemuneration Totals for Contract Account Display2CTRTBU_IDCommission Contract Numbernvarchar200
85YSVMA_SUMRE01Commissions: Reference Totals Table for Compensation2CTRTBU_IDCommission Contract Numbernvarchar200
86YSVMA_SUMSEDue Date Totals for Contract Account Display2CTRTBU_IDCommission Contract Numbernvarchar200
87YTEL01_B_VAR_INVVariants for Commission Case Participants15CTRTBU_IDCommission Contract Numbernvarchar200
88YTEL01_B_VAR_LINVariants for Alternative Commission18CTRTBU_IDCommission Contract Numbernvarchar200
89YTEL01_DOCINVParticipant in Commission Document9CTRTBU_IDCommission Contract Numbernvarchar200
90YTEL01_DOCRECommission Document, Remuneration and Liability35CTRTBU_IDCommission Contract Numbernvarchar200
91YTEL01_DOCSECommission Document: Due Dates25CTRTBU_IDCommission Contract Numbernvarchar200
92YTEL01_INVCommission Case Participants11CTRTBU_IDCommission Contract Numbernvarchar200
93YTEL01_LINVariant Commissions14CTRTBU_IDCommission Contract Numbernvarchar200
94YTEL01_SUMRERemuneration Totals for Contract Account Display2CTRTBU_IDCommission Contract Numbernvarchar200
95YTEL01_SUMSEDue Date Totals for Contract Account Display2CTRTBU_IDCommission Contract Numbernvarchar200
96YTEL01_SUMSE02Reference Table for Settlement2CTRTBU_IDCommission Contract Numbernvarchar200
97YTEL01_SUMVA02Reference Totals Table for Valuation (TELUS)6CTRTBU_IDCommission Contract Numbernvarchar200
98YTEL05_B_VAR_INVVariants for Commission Case Participants17CTRTBU_IDCommission Contract Numbernvarchar200
99YTEL05_B_VAR_LINVariants for Alternative Commission18CTRTBU_IDCommission Contract Numbernvarchar200
100YTEL05_DOCINVParticipant in Commission Document11CTRTBU_IDCommission Contract Numbernvarchar200
101YTEL05_DOCRECommission Document, Remuneration and Liability29CTRTBU_IDCommission Contract Numbernvarchar200
102YTEL05_DOCSECommission Document: Due Dates14CTRTBU_IDCommission Contract Numbernvarchar200
103YTEL05_INVCommission Case Participants13CTRTBU_IDCommission Contract Numbernvarchar200
104YTEL05_LINVariant Commissions14CTRTBU_IDCommission Contract Numbernvarchar200
105YTEL05_SESHDSettlement Schedule Header16CTRTBU_IDCommission Contract Numbernvarchar200
106YTEL05_SESITSettlement Schedule Item11CTRTBU_IDCommission Contract Numbernvarchar200
107YTEL05_SUMRERemuneration Totals for Contract Account Display2CTRTBU_IDCommission Contract Numbernvarchar200
108YTEL05_SUMSEDue Date Totals for Contract Account Display2CTRTBU_IDCommission Contract Numbernvarchar200
109ZICMAG_B_VAR_INVVariants for Commission Case Participants15CTRTBU_IDCommission Contract Numbernvarchar200
110ZICMAG_B_VAR_LINVariants for Alternative Commission18CTRTBU_IDCommission Contract Numbernvarchar200
111ZICMAG_DOCINVParticipant in Commission Document9CTRTBU_IDCommission Contract Numbernvarchar200
112ZICMAG_DOCRECommission Document, Remuneration and Liability13CTRTBU_IDCommission Contract Numbernvarchar200
113ZICMAG_DOCSECommission Document: Due Dates8CTRTBU_IDCommission Contract Numbernvarchar200
114ZICMAG_INVCommission Case Participants11CTRTBU_IDCommission Contract Numbernvarchar200
115ZICMAG_LINVariant Commissions14CTRTBU_IDCommission Contract Numbernvarchar200
116ZICMAG_SUMRERemuneration Totals for Contract Account Display2CTRTBU_IDCommission Contract Numbernvarchar200
117ZICMAG_SUMSEDue Date Totals for Contract Account Display2CTRTBU_IDCommission Contract Numbernvarchar200
118ZZBG_T_REGIONYSVMA Region for Targets3CTRTBU_IDCommission Contract Numbernvarchar200