A_SlsQtanItmSubsqntProcFlow

DDL: A_SLSQTANITMSUBSQNTPROCFLOW Type: view_entity COMPOSITE Package: ODATA_SD_QUOTATION
18 Fields 1 Data Sources 2 Associations

Item Subsequent Process Flow

A_SlsQtanItmSubsqntProcFlow is a Composite CDS View that provides data about "Item Subsequent Process Flow" in SAP S/4HANA. It reads from 1 data source (I_SlsQtanItmSubsqntProcFlow) and exposes 18 fields with key fields SalesQuotation, SalesQuotationItem, DocRelationshipUUID. It has 2 associations to related views. Part of development package ODATA_SD_QUOTATION.

Data Sources (1)

SourceAliasJoin Type
I_SlsQtanItmSubsqntProcFlow SubsequentProcFlowItem from

Associations (2)

CardinalityTargetAliasCondition
[1..1] A_SalesQuotation _SalesQuotation $projection.SalesQuotation = _SalesQuotation.SalesQuotation
[1..1] A_SalesQuotationItem _SalesQuotationItem $projection.SalesQuotation = _SalesQuotationItem.SalesQuotation and $projection.SalesQuotationItem = _SalesQuotationItem.SalesQuotationItem

Annotations (8)

NameValueLevelField
EndUserText.label Item Subsequent Process Flow view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
Metadata.ignorePropagatedAnnotations true view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY SalesQuotation I_SlsQtanItmSubsqntProcFlow SalesQuotation SD Document
KEY SalesQuotationItem I_SlsQtanItmSubsqntProcFlow SalesQuotationItem Sales Document Item
KEY DocRelationshipUUID I_SlsQtanItmSubsqntProcFlow DocRelationshipUUID
SubsequentDocument I_SlsQtanItmSubsqntProcFlow SubsequentDocument
SubsequentDocumentItem I_SlsQtanItmSubsqntProcFlow SubsequentDocumentItem
SubsequentDocumentCategory I_SlsQtanItmSubsqntProcFlow SubsequentDocumentCategory
ProcessFlowLevel I_SlsQtanItmSubsqntProcFlow ProcessFlowLevel
StatusCode
SDDocumentStatusDesc
CreationDate I_SlsQtanItmSubsqntProcFlow CreationDate Time Stamp
CreationTime I_SlsQtanItmSubsqntProcFlow CreationTime Time of Change
LastChangeDate I_SlsQtanItmSubsqntProcFlow LastChangeDate Time Stamp
SalesQuotationType _SalesQuotation SalesQuotationType
SalesOrganization _SalesQuotation SalesOrganization Sales Organization
DistributionChannel _SalesQuotation DistributionChannel RefDistCh-Cust/Mat.
OrganizationDivision _SalesQuotation OrganizationDivision Org. Division
_SalesQuotation _SalesQuotation
_SalesQuotationItem _SalesQuotationItem

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 A_SlsQtanItmSubsqntProcFlow.
-- 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 A_SlsQtanItmSubsqntProcFlow AS
SELECT
  SubsequentProcFlowItem.SalesQuotation AS SalesQuotation,
  SubsequentProcFlowItem.SalesQuotationItem AS SalesQuotationItem,
  SubsequentProcFlowItem.DocRelationshipUUID AS DocRelationshipUUID,
  SubsequentProcFlowItem.SubsequentDocument AS SubsequentDocument,
  SubsequentProcFlowItem.SubsequentDocumentItem AS SubsequentDocumentItem,
  SubsequentProcFlowItem.SubsequentDocumentCategory AS SubsequentDocumentCategory,
  SubsequentProcFlowItem.ProcessFlowLevel AS ProcessFlowLevel,
  cast('' as status_va ) AS StatusCode,
  cast('' as status_bez ) AS SDDocumentStatusDesc,
  SubsequentProcFlowItem.CreationDate AS CreationDate,
  SubsequentProcFlowItem.CreationTime AS CreationTime,
  SubsequentProcFlowItem.LastChangeDate AS LastChangeDate,
  _SalesQuotation.SalesQuotationType AS SalesQuotationType,
  _SalesQuotation.SalesOrganization AS SalesOrganization,
  _SalesQuotation.DistributionChannel AS DistributionChannel,
  _SalesQuotation.OrganizationDivision AS OrganizationDivision
FROM I_SlsQtanItmSubsqntProcFlow AS SubsequentProcFlowItem
LEFT OUTER JOIN A_SalesQuotation AS _SalesQuotation ON SalesQuotation = _SalesQuotation.SalesQuotation  -- association [1..1]
LEFT OUTER JOIN A_SalesQuotationItem AS _SalesQuotationItem ON SalesQuotation = _SalesQuotationItem.SalesQuotation AND SalesQuotationItem = _SalesQuotationItem.SalesQuotationItem  -- association [1..1]
;

Learn More