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
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

142 tablesERP 6.0 

Payroll :: The Netherlands :: Reporting
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0P05TPRNL_C_NUMIR71Pension Return: current IR numberReporting
2ERP EHP76.0P05TPRNL_C_SEQNO61Pension Return: Current sequence number per periodReporting
3ERP EHP76.0P05TPRNL_EE_ADM141Pension Return: Admin Income Relationship - Pers LevelReporting
4ERP EHP76.0P05TPRNL_EE_ADMS182Pension Return: Admin of Status Income Relationship - Pers LReporting
5ERP EHP76.0P05TPRNL_EE_IRI141Pension Return: Income Relationship IndicatorsReporting
6ERP EHP76.0P05TPRNL_EE_IRP221Pension Return: Income Relationship - Income Period - Pers LReporting
7ERP EHP76.0P05TPRNL_EE_PD351Pension Return: Personal Data - Pers LevelReporting
8ERP EHP76.0P05TPRNL_EE_PR141Pension Return: Income Relationship Pens/Ins Relationship PLReporting
9ERP EHP76.0P05TPRNL_EE_PRP161Pension Return: Income Rel - Pens/Ins Relation Period - PLReporting
10ERP EHP76.0P05TPRNL_EE_PRPI181Pension Return: Income Rel - Pens/Ins Rel Period Indic PLReporting
11ERP EHP76.0P05TPRNL_LP_ADM141Pension Return: Administration - Legal Pers LevelReporting
12ERP EHP76.0P05TPRNL_LP_ADMS161Pension Return: Administration of Status - Legal Pers LevelReporting
13ERP EHP76.0P05TPRNL_LP_COLL141Pension Return: Collective Return - Legal Pers LevelReporting
14ERP EHP76.0P05TPRNL_M_NUMIR61Pension Return: Highest Assigned IR Number so farReporting
15ERP EHP76.0P05T_AE_AANGIFTE81Wage Return: Administrative Unit - Collective ReturnReporting
16ERP EHP76.0P05T_AE_AANG_CUM81Wage Return: Cumulated Values CollectiveReporting
17ERP EHP76.0P05T_AE_ADM91Wage Return: Administrative Unit - Admin. TableReporting
18ERP EHP76.0P05T_AE_ADM_STAT142Wage Return: Administrative Unit - Status TableReporting
19ERP EHP76.0P05T_AE_CORSALDO91Wage Return: Administrative Unit - Balance AdjustmentsReporting
20ERP EHP76.0P05T_AE_WGF101Wage Return: Administrative Unit - Redundancy Pay SchemeReporting
21ERP EHP76.0P05T_AE_WGF_CUM101Wage Return: Administrative Unit: Sect/Risk Group CumulatedReporting
22ERP EHP76.0P05T_A_EXT112Wage Return: Collective Employer Data - Wage ReturnReporting
23ERP EHP76.0P05T_CORR_REL51Wage Return: Indicators Relevant for CorrectionsReporting
24ERP EHP76.0P05T_CR_CUST71Wage Return: Indicators Relevant for Corrections (Customer)Reporting
25ERP EHP76.0P05T_CR_TABS11Wage Return: Tables with Correction Relevant FieldsReporting
26ERP EHP76.0P05T_CUM_KENT71Wage Return: Indicator Cumulation Wage TypesReporting
27ERP EHP76.0P05T_CURR_NUMIV61Wage Return: current IR numberReporting
28ERP EHP76.0P05T_CURR_VNR_JR41Wage Return: Current sequence number per yearReporting
29ERP EHP76.0P05T_CURR_VOLGNR31Wage Return: Current Sequence NumberReporting
30ERP EHP76.0P05T_CVZ_HEADER91HCIB transfer file headerlinesReporting
31ERP EHP76.0P05T_CVZ_REG182HCIB: Registration tableReporting
32ERP EHP76.0P05T_CVZ_REG_DAT272(De)registration data for HCIBReporting
33ERP EHP76.0P05T_CVZ_UITW641CVZ: Tabel voor uitwisselingsbestandReporting
34ERP EHP76.0P05T_EDM_PERSOON111Personal data for Day-one-announcement (EDM)Reporting
35ERP EHP76.0P05T_IV_AANGIFTE101Wage Return: Income Relationship - Nominative ReturnReporting
36ERP EHP76.0P05T_IV_AANG_CUM101Wage Return: Cumulated Values per Income RelationshipReporting
37ERP EHP76.0P05T_IV_AA_BSN121Wage Return: Cumulated Values for BSN ChangersReporting
38ERP EHP76.0P05T_IV_ADM111Wage Return: Income Relationship - Admin. TableReporting
39ERP EHP76.0P05T_IV_ADM_STAT162Wage Return: Income Relationship - Status TableReporting
40ERP EHP76.0P05T_IV_DA111Wage Return: Income Relationship - Return DataReporting
41ERP EHP76.0P05T_IV_DA_BSN121Wage Return: Other Cumulated Return DataReporting
42ERP EHP76.0P05T_IV_DA_CUM101Wage Return: Other Cumulated Return DataReporting
43ERP EHP76.0P05T_IV_INKPER361Wage Return: Income Relationship - Income PeriodReporting
44ERP EHP76.0P05T_IV_INKPERSA111Wage Return: Income Relationship - Income Period SIReporting
45ERP EHP76.0P05T_IV_PERSOON251Wage Return: Income Relationship - Personal DataReporting
46ERP EHP76.0P05T_IV_RG141Wage Return: Income Relationship - Risk Group SectorReporting
47ERP EHP76.0P05T_IV_RG_CUM121Wage Return: Income Relationship: Sect./Riskgrp. cumulatedReporting
48ERP EHP76.0P05T_IV_SA51Wage Return: Income Relationship - Special IndicatorsReporting
49ERP EHP76.0P05T_JLO_DATA641Data for Annual Wage ReturnReporting
50ERP EHP76.0P05T_JLO_FIELDS91Use of table fields for Annual Wage ReturnReporting
51ERP EHP76.0P05T_JLO_HEADER81Data and heading for Annual Wage Return CSV transfer fileReporting
52ERP EHP76.0P05T_JLO_STAT172Annual Wage Return statusReporting
53ERP EHP76.0P05T_KENTEKEN51Wage Return: IndicatorReporting
54ERP EHP76.0P05T_KENT_CUST51Wage Return: Customizing Indicators for CustomersReporting
55ERP EHP76.0P05T_KENT_TXT51Wage Return: Indicator Text TableReporting
56ERP EHP76.0P05T_LL_SPLIT51Aangifte LH: Splitting of life-course saving scheme paymentsReporting
57ERP EHP76.0P05T_MAX_NUMIV51Wage Return: highest assigned IR number so farReporting
58ERP EHP76.0P05T_MFTP71Nominative Contribution May Be IncorrectReporting
59ERP EHP76.0P05T_NOM_ERROR112Errors in Nominative Wage ReturnsReporting
60ERP EHP76.0P05T_NO_XML_TAG51Wage Return: Text Table Feature without XML TagsReporting
61ERP EHP76.0P05T_RESP2LA71Wage Return: Rel. between Response Message and Wage ReturnReporting
62ERP EHP76.0P05T_RESPONSE121Wage Return: Table for Response MessagesReporting
63ERP EHP76.0P05T_RESP_LINE81Wage Return: Table for Response Message ErrorsReporting
64ERP EHP76.0P05T_RESP_LINE_A41Wage Return: Table for Resp. Message Errors (Add. Fields)Reporting
65ERP EHP76.0P05T_SOM_KENT61Wage Return: IndicatorsReporting
66ERP EHP76.0P05T_TIMEFRAME61Timeframe About Which a Response Message Contains DataReporting
67ERP EHP76.0P05T_T_WCR_CODE61Codes for the Work Cost RegulationReporting
68ERP EHP76.0P05T_T_WCR_CODET51WCR Code DescriptionReporting
69ERP EHP76.0P05T_UITS_KENT61Indicator ExclusionReporting
70ERP EHP76.0P05T_WCR_CWT61WCR Code for wage typeReporting
71ERP EHP76.0P05T_WCR_EE_DATA91WCR Data on Employee LevelReporting
72ERP EHP76.0P05T_WCR_ER_DATA91WCR Data on Employer LevelReporting
73ERP EHP76.0P05T_WCR_ER_INFO191WCR Info on Employer LevelReporting
74ERP EHP76.0P05T_WCR_FL81WCR: Final Levy and Final SettlementReporting
75ERP EHP76.0P05T_WCR_PROT111WCR Protocol TableReporting
76ERP EHP76.0P05T_WCR_STAT121WCR Status TableReporting
77ERP EHP76.0P05T_WCR_SYSID41Work Cost Regulation: System IDReporting
78ERP EHP76.0P05T_WCR_SYSID_T41Work Cost Regulation: System ID DescriptionsReporting
79ERP EHP76.0P05T_XML_KENT81Wage Return: XML Tags Mapping IndicatorReporting
80ERP EHP76.0P05T_XML_VERSION71Wage Return: VersionsReporting
81ERP EHP76.0P05_TTCM91Mapping: Tax Table Column - Function Module ParameterReporting
82ERP EHP76.0P05_TTCM_TEXT41NL Tax Table Column DescriptionReporting
83ERP EHP76.0P05_TTFM91Mapping: Tax Table - Function ModuleReporting
84ERP EHP76.0P05_TTFM_TEXT31NL Tax Table DescriptionReporting
85ERP EHP76.0P05_TTFM_TTYPE11CSV Tax Table Check Report: Table TypesReporting
86ERP EHP76.0P05_TTFM_TTYPET31CSV Tax Table Check Report: Tax Table Type Text TableReporting
87ERP EHP76.0T5N0E51Link Between Difference Wage Types and Wage TypesReporting
88ERP EHP76.0T5N0F51Link back-payment wage types to difference wage typesReporting
89ERP EHP76.0T5N0G81Control Table for Guaranteed Net AmountsReporting
90ERP EHP76.0T5N0_FEATURE51Return matrix for table transfer featuresReporting
91ERP EHP76.0T5N1661Social Security TypesReporting
92ERP EHP76.0T5N16T41Text Table for SI TypesReporting
93ERP EHP76.0T5N1741Social Insurance Calculation MethodsReporting
94ERP EHP76.0T5N17T41Description of Social Insurance Calculation MethodsReporting
95ERP EHP76.0T5N1831Control Table for Mapping SI Variables to Wage TypesReporting
96ERP EHP76.0T5N1G51Valuation of AbsencesReporting
97ERP EHP76.0T5N1L231Social Insurance Contribution DataReporting
98ERP EHP76.0T5N1U31Check Table for EmployerReporting
99ERP EHP76.0T5N20141Payroll Parameters for Employment Rebate and Tax (NL)Reporting
100ERP EHP76.0T5N2191Final levyReporting
101ERP EHP76.0T5N2351Assign Wage Tax Return Indicator to Annual Employee Statem.Reporting
102ERP EHP76.0T5N2461Additional Amount Percentage Private Use of CarReporting
103ERP EHP76.0T5N2K41Text: Premium Reduction Type (NL)Reporting
104ERP EHP76.0T5N2L41Text: Period Type (NL)Reporting
105ERP EHP76.0T5N2O111Premium Reductions (NL)Reporting
106ERP EHP76.0T5N2P21Period Type (NL)Reporting
107ERP EHP76.0T5N2U21Premium Reduction TypeReporting
108ERP EHP76.0T5N2Z131Taxable Allowance for ChildcareReporting
109ERP EHP76.0T5N5L41Text: Calculation Methods (NL)Reporting
110ERP EHP76.0T5N5M21Calculation Methods for Pensions (NL)Reporting
111ERP EHP76.0T5N5N21Check Table for Pension Schemes (NL)Reporting
112ERP EHP76.0T5N5O41Text: Pension Schemes (NL)Reporting
113ERP EHP76.0T5N5P51Pension Schemes (NL)Reporting
114ERP EHP76.0T5N5Q601Calculation Table for Pensions (NL)Reporting
115ERP EHP76.0T5N5R41Text: Pension Indicators (NL)Reporting
116ERP EHP76.0T5N5V61Marital Status for EvaluationsReporting
117ERP EHP76.0T5N6A61RegulationsReporting
118ERP EHP76.0T5N6AT41Description of RegulationsReporting
119ERP EHP76.0T5N6B21Calculation Components of RegulationReporting
120ERP EHP76.0T5N6BT41Description of Calculation Components of RegulationReporting
121ERP EHP76.0T5N6C61Link between Regulations and Calculation ComponentsReporting
122ERP EHP76.0T5N6D31Calculation Codes for RegulationsReporting
123ERP EHP76.0T5N6DT41Description of Calculation CodesReporting
124ERP EHP76.0T5N6E141Calculation Data for EntitlementsReporting
125ERP EHP76.0T5N6F141Calculation Data for ReservationsReporting
126ERP EHP76.0T5N6G241Calculation Data for Pay-out and ForwardingReporting
127ERP EHP76.0T5N7631Municipal Personal Records Database [GBA] Code CountriesReporting
128ERP EHP76.0T77PRNL_ADDLPD51Pension Return: Additional Legal Person DataReporting
129ERP EHP76.0T77PRNL_EMK21Pension Return AGP: External Marital Status KeyReporting
130ERP EHP76.0T77PRNL_EMKT41Pension Return AGP: External Marital Status KeyReporting
131ERP EHP76.0T77PRNL_FILL151Pension Return: Fill Table APGReporting
132ERP EHP76.0T77PRNL_IN61Pension Return: IndicatorReporting
133ERP EHP76.0T77PRNL_IN_CPR101Pension Return: Assignment of Ind. to CumWTs Prod. RelatedReporting
134ERP EHP76.0T77PRNL_IN_CUM81Pension Return: Assignment of Cumulative Wage TypesReporting
135ERP EHP76.0T77PRNL_IN_SUM71Pension Return: Sum up indicatorsReporting
136ERP EHP76.0T77PRNL_IN_TXT61Pension Return: Indicator Text TableReporting
137ERP EHP76.0T77PRNL_MST61Pension Return AGP: Conversion of Marital Status KeyReporting
138ERP EHP76.0T77PRNL_SEL81Pension Return: Product Selection TableReporting
139ERP EHP76.0T77PRNL_SELWT71Pension Return: Selection Table APG for Wage TypesReporting
140ERP EHP76.0T77PRNL_SYCHNG41Pension Return: System ChangeReporting
141ERP EHP76.0T77PRNL_XML_IN91Pension Return: XML Tags Mapping IndicatorReporting
142ERP EHP76.0T77PRNL_XML_V81Pension Return: XML VersionsReporting