I_SalesQuotationSituation

DDL: I_SALESQUOTATIONSITUATION SQL: ISDSLESQTANST Type: view COMPOSITE Package: VDM_SD_ANALYTICS
44 Fields 1 Data Sources 1 Associations

Sales Quotation Situation

I_SalesQuotationSituation is a Composite CDS View that provides data about "Sales Quotation Situation" in SAP S/4HANA. It reads from 1 data source (P_SalesQuotationSituation) and exposes 44 fields with key field SalesQuotation. It has 1 association to related views. Part of development package VDM_SD_ANALYTICS.

Data Sources (1)

SourceAliasJoin Type
P_SalesQuotationSituation SQ from

Associations (1)

CardinalityTargetAliasCondition
[0..1] E_SalesDocumentBasic _Extension SQ.SalesQuotation = _Extension.SalesDocument

Annotations (11)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
AbapCatalog.sqlViewName ISDSLESQTANST view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
EndUserText.label Sales Quotation Situation view

Fields (44)

KeyFieldSource TableSource FieldDescription
KEY SalesQuotation SalesQuotation
SalesDocumentType SalesDocumentType Sales Doc. Type
SalesOrganization SalesOrganization Sales Organization
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
Division OrganizationDivision Org. Division
SalesGroup SalesGroup Sales Group
SalesOffice SalesOffice Sales Office
SoldToParty SoldToParty Sold-to Party
CustomerGroup CustomerGroup Customer Group
AdditionalCustomerGroup1 AdditionalCustomerGroup1 Customer Grp 1
AdditionalCustomerGroup2 AdditionalCustomerGroup2 Customer Grp 2
AdditionalCustomerGroup3 AdditionalCustomerGroup3 Customer Grp 3
AdditionalCustomerGroup4 AdditionalCustomerGroup4 Customer Grp 4
AdditionalCustomerGroup5 AdditionalCustomerGroup5 Customer Grp 5
ResponsibleEmployee ResponsibleEmployee Employee Resp.
SalesEmployee SalesEmployee Sales Employee
SalesEmployeeUserID
ResponsibleEmployeeUserID
CreatedByUser CreatedByUser User Name
CreationDate CreationDate Time Stamp
SalesQuotationDate SalesQuotationDate Document Date
BindingPeriodValidityStartDate BindingPeriodValidityStartDate
BindingPeriodValidityEndDate BindingPeriodValidityEndDate Binding Period
TodayDate TodayDate
OverallSDProcessStatus OverallSDProcessStatus
OverallSDDocReferenceStatus OverallSDDocReferenceStatus
TransactionCurrency TransactionCurrency Transaction Currency
TotalNetAmount TotalNetAmount Total Net Amount
CnvrtdSalesQuotationNetAmount CnvrtdSalesQuotationNetAmount
SlsQtanConversionRateInPct SlsQtanConversionRateInPct
PrdtvSlsQtanCnvrsnRateInPct PrdtvSlsQtanCnvrsnRateInPct
_SalesDocumentType _SalesDocumentType
_SalesOrganization _SalesOrganization
_DistributionChannel _DistributionChannel
_OrganizationDivision _OrganizationDivision
_SalesGroup _SalesGroup
_SalesOffice _SalesOffice
_SoldToParty _SoldToParty
_CustomerGroup _CustomerGroup
_AdditionalCustomerGroup1 _AdditionalCustomerGroup1
_AdditionalCustomerGroup2 _AdditionalCustomerGroup2
_AdditionalCustomerGroup3 _AdditionalCustomerGroup3
_AdditionalCustomerGroup4 _AdditionalCustomerGroup4
_AdditionalCustomerGroup5 _AdditionalCustomerGroup5

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 I_SalesQuotationSituation.
-- 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: ISDSLESQTANST

CREATE VIEW I_SalesQuotationSituation AS
SELECT
  SalesQuotation,
  SalesDocumentType,
  SalesOrganization,
  DistributionChannel,
  OrganizationDivision AS Division,
  SalesGroup,
  SalesOffice,
  SoldToParty,
  CustomerGroup,
  AdditionalCustomerGroup1,
  AdditionalCustomerGroup2,
  AdditionalCustomerGroup3,
  AdditionalCustomerGroup4,
  AdditionalCustomerGroup5,
  ResponsibleEmployee,
  SalesEmployee,
  cast ( SalesEmployee._WorkforcePerson._BusinessUser.UserID as sales_empl_userid ) AS SalesEmployeeUserID,
  cast ( ResponsibleEmployee._WorkforcePerson._BusinessUser.UserID as resp_empl_userid ) AS ResponsibleEmployeeUserID,
  CreatedByUser,
  CreationDate,
  SalesQuotationDate,
  BindingPeriodValidityStartDate,
  BindingPeriodValidityEndDate,
  TodayDate,
  OverallSDProcessStatus,
  OverallSDDocReferenceStatus,
  TransactionCurrency,
  TotalNetAmount,
  CnvrtdSalesQuotationNetAmount,
  SlsQtanConversionRateInPct,
  PrdtvSlsQtanCnvrsnRateInPct
FROM P_SalesQuotationSituation AS SQ
LEFT OUTER JOIN E_SalesDocumentBasic AS _Extension ON SQ.SalesQuotation = _Extension.SalesDocument  -- association [0..1]
;

Learn More