ROOSOURCE
Kopf Tabelle für SAP BW OLTP Sources (ab 2.0 relevant)
ROOSOURCE is an SAP database table in S/4HANA. Kopf Tabelle für SAP BW OLTP Sources (ab 2.0 relevant). It contains 15 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| RSODP_SAPI_Extraction | view | from | ODP SAPI Extraction |
Fields (15)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | oltpsource | roosourcer | DataSource | |||
| KEY | objvers | roobjvers | OLPTSrc Version | |||
| type | roostype | DataSource Type | ||||
| applnm | rsapplnm | Application comp. | ||||
| basosource | robasource | Internal Name | ||||
| invfield | rsinvfd | Record Mode | ||||
| segment | roflag | Ind. | ||||
| tfmethods | rotfmethds | TF Methods | ||||
| archmethod | roarchmthd | Archive Conn. | ||||
| duprec | roduprec | Duplicate Recs | ||||
| sclient | rosclient | Single Client | ||||
| primsegid | roosprims | Primary Segment | ||||
| objectfd | roosobjfd | Name: Object ID | ||||
| contsrcvers | rocontvers | Content Version | ||||
| reconciliation | roreconciliation | Data Reconcil. |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- Kopf Tabelle für SAP BW OLTP Sources (ab 2.0 relevant)
-- Category TRANSPARENT · Delivery class W
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ROOSOURCE (
OLTPSOURCE, -- DataSource [roosourcer]
OBJVERS, -- OLPTSrc Version [roobjvers]
TYPE, -- DataSource Type [roostype]
APPLNM, -- Application comp. [rsapplnm]
BASOSOURCE, -- Internal Name [robasource]
INVFIELD, -- Record Mode [rsinvfd]
SEGMENT, -- Ind. [roflag]
TFMETHODS, -- TF Methods [rotfmethds]
ARCHMETHOD, -- Archive Conn. [roarchmthd]
DUPREC, -- Duplicate Recs [roduprec]
SCLIENT, -- Single Client [rosclient]
PRIMSEGID, -- Primary Segment [roosprims]
OBJECTFD, -- Name: Object ID [roosobjfd]
CONTSRCVERS, -- Content Version [rocontvers]
RECONCILIATION, -- Data Reconcil. [roreconciliation]
PRIMARY KEY (OLTPSOURCE, OBJVERS)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA