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

156 columns | Print definition?ERP 6.0  | DELETE_FLG

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1FMATGREC30010001Derivation Rule:Derive activity group from value type only6DELETE_FLGDeletion Flagnvarchar10
2FMATGREC30010002Derivation Rule:Derivation using original CO transaction and8DELETE_FLGDeletion Flagnvarchar10
3K9REC38000057Derivation rule:commodity risk plan exposure8DELETE_FLGCharacter field,length 1nvarchar10
4K9REC38000058Derivation rule:Valuation Rule6DELETE_FLGCharacter field,length 1nvarchar10
5K9REC38000059Derivation rule:commodity mgmt derivation transfered exposu8DELETE_FLGCharacter field,length 1nvarchar10
6K9REC38000060Derivation rule:commodity mgmt derivation manual exp.8DELETE_FLGCharacter field,length 1nvarchar10
7K9REC38000061Derivation rule:Commodities8DELETE_FLGCharacter field,length 1nvarchar10
8K9REC38000062Derivation rule:Commodities8DELETE_FLGCharacter field,length 1nvarchar10
9K9REC38000065Derivation rule:CM: Valuation Rule6DELETE_FLGCharacter field,length 1nvarchar10
10K9REC38000066Derivation rule:CM: Valuation Rule Exposures6DELETE_FLGCharacter field,length 1nvarchar10
11K9REC38000073Derivation rule:Master: Requester ID --> Partner6DELETE_FLGCharacter field,length 1nvarchar10
12K9REC38000074Derivation rule:SAP Transaction Type < 360T SpotIndicator8DELETE_FLGCharacter field,length 1nvarchar10
13K9REC38000075Derivation rule:6DELETE_FLGCharacter field,length 1nvarchar10
TOPArchive Development Kit
14ADMI_RUNArchive Runs Header Data9DELETE_FLGArchiving note for administrative datanvarchar10
15ADMI_XRUNArchiving Session for XML Archiving Objects10DELETE_FLGArchiving note for administrative datanvarchar10
16ARCH_DEFDefinition of archive object6DELETE_FLGData that Is NOT to Be Deletednvarchar10
17CLASS_DEFDefinition of an archiving class3DELETE_FLGData that Is NOT to Be Deletednvarchar10
TOPAvailability Control
18K9RKI48050002Derivation rule:Derive act. group from value type only6DELETE_FLGCharacter field,length 1nvarchar10
19K9RKI48050003Derivation rule:Derivation using original CO transaction and8DELETE_FLGCharacter field,length 1nvarchar10
TOPFunctions for U.S. Federal Government
20FMFGBLDRVAREAEAADerivation rule:Set Expended Appropriations - Actuals (EAA)6DELETE_FLGDeletion Flagnvarchar10
21FMFGBLDRVAREAMRDerivation rule:Set Miscellaneous Receipts - Actuals (MIR)8DELETE_FLGDeletion Flagnvarchar10
TOPFunds Management
22FMDERIVE002Derivation rule:Cost Center/CE to Commitment Item/Funds Ctr/13DELETE_FLGDeletion Flagnvarchar10
23FMDERIVE004Derivation rule:Order/CE to Commitment Item/Funds Ctr/Fund/F11DELETE_FLGDeletion Flagnvarchar10
24FMDERIVE005Derivation rule:Order to Commitment Item/Funds Ctr/Fund/Func9DELETE_FLGDeletion Flagnvarchar10
25FMDERIVE006Derivation rule:WBS Element/CE to Commitment Item/Funds Ctr/11DELETE_FLGDeletion Flagnvarchar10
26FMDERIVE008Profit Ctr/CE to Commit Item/Funds Center/Fund/Function11DELETE_FLGDeletion Flagnvarchar10
27FMDERIVE009Derivation rule:Profit Center to Commitment Item/Funds Ctr/F9DELETE_FLGDeletion Flagnvarchar10
TOPGeneral Application Functions
28FMFMOAID38000003Derivation rule:7DELETE_FLGDeletion Flagnvarchar10
29FMFMOAID38000004Derivation rule:6DELETE_FLGDeletion Flagnvarchar10
30FMFMOAID38000016Derivation rule:Order to Commitment Item/Funds Ctr/Fund/Func9DELETE_FLGDeletion Flagnvarchar10
31FMFMOAID38000042Derivation rule:Cost Center to all13DELETE_FLGDeletion Flagnvarchar10
32KX9RABA0000108Ableitungsregel:df8DELETE_FLGCharacterfeld Länge 1nvarchar10
TOPMaster Data
33BCA_US_HLD2RELHold Records which have not been released - Dual Control19DELETE_FLGMarked for Deletionnvarchar10
34BCA_US_HOLDHold Amounts Which Affect Available Balance18DELETE_FLGMarked for Deletionnvarchar10
TOPProfitability Analysis
35ACEDTF7300085Derivation rule:Determine Document type6DELETE_FLGCharacter field,length 1nvarchar10
36ACEDTF7300086Derivation rule:Accrual Types, Acc. Principle, Process in A10DELETE_FLGCharacter field,length 1nvarchar10
37ACEDTF7300087Derivation rule:Posting Rule to GL Accounts9DELETE_FLGCharacter field,length 1nvarchar10
38ACEID38000034Règle dérivat.:Document Type FR8DELETE_FLGZone de caract. long. 1nvarchar10
39ACEID38000035Règle dérivat.:Comptes FR9DELETE_FLGZone de caract. long. 1nvarchar10
40ACEID38000036Ableitungsregel:Document type8DELETE_FLGCharacterfeld Länge 1nvarchar10
41ACEID38000040Ableitungsregel:Accounts for other accrual types (costs)13DELETE_FLGCharacterfeld Länge 1nvarchar10
42ACEID38000041Ableitungsregel:Document type for accrual type INSURA8DELETE_FLGCharacterfeld Länge 1nvarchar10
43ACEID38000042Ableitungsregel:Accounts for accrual type INSURA9DELETE_FLGCharacterfeld Länge 1nvarchar10
44ACEID38000055Derivation rule:OR Accruals IPM HT - Document Type6DELETE_FLGCharacter field,length 1nvarchar10
45ACEID38000056Derivation rule:OR Accruals IPM HT - Account Determination9DELETE_FLGCharacter field,length 1nvarchar10
46FILADTF7300081Derivation rule:Derivation of Classification13DELETE_FLGCharacter field,length 1nvarchar10
47FILADTF7300082Derivation rule:Derivation of Useful Life11DELETE_FLGCharacter field,length 1nvarchar10
48FILADTF7300091Ableitungsregel:Valueid's bestimmen6DELETE_FLGCharacterfeld Länge 1nvarchar10
49FOTPDTF7300088Derivation rule:One Time Postings Acc.Princ. 0111DELETE_FLGCharacter field,length 1nvarchar10
50FOTPDTF7300089Derivation rule:One Time Postings Acc.Princ. 6011DELETE_FLGCharacter field,length 1nvarchar10
51K9RALR0000472SAPDerivation Rule: Destination from Flight Segment6DELETE_FLGCharacter field,length 1nvarchar10
52K9RALR0000473SAPDerivation Rule: Departure Location from Flight Segment6DELETE_FLGCharacter field,length 1nvarchar10
53K9RALR0000474SAPDerivation Rule: Rotation from Flight Number6DELETE_FLGCharacter field,length 1nvarchar10
54K9RALR0000475SAPDerivation Rule: Region from Destination6DELETE_FLGCharacter field,length 1nvarchar10
55K9RALR0000476SAPDerivation Rule: Flight Type from Flight Number6DELETE_FLGCharacter field,length 1nvarchar10
56K9RALR1000001SAPDerivation Rule: Strategic Business Unit from Customer Group8DELETE_FLGCharacter field,length 1nvarchar10
57K9RID34000007Derivation rule:14DELETE_FLGCharacter field,length 1nvarchar10
58K9RID34000008Derivation rule:Derivation: State from Dstrct.6DELETE_FLGCharacter field,length 1nvarchar10
59K9RID34000020Ableitungsregel:PrdHierarchie -> PrdKategorie6DELETE_FLGCharacterfeld Länge 1nvarchar10
60K9RID34000022Derivation rule:13DELETE_FLGCharacter field,length 1nvarchar10
61K9RID34000025Derivation rule:Template determination for sales processes10DELETE_FLGCharacter field,length 1nvarchar10
62K9RID34000026Derivation rule:Template determination for sales processes10DELETE_FLGCharacter field,length 1nvarchar10
63K9RID34000027Derivation rule:ac420 template determination6DELETE_FLGCharacter field,length 1nvarchar10
64K9RID34000028Derivation rule:AC610 Derive Profit Center 101610DELETE_FLGCharacter field,length 1nvarchar10
65K9RID34000029Derivation rule:10DELETE_FLGCharacter field,length 1nvarchar10
66K9RID35000001Ableitungsregel:Empfangsland --> Intern.Region6DELETE_FLGCharacterfeld Länge 1nvarchar10
67K9RID35000002Ableitungsregel:PrdHierarchie -> PrdKategorie6DELETE_FLGCharacterfeld Länge 1nvarchar10
68K9RID35000003Ableitungsregel:Debitor --> Intercompany Kennz6DELETE_FLGCharacterfeld Länge 1nvarchar10
69K9RID35000004Ableitungsregel:Prod.Kat. + Branche -> SGE8DELETE_FLGCharacterfeld Länge 1nvarchar10
70K9RID35020001Ableitungsregel:Empfangsland --> Intern.Region6DELETE_FLGCharacterfeld Länge 1nvarchar10
71K9RID35020002Ableitungsregel:PrdHierarchie -> PrdKategorie6DELETE_FLGCharacterfeld Länge 1nvarchar10
72K9RID35020003Ableitungsregel:Debitor --> Intercompany Kennz6DELETE_FLGCharacterfeld Länge 1nvarchar10
73K9RID35020004Ableitungsregel:Prod.Kat. + Branche -> SGE8DELETE_FLGCharacterfeld Länge 1nvarchar10
74K9RID35030001Ableitungsregel:Empfangsland --> Intern.Region6DELETE_FLGCharacterfeld Länge 1nvarchar10
75K9RID35030002Ableitungsregel:PrdHierarchie -> PrdKategorie6DELETE_FLGCharacterfeld Länge 1nvarchar10
76K9RID35030003Ableitungsregel:Debitor --> Intercompany Kennz6DELETE_FLGCharacterfeld Länge 1nvarchar10
77K9RID35030004Ableitungsregel:Prod.Kat. + Branche -> SGE8DELETE_FLGCharacterfeld Länge 1nvarchar10
78K9RID35030005Ableitungsregel:Ableitung Gebiet von Bezirk6DELETE_FLGCharacterfeld Länge 1nvarchar10
79K9RID35050001Ableitungsregel:Empfangsland --> Intern.Region6DELETE_FLGCharacterfeld Länge 1nvarchar10
80K9RID35050002Ableitungsregel:PrdHierarchie -> PrdKategorie6DELETE_FLGCharacterfeld Länge 1nvarchar10
81K9RID35050003Ableitungsregel:Debitor --> Intercompany Kennz6DELETE_FLGCharacterfeld Länge 1nvarchar10
82K9RID35050004Ableitungsregel:Prod.Kat. + Branche -> SGE8DELETE_FLGCharacterfeld Länge 1nvarchar10
83K9RID35070001Ableitungsregel:Empfangsland --> Intern.Region6DELETE_FLGCharacterfeld Länge 1nvarchar10
84K9RID35070002Ableitungsregel:PrdHierarchie -> PrdKategorie6DELETE_FLGCharacterfeld Länge 1nvarchar10
85K9RID35070003Ableitungsregel:Debitor --> Intercompany Kennz6DELETE_FLGCharacterfeld Länge 1nvarchar10
86K9RID35070004Ableitungsregel:Prod.Kat. + Branche -> SGE8DELETE_FLGCharacterfeld Länge 1nvarchar10
87K9RID35080001Ableitungsregel:Empfangsland --> Intern.Region6DELETE_FLGCharacterfeld Länge 1nvarchar10
88K9RID35080002Ableitungsregel:PrdHierarchie -> PrdKategorie6DELETE_FLGCharacterfeld Länge 1nvarchar10
89K9RID35080003Ableitungsregel:Debitor --> Intercompany Kennz6DELETE_FLGCharacterfeld Länge 1nvarchar10
90K9RID35080004Ableitungsregel:Prod.Kat. + Branche -> SGE8DELETE_FLGCharacterfeld Länge 1nvarchar10
91K9RID35120001Derivation rule:Derivation: State from Dstrct.6DELETE_FLGCharacter field,length 1nvarchar10
92K9RID35130001Derivation rule:Country Ship-to --> Intern.Reg6DELETE_FLGCharacter field,length 1nvarchar10
93K9RID35130002Derivation rule:Prd.Hierarchy -> Prd. Category6DELETE_FLGCharacter field,length 1nvarchar10
94K9RID35130003Derivation rule:Customer --> Intercompany ind.6DELETE_FLGCharacter field,length 1nvarchar10
95K9RID35130004Derivation rule:Prod.Cat. + Industry -> SBU8DELETE_FLGCharacter field,length 1nvarchar10
96K9RID35160001Ableitungsregel:Empfangsland --> Intern.Region6DELETE_FLGCharacterfeld Länge 1nvarchar10
97K9RID35160002Ableitungsregel:PrdHierarchie -> PrdKategorie6DELETE_FLGCharacterfeld Länge 1nvarchar10
98K9RID35160003Ableitungsregel:Debitor --> Intercompany Kennz6DELETE_FLGCharacterfeld Länge 1nvarchar10
99K9RID35160004Ableitungsregel:Prod.Kat. + Branche -> SGE8DELETE_FLGCharacterfeld Länge 1nvarchar10
100K9RID35250001Derivation rule:Derivation: State from Dstrct.6DELETE_FLGCharacter field,length 1nvarchar10
101K9RID35290001Derivation rule:Derivation: State from Dstrct.6DELETE_FLGCharacter field,length 1nvarchar10
102K9RID35290002Reglas derivac.:País destino --> Reg.intern.6DELETE_FLGCampo de texto, longitud 1nvarchar10
103K9RID35290003Reglas derivac.:Jerarquía prod.-> Categ.prod.6DELETE_FLGCampo de texto, longitud 1nvarchar10
104K9RID35290004Reglas derivac.:Deudor --> Ind.multisociedades6DELETE_FLGCampo de texto, longitud 1nvarchar10
105K9RID35290005Reglas derivac.:Categoría Prod + Ramo -> SBU8DELETE_FLGCampo de texto, longitud 1nvarchar10
106K9RID35370001Regra derivação:Derivação de área de distrito6DELETE_FLGCampo de caractere de comprimento 1nvarchar10
107K9RID38000001Derivation Rule: Ship-to country --> Intern.region6DELETE_FLGCharacter field,length 1nvarchar10
108K9RID38000002Derivation Rule: Product Hierarchy -> Product Category6DELETE_FLGCharacter field,length 1nvarchar10
109K9RID38000003Derivation Rule: Customer -> Intercompany Flag6DELETE_FLGCharacter field,length 1nvarchar10
110K9RID38000004Derivation Rule: Product Category + Industry -> SBU8DELETE_FLGCharacter field,length 1nvarchar10
111K9RID38000006Derivation Rule: Assignment to plant14DELETE_FLGCharacter field,length 1nvarchar10
112K9RID38000012Derivation Rule: Procedure Determination for Sales Processes10DELETE_FLGCharacter field,length 1nvarchar10
113K9RID38000016Ableitungsregel:T-Ableitungsregel Umwertung Nr 114DELETE_FLGCharacterfeld Länge 1nvarchar10
114K9RID38000017Ableitungsregel:T-Ableitungsregel Verteilung Nr 114DELETE_FLGCharacterfeld Länge 1nvarchar10
115K9RID38000018Ableitungsregel:T-Ableitungsregel Prognose Nr 114DELETE_FLGCharacterfeld Länge 1nvarchar10
116K9RID38000019Ableitungsregel:IDES- Matnummer -> Rep. Materialnummer6DELETE_FLGCharacterfeld Länge 1nvarchar10
117K9RID38000020Derivation Rule: Product Hierarchy -> Product Category6DELETE_FLGCharacter field,length 1nvarchar10
118K9RID38000021Derivation Rule: IDES Standard Derivation8DELETE_FLGCharacter field,length 1nvarchar10
119K9RID38000022Ableitungsregel:Umwertung 38DELETE_FLGCharacterfeld Länge 1nvarchar10
120K9RID38000023Derivation Rule: Access to Cost Estimate for Transfer Prices14DELETE_FLGCharacter field,length 1nvarchar10
121K9RID38000024Ableitungsregel:Ableitung Gebiet von Bezirk6DELETE_FLGCharacterfeld Länge 1nvarchar10
122K9RID38000025Derivation Rule: Unit of Measure from Material Group6DELETE_FLGCharacter field,length 1nvarchar10
123K9RID38000026Derivation Rule: Assignment at Material Type / Plant Level18DELETE_FLGCharacter field,length 1nvarchar10
124K9RID38000028Derivation Rule: Access to Material Type Level14DELETE_FLGCharacter field,length 1nvarchar10
125K9RID38000030Derivation Rule: Access to Cost Estimate for Transfer Prices15DELETE_FLGCharacter field,length 1nvarchar10
126K9RID38000031Ableitungsregel:PartnerPrCtr aus Kundennummer6DELETE_FLGCharacterfeld Länge 1nvarchar10
127K9RID38000032Ableitungsregel:Konto/Buchungskreis/Geschäftsbereich10DELETE_FLGCharacterfeld Länge 1nvarchar10
128K9RID38000033Derivation rule:AC420 TEMPLATE DETERMINATION6DELETE_FLGCharacter field,length 1nvarchar10
129K9RID38000043Ableitungsregel:8DELETE_FLGCharacterfeld Länge 1nvarchar10
130K9RID38000044Ableitungsregel:Foreign Exchange10DELETE_FLGCharacterfeld Länge 1nvarchar10
131K9RID38000045Ableitungsregel:Loans8DELETE_FLGCharacterfeld Länge 1nvarchar10
132K9RID38000046Ableitungsregel:Money Market8DELETE_FLGCharacterfeld Länge 1nvarchar10
133K9RID38000047Ableitungsregel:Depot-Gattungsbestand8DELETE_FLGCharacterfeld Länge 1nvarchar10
134K9RID38000048Ableitungsregel:Risikoträger8DELETE_FLGCharacterfeld Länge 1nvarchar10
135K9RID38000049Ableitungsregel:INT/EXT Kennzeichen6DELETE_FLGCharacterfeld Länge 1nvarchar10
136K9RID38000050Ableitungsregel:Debitor --> Intercompany Kennz6DELETE_FLGCharacterfeld Länge 1nvarchar10
137K9RID38000051Ableitungsregel:Empfangsland --> Intern.Region6DELETE_FLGCharacterfeld Länge 1nvarchar10
138K9RID38000052Ableitungsregel:PrdHierarchie -> PrdKategorie6DELETE_FLGCharacterfeld Länge 1nvarchar10
139K9RID38000053Ableitungsregel:Prod.Kat. + Branche -> SGE8DELETE_FLGCharacterfeld Länge 1nvarchar10
140K9RID38000054Ableitungsregel:Mengeneinheit aus Warengruppe6DELETE_FLGCharacterfeld Länge 1nvarchar10
141K9RIDT8000032Ableitungsregel:Warenhauptgruppe aus Warengruppe6DELETE_FLGCharacterfeld Länge 1nvarchar10
142K9RIDT8000033Ableitungsregel:Verkaufsorganisation aus Land6DELETE_FLGCharacterfeld Länge 1nvarchar10
143K9RIDT8000034Ableitungsregel:Verkaufsorganisation aus Land und Region8DELETE_FLGCharacterfeld Länge 1nvarchar10
144K9RIDT8000050Ableitungsregel:8DELETE_FLGCharacterfeld Länge 1nvarchar10
145K9RIDT8000052Ableitungsregel:KontRef BB 002: 1000; P.typ; B.kl.8DELETE_FLGCharacterfeld Länge 1nvarchar10
146K9RIDT8000053Ableitungsregel:KontRef BB 001: 1000; P.typ; B.kl.8DELETE_FLGCharacterfeld Länge 1nvarchar10
147K9RIDT8000054Ableitungsregel:KontRef BB 003: Produkttyp; Bew.kl.8DELETE_FLGCharacterfeld Länge 1nvarchar10
148K9RIDT8000055Ableitungsregel:KontRef BB 001: Produkttyp; Bew.kl.8DELETE_FLGCharacterfeld Länge 1nvarchar10
149K9RIDT8000056Ableitungsregel:KontRef BB 002: Produkttyp; Bew.kl.8DELETE_FLGCharacterfeld Länge 1nvarchar10
150K9RIDT8000057Ableitungsregel:KontRef BB 003: Produkttyp; Bew.kl.8DELETE_FLGCharacterfeld Länge 1nvarchar10
151K9RP000000019SAPDerivation Rule: Main Product Group from Material Group6DELETE_FLGCharacter field,length 1nvarchar10
152K9RP991000002SAPDerivation Rule: Strategic Business Unit from Customer Group8DELETE_FLGCharacter field,length 1nvarchar10
TOPRental Accounting
153ACESLN0000002Ableitungsregel:Belegart6DELETE_FLGAlfanumeriek veld, lengte 1nvarchar10
154ACESLN0000003Ableitungsregel:Konten11DELETE_FLGAlfanumeriek veld, lengte 1nvarchar10
155ACESLN1000001Derivation Rule: Document Type6DELETE_FLGCharacter field,length 1nvarchar10
156ACESLN1000002Derivation Rule: Accounts11DELETE_FLGCharacter field,length 1nvarchar10