1. Home
  2. Resources
  3. SAP Tables
  4. RODYNP100 - Screen Structure for Creating an OLTP Source

SAP Table RODYNP100

Screen Structure for Creating an OLTP Source

RODYNP100 (Screen Structure for Creating an OLTP Source) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link RODYNP100 to other SAP tables.

RODYNP100 table fields

Field Data element Checktable Datatype Length Decimals
OLTPSOURCE DataSource (OSOA/OSOD) ROOSOURCER ROOSOURCE CHAR 30 0
TYPE DataSource Type ROOSTYPE CHAR 4 0
ATTR Attributes
TRAN Transactional Data
TEXT Text
HIER Hierarchy Nodes
APPE DataSource Append
ODS ODS DataSource
SEGM Segmented Data
APPLNM Application Component ROAPPLR CHAR 30 0
BASOSOURCE Internal Name of DataSource ROBASOURCE CHAR 30 0
DELTA Delta Process for a DataSource ROGENDELTA RODELTAM CHAR 4 0
READONLY Key Figures for Extractor Tests in Delta Mode RSONLYREAD CHAR 1 0
NULL No
X Yes
INITSIMU DataSource Controls the Delta Init Simulation Mode ROINITSIMU CHAR 1 0
NULL undefined
1 supported
2 not supported
INITCOMMIT Extractor Needs SAP-Commit After Init-Phase ROINITCOMM CHAR 1 0
NULL Undefined
1 SAP Commit Required
2 No SAP Commit Required
ZDD_ABLE Indicator: DataSource Can Post During Delta Init ROZDDABLE CHAR 1 0
NULL No
X Yes
STOCKUPD DataSource generates an initial non-cumulative ROSTOCK CHAR 1 0
NULL No
X Yes
EXMETHOD DataSource Extraction Method ROEXMETHOD CHAR 2 0
V Transparent Table or DB View
D Fixed Values for Domain
F1 Function Module (Complete Interface)
F2 Function Module (Simple Interface)
FS Function Module (Segmented Data Transfer)
Q Extraction Using ABAP Query
A DataSource Append
CA Class-Based BI Agent
CO Extraction Using ODP Cursor Interface
EXTRACTOR DataSource Extractor ROEXTRACTO CHAR 30 0
EXSTRUCT Extract Structure for a DataSource ROSTRUCT DD02L CHAR 30 0
GENFLAG DataSource uses generic interfaces ROGENFLAG CHAR 1 0
NULL No
X Yes
VIRTCUBE DataSource: Extractor Supports Direct Access ROVIRTFL CHAR 1 0
1 supported (without preaggregation)
2 supported (with preaggregation)
D not supported
TSTPNM Last changed by RSTSTPNM CHAR 12 0
TSTPDAT Changed On RSTSTPDAT DATS 8 0
TSTPTIM Changed at RSTSTPTIM TIMS 6 0
FIELD Extract Structure Field ROFIELD CHAR 30 0
POSIT Position of the field in the table TABFDPOS NUMC 4 0
SELECTION Properties of a DataSource Field ROSELEC CHAR 1 0
A Field in OLTP and BW Hidden by SAP
M Selection Required, Visible
NULL No Selection Possible, Visibility Set
P Selection Adjustable, Visibility Set
X Selection Adjustable, Visibility Set
1 Pure Selection Field, Selection Set
2 Pure Selection Field, Selection Set
3 Selection Adjustable, Visibility Adjustable
4 No Selection Possible, Visibility Adjustable
SELOPTS Selection Options ROSELOPTS INT4 10 0
0 Undefined Selection Options
1 Selection EQ Permitted
2 Selection BT Permitted
3 Selection EQ, BT Permitted
7 Selection EQ, BT, CP Permitted
NOTEXREL Only Known in Exit RONOTEXRE CHAR 1 0
NULL No
X Yes
UNIFIELDNM Reference field for currency and qty fields REFFIELD CHAR 30 0
TXTSH Short description RSTXTSH CHAR 20 0
TXTMD Medium description RSTXTMD CHAR 40 0
TXTLG Long description RSTXTLG CHAR 60 0
DEVCLASS Package DEVCLASS CHAR 30 0
ORIGLANGU Language Key LANGU LANG 1 0
STATUS OLTP Source Version ROOBJVERS CHAR 1 0
A active version
M Modified Version
D Delivered Version (From this System)
P Version Delivered in Patch
DTELNM Data element (semantic domain) ROLLNAME CHAR 30 0
OBJVERS OLTP Source Version ROOBJVERS CHAR 1 0
A active version
M Modified Version
D Delivered Version (From this System)
P Version Delivered in Patch
TECHEXT DataSource Extractor ROEXTRACTO CHAR 30 0
INVFIELD Field That Transfers Record Mode RSINVFD CHAR 30 0
STORNO Field Inverted if Canceled RSSTORNO CHAR 1 0
NULL No
X Yes
F4TYPE F4 Type for a DataSource Field ROF4TYPE CHAR 1 0
NULL DDIC Standard Help
1 Matchcodes
2 DataSource Text
3 Input Help Switched Off
F4EXTRAKT Extractor for Input Help ROF4EXTRAC CHAR 30 0
AFTERIMP After-Import Methods of a DataSource AFTERIMP CHAR 30 0
BEFOREXP Function name FUNCNAME CHAR 30 0
MAINTAIN DataSource Event Maintenance MAINTAINDS CHAR 30 0
CHECKDS Function name FUNCNAME CHAR 30 0
SAVEDS Save Event of a DataSource SAVEDS CHAR 30 0
TRANSPDS Transport Event of a DataSource TRSANSPDS CHAR 30 0
DELETE_DS Deletion of Datasource DELETE_DS CHAR 30 0
RESETDELTA Function Module for Invalidatin a Delta Update ROOSFDELTA CHAR 30 0
ZDD_REPLAY DataSource Event: Replay for Zero Downtime Delta ROREPLAYZD CHAR 30 0
WORKMODE Work Type ROWMODE CHAR 1 0
A Create
D Appearance
C Change
SAVED Indicator ROFLAG CHAR 1 0
X Yes
NULL No
GL_SAVED Indicator ROFLAG CHAR 1 0
X Yes
NULL No
OK OK code ROOKCODE CHAR 4 0
OKAY OK
CANC Cancel
DELT Delta Maintenance
DELE Delete
CHEC Check
CONT Display Content
DISP Display
EXTR Extracting
SAVE Save
STAP Stack
CTS Transport
DOKU Documentation
INFO Information
PICK Choose
BACK Back
EXST Expand Structure
CMOD Exit Programming
EXIT Cancel
OTHE Other object
ENTE Enter
PRIN Print
HIER Maintain Hierarchy
GENE Generate
IOBJ Create/Maintain InfoObject
SORT Sort
ASSD Assign InfoObjects by Data Element
ASSR Assign InfoObjects by Domain
MARK Select Rows
DEMA Deselect Rows
ANSWER Indicator ROFLAG CHAR 1 0
X Yes
NULL No
DEVC Package DEVCLASS CHAR 30 0
APPL_PROP Application Proposal for Transfer Rules APPL_PROP CHAR 30 0
HOK OK code ROOKCODE CHAR 4 0
OKAY OK
CANC Cancel
DELT Delta Maintenance
DELE Delete
CHEC Check
CONT Display Content
DISP Display
EXTR Extracting
SAVE Save
STAP Stack
CTS Transport
DOKU Documentation
INFO Information
PICK Choose
BACK Back
EXST Expand Structure
CMOD Exit Programming
EXIT Cancel
OTHE Other object
ENTE Enter
PRIN Print
HIER Maintain Hierarchy
GENE Generate
IOBJ Create/Maintain InfoObject
SORT Sort
ASSD Assign InfoObjects by Data Element
ASSR Assign InfoObjects by Domain
MARK Select Rows
DEMA Deselect Rows
ACTIVATE Activation of a DataSource ROACTEVENT CHAR 30 0
TFMETHODS Supported Transfer Methods ROTFMETHDS CHAR 1 0
NULL Undefined (Depending on Data Type)
1 IDOC Only
2 PSA Only
3 PSA and IDOC
RB_IDOC Radio Button: IDOC Transfer Only RORB_IDOC CHAR 1 0
X Yes
NULL No
RB_PSA Radio Button: PSA Transfer Only RORB_PSA CHAR 1 0
X Yes
NULL No
RB_IDOCPSA Radio Button: PSA or IDOC Transfer RORB_IDPSA CHAR 1 0
X Yes
NULL No
ARCHMETHOD DataSource Archive Connection ROARCHMTHD CHAR 1 0
NULL No Archive Access
1 Archive Access with Mandatory File Selection
2 Archive Access with Optional File Selection
RB_ARCH0 Radio Button: No Archive Connection RORB_ARCH0 CHAR 1 0
NULL No
X Yes
RB_ARCH1 Radio Button: Archive Connection wth Manual File Selection RORB_ARCH1 CHAR 1 0
NULL No
X Yes
RB_ARCH2 Radio Button:Archive Connection wth Automatic File Selection RORB_ARCH2 CHAR 1 0
NULL No
X Yes
SCLIENT DataSource is only allwd to be replicated for single client ROSCLIENT CHAR 1 0
NULL No restrictions
X Replication Only For "Single Client"
KEYFLAG Identifies a key field of a table KEYFLAG CHAR 1 0
NULL No key field
X Key field
KEYFLAG_DS DataSource Key Field ROKEYFLAG CHAR 1 0
NULL Field transfers DDIC setting (extract structure key)
X Field is a key field (independent of DDIC)
- Field is not a key field (independent of DDIC)
DUPREC Indicator: DataSource Delivers Duplicate Records RODUPREC CHAR 1 0
NULL Undefined
0 are not extracted
1 may occur
PRIMSEGID Primary Segment ROOSPRIMS NUMC 4 0
OBJECTFD Field Name: Object ID ROOSOBJFD CHAR 30 0
CONTSRCVERS Content Version of DataSource ROCONTVERS CHAR 6 0
RECONCILIATION DataSource for Data Reconciliation RORECONCILIATION CHAR 1 0
NULL No
X Yes
REALTIME DataSource Is Real-Time Enabled ROREALTIME CHAR 1 0
NULL No
X Yes
TRNSTATE Field Transfer Possible ROTRNSTATE CHAR 1 0
NULL No
X Yes
SELSTATE Field can be Used for Selection ROSELSTATE CHAR 1 0
NULL No
X Yes
CLSNAME_ODP Class Name for ODP Extraction ROCLSNAME_ODP CHAR 30 0

RODYNP100 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
RODYNP100 DELTA RODYNP100 DELTA RODELTAM BW Delta Process DELTA
RODYNP100 EXSTRUCT RODYNP100 EXSTRUCT DD02L SAP Tables TABNAME
RODYNP100 EXSTRUCT 'A' DD02L SAP Tables AS4LOCAL
RODYNP100 EXSTRUCT * DD02L SAP Tables AS4VERS
RODYNP100 OLTPSOURCE RODYNP100 OLTPSOURCE ROOSOURCE Table Header for SAP BW OLTP Sources (Relevant From 2.0) OLTPSOURCE
RODYNP100 OLTPSOURCE 'A' ROOSOURCE Table Header for SAP BW OLTP Sources (Relevant From 2.0) OBJVERS