C_APProcessFlowDocumentVH

DDL: C_APPROCESSFLOWDOCUMENTVH SQL: CAPPROCFLOWDOC Type: view CONSUMPTION

Document Number

C_APProcessFlowDocumentVH is a Consumption CDS View that provides data about "Document Number" in SAP S/4HANA. It reads from 1 data source (I_APProcessFlowDocumentVH) and exposes 32 fields with key fields SourceLedger, Documentid, DocumentType, FiscalYear, CompanyCode.

Data Sources (1)

SourceAliasJoin Type
I_APProcessFlowDocumentVH I_APProcessFlowDocumentVH from

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName CAPPROCFLOWDOC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.dataCategory #VALUE_HELP view
VDM.viewType #CONSUMPTION view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
EndUserText.label Document Number view

Fields (32)

KeyFieldSource TableSource FieldDescription
KEY SourceLedger SourceLedger Source Ledger
KEY Documentid Documentid Routing slip doc. ID
KEY DocumentType Order Type
KEY FiscalYear FiscalYear G/L Fiscal Year
KEY CompanyCode CompanyCode Receiver Company Code
KEY Ledger Ledger Ledger
Supplier Supplier Supplier
ParentProcessFlowNodeDocItem ParentProcessFlowNodeDocItem Posting View Item
DocumentTypeDescription DocumentTypeDescription
ReferenceDocument DocumentReferenceID Reference
PurchasingGroup PurchasingGroup Purchasing Group
PurchasingOrganization PurchasingOrganization Purchasing Organization
PurchaseOrderType PurchaseOrderType PO Type
Plant Plant Valuation Area
StorageLocation StorageLocation StorageLocation
GoodsMovementType GoodsMovementType Movement Type
CustomerBasicAuthorizationGrp CustomerBasicAuthorizationGrp AuthorizGroup
SupplierBasicAuthorizationGrp SupplierBasicAuthorizationGrp AuthorizGroup
BPPersonAuthorizationGroup BPPersonAuthorizationGroup AuthorizGroup
IsEndOfPurposeBlocked IsEndOfPurposeBlocked Busin. Purp. Cmpltd.
FinancialAccountType FinancialAccountType Fin. Account Type
BusinessArea BusinessArea Business Area
FunctionalArea FunctionalArea Sendr Fctl Area
Segment Segment Segment number
IssuingOrReceivingPlant IssuingOrReceivingPlant Transfer Plant
IsIssgOrRcvgStorLocAuthChkActv IsIssgOrRcvgStorLocAuthChkActv
IssuingOrReceivingStorageLoc IssuingOrReceivingStorageLoc Receiving SLoc.
Customer Customer Sold-to Party
StockOwner StockOwner Owner of stock
IsStorLocAuthznCheckActive IsStorLocAuthznCheckActive
AuthorizationGroup AuthorizationGroup AuthorizGroup
CompanyCodeName CompanyCodeName Company Name

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_APProcessFlowDocumentVH.
-- 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: CAPPROCFLOWDOC

CREATE VIEW C_APProcessFlowDocumentVH AS
SELECT
  SourceLedger,
  Documentid,
  cast(DocumentType as fap_dispprocflow_doctype) AS DocumentType,
  FiscalYear,
  CompanyCode,
  Ledger,
  Supplier,
  ParentProcessFlowNodeDocItem,
  DocumentTypeDescription,
  DocumentReferenceID AS ReferenceDocument,
  PurchasingGroup,
  PurchasingOrganization,
  PurchaseOrderType,
  Plant,
  StorageLocation,
  GoodsMovementType,
  CustomerBasicAuthorizationGrp,
  SupplierBasicAuthorizationGrp,
  BPPersonAuthorizationGroup,
  IsEndOfPurposeBlocked,
  FinancialAccountType,
  BusinessArea,
  FunctionalArea,
  Segment,
  IssuingOrReceivingPlant,
  IsIssgOrRcvgStorLocAuthChkActv,
  IssuingOrReceivingStorageLoc,
  Customer,
  StockOwner,
  IsStorLocAuthznCheckActive,
  AuthorizationGroup,
  CompanyCodeName
FROM I_APProcessFlowDocumentVH
;