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  | P2RK_GRDBT
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.0P2RK_GRDBT501Payroll results Canada: Garnishment debt
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, IONUM, OBJPS, DBCOD, LGART, DBCAT, CRCOD, CRSPY, CRARR, INSID, IDBAL, IDOPA, IDOPU, ABPAY, ABREM, ACPRP, AMTOD, AYTOD, ATTOD, DMTOD, DMTDL, DMAIN, DARRS, AREQR, APNOW, APPRE, APADD, APNXM, APVEN, GCURR, GCPRP, GMTOD, NCURR, NCPRP, NMTOD, XCURR, XXTND, NXUNA, IGRNP, REPRI, RECSE, RESID, REWID, TCPRP, TMTOD, EXPNT, HISTORIC FROM P2RK_GRDBT
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? 
5IONUMInternal order numbernvarchar40NUMC(N'0000')YesP_IONUM Allow NULL? 
6OBJPSGarnishment: OBJPS by which debts are distinguishednvarchar20CHAR(N' ')YesP_GRNOBJPS Allow NULL? 
7DBCODDebt codenvarchar20CHAR(N' ')Yes*P_DBCOD Allow NULL? 
8LGARTWage type for the debtnvarchar40CHAR(N' ')Yes*P_DBLGA Allow NULL? 
9DBCATFundamental type of debtchar10CHAR(N' ')YesP_DBCAT Allow NULL? 
10CRCODCode for calculation rulenvarchar30CHAR(N' ')Yes*P_CRCOD Allow NULL? 
11CRSPYShould special pay be excluded from garnishment?char10CHAR(N' ')YesP_CRSPY Allow NULL? 
12CRARRShould arrears be accumulated indefinitely?char10CHAR(N' ')YesP_CRARR Allow NULL? 
13INSIDGarnishment: Insert indicator for payroll result of debtchar10CHAR(N' ')YesP_GRNINSID Allow NULL? 
14IDBALInitial balancedecimal92CURR((0))YesPCA_IDBAL
15IDOPAAmount of ongoing paymentdecimal92CURR((0))YesPCA_IDOPA
16IDOPUUnit of ongoing paymentchar10CHAR(N' ')YesPCA_IDOPU Allow NULL? 
17ABPAYGarnishment: paid balancedecimal112CURR((0))YesPCA_GABPAY
18ABREMGarnishment: remaining balancedecimal112CURR((0))YesPCA_GABREM
19ACPRPGarnishment: amount paid in current payroll perioddecimal112CURR((0))YesPCA_GACPRP
20AMTODGarnishment: amount paid from beginning of month to datedecimal112CURR((0))YesPCA_GAMTOD
21AYTODGarnishment: amount paid from beginning of year to datedecimal112CURR((0))YesPCA_GAYTOD
22ATTODGarnishment: total amount paid to datedecimal112CURR((0))YesPCA_GATTOD
23DMTODGarnishment: difference accumulated month to datedecimal112CURR((0))YesPCA_GDMTOD
24DMTDLGarnishment: difference accumulated month to date in last PPdecimal112CURR((0))YesPCA_GDMTDL
25DMAINGarn.: Diff between amount requested and paid for main debtdecimal112CURR((0))YesPCA_GDMAIN
26DARRSGarnishment: Arrears accumulated indefinitelydecimal112CURR((0))YesPCA_GDARRS
27AREQRGarnishment: amount requested in current payroll rundecimal112CURR((0))YesPCA_GAREQR
28APNOWGarnishment: amount paid nowdecimal112CURR((0))YesPCA_GAPNOW
29APPREGarnishment: amount paid for previous higher-priority debtsdecimal112CURR((0))YesPCA_GAPPRE
30APADDGarnishment: amount paid for additional paymentdecimal112CURR((0))YesPCA_GAPADD
31APNXMGarnishment: amount paid from completely non-exempt moneydecimal112CURR((0))YesPCA_GAPNXM
32APVENGarnishment: amount paid to vendordecimal112CURR((0))YesPCA_GAPVEN
33GCURRGarnishment: current grossdecimal112CURR((0))YesPCA_GGCURR
34GCPRPGarnishment: gross summed over current payroll perioddecimal112CURR((0))YesPCA_GGCPRP
35GMTODGarnishment: gross summed month to datedecimal112CURR((0))YesPCA_GGMTOD
36NCURRGarnishment: current netdecimal112CURR((0))YesPCA_GNCURR
37NCPRPGarnishment: net summed over current payroll perioddecimal112CURR((0))YesPCA_GNCPRP
38NMTODGarnishment: net summed month to datedecimal112CURR((0))YesPCA_GNMTOD
39XCURRGarnishment: current non-exempt amountdecimal112CURR((0))YesPCA_GXCURR
40XXTNDGarnishment: extended non-exempt amountdecimal112CURR((0))YesPCA_GXXTND
41NXUNAUnit of amount value in non-exempt calculationchar10CHAR(N' ')YesPCA_NXUNA Allow NULL? 
42IGRNPGarnishment: indicator that a payment has been madechar10CHAR(N' ')YesPCA_GIGRNP Allow NULL? 
43REPRIPriority of the debt in relation to other debtsnvarchar30NUMC(N'000')YesPCA_REPRI Allow NULL? 
44RECSESpecial cases for relation of debt to other debtschar10CHAR(N' ')YesPCA_RECSE Allow NULL? 
45RESIDIndicator on how debt is sorted in relation to other debtschar10CHAR(N' ')YesPCA_RESID Allow NULL? 
46REWIDIndicator on how debt is weighted in relation to other debtschar10CHAR(N' ')YesPCA_REWID Allow NULL? 
47TCPRPGarn.: total paid by higher-priority debts in current PayPerdecimal112CURR((0))YesPCA_GTCPRP
48TMTODGarn.: total paid by higher-priority debts in monthdecimal112CURR((0))YesPCA_GTMTOD
49EXPNTGarnishment payroll: Pointer to entry in ext. table for debtvarbinary20RAWYesPCA_EXPNT
50HISTORICHistoric data flagchar10CHAR(N' ')YesPCA_HIST Allow NULL? 
NamePrimaryUniqueTypeColumns
P2RK_GRDBT~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