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

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)
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9BSEG345Accounting Document Segment
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
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OINM101Whse Journal
10OSRN20Serial Numbers Master Data

60 columns | Print definition?ERP 6.0  | BTZNR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1HRPADNLP_LOGIMMENL Pens: Immediate Payments - log for Payroll Process7BTZNRAssignment of Transfersvarbinary10
2P2BR_GRRECAlimony record12BTZNRAssignment of Transfersvarbinary10
3P2CN_CNREIPayroll result: structure for retro difference details16BTZNRAssignment of Bank Transfersvarbinary10
4P2CN_CNREOPayroll result: structure for retro difference details16BTZNRAssignment of Bank Transfersvarbinary10
5P2CO_COAVAPC2CO_AVA30BTZNRAssignment of Bank Transfersvarbinary10
6P2HK_RETIPayroll structure for retroactive accounting18BTZNRAssignment of Bank Transfersvarbinary10
7P2HK_RETOPayroll structure for retroactive accounting18BTZNRAssignment of Bank Transfersvarbinary10
8P2IS_RETIPayroll structure for retroactive accounting18BTZNRAssignment of Bank Transfersvarbinary10
9P2IS_RETOPayroll structure for retroactive accounting18BTZNRAssignment of Bank Transfersvarbinary10
10P2MX_GRRECMaintenance Payment payroll results16BTZNRAssignment of Transfersvarbinary10
11P2NZ_SALSACSalary Sacrifice Details15BTZNRAssignment of Bank Transfersvarbinary10
12P2RA_DFRTPayroll Result for Other Payroll Periods16BTZNRAssignment of Bank Transfersvarbinary10
13P2RB_BEEVLPayroll Results: Belgium table for Evaluation14BTZNRAssignment of Bank Transfersvarbinary10
14P2RE_GARNTPayroll result: Garnishments (Spain)17BTZNRAssignment of Transfersvarbinary10
15P2RH_HU_HKIFP21PB13BTZNRAssignment of Bank Transfersvarbinary10
16P2RI_IPCUMRI cluster structure for cumulations (IPCUM)13BTZNRAssignment of Bank Transfersvarbinary10
17P2RI_ITIOTRI cluster structure for retroactive accounting15BTZNRAssignment of Bank Transfersvarbinary10
18P2RQ_HTPayroll Results: Results Table13BTZNRAssignment of Bank Transfersvarbinary10
19P2RQ_NTPayroll Results: Results Table13BTZNRAssignment of Bank Transfersvarbinary10
20P2RQ_SMTHSMTH and SQTR for Superannuation (Australia)13BTZNRAssignment of Bank Transfersvarbinary10
21P2RQ_SQTRSMTH and SQTR for Superannuation (Australia)13BTZNRAssignment of Bank Transfersvarbinary10
22P2RR_SRTPayroll Results: Results Table13BTZNRAssignment of Bank Transfersvarbinary10
23P2RX_BTPayroll Results: Bank Transfers5BTZNRAssignment of Transfersvarbinary10
24P2RX_BT_PERSONPayment-Related Information (Person)7BTZNRAssignment of Transfersvarbinary10
25P2RX_CODISTDistribution opf Liabilities15BTZNRAssignment of Bank Transfersvarbinary10
26P2RX_GRTPayroll Results: Results Table13BTZNRAssignment of Bank Transfersvarbinary10
27P2RX_RTPayroll Results: Results Table13BTZNRAssignment of Bank Transfersvarbinary10
28P2RX_RT_PERSONResults Table (Person)17BTZNRAssignment of Bank Transfersvarbinary10
29P2TN_TWOTPayroll Results: Results Table13BTZNRAssignment of Bank Transfersvarbinary10
30P2UA_UARFStructure for Ukrainian social insurance(PF) calculation16BTZNRAssignment of Bank Transfersvarbinary10
31P2UA_UARTPayroll Results: Results Table13BTZNRAssignment of Bank Transfersvarbinary10
32P2UA_UATIStructure for Ukrainian social insurance(PF) calculation17BTZNRAssignment of Bank Transfersvarbinary10
33P2UA_UATRStructure for Ukrainian social insurance(PF) calculation17BTZNRAssignment of Bank Transfersvarbinary10
34P2UA_UATSStructure for Ukrainian social insurance(PF) calculation17BTZNRAssignment of Bank Transfersvarbinary10
35P2UN_HTPayroll Results: Results Table13BTZNRAssignment of Bank Transfersvarbinary10
36P2UN_NTPayroll Results: Results Table13BTZNRAssignment of Bank Transfersvarbinary10
37P2UR_RURTPayroll Results: Results Table13BTZNRAssignment of Bank Transfersvarbinary10
38T5FDSNPAYMTemp table for PAYFR_RESULT-PAYM12BTZNRAffectation virementsvarbinary10
39T77PAYKZBTBank Transfer Table Image (BTKZ)22BTZNRAssignment of Transfersvarbinary10
TOPAustria
40HRPAYAT_PAYRSRESSaves Wage Types from Simulated Payroll Results14BTZNRAssignment of Bank Transfersvarbinary10
TOPCompany Pension Scheme Germany
41P01CBEActive CPS Contributions14BTZNRAssignment of Reimbursement Transfersnvarchar40
42P01CBTTransfer Records for Reimbursement of Contributions CPS4BTZNRAssignment of Reimbursement Transfersnvarchar40
43P01CKAFunded Pension Rights CPS14BTZNRAssignment of Reimbursement Transfersnvarchar40
44P01CRPReimbursement Amounts CPS4BTZNRAssignment of Reimbursement Transfersnvarchar40
45P01VA_BEActual Contributions CPS for Pension Equalization Payment15BTZNRAssignment of Reimbursement Transfersnvarchar40
46P01VA_CBEReduction Amounts for Actual Contributions CPS15BTZNRAssignment of Reimbursement Transfersnvarchar40
47P01VA_CKAReduction Amounts for Funded Pension Rights CPS17BTZNRAssignment of Reimbursement Transfersnvarchar40
48P01VA_KAFunded Pension Rights CPS for Pension Equalization Payment17BTZNRAssignment of Reimbursement Transfersnvarchar40
TOPData Transfer
49PPMIXIndex Payroll Results Lines -> Posting Lines for Payment8BTZNRAssignment of Transfersvarbinary10
TOPDenmark
50T5M9HSplit Indicators for Wage Types Sent to PBS14BTZNRAssignment of Bank Transfersvarbinary10
TOPGermany
51T5D0IFictitious Run Control: Wage Type Assignment18BTZNRDelete Indicator for Bank Transfersnvarchar10
TOPOff-Cycle
52T52OCLOff-cycle: Bank Transfer Replaced by Check or Reversed5BTZNRAssignment of Transfersvarbinary10
TOPPayment Transactions
53PAYRPayment Medium File56BTZNRAssignment of Transfersvarbinary10
54REGUHSettlement data from payment program111BTZNRAssignment of Transfersvarbinary10
TOPPayroll
55T5TA1External transfers5BTZNRSequential number (field)nvarchar20
56T7SKA1External transfers5BTZNRSequence number (four characters)nvarchar40
TOPPayroll General Parts
57T558DTransfer Wage Types with Split Indicator12BTZNRHR: Outsourcing: Transfer assignmentnvarchar20
TOPPersonnel Administration
58T7COT8Payroll external results transfer: COAVA30BTZNRAssignment of Bank Transfersvarbinary10
TOPPersonnel Management
59/BKC/S21_RT_NEUC&T! - Table RT for the payroll comparison programs17BTZNRAssignment of Bank Transfersvarbinary10
TOPTools
60T532BHR: Connection to Third-Party Payroll: Choice of Wage Types14BTZNRComponent 709: Entry field for field selection in PC207nvarchar10