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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OVTG52Tax Definition
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

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
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

151 columns | Print definition?ERP 6.0  | ADDED_BY

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1FMATGREC30010001Derivation Rule:Derive activity group from value type only7ADDED_BYCreated bynvarchar120
2FMATGREC30010002Derivation Rule:Derivation using original CO transaction and9ADDED_BYCreated bynvarchar120
3K9REC38000057Derivation rule:commodity risk plan exposure9ADDED_BYCreated bynvarchar120
4K9REC38000058Derivation rule:Valuation Rule7ADDED_BYCreated bynvarchar120
5K9REC38000059Derivation rule:commodity mgmt derivation transfered exposu9ADDED_BYCreated bynvarchar120
6K9REC38000060Derivation rule:commodity mgmt derivation manual exp.9ADDED_BYCreated bynvarchar120
7K9REC38000061Derivation rule:Commodities9ADDED_BYCreated bynvarchar120
8K9REC38000062Derivation rule:Commodities9ADDED_BYCreated bynvarchar120
9K9REC38000065Derivation rule:CM: Valuation Rule7ADDED_BYCreated bynvarchar120
10K9REC38000066Derivation rule:CM: Valuation Rule Exposures7ADDED_BYCreated bynvarchar120
11K9REC38000073Derivation rule:Master: Requester ID --> Partner7ADDED_BYCreated bynvarchar120
12K9REC38000074Derivation rule:SAP Transaction Type < 360T SpotIndicator9ADDED_BYCreated bynvarchar120
13K9REC38000075Derivation rule:7ADDED_BYCreated bynvarchar120
14SATC_AC_NAMESPCSCustomer Namespaces2ADDED_BYLast Changed bynvarchar120
TOPAvailability Control
15K9RKI48050002Derivation rule:Derive act. group from value type only7ADDED_BYCreated bynvarchar120
16K9RKI48050003Derivation rule:Derivation using original CO transaction and9ADDED_BYCreated bynvarchar120
TOPFunctions for U.S. Federal Government
17FMFGBLDRVAREAEAADerivation rule:Set Expended Appropriations - Actuals (EAA)7ADDED_BYCreated bynvarchar120
18FMFGBLDRVAREAMRDerivation rule:Set Miscellaneous Receipts - Actuals (MIR)9ADDED_BYCreated bynvarchar120
TOPFunds Management
19FMDERIVE002Derivation rule:Cost Center/CE to Commitment Item/Funds Ctr/14ADDED_BYCreated bynvarchar120
20FMDERIVE004Derivation rule:Order/CE to Commitment Item/Funds Ctr/Fund/F12ADDED_BYCreated bynvarchar120
21FMDERIVE005Derivation rule:Order to Commitment Item/Funds Ctr/Fund/Func10ADDED_BYCreated bynvarchar120
22FMDERIVE006Derivation rule:WBS Element/CE to Commitment Item/Funds Ctr/12ADDED_BYCreated bynvarchar120
23FMDERIVE008Profit Ctr/CE to Commit Item/Funds Center/Fund/Function12ADDED_BYCreated bynvarchar120
24FMDERIVE009Derivation rule:Profit Center to Commitment Item/Funds Ctr/F10ADDED_BYCreated bynvarchar120
TOPGeneral Application Functions
25FMFMOAID38000003Derivation rule:8ADDED_BYCreated bynvarchar120
26FMFMOAID38000004Derivation rule:7ADDED_BYCreated bynvarchar120
27FMFMOAID38000016Derivation rule:Order to Commitment Item/Funds Ctr/Fund/Func10ADDED_BYCreated bynvarchar120
28FMFMOAID38000042Derivation rule:Cost Center to all14ADDED_BYCreated bynvarchar120
29KX9RABA0000108Ableitungsregel:df9ADDED_BYErfasser (Hinzufüge-Verantwortlicher)nvarchar120
TOPProfitability Analysis
30ACEDTF7300085Derivation rule:Determine Document type7ADDED_BYCreated bynvarchar120
31ACEDTF7300086Derivation rule:Accrual Types, Acc. Principle, Process in A11ADDED_BYCreated bynvarchar120
32ACEDTF7300087Derivation rule:Posting Rule to GL Accounts10ADDED_BYCreated bynvarchar120
33ACEID38000034Règle dérivat.:Document Type FR9ADDED_BYAuteur (responsable de la création)nvarchar120
34ACEID38000035Règle dérivat.:Comptes FR10ADDED_BYAuteur (responsable de la création)nvarchar120
35ACEID38000036Ableitungsregel:Document type9ADDED_BYErfasser (Hinzufüge-Verantwortlicher)nvarchar120
36ACEID38000040Ableitungsregel:Accounts for other accrual types (costs)14ADDED_BYErfasser (Hinzufüge-Verantwortlicher)nvarchar120
37ACEID38000041Ableitungsregel:Document type for accrual type INSURA9ADDED_BYErfasser (Hinzufüge-Verantwortlicher)nvarchar120
38ACEID38000042Ableitungsregel:Accounts for accrual type INSURA10ADDED_BYErfasser (Hinzufüge-Verantwortlicher)nvarchar120
39ACEID38000055Derivation rule:OR Accruals IPM HT - Document Type7ADDED_BYCreated bynvarchar120
40ACEID38000056Derivation rule:OR Accruals IPM HT - Account Determination10ADDED_BYCreated bynvarchar120
41FILADTF7300081Derivation rule:Derivation of Classification14ADDED_BYCreated bynvarchar120
42FILADTF7300082Derivation rule:Derivation of Useful Life12ADDED_BYCreated bynvarchar120
43FILADTF7300091Ableitungsregel:Valueid's bestimmen7ADDED_BYErfasser (Hinzufüge-Verantwortlicher)nvarchar120
44FOTPDTF7300088Derivation rule:One Time Postings Acc.Princ. 0112ADDED_BYCreated bynvarchar120
45FOTPDTF7300089Derivation rule:One Time Postings Acc.Princ. 6012ADDED_BYCreated bynvarchar120
46K9RALR0000472SAPDerivation Rule: Destination from Flight Segment7ADDED_BYCreated bynvarchar120
47K9RALR0000473SAPDerivation Rule: Departure Location from Flight Segment7ADDED_BYCreated bynvarchar120
48K9RALR0000474SAPDerivation Rule: Rotation from Flight Number7ADDED_BYCreated bynvarchar120
49K9RALR0000475SAPDerivation Rule: Region from Destination7ADDED_BYCreated bynvarchar120
50K9RALR0000476SAPDerivation Rule: Flight Type from Flight Number7ADDED_BYCreated bynvarchar120
51K9RALR1000001SAPDerivation Rule: Strategic Business Unit from Customer Group9ADDED_BYCreated bynvarchar120
52K9RID34000007Derivation rule:15ADDED_BYCreated bynvarchar120
53K9RID34000008Derivation rule:Derivation: State from Dstrct.7ADDED_BYCreated bynvarchar120
54K9RID34000020Ableitungsregel:PrdHierarchie -> PrdKategorie7ADDED_BYErfasser (Hinzufüge-Verantwortlicher)nvarchar120
55K9RID34000022Derivation rule:14ADDED_BYCreated bynvarchar120
56K9RID34000025Derivation rule:Template determination for sales processes11ADDED_BYCreated bynvarchar120
57K9RID34000026Derivation rule:Template determination for sales processes11ADDED_BYCreated bynvarchar120
58K9RID34000027Derivation rule:ac420 template determination7ADDED_BYCreated bynvarchar120
59K9RID34000028Derivation rule:AC610 Derive Profit Center 101611ADDED_BYCreated bynvarchar120
60K9RID34000029Derivation rule:11ADDED_BYCreated bynvarchar120
61K9RID35000001Ableitungsregel:Empfangsland --> Intern.Region7ADDED_BYErfasser (Hinzufüge-Verantwortlicher)nvarchar120
62K9RID35000002Ableitungsregel:PrdHierarchie -> PrdKategorie7ADDED_BYErfasser (Hinzufüge-Verantwortlicher)nvarchar120
63K9RID35000003Ableitungsregel:Debitor --> Intercompany Kennz7ADDED_BYErfasser (Hinzufüge-Verantwortlicher)nvarchar120
64K9RID35000004Ableitungsregel:Prod.Kat. + Branche -> SGE9ADDED_BYErfasser (Hinzufüge-Verantwortlicher)nvarchar120
65K9RID35020001Ableitungsregel:Empfangsland --> Intern.Region7ADDED_BYErfasser (Hinzufüge-Verantwortlicher)nvarchar120
66K9RID35020002Ableitungsregel:PrdHierarchie -> PrdKategorie7ADDED_BYErfasser (Hinzufüge-Verantwortlicher)nvarchar120
67K9RID35020003Ableitungsregel:Debitor --> Intercompany Kennz7ADDED_BYErfasser (Hinzufüge-Verantwortlicher)nvarchar120
68K9RID35020004Ableitungsregel:Prod.Kat. + Branche -> SGE9ADDED_BYErfasser (Hinzufüge-Verantwortlicher)nvarchar120
69K9RID35030001Ableitungsregel:Empfangsland --> Intern.Region7ADDED_BYErfasser (Hinzufüge-Verantwortlicher)nvarchar120
70K9RID35030002Ableitungsregel:PrdHierarchie -> PrdKategorie7ADDED_BYErfasser (Hinzufüge-Verantwortlicher)nvarchar120
71K9RID35030003Ableitungsregel:Debitor --> Intercompany Kennz7ADDED_BYErfasser (Hinzufüge-Verantwortlicher)nvarchar120
72K9RID35030004Ableitungsregel:Prod.Kat. + Branche -> SGE9ADDED_BYErfasser (Hinzufüge-Verantwortlicher)nvarchar120
73K9RID35030005Ableitungsregel:Ableitung Gebiet von Bezirk7ADDED_BYErfasser (Hinzufüge-Verantwortlicher)nvarchar120
74K9RID35050001Ableitungsregel:Empfangsland --> Intern.Region7ADDED_BYErfasser (Hinzufüge-Verantwortlicher)nvarchar120
75K9RID35050002Ableitungsregel:PrdHierarchie -> PrdKategorie7ADDED_BYErfasser (Hinzufüge-Verantwortlicher)nvarchar120
76K9RID35050003Ableitungsregel:Debitor --> Intercompany Kennz7ADDED_BYErfasser (Hinzufüge-Verantwortlicher)nvarchar120
77K9RID35050004Ableitungsregel:Prod.Kat. + Branche -> SGE9ADDED_BYErfasser (Hinzufüge-Verantwortlicher)nvarchar120
78K9RID35070001Ableitungsregel:Empfangsland --> Intern.Region7ADDED_BYErfasser (Hinzufüge-Verantwortlicher)nvarchar120
79K9RID35070002Ableitungsregel:PrdHierarchie -> PrdKategorie7ADDED_BYErfasser (Hinzufüge-Verantwortlicher)nvarchar120
80K9RID35070003Ableitungsregel:Debitor --> Intercompany Kennz7ADDED_BYErfasser (Hinzufüge-Verantwortlicher)nvarchar120
81K9RID35070004Ableitungsregel:Prod.Kat. + Branche -> SGE9ADDED_BYErfasser (Hinzufüge-Verantwortlicher)nvarchar120
82K9RID35080001Ableitungsregel:Empfangsland --> Intern.Region7ADDED_BYErfasser (Hinzufüge-Verantwortlicher)nvarchar120
83K9RID35080002Ableitungsregel:PrdHierarchie -> PrdKategorie7ADDED_BYErfasser (Hinzufüge-Verantwortlicher)nvarchar120
84K9RID35080003Ableitungsregel:Debitor --> Intercompany Kennz7ADDED_BYErfasser (Hinzufüge-Verantwortlicher)nvarchar120
85K9RID35080004Ableitungsregel:Prod.Kat. + Branche -> SGE9ADDED_BYErfasser (Hinzufüge-Verantwortlicher)nvarchar120
86K9RID35120001Derivation rule:Derivation: State from Dstrct.7ADDED_BYCreated bynvarchar120
87K9RID35130001Derivation rule:Country Ship-to --> Intern.Reg7ADDED_BYCreated bynvarchar120
88K9RID35130002Derivation rule:Prd.Hierarchy -> Prd. Category7ADDED_BYCreated bynvarchar120
89K9RID35130003Derivation rule:Customer --> Intercompany ind.7ADDED_BYCreated bynvarchar120
90K9RID35130004Derivation rule:Prod.Cat. + Industry -> SBU9ADDED_BYCreated bynvarchar120
91K9RID35160001Ableitungsregel:Empfangsland --> Intern.Region7ADDED_BYErfasser (Hinzufüge-Verantwortlicher)nvarchar120
92K9RID35160002Ableitungsregel:PrdHierarchie -> PrdKategorie7ADDED_BYErfasser (Hinzufüge-Verantwortlicher)nvarchar120
93K9RID35160003Ableitungsregel:Debitor --> Intercompany Kennz7ADDED_BYErfasser (Hinzufüge-Verantwortlicher)nvarchar120
94K9RID35160004Ableitungsregel:Prod.Kat. + Branche -> SGE9ADDED_BYErfasser (Hinzufüge-Verantwortlicher)nvarchar120
95K9RID35250001Derivation rule:Derivation: State from Dstrct.7ADDED_BYCreated bynvarchar120
96K9RID35290001Derivation rule:Derivation: State from Dstrct.7ADDED_BYCreated bynvarchar120
97K9RID35290002Reglas derivac.:País destino --> Reg.intern.7ADDED_BYCreado por (responsable de añadir)nvarchar120
98K9RID35290003Reglas derivac.:Jerarquía prod.-> Categ.prod.7ADDED_BYCreado por (responsable de añadir)nvarchar120
99K9RID35290004Reglas derivac.:Deudor --> Ind.multisociedades7ADDED_BYCreado por (responsable de añadir)nvarchar120
100K9RID35290005Reglas derivac.:Categoría Prod + Ramo -> SBU9ADDED_BYCreado por (responsable de añadir)nvarchar120
101K9RID35370001Regra derivação:Derivação de área de distrito7ADDED_BYAutor (responsável pela criação)nvarchar120
102K9RID38000001Derivation Rule: Ship-to country --> Intern.region7ADDED_BYCreated bynvarchar120
103K9RID38000002Derivation Rule: Product Hierarchy -> Product Category7ADDED_BYCreated bynvarchar120
104K9RID38000003Derivation Rule: Customer -> Intercompany Flag7ADDED_BYCreated bynvarchar120
105K9RID38000004Derivation Rule: Product Category + Industry -> SBU9ADDED_BYCreated bynvarchar120
106K9RID38000006Derivation Rule: Assignment to plant15ADDED_BYCreated bynvarchar120
107K9RID38000012Derivation Rule: Procedure Determination for Sales Processes11ADDED_BYCreated bynvarchar120
108K9RID38000016Ableitungsregel:T-Ableitungsregel Umwertung Nr 115ADDED_BYErfasser (Hinzufüge-Verantwortlicher)nvarchar120
109K9RID38000017Ableitungsregel:T-Ableitungsregel Verteilung Nr 115ADDED_BYErfasser (Hinzufüge-Verantwortlicher)nvarchar120
110K9RID38000018Ableitungsregel:T-Ableitungsregel Prognose Nr 115ADDED_BYErfasser (Hinzufüge-Verantwortlicher)nvarchar120
111K9RID38000019Ableitungsregel:IDES- Matnummer -> Rep. Materialnummer7ADDED_BYErfasser (Hinzufüge-Verantwortlicher)nvarchar120
112K9RID38000020Derivation Rule: Product Hierarchy -> Product Category7ADDED_BYCreated bynvarchar120
113K9RID38000021Derivation Rule: IDES Standard Derivation9ADDED_BYCreated bynvarchar120
114K9RID38000022Ableitungsregel:Umwertung 39ADDED_BYErfasser (Hinzufüge-Verantwortlicher)nvarchar120
115K9RID38000023Derivation Rule: Access to Cost Estimate for Transfer Prices15ADDED_BYCreated bynvarchar120
116K9RID38000024Ableitungsregel:Ableitung Gebiet von Bezirk7ADDED_BYErfasser (Hinzufüge-Verantwortlicher)nvarchar120
117K9RID38000025Derivation Rule: Unit of Measure from Material Group7ADDED_BYCreated bynvarchar120
118K9RID38000026Derivation Rule: Assignment at Material Type / Plant Level19ADDED_BYCreated bynvarchar120
119K9RID38000028Derivation Rule: Access to Material Type Level15ADDED_BYCreated bynvarchar120
120K9RID38000030Derivation Rule: Access to Cost Estimate for Transfer Prices16ADDED_BYCreated bynvarchar120
121K9RID38000031Ableitungsregel:PartnerPrCtr aus Kundennummer7ADDED_BYErfasser (Hinzufüge-Verantwortlicher)nvarchar120
122K9RID38000032Ableitungsregel:Konto/Buchungskreis/Geschäftsbereich11ADDED_BYErfasser (Hinzufüge-Verantwortlicher)nvarchar120
123K9RID38000033Derivation rule:AC420 TEMPLATE DETERMINATION7ADDED_BYCreated bynvarchar120
124K9RID38000043Ableitungsregel:9ADDED_BYErfasser (Hinzufüge-Verantwortlicher)nvarchar120
125K9RID38000044Ableitungsregel:Foreign Exchange11ADDED_BYErfasser (Hinzufüge-Verantwortlicher)nvarchar120
126K9RID38000045Ableitungsregel:Loans9ADDED_BYErfasser (Hinzufüge-Verantwortlicher)nvarchar120
127K9RID38000046Ableitungsregel:Money Market9ADDED_BYErfasser (Hinzufüge-Verantwortlicher)nvarchar120
128K9RID38000047Ableitungsregel:Depot-Gattungsbestand9ADDED_BYErfasser (Hinzufüge-Verantwortlicher)nvarchar120
129K9RID38000048Ableitungsregel:Risikoträger9ADDED_BYErfasser (Hinzufüge-Verantwortlicher)nvarchar120
130K9RID38000049Ableitungsregel:INT/EXT Kennzeichen7ADDED_BYErfasser (Hinzufüge-Verantwortlicher)nvarchar120
131K9RID38000050Ableitungsregel:Debitor --> Intercompany Kennz7ADDED_BYErfasser (Hinzufüge-Verantwortlicher)nvarchar120
132K9RID38000051Ableitungsregel:Empfangsland --> Intern.Region7ADDED_BYErfasser (Hinzufüge-Verantwortlicher)nvarchar120
133K9RID38000052Ableitungsregel:PrdHierarchie -> PrdKategorie7ADDED_BYErfasser (Hinzufüge-Verantwortlicher)nvarchar120
134K9RID38000053Ableitungsregel:Prod.Kat. + Branche -> SGE9ADDED_BYErfasser (Hinzufüge-Verantwortlicher)nvarchar120
135K9RID38000054Ableitungsregel:Mengeneinheit aus Warengruppe7ADDED_BYErfasser (Hinzufüge-Verantwortlicher)nvarchar120
136K9RIDT8000032Ableitungsregel:Warenhauptgruppe aus Warengruppe7ADDED_BYErfasser (Hinzufüge-Verantwortlicher)nvarchar120
137K9RIDT8000033Ableitungsregel:Verkaufsorganisation aus Land7ADDED_BYErfasser (Hinzufüge-Verantwortlicher)nvarchar120
138K9RIDT8000034Ableitungsregel:Verkaufsorganisation aus Land und Region9ADDED_BYErfasser (Hinzufüge-Verantwortlicher)nvarchar120
139K9RIDT8000050Ableitungsregel:9ADDED_BYErfasser (Hinzufüge-Verantwortlicher)nvarchar120
140K9RIDT8000052Ableitungsregel:KontRef BB 002: 1000; P.typ; B.kl.9ADDED_BYErfasser (Hinzufüge-Verantwortlicher)nvarchar120
141K9RIDT8000053Ableitungsregel:KontRef BB 001: 1000; P.typ; B.kl.9ADDED_BYErfasser (Hinzufüge-Verantwortlicher)nvarchar120
142K9RIDT8000054Ableitungsregel:KontRef BB 003: Produkttyp; Bew.kl.9ADDED_BYErfasser (Hinzufüge-Verantwortlicher)nvarchar120
143K9RIDT8000055Ableitungsregel:KontRef BB 001: Produkttyp; Bew.kl.9ADDED_BYErfasser (Hinzufüge-Verantwortlicher)nvarchar120
144K9RIDT8000056Ableitungsregel:KontRef BB 002: Produkttyp; Bew.kl.9ADDED_BYErfasser (Hinzufüge-Verantwortlicher)nvarchar120
145K9RIDT8000057Ableitungsregel:KontRef BB 003: Produkttyp; Bew.kl.9ADDED_BYErfasser (Hinzufüge-Verantwortlicher)nvarchar120
146K9RP000000019SAPDerivation Rule: Main Product Group from Material Group7ADDED_BYCreated bynvarchar120
147K9RP991000002SAPDerivation Rule: Strategic Business Unit from Customer Group9ADDED_BYCreated bynvarchar120
TOPRental Accounting
148ACESLN0000002Ableitungsregel:Belegart7ADDED_BYIngevoerd door (voor toevoeging verantwoord. persoon)nvarchar120
149ACESLN0000003Ableitungsregel:Konten12ADDED_BYIngevoerd door (voor toevoeging verantwoord. persoon)nvarchar120
150ACESLN1000001Derivation Rule: Document Type7ADDED_BYCreated bynvarchar120
151ACESLN1000002Derivation Rule: Accounts12ADDED_BYCreated bynvarchar120