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
4OVPM154Outgoing Payments
5OIVL77Whse Journal
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

30 columns | Print definition?ERP 6.0  | VADAT

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/BGLOCS/FIINDSETFI Invoice Document Setting4VADATSolution of VAT Due Datenvarchar10
2/SAPF15/XXBPDKF15 FI DUMMY7VADATnvarchar80
3P2RB_PKPension Fund, Payroll Belgium14VADATValue date for PF postingnvarchar80
4P2RC_PKHR-CH: Pension fund payroll values14VADATValue date for PF postingnvarchar80
5P2RN_PKPayroll Result: Pension Module14VADATValue date for PF postingnvarchar80
6P2TN_NHIPayroll Structure NHI Taiwan13VADATNHI contribution fromnvarchar80
7P2TN_NHIFPayroll Structure NHIF Taiwan13VADATNHI contribution fromnvarchar80
8P2UN_PKPension Fund, Payroll United Nations14VADATValue date for PF postingnvarchar80
9T028ABank Statement Table11VADATProcessing datenvarchar80
TOPConditions
10A000Condition Table for Pricing $7VADATVariable Data Partnvarchar1000
11KONHConditions (Header)22VADATVariable Data Partnvarchar1000
TOPData Collection
12MCS0Reference Structure for Generating Info Structures11VADATVariable data partnvarchar10
13MCS1Model Structure for Info Structures with Initial VAKEY11VADATVariable data partnvarchar10
14MCS2Sample Structure for Structural Information - Info Structure4VADATVariable data partnvarchar10
TOPDistributor-Reseller-Management
15W000Condition Table for Rule Determination $6VADATVariable Data Partnvarchar1000
TOPFinancial Accounting
16/BGLOCS/FIPRDSETVAT Protocol Document Setting5VADATSolution of VAT Due Datenvarchar10
TOPFunds Management
17BPDKHeader Entry Document7VADATPlanning/budgeting value datenvarchar80
18BPVKDocument Header for Parked Documents6VADATPlanning/budgeting value datenvarchar80
19FMCFBPAKSFM-FYC: Budget/Planning Updates (Interim Storage)23VADATPlanning/budgeting value datenvarchar80
TOPPatient Accounting
20TN22PIS-H: Control Parameters FI Posting Down Payment17VADATIS-H: Rule for Value Datenvarchar10
21TN22RIS-H: Control Params FI Posting Copayment/Copay.Cred.Memo14VADATIS-H: Rule for Value Datenvarchar10
TOPPension fund General Parts
22T5CPBHR-CH: Pension fund postings7VADATValue date for PF postingnvarchar80
23T72FAHR-PF: FI Index Table13VADATValue date for PF postingnvarchar80
TOPPension fund Netherlands
24T5ND1HR-CH: Pension fund postings7VADATValue date for PF postingnvarchar80
TOPPension Fund Switzerland
25PA3230Personnel Master Record for Infotype 323031VADATValue date for PF postingnvarchar80
TOPPosition Management
26KONHMPortfolio Determination - Data Part12VADATVariable Data Partnvarchar1000
TOPPricing
27PRCM_TABL_000Reference Table for Condition Tables (A000)22VADATVariable Data Part of a Condition Tablenvarchar2000
TOPSAP Healthcare - Industry-Specific Components for Hospitals
28TN22GIS-H: Steuerungsparameter FI-Buchung amb. Zuzahlung11VADATIS-H: Regel für Valutadatumnvarchar10
TOPTaiwan
29PA0352NHI for Family member (TW)43VADATNHI contribution fromnvarchar80
30PA0355National Health Insurance Taiwan26VADATNHI contribution fromnvarchar80