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

Home | ERP 6.0  | P2RI_INFO156
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
1ERP EHP76.0P2RI_INFO156771Payroll results: tax deductions (IT 0156).
SQL:  selectupdate insert create

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

SELECT MANDT, DCT_PERNR, DCT_SEQNR, DCT_ROWID, 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, APAIM FROM P2RI_INFO156
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2DCT_PERNRPersonnel Numbernvarchar80NUMC(N'00000000')NoP_PERNR Allow NULL? 
3DCT_SEQNRSequence Numbernvarchar50NUMC(N'00000')NoHRPY_RGDIRCDSEQ Allow NULL? 
4DCT_ROWIDUnique Row Numbernvarchar50NUMC(N'00000')NoHRDCT_ROWID Allow NULL? 
5TPASIIRPEF taxation typenvarchar20NUMC(N'00')YesP15_TPASI Allow NULL? 
6CDCOIIRPEF contribution indicatornvarchar50CHAR(N' ')YesT5ITTSP15_CDCOI Allow NULL? 
7CDDTRTax deduction indicatornvarchar40CHAR(N' ')YesT5ITDTP15_CDDTR Allow NULL? 
8TPCM1Family member typenvarchar20NUMC(N'00')YesT5ITDSP15_TPCOM Allow NULL? 
9NUCA1Number of family dependentnvarchar20NUMC(N'00')YesP15_NUCAR Allow NULL? 
10PRCO1Deduction percentage for family member typedecimal52DEC((0))YesP15_PRCOM
11XRIC1Component requestchar10CHAR(N' ')YesP15_XRICH Allow NULL? 
12TPCM2Family member typenvarchar20NUMC(N'00')YesT5ITDSP15_TPCOM Allow NULL? 
13NUCA2Number of family dependentnvarchar20NUMC(N'00')YesP15_NUCAR Allow NULL? 
14PRCO2Deduction percentage for family member typedecimal52DEC((0))YesP15_PRCOM
15XRIC2Component requestchar10CHAR(N' ')YesP15_XRICH Allow NULL? 
16TPCM3Family member typenvarchar20NUMC(N'00')YesT5ITDSP15_TPCOM Allow NULL? 
17NUCA3Number of family dependentnvarchar20NUMC(N'00')YesP15_NUCAR Allow NULL? 
18PRCO3Deduction percentage for family member typedecimal52DEC((0))YesP15_PRCOM
19XRIC3Component requestchar10CHAR(N' ')YesP15_XRICH Allow NULL? 
20TPCM4Family member typenvarchar20NUMC(N'00')YesT5ITDSP15_TPCOM Allow NULL? 
21NUCA4Number of family dependentnvarchar20NUMC(N'00')YesP15_NUCAR Allow NULL? 
22PRCO4Deduction percentage for family member typedecimal52DEC((0))YesP15_PRCOM
23XRIC4Component requestchar10CHAR(N' ')YesP15_XRICH Allow NULL? 
24TPCM5Family member typenvarchar20NUMC(N'00')YesT5ITDSP15_TPCOM Allow NULL? 
25NUCA5Number of family dependentnvarchar20NUMC(N'00')YesP15_NUCAR Allow NULL? 
26PRCO5Deduction percentage for family member typedecimal52DEC((0))YesP15_PRCOM
27XRIC5Component requestchar10CHAR(N' ')YesP15_XRICH Allow NULL? 
28TPCM6Family member typenvarchar20NUMC(N'00')YesT5ITDSP15_TPCOM Allow NULL? 
29NUCA6Number of family dependentnvarchar20NUMC(N'00')YesP15_NUCAR Allow NULL? 
30PRCO6Deduction percentage for family member typedecimal52DEC((0))YesP15_PRCOM
31XRIC6Component requestchar10CHAR(N' ')YesP15_XRICH Allow NULL? 
32TPCM7Family member typenvarchar20NUMC(N'00')YesT5ITDSP15_TPCOM Allow NULL? 
33NUCA7Number of family dependentnvarchar20NUMC(N'00')YesP15_NUCAR Allow NULL? 
34PRCO7Deduction percentage for family member typedecimal52DEC((0))YesP15_PRCOM
35XRIC7Component requestchar10CHAR(N' ')YesP15_XRICH Allow NULL? 
36TPCM8Family member typenvarchar20NUMC(N'00')YesT5ITDSP15_TPCOM Allow NULL? 
37NUCA8Number of family dependentnvarchar20NUMC(N'00')YesP15_NUCAR Allow NULL? 
38PRCO8Deduction percentage for family member typedecimal52DEC((0))YesP15_PRCOM
39XRIC8Component requestchar10CHAR(N' ')YesP15_XRICH Allow NULL? 
40TPCM9Family member typenvarchar20NUMC(N'00')YesT5ITDSP15_TPCOM Allow NULL? 
41NUCA9Number of family dependentnvarchar20NUMC(N'00')YesP15_NUCAR Allow NULL? 
42PRCO9Deduction percentage for family member typedecimal52DEC((0))YesP15_PRCOM
43XRIC9Component requestchar10CHAR(N' ')YesP15_XRICH Allow NULL? 
44TPC10Family member typenvarchar20NUMC(N'00')YesT5ITDSP15_TPCOM Allow NULL? 
45NUC10Number of family dependentnvarchar20NUMC(N'00')YesP15_NUCAR Allow NULL? 
46PRC10Deduction percentage for family member typedecimal52DEC((0))YesP15_PRCOM
47XRI10Component requestchar10CHAR(N' ')YesP15_XRICH Allow NULL? 
48TPDE1Deduction typenvarchar20NUMC(N'00')Yes*P15_TPDET Allow NULL? 
49XRTD1Deduction type requestchar10CHAR(N' ')YesP15_XRTDE Allow NULL? 
50TPDE2Deduction typenvarchar20NUMC(N'00')Yes*P15_TPDET Allow NULL? 
51XRTD2Deduction type requestchar10CHAR(N' ')YesP15_XRTDE Allow NULL? 
52TPDE3Deduction typenvarchar20NUMC(N'00')Yes*P15_TPDET Allow NULL? 
53XRTD3Deduction type requestchar10CHAR(N' ')YesP15_XRTDE Allow NULL? 
54TPDE4Deduction typenvarchar20NUMC(N'00')Yes*P15_TPDET Allow NULL? 
55XRTD4Deduction type requestchar10CHAR(N' ')YesP15_XRTDE Allow NULL? 
56TPDE5Deduction typenvarchar20NUMC(N'00')Yes*P15_TPDET Allow NULL? 
57XRTD5Deduction type requestchar10CHAR(N' ')YesP15_XRTDE Allow NULL? 
58TPON1Type of allowable expensenvarchar20NUMC(N'00')Yes*P15_TPONE Allow NULL? 
59XROD1Deductible expenses requestchar10CHAR(N' ')YesP15_XRODE Allow NULL? 
60TPON2Type of allowable expensenvarchar20NUMC(N'00')Yes*P15_TPONE Allow NULL? 
61XROD2Deductible expenses requestchar10CHAR(N' ')YesP15_XRODE Allow NULL? 
62TPON3Type of allowable expensenvarchar20NUMC(N'00')Yes*P15_TPONE Allow NULL? 
63XROD3Deductible expenses requestchar10CHAR(N' ')YesP15_XRODE Allow NULL? 
64TPON4Type of allowable expensenvarchar20NUMC(N'00')Yes*P15_TPONE Allow NULL? 
65XROD4Deductible expenses requestchar10CHAR(N' ')YesP15_XRODE Allow NULL? 
66TPON5Type of allowable expensenvarchar20NUMC(N'00')Yes*P15_TPONE Allow NULL? 
67XROD5Deductible expenses requestchar10CHAR(N' ')YesP15_XRODE Allow NULL? 
68CDALTOther taxation indicatornvarchar40CHAR(N' ')YesT5ITL1P15_CDALT Allow NULL? 
69CDTRERegional tax indicatornvarchar50CHAR(N' ')YesT5ITR5P15_CDTRE Allow NULL? 
70REGIOSpecial status regions and districtsnvarchar30CHAR(N' ')Yes*P15_REGIO Allow NULL? 
71PROVIRegion (State, Province, County)nvarchar30CHAR(N' ')Yes*REGIO Allow NULL? 
72CDTPRProvincial tax indicatornvarchar50CHAR(N' ')Yes*P15_CDTPR Allow NULL? 
73MUNICMunicipality keynvarchar80CHAR(N' ')Yes*P15_MUNIC Allow NULL? 
74CDTMUMunicipal tax indicatornvarchar60CHAR(N' ')Yes*P15_CDTMU Allow NULL? 
75CDEDUDeduction indicatorchar10CHAR(N' ')YesP15_CDEDU Allow NULL? 
76DTMINDeduction minimum limit management requestchar10CHAR(N' ')YesP15_DTMIN Allow NULL? 
77APAIMApplication of a Higher Tax Rate for Income Tax on Soc. Ins.decimal74DEC((0))YesP15_APAIM
NamePrimaryUniqueTypeColumns
P2RI_INFO156~0YesYesCLUSTEREDDCT_ROWID, DCT_SEQNR, DCT_PERNR, MANDT

All references to SAP and SAP logo are trademarks of SAP AG in Germany, EU, USA and other territories.
No warranty is provided to data provided by this site. This website is not affiliated with, maintained, authorized, endorsed or sponsored by the SAP AG Company or any of its affiliates.
About :: Terms :: Privacy