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

47 columns | Print definition?ERP 6.0  | MODIFIED

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/UI2/TMUI BE: Target Mapping18MODIFIEDUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
2/UI2/TM_CLIENTUI BE: Target Mapping - client specific19MODIFIEDUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
3DMC_STREE_TRACEMWB: Trace storage for table DMC_STREE2MODIFIEDMWB: Boolean Variable (X=true, -=false)nvarchar10
4ICNV4DDLDD: Contains incr. conv. tables depend. on release/component2MODIFIEDDD: 'X': ICNV table modified, '': no modificationnvarchar10
5SRM_USR01Internet User Data5MODIFIEDGeneral Flagnvarchar10
TOPABAP Authorization and Role Management
6AGR_1250Authorization data for the activity group7MODIFIEDObject statusnvarchar10
7AGR_1251Authorization data for the activity group10MODIFIEDObject statusnvarchar10
8AUSOBT_CRelation Transaction > Auth. Object (Customer)10MODIFIEDnvarchar10
9HRT1250Table section authorizations7MODIFIEDObject statusnvarchar10
10HRT1251Table section fields10MODIFIEDObject statusnvarchar10
11USOBT_CRelation Transaction > Auth. Object (Customer)10MODIFIEDnvarchar10
12USOBT_C_BACKBackup Table USOBT_C for Modified SU2510MODIFIED'X' or Spacenvarchar10
13USOBX_CCheck Table for Table USOBT_C8MODIFIEDnvarchar10
14USOBX_C_BACKBackup Table USOBX_C for Modified SU258MODIFIED'X' or Spacenvarchar10
TOPABAP Test Frameworks ATC, CheckMan, Code Inspector
15CRM_TCKADDCOMPSTCK Checkman for Solutions: Additional Components5MODIFIEDYes/No Indicatornvarchar10
16CRM_TCKCOMP4PRODTCK Checkman for Solutions: Product's Components7MODIFIEDYes/No Indicatornvarchar10
17CRM_TCKDBSYSTCK Checkman for Solutions: Database Systems8MODIFIEDYes/No Indicatornvarchar10
18CRM_TCKHOSTSTCK Checkman for Solutions: Hosts7MODIFIEDYes/No Indicatornvarchar10
19CRM_TCKINSTANCESTCK Checkman for Solutions: Instances13MODIFIEDYes/No Indicatornvarchar10
20CRM_TCKPRODUCTSTCK Checkman for Solutions: Products of Solutions4MODIFIEDYes/No Indicatornvarchar10
21CRM_TCKSOLPRODTCK Checkman for Solutions: Products3MODIFIEDYes/No Indicatornvarchar10
22CRM_TCKSOLUTIONSTCK Checkman for Solutions: Solution List3MODIFIEDYes/No Indicatornvarchar10
23CRM_TCKSYSTEMSTCK Checkman for Solutions: R/3 Systems6MODIFIEDYes/No Indicatornvarchar10
TOPClaims Management
24ICLDRGITEMDRG Item19MODIFIEDModifiednvarchar10
25ICLITEMClaim Item22MODIFIEDModifiednvarchar10
26ICSDRGITEMDRG Item19MODIFIEDModifiednvarchar10
27ICSITEMClaim Item22MODIFIEDModifiednvarchar10
TOPClinical System
28N2F4_HIT_VALUESIS-H*MED: Values of Hit Lists for Dynamic F4 Help9MODIFIEDFlag (X or Blank)nvarchar10
TOPConsolidation
29TF010Generate Request Screen: Control Information6MODIFIEDSelection Screen: Code has been manually modifiednvarchar10
TOPCross-Application Components
30SPRTLTRANSTransport Information and Time Stamp10MODIFIEDDrag&Relate: Modification Statusnvarchar10
TOPIntegration Engine
31SXMS_EOIOREORGReorganization of EOIO Queues9MODIFIEDUTC time stamp in long form (YYYYMMDDhhmmss,mmmuuun)decimal217
32SXMS_EOIO_ERRError Table for Overserialized EOIO Queues5MODIFIEDUTC time stamp in long form (YYYYMMDDhhmmss,mmmuuun)decimal217
33SXMS_EOIO_REORGReorganization of EOIO Queues9MODIFIEDUTC time stamp in long form (YYYYMMDDhhmmss,mmmuuun)decimal217
34SXMS_EOIO_STATMaximum Number of EOIO Queues9MODIFIEDUTC time stamp in long form (YYYYMMDDhhmmss,mmmuuun)decimal217
TOPLOGFAS
35/ISDFPS/GEOLOCGeolocation Database Table23MODIFIEDChanged Manuallynvarchar10
36/ISDFPS/RICReportable Item Code13MODIFIEDChanged Manuallynvarchar10
TOPMetadata Repository
37RSDCUBETMPTemporary Properties: InfoCubes (InfoProviders)2MODIFIEDnvarchar10
TOPNon Profit Organizations
38T7UNOBJASObject of assistance (local copy of NPO table)13MODIFIEDModifiednvarchar80
TOPOffice Suite Program
39/OSP/T_CJS_GJGeneric Journal11MODIFIEDUTC Timestamp (YYYYMMDDhhmmss)nvarchar140
TOPProduct Safety
40TCGES01EHS: Worklist for Enterprise Search PS Background Process4MODIFIEDData element for domain BOOLE: TRUE (='X') and FALSE (=' ')nvarchar10
TOPRole Generator
41/ISDFPS/AUTH_BCKOriginal Data of the Deactivated Authorizations for Roles8MODIFIEDObject statusnvarchar10
TOPSAP Healthcare - Industry-Specific Components for Hospitals
42N2PRZ_HIT_KATIS-H*MED: SPC Hit Lists Entries Hierarchical Classification8MODIFIEDFlag (X or Blank)nvarchar10
TOPTransport Organizer
43TRBAT3Communication Table for R3trans Parallelization12MODIFIEDNatural Numberint100
TOPUpgrade Tools
44DDCNVTABLDD: Contains incr. conv. tables depend. on release/component4MODIFIEDDD: 'X': ICNV table modified, '': no modificationnvarchar10
45ICNVCANDYDD: Contains incr. conv. tables depend. on release/component4MODIFIEDDD: 'X': ICNV table modified, '': no modificationnvarchar10
TOPWorkforce Management Application
46WFAFC_VOLADJ_TMPSummarization Table for Forecast and Adjustments10MODIFIEDBoolean ( True = 'X', False = ' ')nvarchar10
47WFAFC_WKLDAD_TMPSummarized Workload Forecasted and Adjusted Values9MODIFIEDBoolean ( True = 'X', False = ' ')nvarchar10