FINOC_RT_SOI_OBJ_STATUS

DDL: FINOC_RT_SOI_OBJ_STATUS SQL: FINOCV_RTSOIOSTT Type: view

Orgl Chg: SDocItms with object status

FINOC_RT_SOI_OBJ_STATUS is a CDS View that provides data about "Orgl Chg: SDocItms with object status" in SAP S/4HANA. It reads from 4 data sources (I_SalesDocument, I_SalesDocumentItem, FINOC_RT_SOI_MONTHS, jest) and exposes 2 fields with key fields SalesDocument, SalesDocumentItem.

Data Sources (4)

SourceAliasJoin Type
I_SalesDocument SalesDocument inner
I_SalesDocumentItem SalesDocumentItem from
FINOC_RT_SOI_MONTHS SalesDocumentItemMonths left_outer
jest StatusObject left_outer

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName FINOCV_RTSOIOSTT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Orgl Chg: SDocItms with object status view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY SalesDocument I_SalesDocumentItem SalesDocument SD Document
KEY SalesDocumentItem I_SalesDocumentItem SalesDocumentItem Sales Document Item

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view FINOC_RT_SOI_OBJ_STATUS.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: FINOCV_RTSOIOSTT

CREATE VIEW FINOC_RT_SOI_OBJ_STATUS AS
SELECT
  SalesDocumentItem.SalesDocument AS SalesDocument,
  SalesDocumentItem.SalesDocumentItem AS SalesDocumentItem
FROM I_SalesDocumentItem AS SalesDocumentItem
INNER JOIN I_SalesDocument AS SalesDocument ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN FINOC_RT_SOI_MONTHS AS SalesDocumentItemMonths ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN jest AS StatusObject ON /* join condition not captured in parsed metadata */
;