C_ARProcessFlowSalesDoc

DDL: C_ARPROCESSFLOWSALESDOC SQL: CARPROCFLOWSDDOC Type: view CONSUMPTION
28 Fields 1 Data Sources

Sales Document details for AR process flow

C_ARProcessFlowSalesDoc is a Consumption CDS View that provides data about "Sales Document details for AR process flow" in SAP S/4HANA. It reads from 1 data source (P_ARProcessFlowSalesDoc) and exposes 28 fields with key field SalesDocument.

Data Sources (1)

SourceAliasJoin Type
P_ARProcessFlowSalesDoc P_ARProcessFlowSalesDoc from

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName CARPROCFLOWSDDOC view
VDM.viewType #CONSUMPTION view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Sales Document details for AR process flow view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
DataAging.noAgingRestriction true view
AbapCatalog.preserveKey true view

Fields (28)

KeyFieldSource TableSource FieldDescription
KEY SalesDocument SalesDocument SD Document
SalesDocumentDate SalesDocumentDate Document Date
SalesDocumentType SalesDocumentType Sales Doc. Type
SalesDocumentTypeName SalesDocumentTypeName
OverallSDProcessStatus OverallSDProcessStatus
OverallSDProcessStatusDesc OverallSDProcessStatusDesc
TotalNetAmount TotalNetAmount Total Net Amount
TransactionCurrency TransactionCurrency Transaction Currency
SoldToParty SoldToParty Sold-to Party
CustomerName CustomerName Name of Customer
CustomerFullName CustomerFullName Customer Name
ShipToParty ShipToParty Ship-To Party (obsolete)
ShipToPartyName ShipToPartyName Ship-To Party Name
PurchaseOrderByCustomer PurchaseOrderByCustomer Purchase Order Number
OrganizationDivision OrganizationDivision Org. Division
SalesOrganization SalesOrganization Sales Organization
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
SalesArea SalesArea
SalesAreaDesc SalesAreaDesc
CustomerPaymentTerms CustomerPaymentTerms Pyt Terms
CustomerPaymentTermsName CustomerPaymentTermsName
CreatedByUser CreatedByUser User Name
FullName FullName Name
CreationDate CreationDate Time Stamp
CreationTime CreationTime Time of Change
_ShipToParty _ShipToParty
_SoldToParty _SoldToParty
NumberOfIncomingSlsOrderItems

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_ARProcessFlowSalesDoc.
-- 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: CARPROCFLOWSDDOC

CREATE VIEW C_ARProcessFlowSalesDoc AS
SELECT
  SalesDocument,
  SalesDocumentDate,
  SalesDocumentType,
  SalesDocumentTypeName,
  OverallSDProcessStatus,
  OverallSDProcessStatusDesc,
  TotalNetAmount,
  TransactionCurrency,
  SoldToParty,
  CustomerName,
  CustomerFullName,
  ShipToParty,
  ShipToPartyName,
  PurchaseOrderByCustomer,
  OrganizationDivision,
  SalesOrganization,
  DistributionChannel,
  SalesArea,
  SalesAreaDesc,
  CustomerPaymentTerms,
  CustomerPaymentTermsName,
  CreatedByUser,
  FullName,
  CreationDate,
  CreationTime,
  count( distinct _Item.SalesDocumentItem ) AS NumberOfIncomingSlsOrderItems
FROM P_ARProcessFlowSalesDoc
;

Learn More