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

53 columns | Print definition?ERP 6.0  | CTTYP

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1P2BG_BG_OSIOSI properties Bulgaria8CTTYPContract typenvarchar10
2P2KZ_KZGRPGroupings and statuses of PERNR11CTTYPContract Typenvarchar20
3P2RB_STTax payroll Belgium16CTTYPContract Typenvarchar20
4P2RB_SVSocial Insurance payroll Belgium31CTTYPContract Typenvarchar20
5P2RB_SVEVLPayroll Results: DMFA Social Insurance table for Evaluation17CTTYPContract Type (00050)nvarchar10
6P2RF_FMDPayroll results: Master data7CTTYPContract Typenvarchar20
7P2RF_SVPayroll Result: Social Insurance (F)35CTTYPContract Typenvarchar20
8P2RM_MFAHR-DK: Payroll Results for FA Statistics8CTTYPWork Contract for FA statisticsnvarchar10
9P2RP_SSHR-PT: Payroll Results: Social Security14CTTYPContract typenvarchar10
10P2UA_UAGRPGroupings and statuses of PERNR12CTTYPContract Typenvarchar20
11P2UR_RUSTARussian Statuses9CTTYPContract Typenvarchar20
12T5FDSNCTTemp table for PAYFR_RESULT-CT19CTTYPType de contratnvarchar20
13T5T47NLabour law relationship types2CTTYPContract Typenvarchar20
14T5UPBSTC02Certificate: Certificate Type2CTTYPCertificate Typenvarchar40
15T5UPBSTC02TCertificate: Certificate Type Text Table3CTTYPCertificate Typenvarchar40
16T5UPBSTC11Certificate: Category6CTTYPCertificate Typenvarchar40
17T7QA47RContract Rule Setup4CTTYPContract Typenvarchar20
18T7UNPAD_TEIDTermination Indemnity Number Translation4CTTYPContract Typenvarchar20
TOPArgentina
19T7AR30Types of work contract in Argentina2CTTYPContract Typenvarchar20
TOPBelgium
20T5BS3Employee information except reductions ( level 3 )50CTTYPContract Typenvarchar20
21T5BVBContract Type Belgium2CTTYPContract Typenvarchar20
TOPDenmark
22PA0204HR Master Record, Infotype 0204 (DA/DS Statistics DK)89CTTYPWork Contract for FA statisticsnvarchar10
TOPFrance
23HRP1685BD table for infotype 168522CTTYPContrat Typenvarchar20
TOPItaly
24T5ITELRelation type 7702CTTYPContract Typenvarchar20
25T5ITNG01/M data table - section B5CTTYPContract Typenvarchar20
TOPNon Profit Organizations
26T7UNPAD_RULES_CTNPO: Rules Series Relationship to CTTYP3CTTYPContract Typenvarchar20
TOPPayroll
27PA0771Personel ana verileri: Bilgi tipi 077124CTTYPSözlesme türünvarchar20
28PA0935HR Master Record: Infotype 093524CTTYPContract typenvarchar10
29PA0938HR Master Record: Infotype 093891CTTYPContract typenvarchar10
30PA3261Commission contracts H25CTTYPContract typenvarchar20
31PB0771Personel ana verileri: Bilgi tipi 077124CTTYPSözlesme türünvarchar20
32PB0935Applicant data infotype 0935 (model)24CTTYPContract typenvarchar10
33PB0938Applicant data infotype 0938 (model)91CTTYPContract typenvarchar10
34T5HPBS_LGART_PARComm. - parameter table for specifying techn. wage type3CTTYPContract typenvarchar20
35T5HPBS_SZERZ_TIPComm. - contract type2CTTYPContract typenvarchar20
36T5HPBS_SZERZ_TITComm. - contract type text table3CTTYPContract typenvarchar20
37T5T47Contract types - extension of T547V2CTTYPContract Typenvarchar20
38T7BG1BDefinition of Insurance Calc/NoCalc for InsTyp & Contr.Types2CTTYPContract typenvarchar10
39T7BGC1Contract types1CTTYPContract typenvarchar10
40T7BGC1TContract types - text2CTTYPContract typenvarchar10
41T7BGC7Normative costs - obsolete (from 8/2011)1CTTYPContract typenvarchar10
42T7BGC7NNormative costs2CTTYPContract typenvarchar10
43T7RO47VContract Types - Addition information2CTTYPContract Typenvarchar20
44T7TRS09Istihdam durumunun Yasal Olanlar ile eslestirilmesi2CTTYPSözlesme türünvarchar20
TOPPersonnel Administration
45PA0016HR Master Record: Infotype 0016 (Contract Elements)39CTTYPContract Typenvarchar20
46T547SContract Type Texts3CTTYPContract Typenvarchar20
47T547VContract Types2CTTYPContract Typenvarchar20
48T7SI42AConversion of contract types to M1 values3CTTYPContract Typenvarchar20
49T7SK47VContract type2CTTYPContract Typenvarchar20
TOPPortugal
50PA0332HR Master Record: Infotype 0332 (Social Security - PT)29CTTYPContract typenvarchar10
51T5P2YHR-PT: Contract Types2CTTYPContract typenvarchar10
52T5PCEHR-PT: Contract Elements2CTTYPContract Typenvarchar20
TOPRecruitment
53PB0016Applicant Master Record Infotype 0016 (Contract Elements)39CTTYPContract Typenvarchar20