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  | P2KR_KRSP1
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
1ERP EHP76.0P2KR_KRSP1641Payroll Results Korea: Separation payroll II (Master Data)
SQL:  selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT MANDT, DCT_PERNR, DCT_SEQNR, DCT_ROWID, SEPDT, CRPAY, ADPAY, EXPAY, NAPPR, HPY00, IPY00, SVRPR, DUPPR, CURR1, BUS01, SPY01, HPY01, IPY01, INT01, RET01, SET01, EDT01, LDT01, BUS02, SPY02, HPY02, IPY02, INT02, RET02, SET02, EDT02, LDT02, CURR2, LSPDT, ASVRY, ASVRM, ASVRD, ACSVR, RDSVR, WESVR, TXSVR, SVRHO, VALDT, AGPDT, TXEMP, EXMLS, EXMHO, EXMPC, OVSCT, OSCHO, TEP01, TEP02, RETID, PSPAD, DUPAD, ADJST, DPA01, DPA02, ADDPC, EXMBF, EXMAF, ADDAF, PAYRP, TSVRD FROM P2KR_KRSP1
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2DCT_PERNRPersonnel Numbernvarchar80NUMC(N'00000000')NoP_PERNR Allow NULL? 
3DCT_SEQNRSequence Numbernvarchar50NUMC(N'00000')NoHRPY_RGDIRCDSEQ Allow NULL? 
4DCT_ROWIDUnique Row Numbernvarchar50NUMC(N'00000')NoHRDCT_ROWID Allow NULL? 
5SEPDTSeparation Datenvarchar80DATS(N'00000000')YesPKR_SEPDT Allow NULL? 
6CRPAYCorrection Paydecimal112CURR((0))YesPKR_CRPAY
7ADPAYAdditional paydecimal112CURR((0))YesPKR_ADPAY
8EXPAYExtra Paydecimal112CURR((0))YesPKR_EXPAY
9NAPPRNational pension separation pay convertible amountdecimal112CURR((0))YesPKR_NAPPR
10HPY00Honorary Separation Paydecimal112CURR((0))YesPKR_HPY00
11IPY00Insurance Separation Paydecimal112CURR((0))YesPKR_IPY00
12SVRPRService Period in Previous Companiesnvarchar30NUMC(N'000')YesPKR_SVRPR Allow NULL? 
13DUPPRDuplicated Service Period in Previous Companynvarchar30NUMC(N'000')YesPKR_DUPPR Allow NULL? 
14CURR1Currency Keynvarchar50CUKY(N' ')Yes*WAERS Allow NULL? 
15BUS01Previous Company / Taxpayer Association Business Numbernvarchar120CHAR(N' ')Yes*PKR_BIZNO Allow NULL? 
16SPY01Previous separation paydecimal112CURR((0))YesPKR_SPY01
17HPY01Previous honorary separation paydecimal112CURR((0))YesPKR_HPY01
18IPY01Previous insurance separation paydecimal112CURR((0))YesPKR_IPY01
19INT01Income tax paid in the previous companydecimal92CURR((0))YesPKR_INT01
20RET01Resident tax paid in the previous companydecimal92CURR((0))YesPKR_RET01
21SET01Previous special taxdecimal112CURR((0))YesPKR_SET01
22EDT01Entry date of previous companynvarchar80DATS(N'00000000')YesPKR_EDT01 Allow NULL? 
23LDT01Previous company leave datenvarchar80DATS(N'00000000')YesPKR_LDT01 Allow NULL? 
24BUS02Previous Company / Taxpayer Association Business Numbernvarchar120CHAR(N' ')Yes*PKR_BIZNO Allow NULL? 
25SPY02Previous separation paydecimal112CURR((0))YesPKR_SPY01
26HPY02Previous honorary separation paydecimal112CURR((0))YesPKR_HPY01
27IPY02Previous insurance separation paydecimal112CURR((0))YesPKR_IPY01
28INT02Income tax paid in the previous companydecimal92CURR((0))YesPKR_INT01
29RET02Resident tax paid in the previous companydecimal92CURR((0))YesPKR_RET01
30SET02Previous special taxdecimal112CURR((0))YesPKR_SET01
31EDT02Entry date of previous companynvarchar80DATS(N'00000000')YesPKR_EDT01 Allow NULL? 
32LDT02Previous company leave datenvarchar80DATS(N'00000000')YesPKR_LDT01 Allow NULL? 
33CURR2Currency Keynvarchar50CUKY(N' ')Yes*WAERS Allow NULL? 
34LSPDTSeparation pay base datenvarchar80DATS(N'00000000')YesPKR_LSPDT Allow NULL? 
35ASVRYActual service yearsnvarchar20NUMC(N'00')YesPKR_ASVRY Allow NULL? 
36ASVRMActual service monthsnvarchar20NUMC(N'00')YesPKR_ASVRM Allow NULL? 
37ASVRDActual service daysnvarchar20NUMC(N'00')YesPKR_ASVRD Allow NULL? 
38ACSVRActual service perioddecimal105DEC((0))YesPKR_ACSVR
39RDSVRAdjusted service perioddecimal105DEC((0))YesPKR_RDSVR
40WESVRWeighted service perioddecimal105DEC((0))YesPKR_WESVR
41TXSVRService perid for tax calculationnvarchar20NUMC(N'00')YesPKR_TXSVR Allow NULL? 
42SVRHOService period for tax calculation of honorary paymentnvarchar20NUMC(N'00')YesPKR_SVRHO Allow NULL? 
43VALDTValuation Date of Monthly Average Income for Separation Paynvarchar80DATS(N'00000000')YesPKR_VALDT Allow NULL? 
44AGPDTAgreed Payment Date in case of Mid-separationnvarchar80DATS(N'00000000')YesPKR_AGPDT Allow NULL? 
45TXEMPExemption of Calculated Separation Taxchar10CHAR(N' ')YesPKR_TXEMP Allow NULL? 
46EXMLSExcluded Months for Final Separationnvarchar30NUMC(N'000')YesPKR_EXMLS Allow NULL? 
47EXMHOExcluded Months for Total Separation Paymentnvarchar30NUMC(N'000')YesPKR_EXMHO Allow NULL? 
48EXMPCExcluded Months for Mid-Separationnvarchar30NUMC(N'000')YesPKR_EXMPC Allow NULL? 
49OVSCTTax Credit for Overseadecimal92CURR((0))YesPKR_OVSCT
50OSCHOTax Credit for Oversea Honorabledecimal92CURR((0))YesPKR_OSCHO
51TEP01Tax Exemption in Previous Separation Paymentchar10CHAR(N' ')YesPKR_TXEPR Allow NULL? 
52TEP02Tax Exemption in Previous Separation Paymentchar10CHAR(N' ')YesPKR_TXEPR Allow NULL? 
53RETIDRetirement Reasonnvarchar20CHAR(N' ')Yes*PKR_RETID Allow NULL? 
54PSPADAdjusted Previous Service Periodnvarchar30NUMC(N'000')YesPKR_PSPAD Allow NULL? 
55DUPADAdjusted Duplicated Service Periodnvarchar30NUMC(N'000')YesPKR_DUPAD Allow NULL? 
56ADJSTInfotype Subtypechar10CHAR(N' ')YesPKR_ADJST Allow NULL? 
57DPA01Contribution Amountdecimal112CURR((0))YesPKR_DEPAM
58DPA02Contribution Amountdecimal112CURR((0))YesPKR_DEPAM
59ADDPCAdded Months Before 2013nvarchar30NUMC(N'000')YesPKR_ADDPC Allow NULL? 
60EXMBFExcluded Months Before 2013nvarchar30NUMC(N'000')YesPKR_EXMBF Allow NULL? 
61EXMAFExcluded Months After 2013nvarchar30NUMC(N'000')YesPKR_EXMAF Allow NULL? 
62ADDAFAdded Months After 2013nvarchar30NUMC(N'000')YesPKR_ADDAF Allow NULL? 
63PAYRPApplicable to Retirement Pensionchar10CHAR(N' ')YesPKR_PAYRP Allow NULL? 
64TSVRDTotal Service Daysnvarchar50NUMC(N'00000')YesPKR_TSVRD Allow NULL? 
NamePrimaryUniqueTypeColumns
P2KR_KRSP1~0YesYesCLUSTEREDDCT_ROWID, DCT_SEQNR, DCT_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