C_ARProcessFlowDocumentVH

DDL: C_ARPROCESSFLOWDOCUMENTVH SQL: CARPROCFLOWDOC Type: view CONSUMPTION Package: ODATA_PROCESS_FLOW_AR

Document Number

C_ARProcessFlowDocumentVH is a Consumption CDS View that provides data about "Document Number" in SAP S/4HANA. It reads from 1 data source (I_ARProcessFlowDocumentVH) and exposes 24 fields with key fields DocumentType, CompanyCode, FiscalYear, Documentid, AccountingDocumentItem. It is exposed through 1 OData service (ASQL_F2692). Part of development package ODATA_PROCESS_FLOW_AR.

Data Sources (1)

SourceAliasJoin Type
I_ARProcessFlowDocumentVH I_ARProcessFlowDocumentVH from

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName CARPROCFLOWDOC 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

OData Services (1)

ServiceBindingVersionContractRelease
ASQL_F2692 ASQL_F2692 C2 NOT_RELEASED

Fields (24)

KeyFieldSource TableSource FieldDescription
KEY DocumentType Order Type
KEY CompanyCode CompanyCode Receiver Company Code
KEY FiscalYear FiscalYear G/L Fiscal Year
KEY Documentid Documentid Routing slip doc. ID
KEY AccountingDocumentItem AccountingDocumentItem Posting View Item
ReferenceDocument
DocumentTypeDescription
SalesDocumentType SalesDocumentType Sales Doc. Type
OrganizationDivision OrganizationDivision Org. Division
SalesOrganization SalesOrganization Sales Organization
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
ShippingPoint ShippingPoint Shipping Point
BillingDocumentType BillingDocumentType Billing Type
FinancialAccountType FinancialAccountType Fin. Account Type
BusinessArea BusinessArea Business Area
FunctionalArea FunctionalArea Sendr Fctl Area
Segment Segment Segment number
ValuationArea ValuationArea Valuation Area
SalesOffice SalesOffice Sales Office
SalesGroup SalesGroup Sales Group
SalesOrganizationOrgUnitID SalesOrganizationOrgUnitID
SalesOfficeOrgUnitID SalesOfficeOrgUnitID
SalesGroupOrgUnitID SalesGroupOrgUnitID
ServiceOrganization ServiceOrganization

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_ARProcessFlowDocumentVH.
-- 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: CARPROCFLOWDOC

CREATE VIEW C_ARProcessFlowDocumentVH AS
SELECT
  cast( DocumentType as fap_dispprocflow_doctype) AS DocumentType,
  CompanyCode,
  FiscalYear,
  Documentid,
  AccountingDocumentItem,
  cast(ACMTransactingCustomerRef as bstkd) AS ReferenceDocument,
  cast(DocumentTypeDescription as fap_dispprocflow_doctype_txt) AS DocumentTypeDescription,
  SalesDocumentType,
  OrganizationDivision,
  SalesOrganization,
  DistributionChannel,
  ShippingPoint,
  BillingDocumentType,
  FinancialAccountType,
  BusinessArea,
  FunctionalArea,
  Segment,
  ValuationArea,
  SalesOffice,
  SalesGroup,
  SalesOrganizationOrgUnitID,
  SalesOfficeOrgUnitID,
  SalesGroupOrgUnitID,
  ServiceOrganization
FROM I_ARProcessFlowDocumentVH
;