I_SupplierQuotationEnh

DDL: I_SUPPLIERQUOTATIONENH SQL: IMMQTNENH Type: view COMPOSITE
61 Fields 1 Data Sources 2 Associations

Supplier Quotation Enhanced

I_SupplierQuotationEnh is a Composite CDS View that provides data about "Supplier Quotation Enhanced" in SAP S/4HANA. It reads from 1 data source (I_SupplierQuotation) and exposes 61 fields with key field SupplierQuotation. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_SupplierQuotation I_SupplierQuotation from

Associations (2)

CardinalityTargetAliasCondition
[1..*] I_SupplierQuotationItemEnh _SupplierQuotationItem $projection.SupplierQuotation = _SupplierQuotationItem.SupplierQuotation
[1..1] I_RequestForQuotationEnhanced _RequestForQuotation $projection.RequestForQuotation = _RequestForQuotation.RequestForQuotation

Annotations (13)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.compositionRoot true view
ObjectModel.modelCategory #BUSINESS_OBJECT view
ObjectModel.representativeKey SupplierQuotation view
ObjectModel.semanticKey SupplierQuotation view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view
EndUserText.label Supplier Quotation Enhanced view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
AbapCatalog.sqlViewName IMMQTNENH view

Fields (61)

KeyFieldSource TableSource FieldDescription
KEY SupplierQuotation I_SupplierQuotation SupplierQuotation RFQ
CompanyCode I_SupplierQuotation CompanyCode Receiver Company Code
PurchasingDocumentCategory I_SupplierQuotation PurchasingDocumentCategory Doc. Category
PurchasingDocumentType I_SupplierQuotation PurchasingDocumentType RFQ Type
Supplier I_SupplierQuotation Supplier Supplier
CreatedByUser I_SupplierQuotation CreatedByUser User Name
CreationDate I_SupplierQuotation CreationDate Time Stamp
LastChangeDateTime I_SupplierQuotation LastChangeDateTime Timestamp
Language I_SupplierQuotation Language Report Text Language
DocumentCurrency I_SupplierQuotation DocumentCurrency Document Currency
IncotermsClassification I_SupplierQuotation IncotermsClassification Incoterms
IncotermsTransferLocation I_SupplierQuotation IncotermsTransferLocation Incoterms 2
IncotermsVersion I_SupplierQuotation IncotermsVersion Inco. Version
IncotermsLocation1 I_SupplierQuotation IncotermsLocation1 Inco. Location1
IncotermsLocation2 I_SupplierQuotation IncotermsLocation2 Inco. Location2
PaymentTerms I_SupplierQuotation PaymentTerms Pyt Terms
CashDiscount1Days I_SupplierQuotation CashDiscount1Days Days from Baseline Date for Payment
CashDiscount2Days I_SupplierQuotation CashDiscount2Days Days from Baseline Date for Payment
CashDiscount1Percent I_SupplierQuotation CashDiscount1Percent Disc. Percent 1
CashDiscount2Percent I_SupplierQuotation CashDiscount2Percent Disc. Percent 2
NetPaymentDays I_SupplierQuotation NetPaymentDays Net Pmt Terms Period
PricingProcedure I_SupplierQuotation PricingProcedure Procedure
PurchasingDocumentCondition I_SupplierQuotation PurchasingDocumentCondition Doc. Condition
PurchasingOrganization I_SupplierQuotation PurchasingOrganization Purchasing Organization
PurchasingGroup I_SupplierQuotation PurchasingGroup Purchasing Group
PurchasingDocumentOrderDate I_SupplierQuotation PurchasingDocumentOrderDate PO Date
ExchangeRate I_SupplierQuotation ExchangeRate Exchange rate
ExchangeRateIsFixed I_SupplierQuotation ExchangeRateIsFixed Fixed Exch.Rate
PurContrValidityStartDate I_SupplierQuotation PurContrValidityStartDate Validity Start
PurContrValidityEndDate I_SupplierQuotation PurContrValidityEndDate Validity End
PurchaseContractTargetAmount I_SupplierQuotation PurchaseContractTargetAmount Target Value
IsEndOfPurposeBlocked I_SupplierQuotation IsEndOfPurposeBlocked Busin. Purp. Cmpltd.
PurchasingDocumentDeletionCode I_SupplierQuotation PurchasingDocumentDeletionCode Del. Indicator
RequestForQuotation I_SupplierQuotation RequestForQuotation RFQ
SupplierQuotationExternalID I_SupplierQuotation SupplierQuotationExternalID Quotation
QuotationSubmissionDate I_SupplierQuotation QuotationSubmissionDate Quotation Date
QuotationLatestSubmissionDate I_SupplierQuotation QuotationLatestSubmissionDate Quot. Deadline
BindingPeriodValidityEndDate I_SupplierQuotation BindingPeriodValidityEndDate Binding Period
QtnLifecycleStatus I_SupplierQuotation QtnLifecycleStatus Status
FollowOnDocumentCategory I_SupplierQuotation FollowOnDocumentCategory Follow-On Document Category
FollowOnDocumentType I_SupplierQuotation PurgDocFollowOnDocumentType Follow-On Document Type
_SupplierQuotationItem _SupplierQuotationItem
_CatTextInCurrentLang I_SupplierQuotation _CatTextInCurrentLang
_CompanyCode I_SupplierQuotation _CompanyCode
_IncotermsClassification I_SupplierQuotation _IncotermsClassification
_IncotermsVersion I_SupplierQuotation _IncotermsVersion
_PurchasingDocumentType I_SupplierQuotation _PurchasingDocumentType
_FollowOnDocumentCategory I_SupplierQuotation _FollowOnDocumentCategory
_FollowOnDocumentType I_SupplierQuotation _FollowOnDocumentType
_PurchasingGroup I_SupplierQuotation _PurchasingGroup
_PurchasingOrganization I_SupplierQuotation _PurchasingOrganization
_PurchasingDocumentCategory I_SupplierQuotation _PurchasingDocumentCategory
_Supplier I_SupplierQuotation _Supplier
_PurchaseOrder I_SupplierQuotation _PurchaseOrder
_PurchaseContract I_SupplierQuotation _PurchaseContract
_Language I_SupplierQuotation _Language
_DocumentCurrency I_SupplierQuotation _DocumentCurrency
_CreatedByUser I_SupplierQuotation _CreatedByUser
_QtnLifecycleStatus I_SupplierQuotation _QtnLifecycleStatus
_SupplierQuotationType _SupplierQuotationType
_RequestForQuotation _RequestForQuotation

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_SupplierQuotationEnh.
-- 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: IMMQTNENH

