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  | PA0156
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
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 TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2PERNRPersonnel numbernvarchar80NUMC(N'00000000')NoPA0003PERSNO Allow NULL? 
3SUBTYSubtypenvarchar40CHAR(N' ')NoSUBTY Allow NULL? 
4OBJPSObject Identificationnvarchar20CHAR(N' ')NoOBJPS Allow NULL? 
5SPRPSLock Indicator for HR Master Data Recordchar10CHAR(N' ')NoSPRPS Allow NULL? 
6ENDDAEnd Datenvarchar80DATS(N'00000000')NoENDDA Allow NULL? 
7BEGDAStart Datenvarchar80DATS(N'00000000')NoBEGDA Allow NULL? 
8SEQNRNumber of Infotype Record with Same Keynvarchar30NUMC(N'000')NoSEQNR Allow NULL? 
9AEDTMChanged Onnvarchar80DATS(N'00000000')YesAEDAT Allow NULL? 
10UNAMEName of Person Who Changed Objectnvarchar120CHAR(N' ')YesAENAM Allow NULL? 
11HISTOHistorical Record Flagchar10CHAR(N' ')YesHISTO Allow NULL? 
12ITXEXText Exists for Infotypechar10CHAR(N' ')YesITXEX Allow NULL? 
13REFEXReference Fields Exist (Primary/Secondary Costs)char10CHAR(N' ')YesPRFEX Allow NULL? 
14ORDEXConfirmation Fields Existchar10CHAR(N' ')YesORDEX Allow NULL? 
15ITBLDInfotype Screen Controlnvarchar20CHAR(N' ')YesITBLD Allow NULL? 
16PREASReason for Changing Master Datanvarchar20CHAR(N' ')YesT530EPREAS Allow NULL? 
17FLAG1Reserved Field/Unused Fieldchar10CHAR(N' ')YesNUSED Allow NULL? 
18FLAG2Reserved Field/Unused Fieldchar10CHAR(N' ')YesNUSED Allow NULL? 
19FLAG3Reserved Field/Unused Fieldchar10CHAR(N' ')YesNUSED Allow NULL? 
20FLAG4Reserved Field/Unused Fieldchar10CHAR(N' ')YesNUSED Allow NULL? 
21RESE1Reserved Field/Unused Field of Length 2nvarchar20CHAR(N' ')YesNUSED2 Allow NULL? 
22RESE2Reserved Field/Unused Field of Length 2nvarchar20CHAR(N' ')YesNUSED2 Allow NULL? 
23GRPVLGrouping Value for Personnel Assignmentsnvarchar40CHAR(N' ')YesPCCE_GPVAL Allow NULL? 
24TPASIIRPEF taxation typenvarchar20NUMC(N'00')YesP15_TPASI Allow NULL? 
25CDCOIIRPEF contribution indicatornvarchar50CHAR(N' ')YesT5ITTSP15_CDCOI Allow NULL? 
26CDDTRTax deduction indicatornvarchar40CHAR(N' ')YesT5ITDTP15_CDDTR Allow NULL? 
27TPCM1Family member typenvarchar20NUMC(N'00')YesT5ITDSP15_TPCOM Allow NULL? 
28NUCA1Number of family dependentnvarchar20NUMC(N'00')YesP15_NUCAR Allow NULL? 
29PRCO1Deduction percentage for family member typedecimal52DEC((0))YesP15_PRCOM
30XRIC1Component requestchar10CHAR(N' ')YesP15_XRICH Allow NULL? 
31TPCM2Family member typenvarchar20NUMC(N'00')YesT5ITDSP15_TPCOM Allow NULL? 
32NUCA2Number of family dependentnvarchar20NUMC(N'00')YesP15_NUCAR Allow NULL? 
33PRCO2Deduction percentage for family member typedecimal52DEC((0))YesP15_PRCOM
34XRIC2Component requestchar10CHAR(N' ')YesP15_XRICH Allow NULL? 
35TPCM3Family member typenvarchar20NUMC(N'00')YesT5ITDSP15_TPCOM Allow NULL? 
36NUCA3Number of family dependentnvarchar20NUMC(N'00')YesP15_NUCAR Allow NULL? 
37PRCO3Deduction percentage for family member typedecimal52DEC((0))YesP15_PRCOM
38XRIC3Component requestchar10CHAR(N' ')YesP15_XRICH Allow NULL? 
39TPCM4Family member typenvarchar20NUMC(N'00')YesT5ITDSP15_TPCOM Allow NULL? 
40NUCA4Number of family dependentnvarchar20NUMC(N'00')YesP15_NUCAR Allow NULL? 
41PRCO4Deduction percentage for family member typedecimal52DEC((0))YesP15_PRCOM
42XRIC4Component requestchar10CHAR(N' ')YesP15_XRICH Allow NULL? 
43TPCM5Family member typenvarchar20NUMC(N'00')YesT5ITDSP15_TPCOM Allow NULL? 
44NUCA5Number of family dependentnvarchar20NUMC(N'00')YesP15_NUCAR Allow NULL? 
45PRCO5Deduction percentage for family member typedecimal52DEC((0))YesP15_PRCOM
46XRIC5Component requestchar10CHAR(N' ')YesP15_XRICH Allow NULL? 
47TPCM6Family member typenvarchar20NUMC(N'00')YesT5ITDSP15_TPCOM Allow NULL? 
48NUCA6Number of family dependentnvarchar20NUMC(N'00')YesP15_NUCAR Allow NULL? 
49PRCO6Deduction percentage for family member typedecimal52DEC((0))YesP15_PRCOM
50XRIC6Component requestchar10CHAR(N' ')YesP15_XRICH Allow NULL? 
51TPCM7Family member typenvarchar20NUMC(N'00')YesT5ITDSP15_TPCOM Allow NULL? 
52NUCA7Number of family dependentnvarchar20NUMC(N'00')YesP15_NUCAR Allow NULL? 
53PRCO7Deduction percentage for family member typedecimal52DEC((0))YesP15_PRCOM
54XRIC7Component requestchar10CHAR(N' ')YesP15_XRICH Allow NULL? 
55TPCM8Family member typenvarchar20NUMC(N'00')YesT5ITDSP15_TPCOM Allow NULL? 
56NUCA8Number of family dependentnvarchar20NUMC(N'00')YesP15_NUCAR Allow NULL? 
57PRCO8Deduction percentage for family member typedecimal52DEC((0))YesP15_PRCOM
58XRIC8Component requestchar10CHAR(N' ')YesP15_XRICH Allow NULL? 
59TPCM9Family member typenvarchar20NUMC(N'00')YesT5ITDSP15_TPCOM Allow NULL? 
60NUCA9Number of family dependentnvarchar20NUMC(N'00')YesP15_NUCAR Allow NULL? 
61PRCO9Deduction percentage for family member typedecimal52DEC((0))YesP15_PRCOM
62XRIC9Component requestchar10CHAR(N' ')YesP15_XRICH Allow NULL? 
63TPC10Family member typenvarchar20NUMC(N'00')YesT5ITDSP15_TPCOM Allow NULL? 
64NUC10Number of family dependentnvarchar20NUMC(N'00')YesP15_NUCAR Allow NULL? 
65PRC10Deduction percentage for family member typedecimal52DEC((0))YesP15_PRCOM
66XRI10Component requestchar10CHAR(N' ')YesP15_XRICH Allow NULL? 
67TPDE1Deduction typenvarchar20NUMC(N'00')Yes*P15_TPDET Allow NULL? 
68XRTD1Deduction type requestchar10CHAR(N' ')YesP15_XRTDE Allow NULL? 
69TPDE2Deduction typenvarchar20NUMC(N'00')Yes*P15_TPDET Allow NULL? 
70XRTD2Deduction type requestchar10CHAR(N' ')YesP15_XRTDE Allow NULL? 
71TPDE3Deduction typenvarchar20NUMC(N'00')Yes*P15_TPDET Allow NULL? 
72XRTD3Deduction type requestchar10CHAR(N' ')YesP15_XRTDE Allow NULL? 
73TPDE4Deduction typenvarchar20NUMC(N'00')Yes*P15_TPDET Allow NULL? 
74XRTD4Deduction type requestchar10CHAR(N' ')YesP15_XRTDE Allow NULL? 
75TPDE5Deduction typenvarchar20NUMC(N'00')Yes*P15_TPDET Allow NULL? 
76XRTD5Deduction type requestchar10CHAR(N' ')YesP15_XRTDE Allow NULL? 
77TPON1Type of allowable expensenvarchar20NUMC(N'00')Yes*P15_TPONE Allow NULL? 
78XROD1Deductible expenses requestchar10CHAR(N' ')YesP15_XRODE Allow NULL? 
79TPON2Type of allowable expensenvarchar20NUMC(N'00')Yes*P15_TPONE Allow NULL? 
80XROD2Deductible expenses requestchar10CHAR(N' ')YesP15_XRODE Allow NULL? 
81TPON3Type of allowable expensenvarchar20NUMC(N'00')Yes*P15_TPONE Allow NULL? 
82XROD3Deductible expenses requestchar10CHAR(N' ')YesP15_XRODE Allow NULL? 
83TPON4Type of allowable expensenvarchar20NUMC(N'00')Yes*P15_TPONE Allow NULL? 
84XROD4Deductible expenses requestchar10CHAR(N' ')YesP15_XRODE Allow NULL? 
85TPON5Type of allowable expensenvarchar20NUMC(N'00')Yes*P15_TPONE Allow NULL? 
86XROD5Deductible expenses requestchar10CHAR(N' ')YesP15_XRODE Allow NULL? 
87CDALTOther taxation indicatornvarchar40CHAR(N' ')YesT5ITL1P15_CDALT Allow NULL? 
88CDTRERegional tax indicatornvarchar50CHAR(N' ')YesT5ITR5P15_CDTRE Allow NULL? 
89REGIOSpecial status regions and districtsnvarchar30CHAR(N' ')YesT5ITNSP15_REGIO Allow NULL? 
90PROVIRegion (State, Province, County)nvarchar30CHAR(N' ')YesT005SREGIO Allow NULL? 
91CDTPRProvincial tax indicatornvarchar50CHAR(N' ')YesT5ITP5P15_CDTPR Allow NULL? 
92MUNICMunicipality keynvarchar80CHAR(N' ')YesT5ITM4P15_MUNIC Allow NULL? 
93CDTMUMunicipal tax indicatornvarchar60CHAR(N' ')YesT5ITM5P15_CDTMU Allow NULL? 
94CDEDUDeduction indicatorchar10CHAR(N' ')YesP15_CDEDU Allow NULL? 
95DTMINDeduction minimum limit management requestchar10CHAR(N' ')YesP15_DTMIN Allow NULL? 
96FDMINMin. Limit Deduction Management w/o requestchar10CHAR(N' ')YesP15_FDMIN Allow NULL? 
97RDTSSWithdrawal to Overtime Detaxationchar10CHAR(N' ')YesP15_RDTSS Allow NULL? 
98APAIMApplication of a Higher Tax Rate for Income Tax on Soc. Ins.decimal74DEC((0))YesP15_APAIM
99UDEFAPercentage for further large family deductionsdecimal52DEC((0))YesP15_UDEDFA
100RRCFchar10(N' ')Yes Allow NULL? 
NamePrimaryUniqueTypeColumns
PA0156~0YesYesCLUSTEREDSEQNR, BEGDA, ENDDA, SPRPS, OBJPS, SUBTY, 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