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

50 columns | Print definition?ERP 6.0  | TAG

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/ATL/HOLIDAYSHolidays Administration5TAGDay of month for public holiday calculationnvarchar20
2/CPD/PWSC_MPNAMTag Table2TAGMaster Project Tag IDnvarchar300
3/CPD/PWSC_MPNAMTTag Text2TAGMaster Project Tag IDnvarchar300
4/UI2/CHIP_CTAGSCHIP Cache: Tags2TAGCHIP: Tagnvarchar600
5/UI2/CHIP_CTAGSMCHIP Cache: Tags3TAGCHIP: Tagnvarchar600
6/XLSO/TAGTags for Products4TAGTags for Productnvarchar2000
7BBPC_SUS_COLDEFDefinition of Displayable Fields in a Table Item3TAGHTMLB Tags for SRM SUSnvarchar500
8GHO_DM_EVENTDeferment Event Data8TAGDeferment Event Tagnvarchar200
9GHO_EVT_SRC_DATATable to store deferment events souce data used in alloc run15TAGDeferment Event Tagnvarchar200
10GRFNADJUSTMENTSLog of executed adjustments2TAGAdjustment tagnvarchar200
11TILMSTOREVENTILM DB Store: Event Recording11TAGILM DB Store: Description of Text Tablenvarchar600
12ZDG00Data generation time control5TAGCalendar daynvarchar20
13ZEVENT_PRESENTATTable for the presentations8TAGDate of presentationnvarchar80
14ZSKSTATISTstatistiktabelle2TAGSAP Workload: Startdatum der Messperiodenvarchar80
15ZSK_KALENDkalender2TAGdaynvarchar20
TOPABAP Test Frameworks ATC, CheckMan, Code Inspector
16SATC_MD_SRLZDTransaction data: Serialized data, e.g. memento3TAGName of meta data itemnvarchar320
TOPBasic Functions
17T091CTranslation methods for Asset Accounting5TAGCalendar daynvarchar20
TOPClinical System
18N2RADMPPS_RADIS-H*MED RAD: MPPS Radiation Attribute3TAGRAD: Worklist Attribute Tagnvarchar160
19N2RADMPPS_TAGIS-H*MED RAD: MPPS Attribute3TAGRAD: Worklist Attribute Tagnvarchar160
20N2RADWL1IS-H*MED: Modality Worklist (extended structure)9TAGRAD: Worklist Attribute Tagnvarchar160
21N2TBS_SM_TAGIS-H*MED LTE: Markers Tag Table4TAGDay Markersnvarchar500
22N2TBS_SM_TAG_SETMarker Tag Table for Sets3TAGDay Markersnvarchar500
23N2TBS_SM_VALUEIS-H*MED LTE: Markers5TAGDay Markersnvarchar500
24N2TBS_SM_VAL_SETLTE: Marker Values for Sets4TAGDay Markersnvarchar500
25TN2_LTE_SM_VALUEIS-H*MED LTE: Marker Values3TAGField with Character Length 50nvarchar500
TOPContract Accounts Receivable and Payable
26DFK_JC_CNTR_MSGMessages for Background Processing10TAGChar255nvarchar2550
TOPData Replication Framework
27FOX0_OBJ_TYPEFOX Object Types11TAGIndicatornvarchar30
TOPData Staging
28RSDELDONEBW: Selection Table for Deletion with Full Update Scheduler22TAGNumeric 1-characternvarchar10
29RSLDPDELBW: Selection Table for Deleting with Full Update Scheduler23TAGNumeric 1-characternvarchar10
30RSLDPDELSHBW: Selection Table for Deletion with Full Update Scheduler21TAGNumeric 1-characternvarchar10
TOPGenerating, Monitoring for Mass Data Archiving Solutions
31TADWP003Advanced Efficiency Service - Tags2TAGTagnvarchar200
32TADWP004Advanced Efficiency Service - Tag Assignment3TAGTagnvarchar200
TOPHoliday Calendar, Factory Calendar, Appointment Calendar
33THOLUDates of movable public holidays4TAGDay of month for public holiday calculationnvarchar20
TOPIntegration Engine
34SXMSMONSELSelection Table for Integ. Engine Application Monitoring5TAGCharacter field with length 250nvarchar2500
TOPLocal Currency Changeover
35ADMI_CRITManage critical archiving objects (database conversion)10TAGDate on which the entry was last changednvarchar80
TOPLocalization
36J_3RFBS_XMLDELTBalance sheet forms: XML-tags to be removed:Text table5TAGXML Tag: To Be Removednvarchar2550
TOPMeasurement System
37GHO_IMPTT_ITEMData Capture Items13TAGData Tagnvarchar2550
TOPPendulum List Indirect Sales
38/BEV4/PLDANFKONConverted Request Table with Reporting Period15TAGReporting Daynvarchar20
39/BEV4/PLDANFMELRequest Table with Reporting Period12TAGReporting Daynvarchar20
40/BEV4/PLDANFZEITRequirement Update10TAGReporting Daynvarchar20
TOPRapid Applications
41AXT_EMB_MAPAMapping of Rapid Application to Tagtable Attr.3TAGParameter Valuenvarchar2550
42AXT_EMB_MAP_CAMapping of Rapid Application to Tagtable Attr.4TAGParameter Valuenvarchar2550
TOPRemaining Beverage - Obsolete Objects
43/BEV1/TRVTKTransportation Report - Times Spent at Customers4TAGDay of Tournvarchar10
44/BEV1/TRVTPTransportation Report - Breaks4TAGDay of Tournvarchar10
45/BEV1/TRVTSTransportation Report - Rest Periods4TAGDay of Tournvarchar10
TOPSAP Knowledge Warehouse
46EPSSCHRFRMHTML Tags that Do Not End a Table1TAGCharacter field of length 60nvarchar600
TOPUser Interface
47WCF_TC_LINKLinks between CRM object, tag and user5TAGTag Valuenvarchar2550
48WCF_UST_TAGShared tags5TAGTag Valuenvarchar2550
TOPWD ABAP Page Builder
49CHIP_CACHE_TAGSCHIP Cache: Tags2TAGCHIP: Tagnvarchar600
50CHIP_CACHE_TAGSMCHIP Cache: Tags3TAGCHIP: Tagnvarchar600