I_SDDocCompleteRelatedObject

DDL: I_SDDOCCOMPLETERELATEDOBJECT Type: view_entity BASIC
9 Fields 1 Data Sources

Complete Data on Related Object of SD Document

I_SDDocCompleteRelatedObject is a Basic CDS View that provides data about "Complete Data on Related Object of SD Document" in SAP S/4HANA. It reads from 1 data source (sdro) and exposes 9 fields with key fields SDDocumentCategory, SalesDocument, SalesDocumentItem, SDDocRelatedObjectSequenceNmbr.

Data Sources (1)

SourceAliasJoin Type
sdro RelatedObject from

Annotations (7)

NameValueLevelField
EndUserText.label Complete Data on Related Object of SD Document view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
AccessControl.personalData.blocking #NOT_REQUIRED view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY SDDocumentCategory sdro sddocumentcategory Document Cat.
KEY SalesDocument sdro salesdocument SD Document
KEY SalesDocumentItem sdro salesdocumentitem Sales Document Item
KEY SDDocRelatedObjectSequenceNmbr sdro sddocrelatedobjectsequencenmbr Sequence Number
SDDocumentRelatedObjectType sdro sddocumentrelatedobjecttype Related Object Type
SDDocRelatedObjectSystem sdro sddocrelatedobjectsystem System of Reltd Obj.
SDDocRelatedObjectReference1 sdro sddocrelatedobjectreference1 Reltd Obj Ref
SDDocRelatedObjectReference2 sdro sddocrelatedobjectreference2 Reltd Obj Ref
_SDDocumentRelatedObjectType _SDDocumentRelatedObjectType

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 I_SDDocCompleteRelatedObject.
-- 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.

CREATE VIEW I_SDDocCompleteRelatedObject AS
SELECT
  RelatedObject.sddocumentcategory AS SDDocumentCategory,
  RelatedObject.salesdocument AS SalesDocument,
  RelatedObject.salesdocumentitem AS SalesDocumentItem,
  RelatedObject.sddocrelatedobjectsequencenmbr AS SDDocRelatedObjectSequenceNmbr,
  RelatedObject.sddocumentrelatedobjecttype AS SDDocumentRelatedObjectType,
  RelatedObject.sddocrelatedobjectsystem AS SDDocRelatedObjectSystem,
  RelatedObject.sddocrelatedobjectreference1 AS SDDocRelatedObjectReference1,
  RelatedObject.sddocrelatedobjectreference2 AS SDDocRelatedObjectReference2
FROM sdro AS RelatedObject
;

Learn More