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  | T5HPBS_HAVIBONT
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
Payroll
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0T5HPBS_HAVIBONT362Comm. - payments monthly breakdown by personsPayroll
SQL:  selectupdate insert create

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

SELECT MANDT, BUKRS, PERNR, STRNR, ID, SORSZ, STAT, INPER, FUPER, KIF_DAT, TIMESTAMP, KIF_0164, BRUTTO, FPER, BOOKING_PERNR, UDAT, CLKEY, KISOSSZEGU_E, WAERS, B_MV_EHO, B_MA_JAR, B_MV_JAR, B_MV_NY, B_MV_EUP, B_MV_EUT, K_MV_EHO, K_MA_JAR, K_MV_JAR, K_MV_NY, K_MV_EUP, K_MV_EUT, K_EHONAP, K_EHOFT, K_JARMAX_NAP, K_JARMAX_FELETT, DAILY_AVG FROM T5HPBS_HAVIBONT
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2BUKRSCompany Codenvarchar40CHAR(N' ')NoT001BUKRS Allow NULL? 
3PERNRPersonnel numbernvarchar80NUMC(N'00000000')No*PERSNO Allow NULL? 
4STRNRPersonal tax numbernvarchar200CHAR(N' ')NoP21_STRNR Allow NULL? 
5IDCommission contract internal IDnvarchar80NUMC(N'00000000')NoP21_PS_SZERZ_ID Allow NULL? 
6SORSZSequence number of paymentnvarchar20NUMC(N'00')NoP21_PS_SORSZAM Allow NULL? 
7STATComm - Processing status (Act, Rev, Old)char10CHAR(N' ')NoP21_PS_FELDOG_STAT Allow NULL? 
8INPERIn-period for payrollnvarchar60CHAR(N' ')NoIPERI Allow NULL? 
9FUPERFor-period for payrollnvarchar60CHAR(N' ')NoFAPER Allow NULL? 
10KIF_DATPayment datenvarchar80DATS(N'00000000')NoP21_PS_DAT_KIFIZ Allow NULL? 
11TIMESTAMPProgram run ID (YYYYMMDDhhmmss###)nvarchar170NUMC(N'00000000000000000')NoP21_MBJOBID Allow NULL? 
12KIF_0164Comm -0164 valid at payment(AGREN,EUHOZ,ANREN,ANKRA-B,EUPRZ)nvarchar60CHAR(N' ')YesP21_PS_IT0164_KIFIZ Allow NULL? 
13BRUTTOComm - Gross amounts in itemsdecimal258CURR((0))YesP21_PS_BRUTTO_OSSZ
14FPERComm - First processing periodnvarchar60ACCP(N' ')YesP21_PS_ELSO_INPER Allow NULL? 
15BOOKING_PERNRComm - PERNR when postingnvarchar80NUMC(N'00000000')Yes*P21_PS_BOOKING_PERNR Allow NULL? 
16UDATDate of bank transfernvarchar80DATS(N'00000000')YesP21_PS_DAT_UTAL Allow NULL? 
17CLKEYComm - Commission key for relation P21_PS_HAVIBONTnvarchar160CHAR(N' ')YesP21_PS_CLUSTER_KEY Allow NULL? 
18KISOSSZEGU_ESmall-amount paymentchar10CHAR(N' ')YesP21_PS_KISOSSZ Allow NULL? 
19WAERSCurrency Keynvarchar50CUKY(N' ')Yes*WAERS Allow NULL? 
20B_MV_EHOComm - HIP base %decimal258CURR((0))YesP21_PS_BMV_EHO
21B_MA_JARComm - base for contribution paid by employersdecimal258CURR((0))YesP21_PS_BMA_JAR
22B_MV_JARComm - Base for contribution paid by employeesdecimal258CURR((0))YesP21_PS_BMV_JAR
23B_MV_NYComm - Pension fund contribution paid by employeesdecimal258CURR((0))YesP21_PS_BMV_NY
24B_MV_EUPComm - Employee's health insurance contribution cashdecimal258CURR((0))YesP21_PS_BMV_EUP
25B_MV_EUTComm - Employee's health insurance contribution in-kinddecimal258CURR((0))YesP21_PS_BMV_EUT
26K_MV_EHOComm - % HIP base (corr.)decimal258CURR((0))YesP21_PS_KMV_EHO
27K_MA_JARComm - Base for contribution paid by employers (correction)decimal258CURR((0))YesP21_PS_KMA_JAR
28K_MV_JARComm - Base for contribution paid by employees (corr.)decimal258CURR((0))YesP21_PS_KMV_JAR
29K_MV_NYComm - Pension fund contribution paid by employees (corr.)decimal258CURR((0))YesP21_PS_KMV_NY
30K_MV_EUPComm - Employee's health insurance contribution cash (corr.)decimal258CURR((0))YesP21_PS_KMV_EUP
31K_MV_EUTComm - Health fund contrib.paid by employees in-kind (corr.)decimal258CURR((0))YesP21_PS_KMV_EUT
32K_EHONAPComm. - number of itemized HIP dayssmallint50INT2((0))YesP21_PS_K_EHONAP
33K_EHOFTComm - Lump-sum HIP days totaldecimal258CURR((0))YesP21_PS_K_EHO
34K_JARMAX_NAPComm. - days for calculating contribution maximumsmallint50INT2((0))YesP21_PS_K_JARMAX_NAP
35K_JARMAX_FELETTAmount above contribution maximumdecimal258CURR((0))YesP21_PS_K_JARMAX_FELETT
36DAILY_AVGdecimal250((0))Yes
NamePrimaryUniqueTypeColumns
T5HPBS_HAVIBONT~0YesYesCLUSTEREDTIMESTAMP, KIF_DAT, FUPER, INPER, STAT, SORSZ, ID, STRNR, PERNR, BUKRS, MANDT
T5HPBS_HAVIBONT~TINoNoNONCLUSTEREDFUPER, INPER, STAT, TIMESTAMP, 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