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  | PA0785
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 :: Germany :: Public Sector :: Pension Administration
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0PA0785591HR Master Record Infotype 0785Pension Administration
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, DATUM_RECHTSKR, DATUM_ANFRAGE, INDV_ERH_VHS, MIT_RGVH_F2003, ABW_GERICHT, ABW_ADRNR_GER, ABW_AKTENZ, ART_VERFAHREN, VERS_AUSGLEICH, BEGR_BETRAG, BEGR_BETRAG_WAER, DATUM_WIRKSAM_AB, VERS_NR_EHEGATTE, RENTENVERS, TRFGB, TRFGR90, TRFST90, TRFAR90, TRFGB90, SUZUL90, MAN_KAPBETR_P58, MAN_KAPBETR_WAER, KEINE_INDV_ERH, INDV_ERH_VHS08, SUZUL08, KEINE_INDV_ERH08, TRFAR08, TRFGB08, TRFGR08, TRFST08, TRFAR_ENDE_EHE, TRFGB_ENDE_EHE, TRFGR_ENDE_EHE, TRFST_ENDE_EHE, PERNR_ANSPR_BER, GRDL_TEILUNG FROM PA0785
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? 
24DATUM_RECHTSKRDate: Legally Binding Fromnvarchar80DATS(N'00000000')YesPDE_PBSVAVG_P57_DATE_RECHTSKR Allow NULL? 
25DATUM_ANFRAGEDate: Query Fromnvarchar80DATS(N'00000000')YesPDE_PBSVAVG_P57_DATE_ANFRAGE Allow NULL? 
26INDV_ERH_VHSIndividual Percentage Increase (Manual)decimal52DEC((0))YesPDE_PBSVAVG_P57_INDV_ERH_VHS
27MIT_RGVH_F2003With Pension Percentage Version 2003char10CHAR(N' ')YesPDE_PBSVAVG_P57_MIT_RGVH_F2003 Allow NULL? 
28ABW_GERICHTDifferent Court (Municipal/Regional Court of Appeal/Fed.Sup)nvarchar20CHAR(N' ')YesPDE_PBSVAVG_P57_ABW_GERICHT Allow NULL? 
29ABW_ADRNR_GERAlternative Address Number of Courtnvarchar100CHAR(N' ')Yes*PDE_PBSVAVG_P57_ABW_ADRNR_GER Allow NULL? 
30ABW_AKTENZOther Case Number of Pension Equalization Paymentnvarchar200CHAR(N' ')YesPDE_PBSVAVG_P57_ABW_AKTENZ Allow NULL? 
31ART_VERFAHRENType of Court Hearingnvarchar20CHAR(N' ')YesPDE_PBSVAVG_P57_ART_VERFAHREN Allow NULL? 
32VERS_AUSGLEICHPension Equalization Paymentnvarchar20CHAR(N' ')YesPDE_PBSVAVG_P57_VERS_AUSGLEICH Allow NULL? 
33BEGR_BETRAGEqualization Valuedecimal92CURR((0))YesPDE_PBSVAVG_P57_BEGR_BETRAG
34BEGR_BETRAG_WAERCurrency Keynvarchar50CUKY(N' ')YesT500WWAERS Allow NULL? 
35DATUM_WIRKSAM_ABEffective from Datenvarchar80DATS(N'00000000')YesPDE_PBSVAVG_P57_DATE_WIRKS_AB Allow NULL? 
36VERS_NR_EHEGATTEInsurance Policy Number of Spousenvarchar140CHAR(N' ')YesPDE_PBSVAVG_P57_VERSICH_NUM Allow NULL? 
37RENTENVERSPension Insurancenvarchar20CHAR(N' ')YesPDE_PBSVAVG_P57_RENTENVERS Allow NULL? 
38TRFGBPay Scale Area for Pensionnvarchar20CHAR(N' ')YesT510GPDE_PBSVAVG_P57_TRFGB_RENTE Allow NULL? 
39TRFGR90PS Group at End of Marriage for Individual Increase 1990nvarchar80CHAR(N' ')YesT510PDE_PBSVAVG_P57_TRFGR90 Allow NULL? 
40TRFST90Pay Scale Level at End of Marriage for Indiv. Increase 1990nvarchar20CHAR(N' ')YesT510PDE_PBSVAVG_P57_TRFST90 Allow NULL? 
41TRFAR90Pay Scale Type at End of Marriage for Indiv. Increase 1990nvarchar20CHAR(N' ')YesT510APDE_PBSVAVG_P57_TRFAR90 Allow NULL? 
42TRFGB90Pay Scale Area at End of Marriage Ind. Increase 1990nvarchar20CHAR(N' ')YesT510GPDE_PBSVAVG_P57_TRFGB90 Allow NULL? 
43SUZUL90Total of Other Bonuses 1990decimal92DEC((0))YesPDE_PBSVAVG_P57_SUZUL90
44MAN_KAPBETR_P58Manually Entered Prevention Amountdecimal92CURR((0))YesPDE_PBSVAVG_P57_KAPBTR_P58_MAN
45MAN_KAPBETR_WAERCurrency Keynvarchar50CUKY(N' ')YesT500WWAERS Allow NULL? 
46KEINE_INDV_ERHNo Individual Increase 1990char10CHAR(N' ')YesPDE_PBSVAVG_P57_KEINE_INDV_ERH Allow NULL? 
47INDV_ERH_VHS08Individual Percentage Increase (Manual)decimal52DEC((0))YesPDE_PBSVAVG_P57_INDV_ERH_VHS08
48SUZUL08Total of Other Bonusesdecimal92DEC((0))YesPDE_PBSVAVG_P57_SUZUL08
49KEINE_INDV_ERH08No Individual Increasechar10CHAR(N' ')YesPDE_PBSVAVG_P57_KEINE_IN_ERH08 Allow NULL? 
50TRFAR08PS Type at End of Marriage/Partnership for Indiv. Increasenvarchar20CHAR(N' ')YesT510APDE_PBSVAVG_P57_TRFAR08 Allow NULL? 
51TRFGB08PS Area at End of Marriage/Partnership for Indiv. Increasenvarchar20CHAR(N' ')YesT510GPDE_PBSVAVG_P57_TRFGB08 Allow NULL? 
52TRFGR08PS Group at End of Marriage/Partnership for Indiv. Increasenvarchar80CHAR(N' ')YesT510PDE_PBSVAVG_P57_TRFGR08 Allow NULL? 
53TRFST08PS Level at End of Marriage/Partnership for Indiv. Increasenvarchar20CHAR(N' ')YesT510PDE_PBSVAVG_P57_TRFST08 Allow NULL? 
54TRFAR_ENDE_EHEPay Scale Type on Date of End of Marriage/Partnershipnvarchar20CHAR(N' ')YesT510APDE_PBSVAVG_P57_TRFAR Allow NULL? 
55TRFGB_ENDE_EHEPay Scale Area on Date of End of Marriage/Partnershipnvarchar20CHAR(N' ')YesT510GPDE_PBSVAVG_P57_TRFGB Allow NULL? 
56TRFGR_ENDE_EHEPay Scale Group on Date of End of Marriage/Partnershipnvarchar80CHAR(N' ')YesT510PDE_PBSVAVG_P57_TRFGR Allow NULL? 
57TRFST_ENDE_EHEPay Scale Level on Date of End of Marriage/Partnershipnvarchar20CHAR(N' ')YesT510PDE_PBSVAVG_P57_TRFST Allow NULL? 
58PERNR_ANSPR_BERPers. No. of Person Entitled to Pension Equalization Paymentnvarchar80NUMC(N'00000000')YesPDE_PBSVAVG_P57_PNR_ANSPR_BER Allow NULL? 
59GRDL_TEILUNGLegal Basis Distributionnvarchar20CHAR(N' ')YesPDE_PBSVAVG_P57_GRDL_TEILUNG Allow NULL? 
NamePrimaryUniqueTypeColumns
PA0785~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