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  | PA0202
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)
8BSEG345Accounting Document Segment
9/1RA/0SD010MI170Items for Class SD01 - Raw Data
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
1ORCT154Incoming Payment
2OITM249Items
3OINV268A/R Invoice
4OIVL77Whse Journal
5OINM101Whse Journal
6OVPM154Outgoing Payments
7OPCH268A/P Invoice
8JDT1110Journal Entry - Rows
9OOCR9Loading Factors
10OSRN20Serial Numbers Master Data
Personnel Management :: Pension Schemes :: Company Pension Scheme Germany
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0PA02021381HR Master Record Infotype 0202 (Entitlements)Company Pension Scheme Germany
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, HANSP, MODBV, LURSP, ANGRP, LTRGR, BETFI, BTFKZ, BETMA, BETMI, ANZHL, ZEINH, TBEGA, TBGDZ, BEGUA, UAVER, STAUA, DATRD, DATUA, DATRG, WZVER, BEGWZ, KZKWZ, MMKWZ, ARTUE, BETUE, DATUE, EWERK, DATRU, RELAB, MITST, MITNR, MGLST, PNRBZ, EINZV, DATMS, BEITR, BEIKZ, BEITR_ABR, BEIKZ_ABR, MODBV_ABR, DZPRZ, RSTGR, KFUNK, LGABZ, ALDAT, VTBET, VTPER, ZNRUA, ZNRGP, ZNRBT, ZNRRB, BTTYP, BTRGL, VZKRZ, VMANR, VMBEG, DZALT, WAERS, ZFPER, ZANZL, JBEWE, JGEVE, BEGAZ, ENDAZ, IDAUS, METH1, LGAG1, VBEL1, VBEE1, SBEL1, SBEE1, PROL1, PROE1, METH2, LGAG2, VBEL2, VBEE2, SBEL2, SBEE2, PROL2, PROE2, METH3, LGAG3, VBEL3, VBEE3, SBEL3, SBEE3, PROL3, PROE3, METH4, LGAG4, VBEL4, VBEE4, SBEL4, SBEE4, PROL4, PROE4, METH5, LGAG5, VBEL5, VBEE5, SBEL5, SBEE5, PROL5, PROE5, METH6, LGAG6, VBEL6, VBEE6, SBEL6, SBEE6, PROL6, PROE6, NVAEG, TLREL FROM PA0202
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? 
24HANSPCompany Pension Scheme Entitlementnvarchar40CHAR(N' ')YesT5DWBP01C_HANSP Allow NULL? 
25MODBVCalculation Variant for Entitlementnvarchar20CHAR(N' ')YesT5DWEP01C_MODBV Allow NULL? 
26LURSPCompany Responsiblenvarchar40CHAR(N' ')YesT5DC3P01C_LURSP Allow NULL? 
27ANGRPPension Plannvarchar40CHAR(N' ')YesT5DWAP01C_ANGRP Allow NULL? 
28LTRGRBenefits Providernvarchar40CHAR(N' ')YesT5DCUP01C_LTRGR Allow NULL? 
29BETFIFixed Amount of Benefitdecimal92CURR((0))YesP01C_BETFI
30BTFKZIndicator for Annual/Monthly Benefitchar10CHAR(N' ')YesP01C_BTFKZ Allow NULL? 
31BETMAMaximum Benefitdecimal92CURR((0))YesP01C_BETMA
32BETMIMinimum Benefitdecimal92CURR((0))YesP01C_BETMI
33ANZHLNumberdecimal72DEC((0))YesANZHL
34ZEINHTime/measurement unitnvarchar30CHAR(N' ')YesT538AP01C_PT_ZEINH Allow NULL? 
35TBEGATechnical Start Date of Entitlementnvarchar80DATS(N'00000000')YesP01C_TBEGA Allow NULL? 
36TBGDZTechnical Start Date for Valuation of Employment Periodnvarchar80DATS(N'00000000')YesP01C_TBGDZ Allow NULL? 
37BEGUATechnical Start Date for Vesting Checknvarchar80DATS(N'00000000')YesP01C_BEGUA Allow NULL? 
38UAVERWaiver VE Checkchar10CHAR(N' ')YesP01C_UAVER Allow NULL? 
39STAUAVesting Statuschar10CHAR(N' ')YesP01C_STAUA Allow NULL? 
40DATRDDifferent Valuation Datenvarchar80DATS(N'00000000')YesP01C_DATRD Allow NULL? 
41DATUAVested Sincenvarchar80DATS(N'00000000')YesP01C_DATUA Allow NULL? 
42DATRGDifferent Rule Datenvarchar80DATS(N'00000000')YesP01C_DATRG Allow NULL? 
43WZVERWaiver of Waiting Period Checkchar10CHAR(N' ')YesP01C_WZVER Allow NULL? 
44BEGWZTechnical Start Date for Waiting Period Checknvarchar80DATS(N'00000000')YesP01C_BEGWZ Allow NULL? 
45KZKWZIndicator for Reduced Waiting Periodchar10CHAR(N' ')YesP01C_KZKWZ Allow NULL? 
46MMKWZMonths of Waiting Period Reductionnvarchar30NUMC(N'000')YesP01C_MMKWZ Allow NULL? 
47ARTUEMethod of Capital Transfer (Sender/Recipient)char10CHAR(N' ')YesP01C_ARTUE Allow NULL? 
48BETUETransferred Capitaldecimal92CURR((0))YesP01C_BETUE
49DATUEDate of Capital Transfernvarchar80DATS(N'00000000')YesP01C_DATUE Allow NULL? 
50EWERKReceiving/Sending Companynvarchar40CHAR(N' ')YesT5DC3P01C_WRKUE Allow NULL? 
51DATRUDate of Reimbursementnvarchar80DATS(N'00000000')YesP01C_DATRU Allow NULL? 
52RELABBase Determination through Payroll Accountingchar10CHAR(N' ')YesP01C_RELAB Allow NULL? 
53MITSTEntitlement Statuschar10CHAR(N' ')YesT5DCVP01C_MITST Allow NULL? 
54MITNRMembership Number/File Numbernvarchar150CHAR(N' ')YesP01C_MITNR Allow NULL? 
55MGLSTMember Statuschar10CHAR(N' ')YesT5DWVP01C_MGLST Allow NULL? 
56PNRBZPersonnel Number of Contribution Payernvarchar80NUMC(N'00000000')YesP01C_PNRBZ Allow NULL? 
57EINZVDebit Procedure for Contributionschar10CHAR(N' ')YesP01C_EINZV Allow NULL? 
58DATMSCreation Date of Membership Certificatenvarchar80DATS(N'00000000')YesP01C_DATMS Allow NULL? 
59BEITRContributiondecimal92CURR((0))YesP01C_BEITR
60BEIKZContribution Indicatorchar10CHAR(N' ')YesP01C_BEIKZ Allow NULL? 
61BEITR_ABRContributiondecimal92CURR((0))YesP01C_BEITR
62BEIKZ_ABRContribution Indicatorchar10CHAR(N' ')YesP01C_BEIKZ Allow NULL? 
63MODBV_ABRCalculation Variant for Entitlementnvarchar20CHAR(N' ')Yes*P01C_MODBV Allow NULL? 
64DZPRZPercentage Rate for Valuation of Employment Perioddecimal52DEC((0))YesP01C_DZPRZ
65RSTGRReserve Groupnvarchar40CHAR(N' ')YesT5DW1P01C_RSTGR Allow NULL? 
66KFUNKFund Functionchar10CHAR(N' ')YesT5DCGP01C_KFUNK Allow NULL? 
67LGABZContribution Retentionchar10CHAR(N' ')YesP01C_LGABZ Allow NULL? 
68ALDATDatenvarchar80DATS(N'00000000')YesP01C_ALDAT Allow NULL? 
69VTBETMaximum Conversiondecimal92CURR((0))YesP01C_VTBET
70VTPERContract Duration in Yearsnvarchar20NUMC(N'00')YesP01C_VTPER Allow NULL? 
71ZNRUAAssignment Number for Vested Entitlementsnvarchar40NUMC(N'0000')YesP01C_ZNRUA Allow NULL? 
72ZNRGPAssignment Number for Vested Paymentsnvarchar40NUMC(N'0000')YesP01C_ZNRGP Allow NULL? 
73ZNRBTAssignment Number for Transfer Records for Cont.Reimbursmntnvarchar40NUMC(N'0000')YesP01C_ZNRBT Allow NULL? 
74ZNRRBAssignment Number for Pension Paymentsnvarchar40NUMC(N'0000')YesP01C_ZNRRB Allow NULL? 
75BTTYPType of Amount Calculationchar10CHAR(N' ')YesP01C_BTTYP Allow NULL? 
76BTRGLRule for Amount Calculationnvarchar40CHAR(N' ')YesP01C_BTRGL Allow NULL? 
77VZKRZWaiver Bonuses/Deductionschar10CHAR(N' ')YesP01C_VZKRZ Allow NULL? 
78VMANRIdentification Number for Assessornvarchar150CHAR(N' ')YesP01C_VMANR Allow NULL? 
79VMBEGFinancing Start for Reservesnvarchar80DATS(N'00000000')YesP01C_VMBEG Allow NULL? 
80DZALTCompensated Employment Yearsdecimal42DEC((0))YesP01C_DZJJA
81WAERSCurrency keynvarchar50CUKY(N' ')YesTCURCP01C_WAERS Allow NULL? 
82ZFPERFirst payment periodnvarchar20NUMC(N'00')YesDZFPER Allow NULL? 
83ZANZLNumber for determining further payment datesdecimal30DEC((0))YesDZANZL
84JBEWEYear for Valuation in Pension Calculationchar10CHAR(N' ')YesP01C_JBEWE Allow NULL? 
85JGEVECalendar Year for First Paymentchar10CHAR(N' ')YesP01C_JGEVE Allow NULL? 
86BEGAZStart of Conversion Periodnvarchar80DATS(N'00000000')YesP01C_BEGAZ Allow NULL? 
87ENDAZEnd of Conversion Periodnvarchar80DATS(N'00000000')YesP01C_ENDAZ Allow NULL? 
88IDAUSRule for Payment Controlnvarchar40CHAR(N' ')YesT5DWXP01C_IDAUS Allow NULL? 
89METH1Method for Calculation of Conversion Amountnvarchar20CHAR(N' ')YesT5DCFP01C_WMETH Allow NULL? 
90LGAG1Wage Type Grouping for Payroll Controlnvarchar20CHAR(N' ')YesT5DC7P01C_LGAGP Allow NULL? 
91VBEL1Maximum Conversiondecimal92CURR((0))YesP01C_VTBET
92VBEE1Maximum Conversiondecimal92CURR((0))YesP01C_VTBET
93SBEL1Base Amountdecimal92CURR((0))YesP01C_SOBET
94SBEE1Base Amountdecimal92CURR((0))YesP01C_SOBET
95PROL1Percentage Rate for Conversiondecimal52DEC((0))YesP01C_WAPRZ
96PROE1Percentage Rate for Conversiondecimal52DEC((0))YesP01C_WAPRZ
97METH2Method for Calculation of Conversion Amountnvarchar20CHAR(N' ')YesT5DCFP01C_WMETH Allow NULL? 
98LGAG2Wage Type Grouping for Payroll Controlnvarchar20CHAR(N' ')YesT5DC7P01C_LGAGP Allow NULL? 
99VBEL2Maximum Conversiondecimal92CURR((0))YesP01C_VTBET
100VBEE2Maximum Conversiondecimal92CURR((0))YesP01C_VTBET
101SBEL2Base Amountdecimal92CURR((0))YesP01C_SOBET
102SBEE2Base Amountdecimal92CURR((0))YesP01C_SOBET
103PROL2Percentage Rate for Conversiondecimal52DEC((0))YesP01C_WAPRZ
104PROE2Percentage Rate for Conversiondecimal52DEC((0))YesP01C_WAPRZ
105METH3Method for Calculation of Conversion Amountnvarchar20CHAR(N' ')YesT5DCFP01C_WMETH Allow NULL? 
106LGAG3Wage Type Grouping for Payroll Controlnvarchar20CHAR(N' ')YesT5DC7P01C_LGAGP Allow NULL? 
107VBEL3Maximum Conversiondecimal92CURR((0))YesP01C_VTBET
108VBEE3Maximum Conversiondecimal92CURR((0))YesP01C_VTBET
109SBEL3Base Amountdecimal92CURR((0))YesP01C_SOBET
110SBEE3Base Amountdecimal92CURR((0))YesP01C_SOBET
111PROL3Percentage Rate for Conversiondecimal52DEC((0))YesP01C_WAPRZ
112PROE3Percentage Rate for Conversiondecimal52DEC((0))YesP01C_WAPRZ
113METH4Method for Calculation of Conversion Amountnvarchar20CHAR(N' ')YesT5DCFP01C_WMETH Allow NULL? 
114LGAG4Wage Type Grouping for Payroll Controlnvarchar20CHAR(N' ')YesT5DC7P01C_LGAGP Allow NULL? 
115VBEL4Maximum Conversiondecimal92CURR((0))YesP01C_VTBET
116VBEE4Maximum Conversiondecimal92CURR((0))YesP01C_VTBET
117SBEL4Base Amountdecimal92CURR((0))YesP01C_SOBET
118SBEE4Base Amountdecimal92CURR((0))YesP01C_SOBET
119PROL4Percentage Rate for Conversiondecimal52DEC((0))YesP01C_WAPRZ
120PROE4Percentage Rate for Conversiondecimal52DEC((0))YesP01C_WAPRZ
121METH5Method for Calculation of Conversion Amountnvarchar20CHAR(N' ')YesT5DCFP01C_WMETH Allow NULL? 
122LGAG5Wage Type Grouping for Payroll Controlnvarchar20CHAR(N' ')YesT5DC7P01C_LGAGP Allow NULL? 
123VBEL5Maximum Conversiondecimal92CURR((0))YesP01C_VTBET
124VBEE5Maximum Conversiondecimal92CURR((0))YesP01C_VTBET
125SBEL5Base Amountdecimal92CURR((0))YesP01C_SOBET
126SBEE5Base Amountdecimal92CURR((0))YesP01C_SOBET
127PROL5Percentage Rate for Conversiondecimal52DEC((0))YesP01C_WAPRZ
128PROE5Percentage Rate for Conversiondecimal52DEC((0))YesP01C_WAPRZ
129METH6Method for Calculation of Conversion Amountnvarchar20CHAR(N' ')YesT5DCFP01C_WMETH Allow NULL? 
130LGAG6Wage Type Grouping for Payroll Controlnvarchar20CHAR(N' ')YesT5DC7P01C_LGAGP Allow NULL? 
131VBEL6Maximum Conversiondecimal92CURR((0))YesP01C_VTBET
132VBEE6Maximum Conversiondecimal92CURR((0))YesP01C_VTBET
133SBEL6Base Amountdecimal92CURR((0))YesP01C_SOBET
134SBEE6Base Amountdecimal92CURR((0))YesP01C_SOBET
135PROL6Percentage Rate for Conversiondecimal52DEC((0))YesP01C_WAPRZ
136PROE6Percentage Rate for Conversiondecimal52DEC((0))YesP01C_WAPRZ
137NVAEGNew Contract under German Pension Tax Lawchar10CHAR(N' ')YesP01A_NVAEG Allow NULL? 
138TLRELSplit Relevancechar10CHAR(N' ')YesP01_VA_TLREL Allow NULL? 
NamePrimaryUniqueTypeColumns
PA0202~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