ROOSOURCE is a standard BW Service API Transparent Table in SAP Basis application, which stores Table Header for SAP BW OLTP Sources (Relevant From 2.0) data. Below you can view the Table Structure, columns(fields), SAP Wiki pages, discussion threads, related TCodes, FMs, ABAP Reports, BW Datasources, and Authorization Objects for ROOSOURCE. You can use the transaction code SE16 to view the data in this table, and SE11 TCode for the table structure and definition.


Description: Table Header for SAP BW OLTP Sources (Relevant From 2.0)
Main Category: Basis
Sub Category: BW Service API
Table type: Transparent Table (TRANSP)

ROOSOURCE — Table Structure, Fields(Columns) and Definitions

    Position Column Name Description Primary Key Data Type Length Check Table
    1 OLTPSOURCE DataSource X CHAR 30
    2 OBJVERS Version X CHAR 1
    3 TYPE Message type: S Success CHAR 4
    4 APPLNM Application Component CHAR 30
    5 BASOSOURCE Internal Name of DataSource CHAR 30
    6 .INCLUDE 0
    7 DELTA Delta Process for a DataSource CHAR 4 RODELTAM
    8 STOCKUPD Flag: Creation of opening balance is supported CHAR 1
    9 UPDFLG1 Indicator CHAR 1
    10 UPDFLG2 Indicator CHAR 1
    11 UPDFLG3 Indicator CHAR 1
    12 READONLY The database is read only CHAR 1
    13 INITSIMU DataSource Controls the Delta Init Simulation Mode CHAR 1
    14 INITCOMMIT Extractor Needs SAP-Commit After Init-Phase CHAR 1
    15 ZDD_ABLE Indicator: DataSource Can Post During Delta Init CHAR 1
    16 REALTIME DataSource Is Real-Time Enabled CHAR 1
    17 .INCLUDE 0
    18 EXMETHOD DataSource Extraction Method CHAR 2
    19 EXTRACTOR DataSource Extractor CHAR 30
    20 EXSTRUCT 30 Characters CHAR 30 *
    21 GENFLAG Generation flag CHAR 1
    22 VIRTCUBE DataSource: Extractor Supports Direct Access CHAR 1
    23 APPENDFLAG Flag: InfoSource fields were attached at customers CHAR 1
    24 .INCLUDE 0
    25 TSTPNM Last Changed By CHAR 12 USR02
    26 TSTPDAT Last Changed On DATS 8
    27 TSTPTIM Last changed at TIMS 6
    28 INVFIELD Field That Transfers Record Mode CHAR 30
    29 .INCLUDE 0
    30 GENDELTAFD Delta-Specific Field for DataSource CHAR 30 *
    31 GENDELTATP Type of Delta-Relevant Field CHAR 1
    32 DELTASAFE1 Safety Interval Lower Limit CHAR 45
    33 DELTASAFE2 Safety Interval Upper Limit of Delta Selection CHAR 45
    34 DLTAGETMAX Function Module for Determining Maximum Value CHAR 30 *
    35 SEGMENT Segment CHAR 1
    36 .INCLUDE 0
    37 AFTERIMP After-Import Methods of a DataSource CHAR 30 *
    38 BEFOREXP Function name CHAR 30 *
    39 MAINTAIN DataSource Event Maintenance CHAR 30 *
    40 CHECKDS Function name CHAR 30 *
    41 SAVEDS Save Event of a DataSource CHAR 30 *
    42 TRANSPDS Transport Event of a DataSource CHAR 30 *
    43 DELETE_DS Deletion of Datasource CHAR 30 *
    44 RESETDELTA Function Module for Invalidatin a Delta Update CHAR 30 *
    45 APPL_PROP Function name CHAR 30 *
    46 ACTIVATE Object should be activated CHAR 30 *
    47 ZDD_REPLAY DataSource Event: Replay for Zero Downtime Delta CHAR 30 *
    48 TFMETHODS Supported Transfer Methods CHAR 1
    49 ARCHMETHOD DataSource Archive Connection CHAR 1
    50 DUPREC Flag: DataSources poss. return duplicate data records CHAR 1
    51 SCLIENT Source Client for Client Copy CHAR 1
    52 PRIMSEGID Primary Segment NUMC 4
    53 OBJECTFD Field Name: Object ID CHAR 30
    54 CONTSRCVERS Content Version of DataSource CHAR 6
    55 RECONCILIATION Checked on CHAR 1

SAP Help, Wiki Resources, and Forum Discussions on ROOSOURCE

Related Tables

TABLE Description Functional Area
RODELTAM BW Delta Process Basis - BW Service API
ROOSFIELD DataSource Fields Basis - BW Service API
RSOLTPSOURCE Replicate Table for OLTP Sources in BW BW - Data Staging
RSDS DataSource in BW BW - Data Staging
ROOSPRMSC Control Parameter Per DataSource Channel Basis - BW Service API
VBAK Sales Document: Header Data SD - Sales
ROOSGENDLM Generic Delta Management for DataSources (Client-Dep.) Basis - BW Service API

Transaction Codes for SAP Table ROOSOURCE

TCODE Description Functional Area
SE11 ABAP Dictionary Maintenance Basis - Dictionary Maintenance
RSA3 Extractor Checker Basis - BW Service API
RSA6 Maintain DataSources Basis - BW Service API
SE16 Data Browser Basis - Workbench Utilities
RSO2 Oltp Metadata Repository Basis - BW Service API
RSA5 Install Business Content Basis - BW Service API
RSA7 BW Delta Queue Monitor Basis - BW Service API
RSA1 Modeling - DW Workbench BW - Data Warehousing Workbench


ABAP Reports for SAP Table ROOSOURCE

ABAP REPORT Description Functional Area
BWOM2_TIMEST BWOM2_TIMEST: Time-stamp Maintenance CO - Information System, iViews
RS_TRANSTRU_ACTIVATE_ALL Activate all active transfer structures for a source system BW - Warehouse Management
RSDS_DATASOURCE_ACTIVATE_ALL Activate DataSources BW - Data Staging
RSAP0001 Program for object type SAP0001 : BapiService Basis - BW Service API
SAPLRSAP Reporting Server: Service API
RSSM_SET_REPAIR_FULL_FLAG Set Repair Indicator for Full Requests BW - Data Staging
RSPC_MONITOR Monitoring of Selected Process Chains (Last Run) BW - Data Staging
SAPDB__S Logical Database __S: Processing without Database

BW Datasources for SAP Table ROOSOURCE

BW DATASOURCE Description Functional Area
0FI_GL_4 General Ledger: Line Items with Delta Extraction FI - General Ledger Accounting
2LIS_11_VAITM Sales Document Item Data SD - Sales and Distribution
2LIS_02_ITM Purchasing Data (Item Level) MM - Materials Management
2LIS_11_VAHDR Sales Document Header Data SD - Sales and Distribution
2LIS_03_BF Goods Movements From Inventory Management MM - Materials Management
0FI_AP_4 Vendors: Line Items with Delta Extrcation FI - Accounts Payable
2LIS_02_HDR Purchasing Data (Header Level) MM - Materials Management
0CO_OM_CCA_9 Cost Centers: Actual Costs Using Delta Extraction CO - Cost Center Accounting

Authorization Objects for SAP Table ROOSOURCE

AUTHORIZATION OBJECT Description Functional Area
S_RS_ADMWB Data Warehousing Workbench - Objects
M_EINK_FRG Release Code and Group (Purchasing)