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  | PA0651
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
Payroll :: Payroll General Parts :: Reuse Services for Country Development
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0PA06511301HR Master Record Infotype 0651Reuse Services for Country Development
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, KVNAM, KNNAM, KGDAT, WVLDT, WALAZ, STWAG, EFZGD, AEZUS, AEBIS, ZLRHT, ZABRT, ZANTO, KDGAM, KDGRD, KDZUM, VWBET, VWBIS, VWRHT, ZUSAR, ZSBTG, LABEG, LAEND, LABE1, LAEN1, FRNTO, FRGKI, KIBE1, KIEN1, KIBE2, KIEN2, KITA1, KITA2, BRTAE, ANGRD, ANFRT, FALNR, FRABL, FADAT, ENTS1, UNTS1, ENTS2, UNTS2, ENTS3, UNTS3, MON01, MON02, MON03, YEA01, YEA02, YEA03, WAERS, UFTAG, KDGSL, AEUEB, FRBTO, UVTRG, SBRHT, ADRS1, ADRS2, ADRS3, KNDNR, ABMSN, VORER, BEGVE1, ENDVE1, BEGVE2, ENDVE2, AEVZMON, AEVZSTD, WAZTRF, BEGTRF, TRFGEM, MMTRF, VRGTGR, VWLMON, EZTRF, AEENTTRF, VWL, BRUSB, NETSB, UNFAZ, UNFTR, BVALS, ABWGRD, ABWBEG, EAZEND, LBTAG, UMGEWAE, VEBBRU, VEBNET, EZKV, EZRV, EZAV, ANZTG, ANZAT, FRTAG01, FRTAG02, ABWAUS, AEERSTTAG, KUERZFAKT, ANZARBTG, AZUNENT1, AZENTSCH1, AZUNENT2, AZENTSCH2, AZUNENT3, AZENTSCH3 FROM PA0651
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? 
24KVNAMFirst Name of Sick Childnvarchar400CHAR(N' ')YesP01W_KVNAM Allow NULL? 
25KNNAMLast Name of Sick Childnvarchar400CHAR(N' ')YesP01W_KNNAM Allow NULL? 
26KGDATChild's Date of Birthnvarchar80DATS(N'00000000')YesP01W_KGDAT Allow NULL? 
27WVLDTStart of Advance Winter Compensation Benefitnvarchar80DATS(N'00000000')YesP01W_WVLDT Allow NULL? 
28WALAZAdvance Winter Compensation Benefit in Last Payroll Periodchar10CHAR(N' ')YesP01W_WALAZ Allow NULL? 
29STWAGAdvance Winter Compensation Benefit: Number of Hoursdecimal52DEC((0))YesP01W_STWAG
30EFZGDContinued Pay <= 6 Weeks: Reasonsnvarchar300CHAR(N' ')YesP01W_EFZGD Allow NULL? 
31AEZUSAdditional Remunerationchar10NUMC(N'0')YesP01W_AEZUS Allow NULL? 
32AEBISAdditional Remuneration: Tonvarchar80DATS(N'00000000')YesP01W_AEBIS Allow NULL? 
33ZLRHTPayment Frequencychar10CHAR(N' ')YesP01W_ZLRHT Allow NULL? 
34ZABRTAdditional Remuneration: Grossdecimal132CURR((0))YesP01W_ZABRT
35ZANTOAdditional Remuneration: Netdecimal132CURR((0))YesP01W_ZANTO
36KDGAMTermination Onnvarchar80DATS(N'00000000')YesP01W_KDGAM Allow NULL? 
37KDGRDTermination Reasonnvarchar300CHAR(N' ')YesP01W_KDGRD Allow NULL? 
38KDZUMTermination Onnvarchar80DATS(N'00000000')YesP01W_KDZUM Allow NULL? 
39VWBETCapital Formation Savings Payment of Employer: Amountdecimal132CURR((0))YesP01W_VWBET
40VWBISCFS Limited Tonvarchar80DATS(N'00000000')YesP01W_VWBIS Allow NULL? 
41VWRHTCFS - Payment Frequencychar10CHAR(N' ')YesP01W_VWRHT Allow NULL? 
42ZUSARAdditional Payments in Kind: Typenvarchar300CHAR(N' ')YesP01W_ZUSAR Allow NULL? 
43ZSBTGAdditional Payments in Kind: Amountdecimal132CURR((0))YesP01W_ZSBTG
44LABEGBuilding Sector: Wage Compensation Fromnvarchar80DATS(N'00000000')YesP01W_LABEG Allow NULL? 
45LAENDBuilding Sector: Wage Compensation Tonvarchar80DATS(N'00000000')YesP01W_LAEND Allow NULL? 
46LABE1Building Sector: Wage Compensation Fromnvarchar80DATS(N'00000000')YesP01W_LABEG Allow NULL? 
47LAEN1Building Sector: Wage Compensation Tonvarchar80DATS(N'00000000')YesP01W_LAEND Allow NULL? 
48FRNTONet Remuneration on First Day of Release from Workdecimal132CURR((0))YesP01W_FRNTO
49FRGKIRelease from Work Due to Same Childchar10CHAR(N' ')YesP01W_FRGKI Allow NULL? 
50KIBE1Release from Work Due to Illness of Same Child: Start Datenvarchar80DATS(N'00000000')YesP01W_KINBG Allow NULL? 
51KIEN1Release from Work Due to Illness of Same Child: End Datenvarchar80DATS(N'00000000')YesP01W_KINED Allow NULL? 
52KIBE2Release from Work Due to Illness of Same Child: Start Datenvarchar80DATS(N'00000000')YesP01W_KINBG Allow NULL? 
53KIEN2Release from Work Due to Illness of Same Child: End Datenvarchar80DATS(N'00000000')YesP01W_KINED Allow NULL? 
54KITA1Release from Work Due to Illness of Same Child: No. of Daysnvarchar20NUMC(N'00')YesP01W_KINTG Allow NULL? 
55KITA2Release from Work Due to Illness of Same Child: No. of Daysnvarchar20NUMC(N'00')YesP01W_KINTG Allow NULL? 
56BRTAEWorking Timechar10CHAR(N' ')YesP01W_BRTAE Allow NULL? 
57ANGRDEntitlement to Paid Release from Workchar10CHAR(N' ')YesP01W_ANGRD Allow NULL? 
58ANFRTTemporary Entitlement tonvarchar20NUMC(N'00')YesP01W_ANFRT Allow NULL? 
59FALNRCase Numbernvarchar120CHAR(N' ')YesP01W_FALNR Allow NULL? 
60FRABLWork Relationship/Period Expirationchar10CHAR(N' ')YesP01W_FRABL Allow NULL? 
61FADATDate of Period Expirationnvarchar80DATS(N'00000000')YesP01W_FADAT Allow NULL? 
62ENTS1Excused Unpaid Working Hoursdecimal52DEC((0))YesP01W_ENTSC
63UNTS1Unexcused Unpaid Working Hoursdecimal52DEC((0))YesP01W_UNTSC
64ENTS2Excused Unpaid Working Hoursdecimal52DEC((0))YesP01W_ENTSC
65UNTS2Unexcused Unpaid Working Hoursdecimal52DEC((0))YesP01W_UNTSC
66ENTS3Excused Unpaid Working Hoursdecimal52DEC((0))YesP01W_ENTSC
67UNTS3Unexcused Unpaid Working Hoursdecimal52DEC((0))YesP01W_UNTSC
68MON01Date - Monthnvarchar20CHAR(N' ')YesP01W_MONXX Allow NULL? 
69MON02Date - Monthnvarchar20CHAR(N' ')YesP01W_MONXX Allow NULL? 
70MON03Date - Monthnvarchar20CHAR(N' ')YesP01W_MONXX Allow NULL? 
71YEA01Date - Yearnvarchar40CHAR(N' ')YesP01W_YEAXX Allow NULL? 
72YEA02Date - Yearnvarchar40CHAR(N' ')YesP01W_YEAXX Allow NULL? 
73YEA03Date - Yearnvarchar40CHAR(N' ')YesP01W_YEAXX Allow NULL? 
74WAERSCurrency Keynvarchar50CUKY(N' ')YesT500WP01W_WAERS Allow NULL? 
75UFTAGAccident Datenvarchar80NUMC(N'00000000')YesP01W_UFTAG Allow NULL? 
76KDGSLTermination Reasonchar10CHAR(N' ')YesP01W_KDGSL Allow NULL? 
77AEUEBRemuneration Exceeds Comparison Net by More Than EUR 50char10CHAR(N' ')YesP01W_AEUEB Allow NULL? 
78FRBTOGross Remuneration on First Day of Release from Workdecimal132CURR((0))YesP01W_FRBTO
79UVTRGName of Accident Insurance Institutionnvarchar300CHAR(N' ')YesP01W_UVTRG Allow NULL? 
80SBRHTHR-DBS: Payments in Kind - Payment Frequencychar10CHAR(N' ')YesP01W_SBRHT Allow NULL? 
81ADRS1Address linenvarchar800CHAR(N' ')YesLINES Allow NULL? 
82ADRS2Address linenvarchar800CHAR(N' ')YesLINES Allow NULL? 
83ADRS3Address linenvarchar800CHAR(N' ')YesLINES Allow NULL? 
84KNDNRChild Numbernvarchar20CHAR(N' ')YesP01_KNDNR Allow NULL? 
85ABMSNJob-Creating Measurechar10CHAR(N' ')YesP01_ABMSN Allow NULL? 
86VORERContinued Pay for Less Than 6 Weekschar10CHAR(N' ')YesP01_SV_EE_VORER Allow NULL? 
87BEGVE1Start of Imputable Periods of Preexisting Conditions 1nvarchar80DATS(N'00000000')YesP01_SV_EE_BEGVE1 Allow NULL? 
88ENDVE1Imputable Periods of Preexisting Conditions End 1nvarchar80DATS(N'00000000')YesP01_SV_EE_ENDVE1 Allow NULL? 
89BEGVE2Start of Imputable Periods of Preexisting Conditions 2nvarchar80DATS(N'00000000')YesP01_SV_EE_BEGVE2 Allow NULL? 
90ENDVE2Imputable Periods of Preexisting Conditions End 2nvarchar80DATS(N'00000000')YesP01_SV_EE_ENDVE2 Allow NULL? 
91AEVZMONMonthly Full-Time Remuneration in Cal. Month Before Startdecimal82CURR((0))YesP01_SV_EE_AEVZMON2
92AEVZSTDHourly Full-Time Remuneration in Cal. Month Before Startdecimal82CURR((0))YesP01_SV_EE_AEVZSTD2
93WAZTRFWeekly Working Time Agreed by Collective Agreementdecimal52DEC((0))YesP01_SV_EE_WAZTRF2
94BEGTRFCurrently Valid Collective Agreement Ofnvarchar80DATS(N'00000000')YesP01_SV_EE_BEGTRF Allow NULL? 
95TRFGEMDefining Pay Scale Group/Collective Agreementnvarchar200CHAR(N' ')YesP01_SV_EE_TRFGEM Allow NULL? 
96MMTRFDefining Pay Scale Group/Collective Agreementchar10CHAR(N' ')YesP01_SV_EE_MMTRF Allow NULL? 
97VRGTGRRemuneration/Wage Groupnvarchar200CHAR(N' ')YesP01_SV_EE_VRGTGR Allow NULL? 
98VWLMONMonthly Coll. Agr. Capital Form. Savings Payment of Employerdecimal82CURR((0))YesP01_SV_EE_VWLMON2
99EZTRFNon-Recurring Annual Payment Regulated by Collective Agr.decimal82CURR((0))YesP01_SV_EE_EZTRF2
100AEENTTRFRemuneration Corresponds to Collective Agreement Conditionschar10CHAR(N' ')YesP01_SV_EE_AEENTTRF Allow NULL? 
101VWLCapital Formation Savings Payment During Bens for Particptndecimal62CURR((0))YesP01_SV_EE_VWL2
102BRUSBGross Cont. Paymts in Kind/Rem. for PT Work in Mnth d. BfPdecimal82CURR((0))YesP01_SV_EE_BRUSB2
103NETSBNet Cont. Payments in Kind/Rem. PT Wrk d. BfP in Monthdecimal82CURR((0))YesP01_SV_EE_NETSB2
104UNFAZAccident Case Number of Relevant Accident Insurance Carriernvarchar200CHAR(N' ')YesP01_SV_EE_UNFAZ Allow NULL? 
105UNFTRInstitute Indicator of Accident Insurance Carriernvarchar150CHAR(N' ')YesP01_SV_EE_UNFTR Allow NULL? 
106BVALSEmployed asnvarchar300CHAR(N' ')YesP01_SV_EE_BVALS Allow NULL? 
107ABWGRDDifferent Submission Reasonnvarchar20NUMC(N'00')YesP01_SV_EE_ABWGRD Allow NULL? 
108ABWBEGLinked Absencenvarchar80DATS(N'00000000')YesP01_SV_EE_ABWBEG Allow NULL? 
109EAZENDLast Settled Payroll Period 1 Endnvarchar80DATS(N'00000000')YesP01_SV_EE_EAZEND1 Allow NULL? 
110LBTAGLast Paid Daynvarchar80DATS(N'00000000')YesP01_SV_EE_LBTAG Allow NULL? 
111UMGEWAERemuneration Conversiondecimal82CURR((0))YesP01_SV_EE_UMGEWAE2
112VEBBRUAgreed Gross Remunerationdecimal82CURR((0))YesP01_SV_EE_VEBBRU2
113VEBNETNet Remunerationdecimal82CURR((0))YesP01_SV_EE_VEBNET2
114EZKVPart of Non-Recurring Payments Liable for Contr. in HIdecimal82CURR((0))YesP01_SV_EE_EZKV2
115EZRVPart of Non-Recurring Payments Liable for Contr. in PIdecimal82CURR((0))YesP01_SV_EE_EZRV2
116EZAVPart of Non-Recurring Payments Liable for Contr. in UIdecimal82CURR((0))YesP01_SV_EE_EZAV2
117ANZTGNumber of Workdays for Payment of Gross Remunerationnvarchar20NUMC(N'00')YesP01_SV_EE_ANZTG Allow NULL? 
118ANZATNumber of Workdays in Release from Work Periodnvarchar20NUMC(N'00')YesP01_SV_EE_ANZAT Allow NULL? 
119FRTAG01Additional Release from Worknvarchar80DATS(N'00000000')YesP01_SV_EE_FRTAGZ Allow NULL? 
120FRTAG02Additional Release from Worknvarchar80DATS(N'00000000')YesP01_SV_EE_FRTAGZ Allow NULL? 
121ABWAUSTermination During Illnesschar10CHAR(N' ')YesP01_SV_EE_ABWAUS Allow NULL? 
122AEERSTTAGWork on First Day of Incapacity to Work (Y/N)char10CHAR(N' ')YesP01_SV_EE_AEETG Allow NULL? 
123KUERZFAKTReduction Factor in Period of Release from Worknvarchar40NUMC(N'0000')YesP01_SV_EE_KRZFK Allow NULL? 
124ANZARBTGTotal Number of Working Days with Release from Worknvarchar20NUMC(N'00')YesP01_SV_EE_ATAGE Allow NULL? 
125AZUNENT1Unpaid Working Days Not Excused Month 1nvarchar20NUMC(N'00')YesP01_SV_EE_AZUNENTTG1 Allow NULL? 
126AZENTSCH1Unpaid Working Days Excused Month 1nvarchar20NUMC(N'00')YesP01_SV_EE_AZENTTG1 Allow NULL? 
127AZUNENT2Unpaid Working Days Not Excused Month 2nvarchar20NUMC(N'00')YesP01_SV_EE_AZUNENTTG2 Allow NULL? 
128AZENTSCH2Unpaid Working Days Excused Month 2nvarchar20NUMC(N'00')YesP01_SV_EE_AZENTTG2 Allow NULL? 
129AZUNENT3Unpaid Working Days Not Excused Month 3nvarchar20NUMC(N'00')YesP01_SV_EE_AZUNENTTG3 Allow NULL? 
130AZENTSCH3Unpaid Working Days Excused Month 3nvarchar20NUMC(N'00')YesP01_SV_EE_AZENTTG3 Allow NULL? 
NamePrimaryUniqueTypeColumns
PA0651~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