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  | PA0483
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.0PA04831051Infotype 0483 - Data entry from CAAF - Italy onlyItaly
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, ANNOF, COFIS, CORIT, ITWAE, IMTIR, IMTSS, ACTSE, IMRIR, IMRSS, RAAC1, RAAC2, NRATE, CRED1, IMTRD, CREC1, IMTRC, IMTRT, CRED2, IMRRD, CREC2, IMRRC, IMRRT, ACTSD, ACTSC, CELD1, IMTCD, CELC1, IMTCC, IMTCT, CELD2, IMRCD, CELC2, IMRCC, IMRCT, ENDDATA, RAAC1D, RAAC1C, RAAC2D, RAAC2C, TIPOC, TIPOR, BLOAC, NOCON, INTEG, DATAC, IMTIRD, IMTIRC, IMRIRD, IMRIRC, AACOMD, AACOMC, AACOM, CAACD, CAACC, CONGLR, CONGLT, ISLSD, ISLSC, ISLST, RSLSD, RSLSC, RSLST, RACTD, RACTC, RACTE, ISLOD, ISLOC, RISLD, RISLC, TIPOA, CETSLD, CETSLC, CERSLD, CERSLC, RASL1D, RASL1C, RASL2D, RASL2C, CONTSTD, CONTSTC, RCSOD, RCSOC FROM PA0483
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')No*MANDT 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? 
24ANNOFYear storednvarchar40NUMC(N'0000')YesKJAHR Allow NULL? 
25COFISTax number of the fiscal office (CAF) that provided supportnvarchar160CHAR(N' ')YesT5ITPCP15_COFIS Allow NULL? 
26CORITCorrection Month for Adjustment or Late Tax Declarationnvarchar20CHAR(N' ')YesP15_CORIT Allow NULL? 
27ITWAECurrency Key for Italynvarchar50CUKY(N' ')YesT500WPB15_WAERS Allow NULL? 
28IMTIRAmount to withhold IRPEFdecimal122CURR((0))YesP15_IMTIR
29IMTSSAmount to withhold CSSNdecimal122CURR((0))YesP15_IMTSS
30ACTSESeparate taxation instalmentdecimal122CURR((0))YesP15_ACTSE
31IMRIRAmount to be refunded IRPEFdecimal122CURR((0))YesP15_IMRIR
32IMRSSAmount to be refunded CSSNdecimal122CURR((0))YesP15_IMRSS
33RAAC11st IRPEF down payment instalment - Tax payer + husband/wifedecimal122CURR((0))YesP15_1RAAC
34RAAC2Second or only IRPEF advance instalmentdecimal122CURR((0))YesP15_2RAAC
35NRATENo.of instalments for settl.payments and poss.down paymentsnvarchar30NUMC(N'000')YesP15_NRATE Allow NULL? 
36CRED1Declarant Regional Code for Deduction Purposesnvarchar20NUMC(N'00')YesP15_CRED1 Allow NULL? 
37IMTRDRegional Surcharge to Deduct - Declarantdecimal122CURR((0))YesP15_IMTRD
38CREC1Spouse Regional Code for Deduction Purposesnvarchar20NUMC(N'00')YesP15_CREC1 Allow NULL? 
39IMTRCRegional Surcharge to Deduct - Spousedecimal122CURR((0))YesP15_IMTRC
40IMTRTAmount to withhold - total local additional chargedecimal122CURR((0))YesP15_IMTRT
41CRED2Declarant Regional Code for Refund Purposesnvarchar20NUMC(N'00')YesP15_CRED2 Allow NULL? 
42IMRRDRegional Surcharge to Refund - Declarantdecimal122CURR((0))YesP15_IMRRD
43CREC2Spouse Regional Code for Refund Purposesnvarchar20NUMC(N'00')YesP15_CREC2 Allow NULL? 
44IMRRCRegional Surcharge to Refund - Spousedecimal122CURR((0))YesP15_IMRRC
45IMRRTTotal local additional charge to refunddecimal122CURR((0))YesP15_IMRRT
46ACTSDSeparate Taxation Advance Pay - Declarantdecimal122CURR((0))YesP15_ACTSD
47ACTSCSeparate Taxation Advance Pay - Spousedecimal122CURR((0))YesP15_ACTSC
48CELD1Cadastral indicator for Munic.Surch. - Declarant and Spousenvarchar40CHAR(N' ')YesP15_CENLO Allow NULL? 
49IMTCDMunicipal Surcharge to Deduct - Declarantdecimal122CURR((0))YesP15_IMTCD
50CELC1Cadastral indicator for Munic.Surch. - Declarant and Spousenvarchar40CHAR(N' ')YesP15_CENLO Allow NULL? 
51IMTCCMunicipal Surcharge to Deduct - Spousedecimal122CURR((0))YesP15_IMTCC
52IMTCTTotal District Additional Charge to be withhelddecimal122CURR((0))YesP15_IMTCT
53CELD2Cadastral indicator for Munic.Surch. - Declarant and Spousenvarchar40CHAR(N' ')YesP15_CENLO Allow NULL? 
54IMRCDMunicipal Surcharge to refund - Declarantdecimal122CURR((0))YesP15_IMRCD
55CELC2Cadastral indicator for Munic.Surch. - Declarant and Spousenvarchar40CHAR(N' ')YesP15_CENLO Allow NULL? 
56IMRCCMunicipal Surcharge to refund - Spousedecimal122CURR((0))YesP15_IMRCC
57IMRCTTotal District Additional Amount to refunddecimal122CURR((0))YesP15_IMRCT
58ENDDATACenter for Fiscal Assistance (CAF) validity endnvarchar80DATS(N'00000000')YesP15_ENDDA Allow NULL? 
59RAAC1DFirst IRPEF advance installment - Declarantdecimal122CURR((0))YesP15_1RAACD
60RAAC1C1st Installment IRPEF Advance Pay - Spousedecimal122CURR((0))YesP15_1RAACC
61RAAC2D2nd or Single IRPEF Advance Installment - Declarantdecimal122CURR((0))YesP15_2RAACD
62RAAC2C2nd or single IRPEF advance installment - Spousedecimal122CURR((0))YesP15_2RAACC
63TIPOCSettlement typechar10CHAR(N' ')YesP15_TIPOC Allow NULL? 
64TIPORAdjustment typechar10CHAR(N' ')YesP15_TIPOR Allow NULL? 
65BLOACCAF: down payment blockchar10CHAR(N' ')YesP15_BLOAC Allow NULL? 
66NOCONCAF: settlement was not carried outchar10CHAR(N' ')YesP15_NOCON Allow NULL? 
67INTEGType of Integration 730char10CHAR(N' ')YesP15_INTEG Allow NULL? 
68DATACUploading date of CAF datanvarchar80DATS(N'00000000')YesP15_DATAL Allow NULL? 
69IMTIRDIRPEF amount to be withheld for declarantdecimal122CURR((0))YesP15_IMTIRD
70IMTIRCIRPEF amount to be withheld for declarant's spousedecimal122CURR((0))YesP15_IMTIRC
71IMRIRDIRPEF amount to be refunded to declarantdecimal122CURR((0))YesP15_IMRIRD
72IMRIRCIRPEF amount to be refunded to declarant's spousedecimal122CURR((0))YesP15_IMRIRC
73AACOMDMunicipal Surcharge Advance Pay to IRPEF for Declarantdecimal122CURR((0))YesP15_AACOMD
74AACOMCMunicipal Surcharge Advance Pay to IRPEF for Spousedecimal122CURR((0))YesP15_AACOMC
75AACOMTotal PIT Municipal Surcharge Down Paymentdecimal122CURR((0))YesP15_AACOM
76CAACDMunicipal surcharge down payment indicator for declarantnvarchar40CHAR(N' ')YesP15_CAACD Allow NULL? 
77CAACCMunicipal surcharge down payment indicator for spousenvarchar40CHAR(N' ')YesP15_CAACC Allow NULL? 
78CONGLRTax Declaration to be done in July - Refunddecimal122CURR((0))YesP15_CONGLR
79CONGLTTax Declaration to be done in July - Deductiondecimal122CURR((0))YesP15_CONGLT
80ISLSDSubstitution Tax for Extra Work - Declarantdecimal122CURR((0))YesP15_ISLSD
81ISLSCSubstitute Tax for Extra Work - Spousedecimal122CURR((0))YesP15_ISLSC
82ISLSTSubstitution Tax for Extra Work (Total)decimal122CURR((0))YesP15_ISLST
83RSLSDSubstitution Tax Refund for Extra Work (730 Int.) - Decl.decimal122CURR((0))YesP15_RSLSD
84RSLSCSubstitution Tax Refund for Extra Work (730 Int.) - Spousedecimal122CURR((0))YesP15_RSLSC
85RSLSTSubstitute Tax Refund for Extra Work (Total)decimal122CURR((0))YesP15_RSLST
86RACTDAdvance Pay Refund on Sep.Taxation (730 Integr.) Declarantdecimal122CURR((0))YesP15_RACTD
87RACTCAdvance Pay Refund on Sep. Taxation (730 Integr.) - Spousedecimal122CURR((0))YesP15_RACTC
88RACTEAdvance Payment Refund on Separate Taxation (Total)decimal122CURR((0))YesP15_RACTE
89ISLODDeclarant rent substitute taxdecimal122CURR((0))YesHRPAYIT_IMP_SOS_LOC_DICH
90ISLOCSpouse rent substitute taxdecimal122CURR((0))YesHRPAYIT_IMP_SOS_LOC_CON
91RISLDDeclarant rent substitute tax refunddecimal122CURR((0))YesHRPAYIT_RIM_IMP_SOS_LOC_DICH
92RISLCSpouse rent substitute tax refunddecimal122CURR((0))YesHRPAYIT_RIM_IMP_SOS_LOC_CON
93TIPOAAdjustment special conditionschar10CHAR(N' ')YesP15_TIPOA Allow NULL? 
94CETSLDFlat Tax on rental income to be deducted to declarantdecimal122CURR((0))YesHRPAYIT_IMP_SEC_LOC_DICH
95CETSLCFlat tax on rental inc. to be deducted to spouse FlTxRIDedSpdecimal122CURR((0))YesHRPAYIT_IMP_SEC_LOC_CON
96CERSLDRefund of flat tax on rental income Declarantdecimal122CURR((0))YesHRPAYIT_RIM_IMP_SEC_LOC_DICH
97CERSLCRefund of spouse flat tax on rental incomedecimal122CURR((0))YesHRPAYIT_RIM_IMP_SEC_LOC_CON
98RASL1D1st adv. payment installment of Flat Tax on rent.inc. -Decl.decimal122CURR((0))YesHRPAYIT_1RA_SEC_LOC_DICH
99RASL1CFirst adv. payment installment Flat Tax on rent.inc.- Spousedecimal122CURR((0))YesHRPAYIT_1RA_SEC_LOC_CON
100RASL2DSecond AdvPaymInst of flat tax on rental income - Declarantdecimal122CURR((0))YesHRPAYIT_2RA_SEC_LOC_DICH
101RASL2CSecond AP installment of flat tax on rental income - Spousedecimal122CURR((0))YesHRPAYIT_2RA_SEC_LOC_CON
102CONTSTDSolidarity contribution to be deducted - Declarantdecimal122CURR((0))YesHRPAYIT_CON_SOL_DICH
103CONTSTCSolidarity contribution to be deducted - Spousedecimal122CURR((0))YesHRPAYIT_CON_SOL_CON
104RCSODSolidarity Contribution refund - Declarantdecimal122CURR((0))YesHRPAYIT_RIM_SOL_DICH
105RCSOCSolidarity Contribution refund - Spousedecimal122CURR((0))YesHRPAYIT_RIM_SOL_CON
NamePrimaryUniqueTypeColumns
PA0483~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