SAP ABAP Table RSTSODS (Operational Data Store for the transfer structure)

Hierarchy

☛ SAP_BW (Software Component) SAP Business Warehouse
   ⤷ BW-WHM-DST (Application Component) Data Staging
     ⤷ RSAR (Package) Data import from source system

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	RSTSODS	Table Relationship Diagram
Short Description	Operational Data Store for the transfer structure

Delivery and Maintenance

Pool/cluster
Delivery Class	C	Customizing table, maintenance only by cust., not SAP import
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	ODSNAME	☑	RSODSNAME	TABNAME	CHAR	30	0	Name of the Persistant Staging Area
2	VERSION	☑	RSAVERSION	NUMC3	NUMC	3	0	Version
3	DATETO	☐	RSDATETO	DATUM	DATS	8	0	Valid-to date
4	DATEFROM	☐	RSDATEFROM	DATUM	DATS	8	0	Valid-From Date
5	OBJSTAT	☐	RSOBJSTAT	RSOBJSTAT	CHAR	3	0	Object Status
6	ODSNAME_TECH	☐	RSODSTECH	DBOBJ_NAME	CHAR	16	0	Technical ODS name in the DB
7	PROGNAME	☐	PROGNAME	PROGNAME	CHAR	40	0	ABAP Program Name
8	MAINTPROG	☐	MAINPROG	PROGNAME	CHAR	40	0	Maintenance Program
9	USERAPP	☐	RSUSERAPP		CHAR	10	0	Name of the application using PSA Service
10	USEROBJ	☐	SOBJ_NAME	SOBJ_NAME	CHAR	40	0	Object Name in Object Directory
11	.INCLUDE	☐				0	0	Include: Last changed by, time stamp in internal format
12	TSTPNM	☐	RSTSTPNM	XUBNAME	CHAR	12	0	Last changed by	USR02
13	TIMESTMP	☐	RSTIMESTMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
14	PARTNO	☐	RSPARTNO	RSPARTNO	NUMC	4	0	Partition number for PSA partitioning

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	RSTSODS	TSTPNM	USR02	BNAME	KEY	C	CN

History

Last changed by/on	SAP	20130604
SAP Release Created in