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

140 columns | Print definition?ERP 6.0  | POST_YEAR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPIncentive and Commission Management ICM
1CACS00_DOCACTCommission Document: Activities2POST_YEARAssignment Year of Commission Case/Documentnvarchar40
2CACS00_DOCDTComn: Detail Items for Remuneration Rows2POST_YEARAssignment Year of Commission Case/Documentnvarchar40
3CACS00_DOCFI_HData Transfer: FI Documents (Header Data)2POST_YEARAssignment Year of Commission Case/Documentnvarchar40
4CACS00_DOCFI_PData Transfer: FI Documents (Items)2POST_YEARAssignment Year of Commission Case/Documentnvarchar40
5CACS00_DOCHDCommission Document Header2POST_YEARAssignment Year of Commission Case/Documentnvarchar40
6CACS00_DOCINVParticipant in Commission Document2POST_YEARAssignment Year of Commission Case/Documentnvarchar40
7CACS00_DOCOBJCommission Document: Object Data2POST_YEARAssignment Year of Commission Case/Documentnvarchar40
8CACS00_DOCPARParticipation of Commission Document2POST_YEARAssignment Year of Commission Case/Documentnvarchar40
9CACS00_DOCRECommission Document, Remuneration and Liability2POST_YEARAssignment Year of Commission Case/Documentnvarchar40
10CACS00_DOCRE01Do Not Use! Enhancement Data Remuneration Lines2POST_YEARAssignment Year of Commission Case/Documentnvarchar40
11CACS00_DOCRELCommission Document: Relationships Between Participants2POST_YEARAssignment Year of Commission Case/Documentnvarchar40
12CACS00_DOCSECommission Document, Settlement2POST_YEARAssignment Year of Commission Case/Documentnvarchar40
13CACS00_DOCSE01Do Not Use! Enhancement Data Settlement Rows2POST_YEARAssignment Year of Commission Case/Documentnvarchar40
14CACS00_DOCSEDTLine Item Detail Line2POST_YEARAssignment Year of Commission Case/Documentnvarchar40
15CACS00_DOCVACommission Document, Valuation2POST_YEARAssignment Year of Commission Case/Documentnvarchar40
16CACS00_DOCVA01Do Not Use! Enhancement Data Evaluation Rows2POST_YEARAssignment Year of Commission Case/Documentnvarchar40
17CACS00_SUMRETotals Table for Remuneration4POST_YEARAssignment Year of Commission Case/Documentnvarchar40
18CACS00_SUMVATotals Table for Valuation5POST_YEARAssignment Year of Commission Case/Documentnvarchar40
19CACS25_SESHDSettlement Schedule Header6POST_YEARAssignment Year of Commission Case/Documentnvarchar40
20CACS42_DOCSHACommission Document: Complex Distribution Ratios2POST_YEARAssignment Year of Commission Case/Documentnvarchar40
21CACSCP_RCP_BUFFRCP: Buffer Table for RCP Processing8POST_YEARAssignment Year of Commission Case/Documentnvarchar40
22CACS_CPD_REFData Reference for Same FS-ICM Reference Key3POST_YEARAssignment Year of Commission Case/Documentnvarchar40
23CACS_DOCFI_TData Transfer: FI Document (Tax Item)3POST_YEARAssignment Year of Commission Case/Documentnvarchar40
24CACS_DOC_REVHISTCommission Document: Reversal History3POST_YEARAssignment Year of Commission Case/Documentnvarchar40
25CACS_FPP_DBSMNTHObject for Parallel Processing ICM Month7POST_YEARYear of Commission Case/Commission Documentnvarchar40
26CACS_STL_REF_DSettlement Document Reference - Detail3POST_YEARAssignment Year of Commission Case/Documentnvarchar40
27YCRM01_DOCACTCommission Document: Activities2POST_YEARAssignment Year of Commission Case/Documentnvarchar40
28YCRM01_DOCDTComn: Detail Items for Remuneration Rows2POST_YEARAssignment Year of Commission Case/Documentnvarchar40
29YCRM01_DOCFI_HData Transfer: FI Documents Header Data2POST_YEARAssignment Year of Commission Case/Documentnvarchar40
30YCRM01_DOCFI_PData Transfer: FI Documents Item2POST_YEARAssignment Year of Commission Case/Documentnvarchar40
31YCRM01_DOCHDCommission Document Header2POST_YEARAssignment Year of Commission Case/Documentnvarchar40
32YCRM01_DOCINVParticipant in Commission Document2POST_YEARAssignment Year of Commission Case/Documentnvarchar40
33YCRM01_DOCOBJCommission Document: Object Data2POST_YEARAssignment Year of Commission Case/Documentnvarchar40
34YCRM01_DOCPARParticipation of Commission Document2POST_YEARAssignment Year of Commission Case/Documentnvarchar40
35YCRM01_DOCRECommission Document, Remuneration and Liability2POST_YEARAssignment Year of Commission Case/Documentnvarchar40
36YCRM01_DOCRE91Do Not Use! Enhancement Data Remuneration Lines2POST_YEARAssignment Year of Commission Case/Documentnvarchar40
37YCRM01_DOCRELCommission Document: Relationships Between Participants2POST_YEARAssignment Year of Commission Case/Documentnvarchar40
38YCRM01_DOCSECommission Document: Due Dates2POST_YEARAssignment Year of Commission Case/Documentnvarchar40
39YCRM01_DOCSE91Do Not Use! Enhancement Data Settlement Rows2POST_YEARAssignment Year of Commission Case/Documentnvarchar40
40YCRM01_DOCSEDTDue Date Details2POST_YEARAssignment Year of Commission Case/Documentnvarchar40
41YCRM01_DOCVACommission Document, Valuation2POST_YEARAssignment Year of Commission Case/Documentnvarchar40
42YCRM01_DOCVA91Do Not Use! Enhancement Data Evaluation Rows2POST_YEARAssignment Year of Commission Case/Documentnvarchar40
43YCRM01_SESHDSettlement Schedule Header6POST_YEARAssignment Year of Commission Case/Documentnvarchar40
44YCRM01_SUMRERemuneration Totals for Contract Account Display4POST_YEARAssignment Year of Commission Case/Documentnvarchar40
45YCRM01_SUMRE02Commissions: Reference Totals Table for Compensation4POST_YEARAssignment Year of Commission Case/Documentnvarchar40
46YCRM01_SUMRE92Commissions: Total Commission Basis5POST_YEARAssignment Year of Commission Case/Documentnvarchar40
47YCRM01_SUMVAValuation Totals for Contract Account Display5POST_YEARAssignment Year of Commission Case/Documentnvarchar40
48YCRM01_SUMVA91Commissions: Reference Totals Table for Valuation2POST_YEARAssignment Year of Commission Case/Documentnvarchar40
49YHITEC_DOCACTCommission Document: Activities2POST_YEARAssignment Year of Commission Case/Documentnvarchar40
50YHITEC_DOCDTComn: Detail Items for Remuneration Rows2POST_YEARAssignment Year of Commission Case/Documentnvarchar40
51YHITEC_DOCFI_HData Transfer: FI Documents Header Data2POST_YEARAssignment Year of Commission Case/Documentnvarchar40
52YHITEC_DOCFI_PData Transfer: FI Documents Item2POST_YEARAssignment Year of Commission Case/Documentnvarchar40
53YHITEC_DOCHDCommission Document Header2POST_YEARAssignment Year of Commission Case/Documentnvarchar40
54YHITEC_DOCINVParticipant in Commission Document2POST_YEARAssignment Year of Commission Case/Documentnvarchar40
55YHITEC_DOCOBJCommission Document: Object Data2POST_YEARAssignment Year of Commission Case/Documentnvarchar40
56YHITEC_DOCPARParticipation of Commission Document2POST_YEARAssignment Year of Commission Case/Documentnvarchar40
57YHITEC_DOCRECommission Document, Remuneration and Liability2POST_YEARAssignment Year of Commission Case/Documentnvarchar40
58YHITEC_DOCRE91Do Not Use! Enhancement Data Remuneration Lines2POST_YEARAssignment Year of Commission Case/Documentnvarchar40
59YHITEC_DOCRELCommission Document: Relationships Between Participants2POST_YEARAssignment Year of Commission Case/Documentnvarchar40
60YHITEC_DOCSECommission Document: Due Dates2POST_YEARAssignment Year of Commission Case/Documentnvarchar40
61YHITEC_DOCSE91Do Not Use! Enhancement Data Settlement Rows2POST_YEARAssignment Year of Commission Case/Documentnvarchar40
62YHITEC_DOCVACommission Document, Valuation2POST_YEARAssignment Year of Commission Case/Documentnvarchar40
63YHITEC_DOCVA91Do Not Use! Enhancement Data Evaluation Rows2POST_YEARAssignment Year of Commission Case/Documentnvarchar40
64YHITEC_SUMRERemuneration Totals for Contract Account Display4POST_YEARAssignment Year of Commission Case/Documentnvarchar40
65YHITEC_SUMVAValuation Totals for Contract Account Display5POST_YEARAssignment Year of Commission Case/Documentnvarchar40
66YSVMA_DOCACTCommission Document: Activities2POST_YEARAssignment Year of Commission Case/Documentnvarchar40
67YSVMA_DOCDTComn: Detail Items for Remuneration Rows2POST_YEARAssignment Year of Commission Case/Documentnvarchar40
68YSVMA_DOCFI_HData Transfer: FI Documents (Header Data)2POST_YEARAssignment Year of Commission Case/Documentnvarchar40
69YSVMA_DOCFI_PData Transfer: FI Documents (Items)2POST_YEARAssignment Year of Commission Case/Documentnvarchar40
70YSVMA_DOCHDCommission Document Header2POST_YEARAssignment Year of Commission Case/Documentnvarchar40
71YSVMA_DOCINVParticipant in Commission Document2POST_YEARAssignment Year of Commission Case/Documentnvarchar40
72YSVMA_DOCOBJCommission Document: Object Data2POST_YEARAssignment Year of Commission Case/Documentnvarchar40
73YSVMA_DOCPARParticipation of Commission Document2POST_YEARAssignment Year of Commission Case/Documentnvarchar40
74YSVMA_DOCRECommission Document, Remuneration and Liability2POST_YEARAssignment Year of Commission Case/Documentnvarchar40
75YSVMA_DOCRELCommission Document: Relationships Between Participants2POST_YEARAssignment Year of Commission Case/Documentnvarchar40
76YSVMA_DOCSECommission Document: Due Dates2POST_YEARAssignment Year of Commission Case/Documentnvarchar40
77YSVMA_DOCSEDTDue Date Details2POST_YEARAssignment Year of Commission Case/Documentnvarchar40
78YSVMA_DOCVACommission Document, Valuation2POST_YEARAssignment Year of Commission Case/Documentnvarchar40
79YSVMA_RCP_BUFFRCP: Buffer Table for RCP Processing8POST_YEARAssignment Year of Commission Case/Documentnvarchar40
80YSVMA_SESHDSettlement Schedule Header6POST_YEARAssignment Year of Commission Case/Documentnvarchar40
81YSVMA_SUMRERemuneration Totals for Contract Account Display4POST_YEARAssignment Year of Commission Case/Documentnvarchar40
82YSVMA_SUMRE01Commissions: Reference Totals Table for Compensation4POST_YEARAssignment Year of Commission Case/Documentnvarchar40
83YSVMA_SUMVAValuation Totals for Contract Account Display5POST_YEARAssignment Year of Commission Case/Documentnvarchar40
84YTEL01_DOCACTCommission Document: Activities2POST_YEARAssignment Year of Commission Case/Documentnvarchar40
85YTEL01_DOCDTComn: Detail Items for Remuneration Rows2POST_YEARAssignment Year of Commission Case/Documentnvarchar40
86YTEL01_DOCFI_HData Transfer: FI Documents Header Data2POST_YEARAssignment Year of Commission Case/Documentnvarchar40
87YTEL01_DOCFI_PData Transfer: FI Documents Item2POST_YEARAssignment Year of Commission Case/Documentnvarchar40
88YTEL01_DOCHDCommission Document Header2POST_YEARAssignment Year of Commission Case/Documentnvarchar40
89YTEL01_DOCINVParticipant in Commission Document2POST_YEARAssignment Year of Commission Case/Documentnvarchar40
90YTEL01_DOCOBJCommission Document: Object Data2POST_YEARAssignment Year of Commission Case/Documentnvarchar40
91YTEL01_DOCPARParticipation of Commission Document2POST_YEARAssignment Year of Commission Case/Documentnvarchar40
92YTEL01_DOCRECommission Document, Remuneration and Liability2POST_YEARAssignment Year of Commission Case/Documentnvarchar40
93YTEL01_DOCRE01Do Not Use! Enhancement Data Remuneration Lines2POST_YEARAssignment Year of Commission Case/Documentnvarchar40
94YTEL01_DOCRELCommission Document: Relationships Between Participants2POST_YEARAssignment Year of Commission Case/Documentnvarchar40
95YTEL01_DOCSECommission Document: Due Dates2POST_YEARAssignment Year of Commission Case/Documentnvarchar40
96YTEL01_DOCSE01Do Not Use! Enhancement Data Settlement Rows2POST_YEARAssignment Year of Commission Case/Documentnvarchar40
97YTEL01_DOCSEDTDue Date Details2POST_YEARAssignment Year of Commission Case/Documentnvarchar40
98YTEL01_DOCVACommission Document, Valuation2POST_YEARAssignment Year of Commission Case/Documentnvarchar40
99YTEL01_DOCVA01Do Not Use! Enhancement Data Evaluation Rows2POST_YEARAssignment Year of Commission Case/Documentnvarchar40
100YTEL01_SUMRERemuneration Totals for Contract Account Display4POST_YEARAssignment Year of Commission Case/Documentnvarchar40
101YTEL01_SUMRE03Reference Table for Compensation3POST_YEARAssignment Year of Commission Case/Documentnvarchar40
102YTEL01_SUMRE04Commissions: Totals Table for Compensation (Scale Base)5POST_YEARAssignment Year of Commission Case/Documentnvarchar40
103YTEL01_SUMVAValuation Totals for Contract Account Display5POST_YEARAssignment Year of Commission Case/Documentnvarchar40
104YTEL01_SUMVA02Reference Totals Table for Valuation (TELUS)2POST_YEARAssignment Year of Commission Case/Documentnvarchar40
105YTEL01_SUMVA03Reference Totals Table for Valuation (TELUS)3POST_YEARAssignment Year of Commission Case/Documentnvarchar40
106YTEL05_DOCACTCommission Document: Activities2POST_YEARAssignment Year of Commission Case/Documentnvarchar40
107YTEL05_DOCDTComn: Detail Items for Remuneration Rows2POST_YEARAssignment Year of Commission Case/Documentnvarchar40
108YTEL05_DOCFI_HData Transfer: FI Documents (Header Data)2POST_YEARAssignment Year of Commission Case/Documentnvarchar40
109YTEL05_DOCFI_PData Transfer: FI Documents (Items)2POST_YEARAssignment Year of Commission Case/Documentnvarchar40
110YTEL05_DOCHDCommission Document Header2POST_YEARAssignment Year of Commission Case/Documentnvarchar40
111YTEL05_DOCINVParticipant in Commission Document2POST_YEARAssignment Year of Commission Case/Documentnvarchar40
112YTEL05_DOCOBJCommission Document: Object Data2POST_YEARAssignment Year of Commission Case/Documentnvarchar40
113YTEL05_DOCPARParticipation of Commission Document2POST_YEARAssignment Year of Commission Case/Documentnvarchar40
114YTEL05_DOCRECommission Document, Remuneration and Liability2POST_YEARAssignment Year of Commission Case/Documentnvarchar40
115YTEL05_DOCRELCommission Document: Relationships Between Participants2POST_YEARAssignment Year of Commission Case/Documentnvarchar40
116YTEL05_DOCSECommission Document: Due Dates2POST_YEARAssignment Year of Commission Case/Documentnvarchar40
117YTEL05_DOCSEDTDue Date Details2POST_YEARAssignment Year of Commission Case/Documentnvarchar40
118YTEL05_DOCSHACommission Document: Complex Distribution Ratios2POST_YEARAssignment Year of Commission Case/Documentnvarchar40
119YTEL05_DOCVACommission Document, Valuation2POST_YEARAssignment Year of Commission Case/Documentnvarchar40
120YTEL05_RCP_BUFFRCP: Buffer Table for RCP Processing8POST_YEARAssignment Year of Commission Case/Documentnvarchar40
121YTEL05_SESHDSettlement Schedule Header6POST_YEARAssignment Year of Commission Case/Documentnvarchar40
122YTEL05_SUMRERemuneration Totals for Contract Account Display4POST_YEARAssignment Year of Commission Case/Documentnvarchar40
123YTEL05_SUMVAValuation Totals for Contract Account Display5POST_YEARAssignment Year of Commission Case/Documentnvarchar40
124ZICMAG_DOCACTCommission Document: Activities2POST_YEARAssignment Year of Commission Case/Documentnvarchar40
125ZICMAG_DOCDTComn: Detail Items for Remuneration Rows2POST_YEARAssignment Year of Commission Case/Documentnvarchar40
126ZICMAG_DOCFI_HData Transfer: FI Documents (Header Data)2POST_YEARAssignment Year of Commission Case/Documentnvarchar40
127ZICMAG_DOCFI_PData Transfer: FI Documents (Items)2POST_YEARAssignment Year of Commission Case/Documentnvarchar40
128ZICMAG_DOCHDCommission Document Header2POST_YEARAssignment Year of Commission Case/Documentnvarchar40
129ZICMAG_DOCINVParticipant in Commission Document2POST_YEARAssignment Year of Commission Case/Documentnvarchar40
130ZICMAG_DOCOBJCommission Document: Object Data2POST_YEARAssignment Year of Commission Case/Documentnvarchar40
131ZICMAG_DOCPARParticipation of Commission Document2POST_YEARAssignment Year of Commission Case/Documentnvarchar40
132ZICMAG_DOCRECommission Document, Remuneration and Liability2POST_YEARAssignment Year of Commission Case/Documentnvarchar40
133ZICMAG_DOCRELCommission Document: Relationships Between Participants2POST_YEARAssignment Year of Commission Case/Documentnvarchar40
134ZICMAG_DOCSECommission Document: Due Dates2POST_YEARAssignment Year of Commission Case/Documentnvarchar40
135ZICMAG_DOCSEDTDue Date Details2POST_YEARAssignment Year of Commission Case/Documentnvarchar40
136ZICMAG_DOCVACommission Document, Valuation2POST_YEARAssignment Year of Commission Case/Documentnvarchar40
137ZICMAG_SUMRERemuneration Totals for Contract Account Display4POST_YEARAssignment Year of Commission Case/Documentnvarchar40
138ZICMAG_SUMVAValuation Totals for Contract Account Display5POST_YEARAssignment Year of Commission Case/Documentnvarchar40
TOPJoint Venture und Production Sharing Accounting
139T8JFRMFarm In/Out & Re-Determination (Farm) Main Table13POST_YEARPosting yearnvarchar40
140T8JFRM_STPFarm In/Out & Re-Determination (Farm) Main Table9POST_YEARPosting yearnvarchar40