I_SDDocumentProcessItemsFlowVH

DDL: I_SDDOCUMENTPROCESSITEMSFLOWVH SQL: ISDDOCITMFLOWVH Type: view COMPOSITE
19 Fields 3 Data Sources

Billing Docs Items with Delivery Items

I_SDDocumentProcessItemsFlowVH is a Composite CDS View that provides data about "Billing Docs Items with Delivery Items" in SAP S/4HANA. It reads from 3 data sources (I_BillingDocument, I_BillingDocumentItem, I_SDDocumentProcessFlow) and exposes 19 fields with key fields PrecedingDocument, PrecedingDocumentItem, BillingDocument, BillingDocumentItem.

Data Sources (3)

SourceAliasJoin Type
I_BillingDocument BillingDocument inner
I_BillingDocumentItem BillingDocumentItem inner
I_SDDocumentProcessFlow DocumentFlow from

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName ISDDOCITMFLOWVH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Billing Docs Items with Delivery Items view
Search.searchable true view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.dataCategory #VALUE_HELP view
Consumption.ranked true view
ObjectModel.representativeKey BillingDocument view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY PrecedingDocument I_SDDocumentProcessFlow PrecedingDocument SD Document
KEY PrecedingDocumentItem I_SDDocumentProcessFlow PrecedingDocumentItem Item
KEY BillingDocument I_BillingDocument BillingDocument SD Document
KEY BillingDocumentItem I_BillingDocumentItem BillingDocumentItem Item
BillingDocumentItemText BillingDocumentItemText Item Descr.
CompanyCode I_BillingDocument CompanyCode Receiver Company Code
BillingDocumentType I_BillingDocument BillingDocumentType Billing Type
BillingDocumentTypeName
SoldToParty I_BillingDocument SoldToParty Sold-to Party
CustomerName
PayerParty I_BillingDocument PayerParty Payer
BillingDocumentDate I_BillingDocument BillingDocumentDate Billing Date
CreationDate I_BillingDocument CreationDate Time Stamp
SalesOrganization I_BillingDocument SalesOrganization Sales Organization
AnchorDocument
AuthorizationGroup
CustomerAccountGroup
IsBusinessPurposeCompleted
_Item _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 I_SDDocumentProcessItemsFlowVH.
-- 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: ISDDOCITMFLOWVH

CREATE VIEW I_SDDocumentProcessItemsFlowVH AS
SELECT
  DocumentFlow.PrecedingDocument AS PrecedingDocument,
  DocumentFlow.PrecedingDocumentItem AS PrecedingDocumentItem,
  BillingDocument.BillingDocument AS BillingDocument,
  BillingDocumentItem.BillingDocumentItem AS BillingDocumentItem,
  BillingDocumentItemText,
  BillingDocument.CompanyCode AS CompanyCode,
  BillingDocument.BillingDocumentType AS BillingDocumentType,
  _BillingDocumentType._Text[1:Language = $session.system_language].BillingDocumentTypeName AS BillingDocumentTypeName,
  BillingDocument.SoldToParty AS SoldToParty,
  BillingDocument._SoldToParty.CustomerName AS CustomerName,
  BillingDocument.PayerParty AS PayerParty,
  BillingDocument.BillingDocumentDate AS BillingDocumentDate,
  BillingDocument.CreationDate AS CreationDate,
  BillingDocument.SalesOrganization AS SalesOrganization,
  cast( BillingDocument.BillingDocument as fac_ddf_anchor_document ) AS AnchorDocument,
  BillingDocument._SoldToParty.AuthorizationGroup AS AuthorizationGroup,
  BillingDocument._SoldToParty.CustomerAccountGroup AS CustomerAccountGroup,
  BillingDocument._SoldToParty.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted
FROM I_SDDocumentProcessFlow AS DocumentFlow
INNER JOIN I_BillingDocument AS BillingDocument ON /* join condition not captured in parsed metadata */
INNER JOIN I_BillingDocumentItem AS BillingDocumentItem ON /* join condition not captured in parsed metadata */
;

Learn More