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

33 columns | Print definition?ERP 6.0  | ANPRJ

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1P05EIR_AANGIFTEElectronic Illness Reporting: Data for Wage Information4ANPRJWage Return For-Period Yearnvarchar40
2P05T_WCR_SIMUWCR Simulation3ANPRJWage Return For-Period Yearnvarchar40
TOPReporting
3P05T_AE_AANGIFTEWage Return: Administrative Unit - Collective Return3ANPRJWage Return For-Period Yearnvarchar40
4P05T_AE_AANG_CUMWage Return: Cumulated Values Collective3ANPRJWage Return For-Period Yearnvarchar40
5P05T_AE_ADMWage Return: Administrative Unit - Admin. Table3ANPRJWage Return For-Period Yearnvarchar40
6P05T_AE_ADM_STATWage Return: Administrative Unit - Status Table3ANPRJWage Return For-Period Yearnvarchar40
7P05T_AE_CORSALDOWage Return: Administrative Unit - Balance Adjustments3ANPRJWage Return For-Period Yearnvarchar40
8P05T_AE_WGFWage Return: Administrative Unit - Redundancy Pay Scheme3ANPRJWage Return For-Period Yearnvarchar40
9P05T_AE_WGF_CUMWage Return: Administrative Unit: Sect/Risk Group Cumulated3ANPRJWage Return For-Period Yearnvarchar40
10P05T_IV_AANGIFTEWage Return: Income Relationship - Nominative Return3ANPRJWage Return For-Period Yearnvarchar40
11P05T_IV_AANG_CUMWage Return: Cumulated Values per Income Relationship3ANPRJWage Return For-Period Yearnvarchar40
12P05T_IV_AA_BSNWage Return: Cumulated Values for BSN Changers3ANPRJWage Return For-Period Yearnvarchar40
13P05T_IV_ADMWage Return: Income Relationship - Admin. Table3ANPRJWage Return For-Period Yearnvarchar40
14P05T_IV_ADM_STATWage Return: Income Relationship - Status Table3ANPRJWage Return For-Period Yearnvarchar40
15P05T_IV_DAWage Return: Income Relationship - Return Data3ANPRJWage Return For-Period Yearnvarchar40
16P05T_IV_DA_BSNWage Return: Other Cumulated Return Data3ANPRJWage Return For-Period Yearnvarchar40
17P05T_IV_DA_CUMWage Return: Other Cumulated Return Data3ANPRJWage Return For-Period Yearnvarchar40
18P05T_IV_INKPERWage Return: Income Relationship - Income Period3ANPRJWage Return For-Period Yearnvarchar40
19P05T_IV_INKPERSAWage Return: Income Relationship - Income Period SI3ANPRJWage Return For-Period Yearnvarchar40
20P05T_IV_PERSOONWage Return: Income Relationship - Personal Data3ANPRJWage Return For-Period Yearnvarchar40
21P05T_IV_RGWage Return: Income Relationship - Risk Group Sector3ANPRJWage Return For-Period Yearnvarchar40
22P05T_IV_RG_CUMWage Return: Income Relationship: Sect./Riskgrp. cumulated3ANPRJWage Return For-Period Yearnvarchar40
23P05T_WCR_EE_DATAWCR Data on Employee Level3ANPRJWage Return For-Period Yearnvarchar40
24P05T_WCR_ER_DATAWCR Data on Employer Level3ANPRJWage Return For-Period Yearnvarchar40
25P05T_WCR_ER_INFOWCR Info on Employer Level3ANPRJWage Return For-Period Yearnvarchar40
26P05T_WCR_FLWCR: Final Levy and Final Settlement5ANPRJWage Return For-Period Yearnvarchar40
27P05T_WCR_PROTWCR Protocol Table3ANPRJWage Return For-Period Yearnvarchar40
28P05T_WCR_STATWCR Status Table3ANPRJWage Return For-Period Yearnvarchar40
TOPTax
29P01T_A_ADMETNotif.: Administration - Employment Tax Notification4ANPRJETNotif.: Year of Notification Periodnvarchar40
30P01T_A_ADSETNotif.: Status Administration/Employment Tax Notification4ANPRJETNotif.: Year of Notification Periodnvarchar40
31P01T_A_BTGETNotif.: Tax Amounts in Employment Tax Notification4ANPRJETNotif.: Year of Notification Periodnvarchar40
32P01T_A_DATETNotif.: General Data for Employment Tax Notification4ANPRJETNotif.: Year of Notification Periodnvarchar40
33P01T_A_EXTETNotif.: External Data4ANPRJETNotif.: Year of Notification Periodnvarchar40