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

48 columns | Print definition?ERP 6.0  | BETRAG

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1ZID_CRNOTECATTBasis Data for CATT zid_apowe3BETRAGAmount in document currencydecimal132
TOPBank Customer Accounts
2FINSTA_POSTable for FINSTA Items (Used, e.g.,in CREATE_FINSTA)6BETRAGAmount in document currencydecimal132
TOPCompany Pension Scheme Germany
3P01RBM_MZ01RBTGDConfirmation MZ01 Pension Receipt Notif.: Contribution Data8BETRAGAmountdecimal92
4P01RBM_MZ01_BTGDReporting Data MZ01 Pension Receipt Notif.: Contribut. Data8BETRAGAmountdecimal92
TOPContract Billing
5EKDIRate Facts15BETRAGCurrency-dependent amountdecimal132
6ETTAFRate Cat.Facts16BETRAGCurrency-dependent amountdecimal132
7ETTIFInstln Facts23BETRAGCurrency-dependent amountdecimal132
8ETTIFBInstallation Facts (Reference Values)16BETRAGCurrency-dependent amountdecimal132
9ETTIFNInstallation Facts (Normal)23BETRAGCurrency-dependent amountdecimal132
TOPLoans Management
10TSZE1Sales data for acct statements6BETRAGAmount in document currencydecimal132
TOPPatient Accounting
11NNLZIS-H: Service <-> Business Partner Assignment11BETRAGdecimal150
TOPPeriodical Sales and Distribution
12JFLIABACCREVERSEIS-M/SD: Revenue Log for Reversal of Liability Acct Transfer10BETRAGIS-M/SD: Cumulated Amountdecimal132
13JFREVACCIS-M/SD: Pl.Cir.f.Rev. - Revenue per Liab.Acct + G/L Account12BETRAGIS-M/SD: Cumulated Amountdecimal132
14TJK14IS-M/SD: Lock Limit - Release for Returns/Complaint6BETRAGIS-M: Amount from Which Release Takes Placedecimal152
TOPPublic Sector
15P593RApplication Status: SI Reimbursement for Rehabilitants13BETRAGWage Type Amount for Paymentsdecimal132
TOPReal Estate Management
16VIEA06Management information: Owner for owner settlement18BETRAGAmount in Local Currencydecimal132
17VIMIUISales-Based Grading Lease-Out Items9BETRAGMinimum rent per sales gradingdecimal132
18VIWB31WB: Finanzierungsplan9BETRAGWB: Betrag der jeweiligen Finanzierungsartdecimal132
19VIWB41WB: Laufende Aufwendungen: Fremdkapitalkosten10BETRAGWB: Betrag der jeweiligen Finanzierungsartdecimal132
TOPRemaining Beverage - Obsolete Objects
20/BEV3/CHKAOBLIGACustomer Evaluation Table: Contract Performances19BETRAGIndividual Amountdecimal162
TOPRisk Analysis
21JBRBPCFKNRM: Aggregated Capital Commitment Cash Flows9BETRAGAggregated Cash Flow Amountdecimal172
22JBRBPCFVRM: BP Update Administration for Cash Flows9BETRAGAggregated Cash Flow Amountdecimal172
23JBRBPCFVNRM: BP Update Management for Cash Flows11BETRAGAggregated Cash Flow Amountdecimal172
24JBRBPCFZNRM: Aggregated Interest Commitment Cash Flows9BETRAGAggregated Cash Flow Amountdecimal172
25JBRCFKAPRM: Aggregated Capital Commitment Cash Flows per BP7BETRAGAggregated Cash Flow Amountdecimal172
26JBRCFZINSRM: Aggregated Fixed-Interest Cash Flows per BP7BETRAGAggregated Cash Flow Amountdecimal172
TOPSAP Healthcare - Industry-Specific Components for Hospitals
27NWATAGBAIS-H AT: Ambulanzgebühren - Ergebnisse / zu verteilen11BETRAGIS-H AT: Summe der Beträge pro Leistungscode (pro Auft.code)decimal152
28NWATAGBEIS-H AT: Ambulanzgebühren - Erfassungsdaten5BETRAGIS-H AT: Betrag von Landesfondsdecimal152
29NWATALSEIS-H AT: Amb. Leistungsstatistik - Ergebnisse10BETRAGIS-H AT: Betrag pro Leistungdecimal152
30NWCH90Fee-Based Services10BETRAGAmountdecimal152
31NWCH90BConditions for Fee-Based Services in NWCH905BETRAGAmountdecimal152
32NWCH91Fee Breakdown Results6BETRAGAmountdecimal152
33NWCH91_AUSGFee Breakdown Results from Clearing Report6BETRAGAmountdecimal152
34NWCH94Fees: Further Breakdown7BETRAGAmountdecimal152
35NWCHLS_RNLRGIS-H CH: ALIS-Fehlerhandlung - Arztzuordnungen (RNLRG)12BETRAGIS-H: Importo che il medico ottiene dalla prestazionedecimal152
36TNWCH102Items for Pool in Fee Billing7BETRAGAmountdecimal152
37TNWCH94LSFees: Limitation Levels6BETRAGAmount for Limitation Leveldecimal152
38TNWCH98Fee limitation6BETRAGAmountdecimal152
39TNWCH99Fee Breakdown Code10BETRAGAmountdecimal152
40TNWCH99SFees: Breakdown Codes for Limit Levels9BETRAGAmountdecimal152
41TNWCHHONPOS102Fee Item Data for Pools8BETRAGAmountdecimal152
42TNWCHHONPOS98Fee Item Data for Codes - Limitations7BETRAGAmountdecimal152
43TNWCHHONPOS99Fee Item Data for Codes - Breakdown Code11BETRAGAmountdecimal152
44TNWCHHONPOS99SFee Item Data for Codes - Breakdown Code10BETRAGAmountdecimal152
TOPSwitzerland
45T5CZOHR-CH: Amount of Child Benefit13BETRAGHR-CH: Amount of bonus (month)decimal72
46T5CZPHR-CH: Amount of Bonus Paid after Birth of Child9BETRAGHR-CH: Amount of bonus (month)decimal72
47T5CZSHR-CH: Calculation Rule for Household Allowance8BETRAGHR-CH: Amount of bonus (month)decimal72
TOPWaste Management
48EWAOBJH_AAT_HISTHistory and Valution of WBCs for Service Freq. Service28BETRAGCurrency-dependent amountdecimal132