C_RejectedSalesQuotation

DDL: C_REJECTEDSALESQUOTATION Type: view CONSUMPTION Package: ODATA_SD_CUSTOMER360

Rejected Sales Quotations

C_RejectedSalesQuotation is a Consumption CDS View that provides data about "Rejected Sales Quotations" in SAP S/4HANA. It reads from 1 data source (I_SalesQuotation) and exposes 16 fields with key field SalesQuotation. It has 1 association to related views. It is exposed through 1 OData service (ASQL_F4645). Part of development package ODATA_SD_CUSTOMER360.

Data Sources (1)

SourceAliasJoin Type
I_SalesQuotation I_SalesQuotation from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_Customer _Customer $projection.SoldToParty = _Customer.Customer

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName CREJCTDSLSQUOT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Rejected Sales Quotations view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view

OData Services (1)

ServiceBindingVersionContractRelease
ASQL_F4645 ASQL_F4645 C2 NOT_RELEASED

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY SalesQuotation SalesQuotation
SoldToParty SoldToParty Sold-to Party
SalesOrganization SalesOrganization Sales Organization
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
OrganizationDivision OrganizationDivision Org. Division
SalesOffice SalesOffice Sales Office
SalesGroup SalesGroup Sales Group
CustomerName _Customer CustomerName Name of Customer
BindingPeriodValidityEndDate BindingPeriodValidityEndDate Binding Period
BindingPeriodValidityStartDate BindingPeriodValidityStartDate
TotalNetAmount TotalNetAmount Total Net Amount
TransactionCurrency TransactionCurrency Transaction Currency
CreationDate CreationDate Time Stamp
OverallSDDocumentRejectionSts OverallSDDocumentRejectionSts
OvrlSDDocumentRejectionStsDesc
SalesQuotationType SalesQuotationType Sales Doc. Type

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_RejectedSalesQuotation.
-- 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.

CREATE VIEW C_RejectedSalesQuotation AS
SELECT
  SalesQuotation,
  SoldToParty,
  SalesOrganization,
  DistributionChannel,
  OrganizationDivision,
  SalesOffice,
  SalesGroup,
  _Customer.CustomerName AS CustomerName,
  BindingPeriodValidityEndDate,
  BindingPeriodValidityStartDate,
  TotalNetAmount,
  TransactionCurrency,
  CreationDate,
  OverallSDDocumentRejectionSts,
  _OverallSDDocumentRejectionSts._Text[1: Language = $session.system_language ].OvrlSDDocumentRejectionStsDesc AS OvrlSDDocumentRejectionStsDesc,
  SalesQuotationType
FROM I_SalesQuotation
LEFT OUTER JOIN I_Customer AS _Customer ON SoldToParty = _Customer.Customer  -- association [0..1]
;