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

30 columns | Print definition?ERP 6.0  | DSTAT

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1P2UN_DSBPDuty Station basic pay split extension10DSTATDuty Stationnvarchar40
2P2UN_RSUN Rental Subsidy internal structure47DSTATDuty Stationnvarchar40
3T7UNPAD_UNISOLADuty Station Unified SOLA Rates3DSTATDuty Stationnvarchar40
TOPBasic Functions
4FEBKOElectronic Bank Statement Header Records8DSTATPrint statusnvarchar10
TOPBelgium
5T5BSDSI Declaration: directory table6DSTATStatus SI declarationnvarchar10
TOPInventory Management
6IKPFHeader: Physical Inventory Document16DSTATStatus of adjustment posting (inventory differences)nvarchar10
TOPManagement of Interested Parties
7VIAR04RE: REsearch - Rental Request - Offer4DSTATStatus Assignment Datenvarchar80
TOPNon Profit Organizations
8PA3244HR Master Record: Infotype 324425DSTATDuty Stationnvarchar40
9T7UNCMT_XREFDutystation Crossreference3DSTATDuty Stationnvarchar40
10T7UNPAD_DDSADuty Station DSA Rates (Daily Subsistence Allowance)3DSTATDuty Stationnvarchar40
11T7UNPAD_DMSADuty Station MSA Rates (Mission Subsistence Allowance)3DSTATDuty Stationnvarchar40
12T7UNPAD_DPDSDependency Allowance: Lowest Entry Level Determinatio4DSTATDuty Stationnvarchar40
13T7UNPAD_DSDuty Station3DSTATDuty Stationnvarchar40
14T7UNPAD_DS0GDuty Station Relation to SAP Entities Payscale Area3DSTATDuty Stationnvarchar40
15T7UNPAD_DS0PDuty Station Relation to SAP Entities Personel Area/Subarea4DSTATDuty Stationnvarchar40
16T7UNPAD_DS0_PFDuty Station Relation to Pension Fund UNJSPF Duty Stations3DSTATDuty Stationnvarchar40
17T7UNPAD_DS1PDuty Station Main Time-Dependent Information3DSTATDuty Stationnvarchar40
18T7UNPAD_DSDADuty Station Dependency Allowance3DSTATDuty Stationnvarchar40
19T7UNPAD_DSPADuty Station Post Adjustment3DSTATDuty Stationnvarchar40
20T7UNPAD_DSPTDuty Station PTA Personnel Transition Allowance3DSTATDuty Stationnvarchar40
21T7UNPAD_EGCEBDuty Station CEB Relation to SAP Entity Duty Station3DSTATDuty Stationnvarchar40
22T7UNPAD_RSACRRental Subsidy Average Commercial Rent Amounts4DSTATDuty Stationnvarchar40
23T7UNPAD_RSDARental Subsidy Entitlements (Amount)3DSTATDuty Stationnvarchar40
24T7UNPAD_RSDERental Subsidy Entitlements (Percentage)3DSTATDuty Stationnvarchar40
25T7UNPAD_RSMARental Subsidy Maximum Amount3DSTATDuty Stationnvarchar40
26T7UNPAD_RSMAGRental Subsidy Maximum Amount Grade Grouping3DSTATDuty Stationnvarchar40
27T7UNPF_DSPFMDuty Station Mapping3DSTATDuty Stationnvarchar40
TOPPublic Sector
28PDPBSZVDCARRIERSZVE-PBS Notification Procedure for Data Medium Admin.6DSTATData Medium Statusnvarchar10
TOPWarehouse Management
29LINKInventory document header in WM5DSTATPrint status in the inventory document headernvarchar10
30LINPInventory document item in WM6DSTATPrint status in the inventory record itemnvarchar10