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

51 columns | Print definition?ERP 6.0  | FAMST

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1CNV_20800_KNVKCNV backup copy: Customer master contact person65FAMSTMarital Status Keynvarchar10
2P2RB_PERMPersonal Features10FAMSTMarital Status Keynvarchar10
3P2RD_PERMPayroll Results: Personal Features10FAMSTMarital Status Keynvarchar10
4P2RD_VBLPayroll Result: Supplementary Pension Public Sector26FAMSTMaterial Status (for SP Notifications) (Obsolete with ZVMP)nvarchar10
5P2RE_STPayroll result: Taxes (ES)10FAMSTMarital statusnvarchar10
6P2RN_NNAMPersonal Data18FAMSTMarital Status Keynvarchar10
7P2RN_PRAPPension Return9FAMSTMarital Status Keynvarchar10
8P2UN_RSUN Rental Subsidy internal structure61FAMSTMarital Status Keynvarchar10
9T7AEPBS07Rental Allocation9FAMSTMarital Status Keynvarchar10
10T7AEPBS19Common Eligibility Rule Configuration17FAMSTMarital Status Keynvarchar10
11T7HK11General information of the IR56 forms12FAMSTSingle-Character Indicatornvarchar10
12T7QA49RMarital status rule setup3FAMSTMarital Status Keynvarchar10
13T7RUMATSTOKIN: Marital Status Designators4FAMSTMarital Status Keynvarchar10
14HRP1702DB Table for Infotype 170238FAMSTMarital Status Keynvarchar10
TOPArgentina
15PA0394Family data: Additional information30FAMSTMarital Status Keynvarchar10
16T7AR85Assignment of ANSeS marital status code2FAMSTMarital Status Keynvarchar10
TOPBelgium
17T5B15Translation Table: Marital Status2FAMSTMarital Status Keynvarchar10
TOPBrazil
18T7BRE1Full description of marital status3FAMSTMarital Status Keynvarchar10
19T7BRECMarital status description2FAMSTMarital Status Keynvarchar10
TOPChina
20PA0528HR Master Record: Infotype 0528 (Family information)36FAMSTMarital Status Keynvarchar10
TOPClinical System
21N1PRPATIS-H*MED: PATREG: Patientenstammdatentabelle28FAMSTIS-H: Medeni durumnvarchar10
22N1PRTMPPATIS-H*MED: PATREG: Temporäre Patientenstammdatentabelle29FAMSTIS-H: Medeni durumnvarchar10
23N1PRTMPPATLOCIS-H*MED: PATREG: NPAT umgeschlüsselt auf N1PRPAT lokal29FAMSTIS-H: Medeni durumnvarchar10
TOPCompany Pension Scheme Germany
24P01CVHActuarial CPS Header Records29FAMSTMarital Status Keynvarchar10
TOPCross-Application Components
25SKNVKCustomer Master Contact table for BC417 Course64FAMSTMarital Status Keynvarchar10
TOPCross-Application Objects in HR
26BBP_TB027HRSRM Decoupling: Copy of Table TB027HR2FAMSTMarital Status Keynvarchar10
27HRP5582DB Table for Infotype 558238FAMSTMarital Status Keynvarchar10
28TCACS_FAMSTConversion of Marital Status: HR -> Business Partner2FAMSTMarital Status Keynvarchar10
TOPCustomer Master
29KNVKCustomer Master Contact Partner64FAMSTMarital Status Keynvarchar10
TOPHong Kong
30PA0344HR Master Record: Infotype 0344 (Familiy members HK)47FAMSTMarital Status Keynvarchar10
TOPMaster Data Synchronization
31CVIC_MARST_LINKLink to Marital Status (Customer/Vendor-->BP)2FAMSTMarital Status Keynvarchar10
TOPNon Profit Organizations
32PA0959HR Master Record: Infotype 095925FAMSTMarital Status Keynvarchar10
33T7UNPAD_T502_TMarital Status Designators Relation to Rental Subsidy MarSta3FAMSTMarital Status Keynvarchar10
34T7UNPF_MARSTMMarital Status Mapping2FAMSTMarital Status Keynvarchar10
TOPPatient Management
35NPATIS-H: Patient Master Data (General)24FAMSTIS-H: Marital Statusnvarchar10
TOPPersonnel Administration
36PA0002HR Master Record: Infotype 0002 (Personal Data)49FAMSTMarital Status Keynvarchar10
37T502TMarital Status Designators3FAMSTMarital Status Keynvarchar10
TOPPublic Sector
38PA0051HR Master Record Infotype 0051 (VBL/SPI Data)40FAMSTMaterial Status (for SP Notifications) (Obsolete with ZVMP)nvarchar10
TOPRecruitment
39PB0002HR Master Record: Infotype 0002 (Personal Data)49FAMSTMarital Status Keynvarchar10
TOPReporting
40P05TPRNL_EE_PDPension Return: Personal Data - Pers Level20FAMSTMarital Status Keynvarchar10
41T5N5VMarital Status for Evaluations3FAMSTMarital Status Keynvarchar10
TOPReuse Services for Country Development
42T5F99FAMMarital status key recodification for DAQ reports4FAMSTMarital Status Keynvarchar10
TOPSales Promotions
43SADLSTRECBDynamic Part of Address List (Record Body)78FAMSTMarital Status Keynvarchar10
TOPSAP Healthcare - Industry-Specific Components for Hospitals
44NPNTCASIS-H: Patient Master Data at Case Level (CV IT)9FAMSTIS-H: Marital Statusnvarchar10
TOPSpain
45PA0062HR master record Infotype 0062 (Tax Spain))26FAMSTMarital statusnvarchar10
TOPStrategic Enterprise Management
46TB027HRConversion of Marital Status: HR - SAP-BP2FAMSTMarital Status Keynvarchar10
TOPSwitzerland
47T5C2O_FAMSTEMP-ACI: Assignment of Marital Status to Event3FAMSTMarital Status Keynvarchar10
48T5C2P_FAMSTWHT Geneva: Conversion of Marital Status from Infotype 00023FAMSTMarital Status Keynvarchar10
49T5C53Conversion Table Marital Status4FAMSTMarital Status Keynvarchar10
TOPUSA
50PA0106HR Master Record: Infotype 0106 (Related Persons NA)49FAMSTMarital Status Keynvarchar10
TOPVenezuela
51T7VEECMarital Status in Venezuela2FAMSTMarital Status Keynvarchar10