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

66 columns | Print definition?ERP 6.0  | SCENARIO_ID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/BA1/TF4_SCNSETAAssign Scenarios to Scenario Sets3SCENARIO_IDScenarionvarchar100
2/IWPGW/C_TGW_COSTask processing consumer and scenario table3SCENARIO_IDScenario Identifiernvarchar320
3/IWPGW/C_TGW_SCNTask Gateway customization table for Scenarios2SCENARIO_IDScenario Identifiernvarchar320
4/IWPGW/C_TGW_SCRTask Gateway Role for Scenario and Consumer assignment3SCENARIO_IDScenario Identifiernvarchar320
5/IWPGW/C_TGW_SCTTask Gateway Text table for Scenarios3SCENARIO_IDScenario Identifiernvarchar320
6/IWPGW/C_TGW_TSKTask Gateway customization table for Scenarios Tasks2SCENARIO_IDScenario Identifiernvarchar320
7/SYCLO/MSG01Syclo Mobile Data Unit Message Queue (Outbound)26SCENARIO_IDScenario Idnvarchar400
8/SYCLO/PSH00Push Scenario Definition2SCENARIO_IDScenario Idnvarchar400
9/SYCLO/PSH00OTPush scenario outbound trigger assignment2SCENARIO_IDScenario Idnvarchar400
10/SYCLO/PSH01Syclo Push Register4SCENARIO_IDScenario Idnvarchar400
11/SYCLO/PSH03Push Instance Subscriber List2SCENARIO_IDScenario Idnvarchar400
12/SYCLO/PSH05User Push history8SCENARIO_IDScenario Idnvarchar400
13/SYCLO/PSH10Push framework: subscription queue5SCENARIO_IDScenario Idnvarchar400
14SRT_REQ_CB_DATAContract-Based Business Scenario: Data2SCENARIO_IDWSP ID of Configuration Request (Mass Configuration)nvarchar320
15SRT_REQ_CB_DIRContract-Based Business Scenario: Directory7SCENARIO_IDWSP ID of Configuration Request (Mass Configuration)nvarchar320
16SRT_REQ_D_CI_CONSRT: Business Scenario Consumer -> Contract Implementation2SCENARIO_IDWSP ID of Configuration Request (Mass Configuration)nvarchar320
17SRT_REQ_D_CI_PROSRT: Business Scenario Provider -> Contract Implementation2SCENARIO_IDWSP ID of Configuration Request (Mass Configuration)nvarchar320
18STC_SCN_ATTRTask List Generic Attributes1SCENARIO_IDTask Listnvarchar320
19THXET_ITEM_SCEffectiveness Test: Results per HItem & HInst. for Scenarios8SCENARIO_IDScenarionvarchar100
20ZSCENARIOScenario Details2SCENARIO_IDScenario IDnvarchar200
21ZTRANSACTIONTransaction detail( Link/Lane)4SCENARIO_IDScenario IDnvarchar200
TOPCommon Functions
22INM_DFM_SYN_ATTRAttributes for DFM synchronization scenarios5SCENARIO_IDDFM Scenario IDnvarchar150
23INM_DFM_SYN_IDScenario IDs for DFM2SCENARIO_IDDFM Scenario IDnvarchar150
24INM_DFM_SYN_ID_TTexts for scenario IDs3SCENARIO_IDDFM Scenario IDnvarchar150
25INM_FIELD_MAPField Mapping between INM objects2SCENARIO_IDDFM Scenario IDnvarchar150
TOPCross-Application Components
26ISX_CTR_ADAPTERUsed Adapters for Master Data Replication2SCENARIO_IDScenario ID for master data replicationnvarchar100
TOPEnvironment, Health and Safety
27/TDAG/CPC_MGRSCCP: Configuration of Tab Pages in Compliance Workbench2SCENARIO_IDCompliance Scenarionvarchar100
28/TDAG/CPC_MGRSCDCP: Language Dependent Identifiers of Workbench Tab Pages2SCENARIO_IDCompliance Scenarionvarchar100
29/TDAG/CPC_SCNORCP: Normalization variants for compliance scenarios2SCENARIO_IDCompliance Scenarionvarchar100
TOPEvent Management
30/SAPTRX/SCAOTMAPScenario AOT Mapping Table4SCENARIO_IDScenario IDnvarchar200
31/SAPTRX/SCCNDMAPScenario Condition Mapping Table4SCENARIO_IDScenario IDnvarchar200
32/SAPTRX/SCENARScenario of a solution which is owner of EM processes2SCENARIO_IDScenario IDnvarchar200
33/SAPTRX/SCENARTScenario of a solution which is owner of EM processes3SCENARIO_IDScenario IDnvarchar200
34/SAPTRX/SCEVTMAPScenario Event Types Mapping Table4SCENARIO_IDScenario IDnvarchar200
35/SAPTRX/SCFUNMAPScenario Functions Mapping Table4SCENARIO_IDScenario IDnvarchar200
36/SAPTRX/SCROLEScenario role mapping table3SCENARIO_IDScenario IDnvarchar200
37/SAPTRX/SCSOMAPMapping of scenarios to solutions3SCENARIO_IDScenario IDnvarchar200
38/SAPTRX/SOSCUSRScenario User Mapping Table3SCENARIO_IDScenario IDnvarchar200
TOPOffice Suite Program
39/OSP/T_IH_NOTIFSTable containing generic header information for Notification2SCENARIO_IDMendocino Scenario IDnvarchar500
TOPPortfolio Management
40RPM_PP_PRIORITYRPM : Porfolio prioritization Scenario2SCENARIO_IDIDnvarchar240
41RPM_PP_PRIO_CSFRPM : Priority CSF combination2SCENARIO_IDIDnvarchar240
42RPM_PP_PRIO_CSFTRPM : Scenario related Critical success factors text3SCENARIO_IDIDnvarchar240
43RPM_PP_PRIO_PCSFRPM : Priority based Critical success factors2SCENARIO_IDIDnvarchar240
44RPM_PP_PRIO_PROJRPM : Projects for Portfolio Prioritization2SCENARIO_IDIDnvarchar240
45RPM_PP_PRIO_TRPM : Portfolio Prioritization scenario text3SCENARIO_IDIDnvarchar240
46RPM_SCENARIO_FINRPM : Scenario financial data2SCENARIO_IDIDnvarchar240
47RPM_SCN_ADD_FLDSRPM : Scenario Additional fields2SCENARIO_IDIDnvarchar240
TOPPublic Sector Contract Accounts Receivable and Payable
48TFMCA_ACTN_0010TRM BRF+: Customizing Table for Scenario4SCENARIO_IDFDT: Universal Unique Identifiernvarchar320
49TFMCA_ACTN_0010ATRM BRF+: Application Table for Scenario4SCENARIO_IDFDT: Universal Unique Identifiernvarchar320
50TFMCA_ACTN_0010STRM BRF+: System Table for Scenario3SCENARIO_IDFDT: Universal Unique Identifiernvarchar320
51TFMCA_ACTN_0011TRM BRF+: Customizing Table for Formfield4SCENARIO_IDFDT: Universal Unique Identifiernvarchar320
52TFMCA_ACTN_0011ATRM BRF+: Application Table for Formfield4SCENARIO_IDFDT: Universal Unique Identifiernvarchar320
53TFMCA_ACTN_0011STRM BRF+: System Table for Formfield3SCENARIO_IDFDT: Universal Unique Identifiernvarchar320
TOPRuntime for ABAP based automated TC
54STC_SCN_HDRTask List Header Data1SCENARIO_IDTask Listnvarchar320
55STC_SCN_HDR_TTask List Description1SCENARIO_IDTask Listnvarchar320
56STC_SCN_TASKSTasks of a Task List1SCENARIO_IDTask Listnvarchar320
57STC_SESSIONTask List Runs3SCENARIO_IDTask Listnvarchar320
58STC_SESSION_EXIMTask List Runs for Refresh3SCENARIO_IDTask Listnvarchar320
59STC_TEMPLATETask List Variants2SCENARIO_IDTask Listnvarchar320
60STC_TEMPLATE_TTask List Variant Description2SCENARIO_IDTask Listnvarchar320
TOPSales
61LORD_SCENARIO_IDLean Order: Scenario ID1SCENARIO_IDLean Order: Scenario IDnvarchar300
62LORD_SCENARIO_ITLean Order: Text for Scenario ID2SCENARIO_IDLean Order: Scenario IDnvarchar300
TOPTreasury and Risk Management
63REGT_DATA_POINTSData Points of Regression Calculation9SCENARIO_IDScenarionvarchar100
TOPWeb Service and SOAP - ABAP
64SRT_REQ_DATA_CONSOAP Configuration Group for Mass Config.: Data Consumer2SCENARIO_IDWSP ID of Configuration Request (Mass Configuration)nvarchar320
65SRT_REQ_DATA_PROSOAP Configuration Group for Mass Config.: Data Provider2SCENARIO_IDWSP ID of Configuration Request (Mass Configuration)nvarchar320
66SRT_REQ_DIRSOAP Configuration Group for Mass Configuration: Directory7SCENARIO_IDWSP ID of Configuration Request (Mass Configuration)nvarchar320