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

77 columns | Print definition?ERP 6.0  | NATIO

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/BIC/B0000285000PSA for 0PERSON_ATTR T90CLNT090 Person10NATIOnvarchar30
2P2AA_PS_SAPayroll Result: Pension Data for KSA8NATIONationalitynvarchar30
3P2AA_SV_SAPayroll Result: SI Data for KSA11NATIONationalitynvarchar30
4P2KZ_KZGRPGroupings and statuses of PERNR9NATIONationality Statusnvarchar10
5P2QA_PS_QAPayroll Result: Pension Data for QA8NATIONationalitynvarchar30
6P2RB_PERMPersonal Features5NATIONationalitynvarchar30
7P2RD_PERMPayroll Results: Personal Features5NATIONationalitynvarchar30
8P2RN_NNAMPersonal Data17NATIONationalitynvarchar30
9T001ECompany Code-Dependent Address Data7NATIOInternational address version IDnvarchar10
10T5PPBS9DPortugal Public Sector - BDAP - Country Codes2NATIONationalitynvarchar30
11T5T2ITax calculation configuration - non-residents4NATIONationalitynvarchar30
12T7AE28Emiratization National3NATIONationalitynvarchar30
13T7AEPBS66Absence Type Limit Condition14NATIONationalitynvarchar30
14T7KW08Absence Type Limit Condition8NATIONationalitynvarchar30
15T7OM11Visa Approval Information7NATIONationalitynvarchar30
16T7OM17Labor Approval Amendment Track4NATIONationalitynvarchar30
17T7OM33Absence Type Limit Condition8NATIONationalitynvarchar30
18T7QA62Visa Approval Information7NATIONationalitynvarchar30
19T7QA68Labor Approval Amendment Track4NATIONationalitynvarchar30
20T7QAPBS25Absence Type Limit Condition8NATIONationalitynvarchar30
21T7RUNATIOOKIN: Nationality3NATIOOKIN: Nationality Codenvarchar10
22T7RUR2Meaning of statuses of IT 0048 (Residence status)3NATIOStatus of Social Insurance Residencenvarchar10
23T7SA46Visa Approval Information7NATIONationalitynvarchar30
24T7SA48Labor Approval Amendment Track4NATIONationalitynvarchar30
25T7SAPBS66Absence Type Limit Condition8NATIONationalitynvarchar30
26HRP1702DB Table for Infotype 170232NATIONationality (Citizenship)nvarchar30
TOPAddress ManagementBusiness Address
27SADRAddress Management: Company Data3NATIOInternational address version IDnvarchar10
28SADRPAddress Management: Personal Data3NATIOInternational address version IDnvarchar10
29T005TCountry Names5NATIONationalitynvarchar150
30TSAVAddress Versions (Business Address Services) (Obsolete)1NATIOInternational address version IDnvarchar10
31TSAVTAddress Versions Text (obsolete)2NATIOInternational address version IDnvarchar10
TOPAdvertising Management
32JHTFKIS-M/AM: Settlement Documents (Billing, Commission) - Header43NATIOInternational address version IDnvarchar10
TOPArgentina
33T7ARM6My Simplification: Nationality-country code relationship2NATIONationalitynvarchar30
TOPAustria
34T5A9ACreated Statement of Employment (A)13NATIONationalitynvarchar150
TOPBrazil
35T7BRNANationality codes2NATIONationalitynvarchar30
TOPCapacity and Resource Planning
36/MRSS/SADRPXIS-Zusatzstruktur zu den SADR*-Strukturen3NATIOInternational address version IDnvarchar10
TOPClinical System
37N1PRPATIS-H*MED: PATREG: Patientenstammdatentabelle32NATIOIS-H: Uyruknvarchar30
38N1PRTMPPATIS-H*MED: PATREG: Temporäre Patientenstammdatentabelle33NATIOIS-H: Uyruknvarchar30
39N1PRTMPPATLOCIS-H*MED: PATREG: NPAT umgeschlüsselt auf N1PRPAT lokal33NATIOIS-H: Uyruknvarchar30
TOPCompany Pension Scheme Germany
40PA0746HR Master Record for Infotype 074652NATIONationalitynvarchar30
TOPConstruction Industry
41PDBKANConstruction Industry Social Fund Proced: ANMEL Data Records31NATIONationalitynvarchar30
TOPData Transfer
42T52CODIST_RETRORetroactive Accounting-Specific Wage Types for Cost Distrib.9NATIOGeneral Flagnvarchar10
TOPIndonesia
43T7ID0IIdentity Types2NATIONationalitynvarchar30
TOPInternational Functions for the Public Sector
44T7PBSDEC_COSTSXDEC: Cost Distribution Definition18NATIOXDEC: The cost is subject to Country Specific rulesnvarchar10
TOPLogbook
45ADFSH_APTMASFlight Scheduling: Airport Master4NATIOInternational address version IDnvarchar10
TOPPatient Management
46NPATIS-H: Patient Master Data (General)26NATIOIS-H: Nationalitynvarchar30
47NWANIS-H: Bad Debt Parties11NATIOIS-H: Nationalitynvarchar30
TOPPayroll
48PA0775Personel ana verileri: Bilgi tipi 077524NATIOUyrugunvarchar30
49T5H8NCodes of nationality2NATIONationalitynvarchar30
50T5TREGTRANSHRCZ - table for transfer items of Insured Register to SAP28NATIONationalitynvarchar30
51T7RO005RO Nationality Names for EE Register4NATIONationality (Max. 50 Characters)nvarchar500
52T7ROG1EE register - ER history7NATIOVersion Number Componentnvarchar20
53T7ROG2EE register - EE history13NATIOVersion Number Componentnvarchar20
54T7ROG5EE register - ER history7NATIOVersion Number Componentnvarchar20
55T7ROG6EE register - EE history15NATIOVersion Number Componentnvarchar20
56T7TRT04Yurtdisi hizmetinde anlasmali gün bilgileri2NATIOUyrugunvarchar30
TOPPersonnel Administration
57PA0002HR Master Record: Infotype 0002 (Personal Data)44NATIONationalitynvarchar30
58PA0152Infotype 0152 - Tax data CZ43NATIOResident's statenvarchar30
59T7PL82Tax rates for foreign workers2NATIONationalitynvarchar30
TOPPublic Sector
60P01ZFA_NN_DATAZfA: Notifications Not Assigned34NATIONationalitynvarchar30
TOPPublic Sector Contract Accounts Receivable and Payable
61DFMCA_BRF590BRF: Process Business Partner (General Information)30NATIOBRF: Expressionnvarchar200
TOPRecruitment
62PB0002HR Master Record: Infotype 0002 (Personal Data)44NATIONationalitynvarchar30
TOPRecycling Administration Core Functions
63J_7LSADRAddress Management: Company Data3NATIOInternational address version IDnvarchar10
TOPReporting
64P05TPRNL_EE_PDPension Return: Personal Data - Pers Level17NATIONationalitynvarchar30
TOPSAP Healthcare - Industry-Specific Components for Hospitals
65NAKR1IS-H AT: LKF - Grunddaten8NATIOIS-H: Staatsangehörigkeitnvarchar30
66NPNTCASIS-H: Patient Master Data at Case Level (CV IT)8NATIOIS-H: Nationalitynvarchar30
67NPSPATIS-H: Pseudonymized Patient Master Data (General)15NATIOIS-H: Nationalitynvarchar30
TOPStaffing
68T777NName Format2NATIONationalitynvarchar30
TOPTaiwan
69T7TW2IReported data of Tax withdrawal report31NATIONationalitynvarchar30
70T7TW2JTax agreement codes2NATIONationalitynvarchar30
71T7TW2JTTax agreement codes description3NATIONationalitynvarchar30
TOPTraining and Event Management
72HRP1034Infotype 1034 DB table23NATIONationalitynvarchar30
TOPUse AP-MD-BP Components
73BUT000BP: General data I59NATIONationalitynvarchar30
74BUT000_TDBP: General Data I, Shadow Table Time Dependency60NATIONationalitynvarchar30
75BUT000_TDSBP: General Data I, Shadow Table Time Dependency61NATIONationalitynvarchar30
TOPUse Subcomponents
76SOPRSAPoffice: System-wide profile51NATIOSAPoffice: international code for character setnvarchar10
77SOUDSAPoffice: user definition72NATIOSAPoffice: international code for character setnvarchar10