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

34 columns | Print definition?ERP 6.0  | ANPRM

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1P05EIR_AANGIFTEElectronic Illness Reporting: Data for Wage Information5ANPRMWage Return For-Periodnvarchar20
2T5C1GPercentages9ANPRMEmployee percent - maledecimal52
3T5C1KHR-CH: insurance contributions8ANPRMInsurance premium per thousanddecimal63
TOPReporting
4P05T_AE_AANGIFTEWage Return: Administrative Unit - Collective Return4ANPRMWage Return For-Periodnvarchar20
5P05T_AE_AANG_CUMWage Return: Cumulated Values Collective4ANPRMWage Return For-Periodnvarchar20
6P05T_AE_ADMWage Return: Administrative Unit - Admin. Table4ANPRMWage Return For-Periodnvarchar20
7P05T_AE_ADM_STATWage Return: Administrative Unit - Status Table4ANPRMWage Return For-Periodnvarchar20
8P05T_AE_CORSALDOWage Return: Administrative Unit - Balance Adjustments4ANPRMWage Return For-Periodnvarchar20
9P05T_AE_WGFWage Return: Administrative Unit - Redundancy Pay Scheme4ANPRMWage Return For-Periodnvarchar20
10P05T_AE_WGF_CUMWage Return: Administrative Unit: Sect/Risk Group Cumulated4ANPRMWage Return For-Periodnvarchar20
11P05T_IV_AANGIFTEWage Return: Income Relationship - Nominative Return4ANPRMWage Return For-Periodnvarchar20
12P05T_IV_AANG_CUMWage Return: Cumulated Values per Income Relationship4ANPRMWage Return For-Periodnvarchar20
13P05T_IV_AA_BSNWage Return: Cumulated Values for BSN Changers4ANPRMWage Return For-Periodnvarchar20
14P05T_IV_ADMWage Return: Income Relationship - Admin. Table4ANPRMWage Return For-Periodnvarchar20
15P05T_IV_ADM_STATWage Return: Income Relationship - Status Table4ANPRMWage Return For-Periodnvarchar20
16P05T_IV_DAWage Return: Income Relationship - Return Data4ANPRMWage Return For-Periodnvarchar20
17P05T_IV_DA_BSNWage Return: Other Cumulated Return Data4ANPRMWage Return For-Periodnvarchar20
18P05T_IV_DA_CUMWage Return: Other Cumulated Return Data4ANPRMWage Return For-Periodnvarchar20
19P05T_IV_INKPERWage Return: Income Relationship - Income Period4ANPRMWage Return For-Periodnvarchar20
20P05T_IV_INKPERSAWage Return: Income Relationship - Income Period SI4ANPRMWage Return For-Periodnvarchar20
21P05T_IV_PERSOONWage Return: Income Relationship - Personal Data4ANPRMWage Return For-Periodnvarchar20
22P05T_IV_RGWage Return: Income Relationship - Risk Group Sector4ANPRMWage Return For-Periodnvarchar20
23P05T_IV_RG_CUMWage Return: Income Relationship: Sect./Riskgrp. cumulated4ANPRMWage Return For-Periodnvarchar20
24P05T_WCR_EE_DATAWCR Data on Employee Level4ANPRMWage Return For-Periodnvarchar20
25P05T_WCR_ER_DATAWCR Data on Employer Level4ANPRMWage Return For-Periodnvarchar20
26P05T_WCR_ER_INFOWCR Info on Employer Level4ANPRMWage Return For-Periodnvarchar20
27P05T_WCR_FLWCR: Final Levy and Final Settlement6ANPRMWage Return For-Periodnvarchar20
28P05T_WCR_PROTWCR Protocol Table4ANPRMWage Return For-Periodnvarchar20
29P05T_WCR_STATWCR Status Table4ANPRMWage Return For-Periodnvarchar20
TOPTax
30P01T_A_ADMETNotif.: Administration - Employment Tax Notification5ANPRMETNotif.: Notification Periodnvarchar20
31P01T_A_ADSETNotif.: Status Administration/Employment Tax Notification5ANPRMETNotif.: Notification Periodnvarchar20
32P01T_A_BTGETNotif.: Tax Amounts in Employment Tax Notification5ANPRMETNotif.: Notification Periodnvarchar20
33P01T_A_DATETNotif.: General Data for Employment Tax Notification5ANPRMETNotif.: Notification Periodnvarchar20
34P01T_A_EXTETNotif.: External Data5ANPRMETNotif.: Notification Periodnvarchar20