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  | P01BN_DATA
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.0P01BN_DATA541Contrib. Statement: Estimate and Corr. Values of Prev. Month
SQL:  selectupdate insert create

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

SELECT MANDT, GUID, SKVBEITR1, KKVBEITR1, SKVBEITR2, KKVBEITR2, SKVBEITR3, KKVBEITR3, SPVBEITR, KPVBEITR, SRVBEITR1, KRVBEITR1, SAVBEITR1, KAVBEITR1, SRVBEITR3, KRVBEITR3, SINSGU, KINSGU, SAVBEITR2, KAVBEITR2, SU1, KU1, SU2, KU2, SKVBEITR6, KKVBEITR6, SRVBEITR5, KRVBEITR5, SKVBEITRF, KKVBEITRF, SPVBEITRF, KPVBEITRF, SERSTAAG, KERSTAAG, SBEITR2, KBEITR2, SBEITR3, KBEITR3, SKVBEITR1SA, KKVBEITR1SA, SKVBEITR3SA, KKVBEITR3SA, SKVBEITRFSA, KKVBEITRFSA, SBTEPST, KBTEPST, BVERF, KORRL, KORRE, WAERS, SZBP, KZBP, SZBF, KZBF FROM P01BN_DATA
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2GUIDUnique Key for Identification of Notificationnvarchar320CHAR(N' ')NoP01_SVGUID Allow NULL? 
3SKVBEITR1HI Contribution General, Estimated Valuedecimal152CURR((0))YesP01_S_KVBEITR1
4KKVBEITR1HI Contribution General, Correction Previous Monthdecimal152CURR((0))YesP01_K_KVBEITR1
5SKVBEITR2HI Contribution Increased, Estimated Valuedecimal152CURR((0))YesP01_S_KVBEITR2
6KKVBEITR2HI Contribution Increased, Correction Previous Monthdecimal152CURR((0))YesP01_K_KVBEITR2
7SKVBEITR3HI Contribution Reduced, Estimated Valuedecimal152CURR((0))YesP01_S_KVBEITR3
8KKVBEITR3HI Contribution Reduced, Correction Previous Monthdecimal152CURR((0))YesP01_K_KVBEITR3
9SPVBEITRCI Contribution, Estimated Valuedecimal152CURR((0))YesP01_S_SPVBEITR
10KPVBEITRCI Contribution, Correction Previous Monthdecimal152CURR((0))YesP01_K_SPVBEITR
11SRVBEITR1PI Contribution Full, Estimated Valuedecimal152CURR((0))YesP01_S_RVBEITR1
12KRVBEITR1PI Contribution Full, Correction Previous Monthdecimal152CURR((0))YesP01_K_RVBEITR1
13SAVBEITR1UI Contribution, Full, Estimated Valuedecimal152CURR((0))YesP01_S_AVBEITR1
14KAVBEITR1UI Contribution Full, Correction Previous Monthdecimal152CURR((0))YesP01_K_AVBEITR1
15SRVBEITR3PI Contribution Half, Estimated Valuedecimal152CURR((0))YesP01_S_RVBEITR3
16KRVBEITR3PI Contribution Half, Correction Previous Monthdecimal152CURR((0))YesP01_K_RVBEITR3
17SINSGUContribution to Insolvency Fund Insurance, Estimated Valuedecimal152CURR((0))YesP01_S_INSGU
18KINSGUContrib. to Insolvency Fund Insurance, Correction Prev.Monthdecimal152CURR((0))YesP01_K_INSGU
19SAVBEITR2UI Contribution, Half, Estimated Valuedecimal152CURR((0))YesP01_S_AVBEITR2
20KAVBEITR2UI Contribution Half, Contribution Previous Monthdecimal152CURR((0))YesP01_K_AVBEITR2
21SU1Contribution Amount Illness Expenses (U1), Estimated Valuedecimal152CURR((0))YesP01_S_U1
22KU1Contribution to Illness Expenses (U1), Correction Prev.Monthdecimal152CURR((0))YesP01_K_U1
23SU2Contrib. Amount Maternity Expenses (U2), Estimated Valuedecimal152CURR((0))YesP01_S_U2
24KU2Contrib. to Maternity Expenses (U2), Correction Prev. Monthdecimal152CURR((0))YesP01_K_U2
25SKVBEITR6HI Contribution Flat-Rate, Estimated Valuedecimal152CURR((0))YesP01_S_KVBEITR6
26KKVBEITR6HI Contribution Flat-Rate, Correction Previous Monthdecimal152CURR((0))YesP01_K_KVBEITR6
27SRVBEITR5PI Contribution Flat-Rate, Estimated Valuedecimal152CURR((0))YesP01_S_RVBEITR5
28KRVBEITR5PI Contribution Flat-Rate, Correction Previous Monthdecimal152CURR((0))YesP01_K_RVBEITR5
29SKVBEITRFHI Contribution Voluntary Members, Estimated Valuedecimal152CURR((0))YesP01_S_KVBEITRF
30KKVBEITRFHI Contribution Voluntary Members, Correction Previous Monthdecimal152CURR((0))YesP01_K_KVBEITRF
31SPVBEITRFCI Contribution Voluntary Members, Estimated Valuedecimal152CURR((0))YesP01_S_PVBEITRF
32KPVBEITRFCI Contribution Voluntary Members, Correction Previous Monthdecimal152CURR((0))YesP01_K_PVBEITRF
33SERSTAAGReimbursement Amount of Employer Expenses, Estimated Valuedecimal152CURR((0))YesP01_S_ERSTAAG
34KERSTAAGReimbursement Amount Employer Expenses, Corr. Prev. Monthdecimal152CURR((0))YesP01_K_ERSTAAG
35SBEITR2Other Contribution (Optional), Estimated Valuedecimal152CURR((0))YesP01_S_BEITR2
36KBEITR2Other Contribution (Optional), Correction Previous Monthdecimal152CURR((0))YesP01_K_BEITR2
37SBEITR3Other Contribution (Optional), Estimated Valuedecimal152CURR((0))YesP01_S_BEITR3
38KBEITR3Other Contribution (Optional), Correction Previous Monthdecimal152CURR((0))YesP01_K_BEITR3
39SKVBEITR1SAHI Contribution General, w/o SI Adjustment, Estimated Valuedecimal152CURR((0))YesP01_S_KVBEITR1SA
40KKVBEITR1SAHI Contrib. Gen., w/o SI Adjustment Correction Prev. Monthdecimal152CURR((0))YesP01_K_KVBEITR1SA
41SKVBEITR3SAHI Contribution Reduced, w/o SI Adjustment, Estimated Valuedecimal152CURR((0))YesP01_S_KVBEITR3SA
42KKVBEITR3SAHI Contribution Reduced, w/o SI Adj., Correction Prev. Monthdecimal152CURR((0))YesP01_K_KVBEITR3SA
43SKVBEITRFSAHI Contrib. Voluntary Members, w/o SI Adj., Estimated Valuedecimal152CURR((0))YesP01_S_KVBEITRFSA
44KKVBEITRFSAHI Contrib. Voluntary Members, w/o SI Adj. Corr. Prev. Monthdecimal152CURR((0))YesP01_K_KVBEITRFSA
45SBTEPSTStandard Flat-Rate Tax for Low-Paid EEs, Estimated Valuedecimal152CURR((0))YesP01_S_BTEPST
46KBTEPSTStandard Flat-Rate Tax for Low-Paid EEs, Correctiondecimal152CURR((0))YesP01_K_BTEPST
47BVERFProcedure for Expected Due Contributionschar10CHAR(N' ')YesP01_BVERF Allow NULL? 
48KORRLCoorection Factor Current Remunerationdecimal32DEC((0))YesP01_KORRL
49KORRECorrection Factor Non-Recurring Paymentdecimal32DEC((0))YesP01_KORRE
50WAERSCurrency Keynvarchar50CUKY(N' ')Yes*WAERS Allow NULL? 
51SZBPSupplementary Contribution Compulsory, Estimated Valuedecimal152CURR((0))YesP01_S_ZBP
52KZBPSupplementary Contribution Compulsorydecimal152CURR((0))YesP01_K_ZBP
53SZBFSupplementary Contribution Voluntary, Estimated Valuedecimal152CURR((0))YesP01_S_ZBF
54KZBFSupplementary Contrib. Voluntary, Correction Previous Monthdecimal152CURR((0))YesP01_K_ZBF
NamePrimaryUniqueTypeColumns
P01BN_DATA~0YesYesCLUSTEREDGUID, 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