C_InquiryRelatedDocsFFS

DDL: C_INQUIRYRELATEDDOCSFFS SQL: CINQYRLTDOCS Type: view CONSUMPTION
15 Fields 1 Data Sources 1 Associations

Related Documents for Inquiry Factsheet

C_InquiryRelatedDocsFFS is a Consumption CDS View that provides data about "Related Documents for Inquiry Factsheet" in SAP S/4HANA. It reads from 1 data source (I_SDDocumentProcessFlow) and exposes 15 fields with key fields SubsequentDocument, PrecedingDocument, DocRelationshipUUID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_SDDocumentProcessFlow SO from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_SalesDocument _RelatedSalesDoc $projection.SubsequentDocument = _RelatedSalesDoc.SalesDocument

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName CINQYRLTDOCS view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Related Documents for Inquiry Factsheet view
VDM.viewType #CONSUMPTION view
Search.searchable true view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
UI.headerInfo.typeName Related Sales Document view
UI.headerInfo.typeNamePlural Related Sales Documents view
UI.headerInfo.title.type #STANDARD view
UI.headerInfo.title.value SalesDocument view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY SubsequentDocument I_SDDocumentProcessFlow SubsequentDocument
KEY PrecedingDocument I_SDDocumentProcessFlow PrecedingDocument SD Document
KEY DocRelationshipUUID I_SDDocumentProcessFlow DocRelationshipUUID
SalesDocument I_SDDocumentProcessFlow SubsequentDocument
SDDocumentCategory _RelatedSalesDoc SDDocumentCategory Document Cat.
SalesDocumentType _RelatedSalesDoc SalesDocumentType Sales Doc. Type
SalesDocumentDate _RelatedSalesDoc SalesDocumentDate Document Date
Status
TotalNetAmount _RelatedSalesDoc TotalNetAmount Total Net Amount
TransactionCurrency _RelatedSalesDoc TransactionCurrency Transaction Currency
_SDDocumentCategory _RelatedSalesDoc _SDDocumentCategory
_SalesDocumentType _RelatedSalesDoc _SalesDocumentType
DistributionChannel _RelatedSalesDoc DistributionChannel RefDistCh-Cust/Mat.
SalesOrganization _RelatedSalesDoc SalesOrganization Sales Organization
OrganizationDivision _RelatedSalesDoc OrganizationDivision Org. Division

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 C_InquiryRelatedDocsFFS.
-- 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: CINQYRLTDOCS

CREATE VIEW C_InquiryRelatedDocsFFS AS
SELECT
  SO.SubsequentDocument AS SubsequentDocument,
  SO.PrecedingDocument AS PrecedingDocument,
  SO.DocRelationshipUUID AS DocRelationshipUUID,
  SO.SubsequentDocument AS SalesDocument,
  _RelatedSalesDoc.SDDocumentCategory AS SDDocumentCategory,
  _RelatedSalesDoc.SalesDocumentType AS SalesDocumentType,
  _RelatedSalesDoc.SalesDocumentDate AS SalesDocumentDate,
  _RelatedSalesDoc._OverallSDProcessStatus._Text[1: Language=$session.system_language ].OverallSDProcessStatusDesc AS Status,
  _RelatedSalesDoc.TotalNetAmount AS TotalNetAmount,
  _RelatedSalesDoc.TransactionCurrency AS TransactionCurrency,
  _RelatedSalesDoc._SDDocumentCategory AS _SDDocumentCategory,
  _RelatedSalesDoc._SalesDocumentType AS _SalesDocumentType,
  _RelatedSalesDoc.DistributionChannel AS DistributionChannel,
  _RelatedSalesDoc.SalesOrganization AS SalesOrganization,
  _RelatedSalesDoc.OrganizationDivision AS OrganizationDivision
FROM I_SDDocumentProcessFlow AS SO
LEFT OUTER JOIN I_SalesDocument AS _RelatedSalesDoc ON SubsequentDocument = _RelatedSalesDoc.SalesDocument  -- association [0..1]
;

Learn More