C_ARProcessFlowQuotation

DDL: C_ARPROCESSFLOWQUOTATION SQL: CARPROCFLOWQUOT Type: view CONSUMPTION
28 Fields 1 Data Sources

Quotation details for AR process flow

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

Data Sources (1)

SourceAliasJoin Type
P_ARProcessFlowQuotation P_ARProcessFlowQuotation from

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName CARPROCFLOWQUOT view
VDM.viewType #CONSUMPTION view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Quotation 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 QuotationDocument QuotationDocument 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.
SalesAreaSemanticKey SalesAreaSemanticKey
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_ARProcessFlowQuotation.
-- 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: CARPROCFLOWQUOT

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

Learn More