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

31 columns | Print definition?ERP 6.0  | ORGAN

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1P2RF_CCRTPayroll Results: Cumulation of Contributions, Wage Types8ORGANSI contribution fundsnvarchar40
2P2RF_FPWPPC2LF20ORGANnvarchar40
3P2RF_RECOTPayroll Results: Cumulation of Contributions9ORGANSI contribution fundsnvarchar40
4P2RT_BHStructure table for challenge14ORGANPension payment authoritynvarchar20
5P2SK_BHPSK0714ORGANPension payment authoritynvarchar20
6PA0429HR Master Record, Infotype 042927ORGANnvarchar40
7PA3307HR Master Record: Infotype 330725ORGANInjured Organnvarchar300
8PB3307Applicant data infotype 3307 (model)25ORGANInjured Organnvarchar300
9T5FDSNCOTISDSN: contributions parameter setting12ORGANSI contribution fundsnvarchar40
10T5FDSNCOTIS2DSN: contributions parameter setting16ORGANSI contribution fundsnvarchar40
11T5FPBS0STTexte organismes externes.3ORGANCode identifiant d'un organismenvarchar40
TOPClinical System
12N1ORGANIS-H*MED: Table for the Codes for Organs3ORGANDescription of an Organnvarchar60
13N1ORGANTIS-H*MED: Text for the Organ Table4ORGANDescription of an Organnvarchar60
14N1TPMIS-H*MED: Medical Enhancements for the Service Catalog Items23ORGANDescription of an Organnvarchar60
TOPFrance
15T5F1ASI organizations (France)2ORGANSI contribution fundsnvarchar40
16T5F1ACControl of payment offsetting to calculate contributions3ORGANSI contribution fundsnvarchar40
17T5F1CSI contributions:rates and wage types2ORGANSI contribution fundsnvarchar40
18T5F1ESI Organizations - addresses2ORGANSI contribution fundsnvarchar40
19T5F1FAssignment to social insurance fund model (France)4ORGANSI contribution fundsnvarchar40
20T5F1LDeletion of bases for the contributions of organizations3ORGANSI contribution fundsnvarchar40
21T5F1MAssignment to social insurance fund model (France)6ORGANSI contribution fundsnvarchar40
22T5F3CContributions and Profit Sharing Agencies4ORGANSI contribution fundsnvarchar40
23T5F4OCContributions by Social Protection Agency (OPS)6ORGANSI contribution fundsnvarchar40
24T5F4VDo not use: replaced by T5F4W7ORGANSI contribution fundsnvarchar40
25T5F4WContributions linked to personnel type7ORGANSI contribution fundsnvarchar40
TOPPatient Management
26NRSFIS-H: Patient Risk Factors17ORGANIS-H: Drug Allergy - Organ Affectednvarchar60
27TN17FIS-H: Drug Allergies - Organs Affected2ORGANIS-H: Drug Allergy - Organ Affectednvarchar60
28TN17OIS-H: Drug allergy: text for organ affected3ORGANIS-H: Drug Allergy - Organ Affectednvarchar60
TOPPayroll
29T5T62HR master record Infotype 062027ORGANPension payment authoritynvarchar20
TOPPersonnel Administration
30PA0620HR master record Infotype 062027ORGANPension payment authoritynvarchar20
31PA0621Personál.kmen.záznam Infotyp 062127ORGANOrgán vyplácajúci dôchodoknvarchar20