CREATE VIEW I_SupplierQuotationEnh AS
SELECT
  I_SupplierQuotation.SupplierQuotation AS SupplierQuotation,
  I_SupplierQuotation.CompanyCode AS CompanyCode,
  I_SupplierQuotation.PurchasingDocumentCategory AS PurchasingDocumentCategory,
  I_SupplierQuotation.PurchasingDocumentType AS PurchasingDocumentType,
  I_SupplierQuotation.Supplier AS Supplier,
  I_SupplierQuotation.CreatedByUser AS CreatedByUser,
  I_SupplierQuotation.CreationDate AS CreationDate,
  I_SupplierQuotation.LastChangeDateTime AS LastChangeDateTime,
  I_SupplierQuotation.Language AS Language,
  I_SupplierQuotation.DocumentCurrency AS DocumentCurrency,
  I_SupplierQuotation.IncotermsClassification AS IncotermsClassification,
  I_SupplierQuotation.IncotermsTransferLocation AS IncotermsTransferLocation,
  I_SupplierQuotation.IncotermsVersion AS IncotermsVersion,
  I_SupplierQuotation.IncotermsLocation1 AS IncotermsLocation1,
  I_SupplierQuotation.IncotermsLocation2 AS IncotermsLocation2,
  I_SupplierQuotation.PaymentTerms AS PaymentTerms,
  I_SupplierQuotation.CashDiscount1Days AS CashDiscount1Days,
  I_SupplierQuotation.CashDiscount2Days AS CashDiscount2Days,
  I_SupplierQuotation.CashDiscount1Percent AS CashDiscount1Percent,
  I_SupplierQuotation.CashDiscount2Percent AS CashDiscount2Percent,
  I_SupplierQuotation.NetPaymentDays AS NetPaymentDays,
  I_SupplierQuotation.PricingProcedure AS PricingProcedure,
  I_SupplierQuotation.PurchasingDocumentCondition AS PurchasingDocumentCondition,
  I_SupplierQuotation.PurchasingOrganization AS PurchasingOrganization,
  I_SupplierQuotation.PurchasingGroup AS PurchasingGroup,
  I_SupplierQuotation.PurchasingDocumentOrderDate AS PurchasingDocumentOrderDate,
  I_SupplierQuotation.ExchangeRate AS ExchangeRate,
  I_SupplierQuotation.ExchangeRateIsFixed AS ExchangeRateIsFixed,
  I_SupplierQuotation.PurContrValidityStartDate AS PurContrValidityStartDate,
  I_SupplierQuotation.PurContrValidityEndDate AS PurContrValidityEndDate,
  I_SupplierQuotation.PurchaseContractTargetAmount AS PurchaseContractTargetAmount,
  I_SupplierQuotation.IsEndOfPurposeBlocked AS IsEndOfPurposeBlocked,
  I_SupplierQuotation.PurchasingDocumentDeletionCode AS PurchasingDocumentDeletionCode,
  I_SupplierQuotation.RequestForQuotation AS RequestForQuotation,
  I_SupplierQuotation.SupplierQuotationExternalID AS SupplierQuotationExternalID,
  I_SupplierQuotation.QuotationSubmissionDate AS QuotationSubmissionDate,
  I_SupplierQuotation.QuotationLatestSubmissionDate AS QuotationLatestSubmissionDate,
  I_SupplierQuotation.BindingPeriodValidityEndDate AS BindingPeriodValidityEndDate,
  I_SupplierQuotation.QtnLifecycleStatus AS QtnLifecycleStatus,
  I_SupplierQuotation.FollowOnDocumentCategory AS FollowOnDocumentCategory,
  I_SupplierQuotation.PurgDocFollowOnDocumentType AS FollowOnDocumentType,
  I_SupplierQuotation._CatTextInCurrentLang AS _CatTextInCurrentLang,
  I_SupplierQuotation._CompanyCode AS _CompanyCode,
  I_SupplierQuotation._IncotermsClassification AS _IncotermsClassification,
  I_SupplierQuotation._IncotermsVersion AS _IncotermsVersion,
  I_SupplierQuotation._PurchasingDocumentType AS _PurchasingDocumentType,
  I_SupplierQuotation._FollowOnDocumentCategory AS _FollowOnDocumentCategory,
  I_SupplierQuotation._FollowOnDocumentType AS _FollowOnDocumentType,
  I_SupplierQuotation._PurchasingGroup AS _PurchasingGroup,
  I_SupplierQuotation._PurchasingOrganization AS _PurchasingOrganization,
  I_SupplierQuotation._PurchasingDocumentCategory AS _PurchasingDocumentCategory,
  I_SupplierQuotation._Supplier AS _Supplier,
  I_SupplierQuotation._PurchaseOrder AS _PurchaseOrder,
  I_SupplierQuotation._PurchaseContract AS _PurchaseContract,
  I_SupplierQuotation._Language AS _Language,
  I_SupplierQuotation._DocumentCurrency AS _DocumentCurrency,
  I_SupplierQuotation._CreatedByUser AS _CreatedByUser,
  I_SupplierQuotation._QtnLifecycleStatus AS _QtnLifecycleStatus
FROM I_SupplierQuotation
LEFT OUTER JOIN I_SupplierQuotationItemEnh AS _SupplierQuotationItem ON SupplierQuotation = _SupplierQuotationItem.SupplierQuotation  -- association [1..*]
LEFT OUTER JOIN I_RequestForQuotationEnhanced AS _RequestForQuotation ON RequestForQuotation = _RequestForQuotation.RequestForQuotation  -- association [1..1]
;

Learn More