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

80 columns | Print definition?ERP 6.0  | REMUNERATION

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPIncentive and Commission Management ICM
1CACS00_B_VAR_LINVariants for Alternative Commission20REMUNERATIONRemuneration Typenvarchar40
2CACS00_DOCRECommission Document, Remuneration and Liability38REMUNERATIONRemuneration Typenvarchar40
3CACS00_DOCSECommission Document, Settlement14REMUNERATIONRemuneration Typenvarchar40
4CACS00_LINVariant Commissions16REMUNERATIONRemuneration Typenvarchar40
5CACS00_SUMRETotals Table for Remuneration3REMUNERATIONRemuneration Typenvarchar40
6CACS00_SUMSETotals Table for Settlement3REMUNERATIONRemuneration Typenvarchar40
7CACS25_SESHDSettlement Schedule Header9REMUNERATIONRemuneration Typenvarchar40
8CACS_CHRETYAccountable Remuneration Types8REMUNERATIONRemuneration Typenvarchar40
9CACS_COMB_NOTICombination of Noti rule with Remu type and Ret rule4REMUNERATIONRemuneration Typenvarchar40
10CACS_DOCREExpected Commission (Remuneration)10REMUNERATIONRemuneration Typenvarchar40
11CACS_EMCLJOCalculation Information for Clerk4REMUNERATIONRemuneration Typenvarchar40
12CACS_NOT_COMBCombination of Noti rule with Remu type and Ret rule4REMUNERATIONRemuneration Typenvarchar40
13CACS_REMAJOFlat-Rate Remuneration: Calculation Log9REMUNERATIONRemuneration Typenvarchar40
14CACS_REMARUFlat-Rate Remuneration Rule10REMUNERATIONRemuneration Typenvarchar40
15CACS_REMSTMRemuneration settlement8REMUNERATIONRemuneration Typenvarchar40
16CACS_SESJOSettlement Schedule Run Log4REMUNERATIONRemuneration Typenvarchar40
17CACS_SETT_LCKIndividual Contract for Settlement Locks for FT Approval7REMUNERATIONRemuneration Typenvarchar40
18CACS_STCRERURule Characteristics for Flat-Rate Agreements in Std Ctrct8REMUNERATIONRemuneration Typenvarchar40
19CACS_STCWARRURule Characteristics for Guarantee Agreement in Std.Contract8REMUNERATIONRemuneration Typenvarchar40
20CACS_STRERUStandard Ruling for Flat-Rate Remunerations7REMUNERATIONRemuneration Typenvarchar40
21CACS_STWARRURule Characteristics for Guarantee Agreement7REMUNERATIONRemuneration Typenvarchar40
22CACS_S_NOT_COCombination of Noti rule with Remu type and Ret rule4REMUNERATIONRemuneration Typenvarchar40
23CACS_WARJOGuarantee Calculation Log9REMUNERATIONRemuneration Typenvarchar40
24CACS_WARRUIndividual Guarantee Agreement10REMUNERATIONRemuneration Typenvarchar40
25TCACS_ELTDOCREVAutomatic Deactivation of ELT Document6REMUNERATIONRemuneration Typenvarchar40
26TCACS_ELTNEGENTTransfer Negative Entitlements in ELT6REMUNERATIONRemuneration Typenvarchar40
27TCACS_ELTPOSTNEGTransfer Reversal Posting in ELT6REMUNERATIONRemuneration Typenvarchar40
28TCACS_ELTREMELT: Attributes of Remuneration Type3REMUNERATIONRemuneration Typenvarchar40
29TCACS_FILTER11Filter: Remuneration Types8REMUNERATIONRemuneration Typenvarchar40
30TCACS_NOTREMAssignment: Notification Rule - Remuneration Type4REMUNERATIONRemuneration Typenvarchar40
31TCACS_NOTREM_TAssignment: Notification Rule - Remun.Type Text Table5REMUNERATIONRemuneration Typenvarchar40
32TCACS_PORTREMPortal / Hide Remuneration Types3REMUNERATIONRemuneration Typenvarchar40
33TCACS_REMCommission Remuneration Types3REMUNERATIONRemuneration Typenvarchar40
34TCACS_REM_TCommissions: Remuneration Types4REMUNERATIONRemuneration Typenvarchar40
35TCACS_RETREMAssignment of Remun.Type to Retention Rule Characteristics3REMUNERATIONRemuneration Typenvarchar40
36TCACS_SETT_LCKConfiguration Table for Settlement Locks for FT Approval7REMUNERATIONRemuneration Typenvarchar40
37YCRM01_B_VAR_LINVariants for Alternative Commission20REMUNERATIONRemuneration Typenvarchar40
38YCRM01_DOCRECommission Document, Remuneration and Liability65REMUNERATIONRemuneration Typenvarchar40
39YCRM01_DOCSECommission Document: Due Dates14REMUNERATIONRemuneration Typenvarchar40
40YCRM01_LINVariant Commissions16REMUNERATIONRemuneration Typenvarchar40
41YCRM01_SESHDSettlement Schedule Header9REMUNERATIONRemuneration Typenvarchar40
42YCRM01_SUMRERemuneration Totals for Contract Account Display3REMUNERATIONRemuneration Typenvarchar40
43YCRM01_SUMRE02Commissions: Reference Totals Table for Compensation3REMUNERATIONRemuneration Typenvarchar40
44YCRM01_SUMRE92Commissions: Total Commission Basis6REMUNERATIONRemuneration Typenvarchar40
45YCRM01_SUMSEDue Date Totals for Contract Account Display3REMUNERATIONRemuneration Typenvarchar40
46YHITEC_B_VAR_LINVariants for Alternative Commission20REMUNERATIONRemuneration Typenvarchar40
47YHITEC_DOCRECommission Document, Remuneration and Liability48REMUNERATIONRemuneration Typenvarchar40
48YHITEC_DOCSECommission Document: Due Dates14REMUNERATIONRemuneration Typenvarchar40
49YHITEC_LINVariant Commissions16REMUNERATIONRemuneration Typenvarchar40
50YHITEC_SUMRERemuneration Totals for Contract Account Display3REMUNERATIONRemuneration Typenvarchar40
51YHITEC_SUMSEDue Date Totals for Contract Account Display3REMUNERATIONRemuneration Typenvarchar40
52YSVMA_B_VAR_LINVariants for Alternative Commission20REMUNERATIONRemuneration Typenvarchar40
53YSVMA_DOCRECommission Document, Remuneration and Liability42REMUNERATIONRemuneration Typenvarchar40
54YSVMA_DOCSECommission Document: Due Dates14REMUNERATIONRemuneration Typenvarchar40
55YSVMA_LINVariant Commissions16REMUNERATIONRemuneration Typenvarchar40
56YSVMA_SESHDSettlement Schedule Header9REMUNERATIONRemuneration Typenvarchar40
57YSVMA_SUMRERemuneration Totals for Contract Account Display3REMUNERATIONRemuneration Typenvarchar40
58YSVMA_SUMRE01Commissions: Reference Totals Table for Compensation3REMUNERATIONRemuneration Typenvarchar40
59YSVMA_SUMSEDue Date Totals for Contract Account Display3REMUNERATIONRemuneration Typenvarchar40
60YTEL01_B_VAR_LINVariants for Alternative Commission20REMUNERATIONRemuneration Typenvarchar40
61YTEL01_DOCRECommission Document, Remuneration and Liability62REMUNERATIONRemuneration Typenvarchar40
62YTEL01_DOCSECommission Document: Due Dates31REMUNERATIONRemuneration Typenvarchar40
63YTEL01_LINVariant Commissions16REMUNERATIONRemuneration Typenvarchar40
64YTEL01_SUMRERemuneration Totals for Contract Account Display3REMUNERATIONRemuneration Typenvarchar40
65YTEL01_SUMRE04Commissions: Totals Table for Compensation (Scale Base)2REMUNERATIONRemuneration Typenvarchar40
66YTEL01_SUMSEDue Date Totals for Contract Account Display3REMUNERATIONRemuneration Typenvarchar40
67YTEL01_SUMSE02Reference Table for Settlement3REMUNERATIONRemuneration Typenvarchar40
68YTEL05_B_VAR_LINVariants for Alternative Commission20REMUNERATIONRemuneration Typenvarchar40
69YTEL05_DOCRECommission Document, Remuneration and Liability56REMUNERATIONRemuneration Typenvarchar40
70YTEL05_DOCSECommission Document: Due Dates20REMUNERATIONRemuneration Typenvarchar40
71YTEL05_LINVariant Commissions16REMUNERATIONRemuneration Typenvarchar40
72YTEL05_SESHDSettlement Schedule Header9REMUNERATIONRemuneration Typenvarchar40
73YTEL05_SUMRERemuneration Totals for Contract Account Display3REMUNERATIONRemuneration Typenvarchar40
74YTEL05_SUMSEDue Date Totals for Contract Account Display3REMUNERATIONRemuneration Typenvarchar40
75ZICMAG_B_VAR_LINVariants for Alternative Commission20REMUNERATIONRemuneration Typenvarchar40
76ZICMAG_DOCRECommission Document, Remuneration and Liability40REMUNERATIONRemuneration Typenvarchar40
77ZICMAG_DOCSECommission Document: Due Dates14REMUNERATIONRemuneration Typenvarchar40
78ZICMAG_LINVariant Commissions16REMUNERATIONRemuneration Typenvarchar40
79ZICMAG_SUMRERemuneration Totals for Contract Account Display3REMUNERATIONRemuneration Typenvarchar40
80ZICMAG_SUMSEDue Date Totals for Contract Account Display3REMUNERATIONRemuneration Typenvarchar40