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
Personnel Management :: Personnel Administration :: Italy
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0PA01561001HR master data, infotype 0156 (Tax deduction)Italy
SQL:  selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT MANDT, PERNR, SUBTY, OBJPS, SPRPS, ENDDA, BEGDA, SEQNR, AEDTM, UNAME, HISTO, ITXEX, REFEX, ORDEX, ITBLD, PREAS, FLAG1, FLAG2, FLAG3, FLAG4, RESE1, RESE2, GRPVL, TPASI, CDCOI, CDDTR, TPCM1, NUCA1, PRCO1, XRIC1, TPCM2, NUCA2, PRCO2, XRIC2, TPCM3, NUCA3, PRCO3, XRIC3, TPCM4, NUCA4, PRCO4, XRIC4, TPCM5, NUCA5, PRCO5, XRIC5, TPCM6, NUCA6, PRCO6, XRIC6, TPCM7, NUCA7, PRCO7, XRIC7, TPCM8, NUCA8, PRCO8, XRIC8, TPCM9, NUCA9, PRCO9, XRIC9, TPC10, NUC10, PRC10, XRI10, TPDE1, XRTD1, TPDE2, XRTD2, TPDE3, XRTD3, TPDE4, XRTD4, TPDE5, XRTD5, TPON1, XROD1, TPON2, XROD2, TPON3, XROD3, TPON4, XROD4, TPON5, XROD5, CDALT, CDTRE, REGIO, PROVI, CDTPR, MUNIC, CDTMU, CDEDU, DTMIN, FDMIN, RDTSS, APAIM, UDEFA, RRCF FROM PA0156
ColumnFieldDescriptionSQL TypeLengthDecimalsRelationDefault ValueConstraintsSQL Create Statement
1MANDTClientnvarchar30 Allow NULL? 
2PERNRPersonnel numbernvarchar80 Allow NULL? 
3SUBTYSubtypenvarchar40 Allow NULL? 
4OBJPSObject Identificationnvarchar20 Allow NULL? 
5SPRPSLock Indicator for HR Master Data Recordchar10 Allow NULL? 
6ENDDAEnd Datenvarchar80 Allow NULL? 
7BEGDAStart Datenvarchar80 Allow NULL? 
8SEQNRNumber of Infotype Record with Same Keynvarchar30 Allow NULL? 
9AEDTMChanged Onnvarchar80 Allow NULL? 
10UNAMEName of Person Who Changed Objectnvarchar120 Allow NULL? 
11HISTOHistorical Record Flagchar10 Allow NULL? 
12ITXEXText Exists for Infotypechar10 Allow NULL? 
13REFEXReference Fields Exist (Primary/Secondary Costs)char10 Allow NULL? 
14ORDEXConfirmation Fields Existchar10 Allow NULL? 
15ITBLDInfotype Screen Controlnvarchar20 Allow NULL? 
16PREASReason for Changing Master Datanvarchar20 Allow NULL? 
17FLAG1Reserved Field/Unused Fieldchar10 Allow NULL? 
18FLAG2Reserved Field/Unused Fieldchar10 Allow NULL? 
19FLAG3Reserved Field/Unused Fieldchar10 Allow NULL? 
20FLAG4Reserved Field/Unused Fieldchar10 Allow NULL? 
21RESE1Reserved Field/Unused Field of Length 2nvarchar20 Allow NULL? 
22RESE2Reserved Field/Unused Field of Length 2nvarchar20 Allow NULL? 
23GRPVLGrouping Value for Personnel Assignmentsnvarchar40 Allow NULL? 
24TPASIIRPEF taxation typenvarchar20 Allow NULL? 
25CDCOIIRPEF contribution indicatornvarchar50 Allow NULL? 
26CDDTRTax deduction indicatornvarchar40 Allow NULL? 
27TPCM1Family member typenvarchar20 Allow NULL? 
28NUCA1Number of family dependentnvarchar20 Allow NULL? 
29PRCO1Deduction percentage for family member typedecimal52
30XRIC1Component requestchar10 Allow NULL? 
31TPCM2Family member typenvarchar20 Allow NULL? 
32NUCA2Number of family dependentnvarchar20 Allow NULL? 
33PRCO2Deduction percentage for family member typedecimal52
34XRIC2Component requestchar10 Allow NULL? 
35TPCM3Family member typenvarchar20 Allow NULL? 
36NUCA3Number of family dependentnvarchar20 Allow NULL? 
37PRCO3Deduction percentage for family member typedecimal52
38XRIC3Component requestchar10 Allow NULL? 
39TPCM4Family member typenvarchar20 Allow NULL? 
40NUCA4Number of family dependentnvarchar20 Allow NULL? 
41PRCO4Deduction percentage for family member typedecimal52
42XRIC4Component requestchar10 Allow NULL? 
43TPCM5Family member typenvarchar20 Allow NULL? 
44NUCA5Number of family dependentnvarchar20 Allow NULL? 
45PRCO5Deduction percentage for family member typedecimal52
46XRIC5Component requestchar10 Allow NULL? 
47TPCM6Family member typenvarchar20 Allow NULL? 
48NUCA6Number of family dependentnvarchar20 Allow NULL? 
49PRCO6Deduction percentage for family member typedecimal52
50XRIC6Component requestchar10 Allow NULL? 
51TPCM7Family member typenvarchar20 Allow NULL? 
52NUCA7Number of family dependentnvarchar20 Allow NULL? 
53PRCO7Deduction percentage for family member typedecimal52
54XRIC7Component requestchar10 Allow NULL? 
55TPCM8Family member typenvarchar20 Allow NULL? 
56NUCA8Number of family dependentnvarchar20 Allow NULL? 
57PRCO8Deduction percentage for family member typedecimal52
58XRIC8Component requestchar10 Allow NULL? 
59TPCM9Family member typenvarchar20 Allow NULL? 
60NUCA9Number of family dependentnvarchar20 Allow NULL? 
61PRCO9Deduction percentage for family member typedecimal52
62XRIC9Component requestchar10 Allow NULL? 
63TPC10Family member typenvarchar20 Allow NULL? 
64NUC10Number of family dependentnvarchar20 Allow NULL? 
65PRC10Deduction percentage for family member typedecimal52
66XRI10Component requestchar10 Allow NULL? 
67TPDE1Deduction typenvarchar20 Allow NULL? 
68XRTD1Deduction type requestchar10 Allow NULL? 
69TPDE2Deduction typenvarchar20 Allow NULL? 
70XRTD2Deduction type requestchar10 Allow NULL? 
71TPDE3Deduction typenvarchar20 Allow NULL? 
72XRTD3Deduction type requestchar10 Allow NULL? 
73TPDE4Deduction typenvarchar20 Allow NULL? 
74XRTD4Deduction type requestchar10 Allow NULL? 
75TPDE5Deduction typenvarchar20 Allow NULL? 
76XRTD5Deduction type requestchar10 Allow NULL? 
77TPON1Type of allowable expensenvarchar20 Allow NULL? 
78XROD1Deductible expenses requestchar10 Allow NULL? 
79TPON2Type of allowable expensenvarchar20 Allow NULL? 
80XROD2Deductible expenses requestchar10 Allow NULL? 
81TPON3Type of allowable expensenvarchar20 Allow NULL? 
82XROD3Deductible expenses requestchar10 Allow NULL? 
83TPON4Type of allowable expensenvarchar20 Allow NULL? 
84XROD4Deductible expenses requestchar10 Allow NULL? 
85TPON5Type of allowable expensenvarchar20 Allow NULL? 
86XROD5Deductible expenses requestchar10 Allow NULL? 
87CDALTOther taxation indicatornvarchar40 Allow NULL? 
88CDTRERegional tax indicatornvarchar50 Allow NULL? 
89REGIOSpecial status regions and districtsnvarchar30 Allow NULL? 
90PROVIRegion (State, Province, County)nvarchar30 Allow NULL? 
91CDTPRProvincial tax indicatornvarchar50 Allow NULL? 
92MUNICMunicipality keynvarchar80 Allow NULL? 
93CDTMUMunicipal tax indicatornvarchar60 Allow NULL? 
94CDEDUDeduction indicatorchar10 Allow NULL? 
95DTMINDeduction minimum limit management requestchar10 Allow NULL? 
96FDMINMin. Limit Deduction Management w/o requestchar10 Allow NULL? 
97RDTSSWithdrawal to Overtime Detaxationchar10 Allow NULL? 
98APAIMApplication of a Higher Tax Rate for Income Tax on Soc. Ins.decimal74
99UDEFAPercentage for further large family deductionsdecimal52
100RRCFchar10 Allow NULL? 
NamePrimaryUniqueTypeColumns
PA0156~0YesYesCLUSTEREDSEQNR, BEGDA, ENDDA, SPRPS, OBJPS, SUBTY, PERNR, MANDT