I_SrcgProjQtnItemIncoterms

DDL: I_SRCGPROJQTNITEMINCOTERMS Type: view_entity BASIC Package: VDM_MM_PUR_SRCGPROJQTN

Incoterms for Itm in Srcg Proj Quotation

I_SrcgProjQtnItemIncoterms is a Basic CDS View that provides data about "Incoterms for Itm in Srcg Proj Quotation" in SAP S/4HANA. It reads from 1 data source (mmspqtnincotrm) and exposes 15 fields with key field SrcgProjQtnItemIncotermsUUID. It has 4 associations to related views. Part of development package VDM_MM_PUR_SRCGPROJQTN.

Data Sources (1)

SourceAliasJoin Type
mmspqtnincotrm mmspqtnincotrm from

Associations (4)

CardinalityTargetAliasCondition
[1..1] I_SourcingProjectQuotation _SourcingProjectQuotation $projection.SourcingProjectQuotationUUID = _SourcingProjectQuotation.SourcingProjectQuotationUUID
[1..1] I_SrcgProjQtnItem _SrcgProjQtnItem $projection.SrcgProjQtnItemUUID = _SrcgProjQtnItem.SrcgProjQtnItemUUID
[0..1] I_IncotermsClassification _IncotermsClassification $projection.IncotermsClassification = _IncotermsClassification.IncotermsClassification
[0..1] I_IncotermsVersion _IncotermsVersion $projection.IncotermsVersion = _IncotermsVersion.IncotermsVersion

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.representativeKey SrcgProjQtnItemIncotermsUUID view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
VDM.viewType #BASIC view
EndUserText.label Incoterms for Itm in Srcg Proj Quotation view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY SrcgProjQtnItemIncotermsUUID srcgprojqtnitemincotermsuuid Incoterms UUID
SrcgProjQtnItemUUID srcgprojqtnitemuuid Supplier Quotation Item UUID
SourcingProjectQuotationUUID sourcingprojectquotationuuid Supplier Quotation UUID
Plant plant Valuation Area
IncotermsClassification incotermsclassification Incoterms
IncotermsTransferLocation incotermstransferlocation Incoterms 2
IncotermsVersion incotermsversion Inco. Version
IncotermsLocation1 incotermslocation1 Inco. Location1
IncotermsLocation2 incotermslocation2 Inco. Location2
CompanyCode companycode Receiver Company Code
ProcurementHubSourceSystem procurementhubsourcesystem Connected System ID
_SourcingProjectQuotation _SourcingProjectQuotation
_SrcgProjQtnItem _SrcgProjQtnItem
_IncotermsClassification _IncotermsClassification
_IncotermsVersion _IncotermsVersion

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_SrcgProjQtnItemIncoterms.
-- 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 I_SrcgProjQtnItemIncoterms AS
SELECT
  SrcgProjQtnItemIncotermsUUID,
  SrcgProjQtnItemUUID,
  SourcingProjectQuotationUUID,
  Plant,
  IncotermsClassification,
  IncotermsTransferLocation,
  IncotermsVersion,
  IncotermsLocation1,
  IncotermsLocation2,
  CompanyCode,
  ProcurementHubSourceSystem
FROM mmspqtnincotrm
LEFT OUTER JOIN I_SourcingProjectQuotation AS _SourcingProjectQuotation ON SourcingProjectQuotationUUID = _SourcingProjectQuotation.SourcingProjectQuotationUUID  -- association [1..1]
LEFT OUTER JOIN I_SrcgProjQtnItem AS _SrcgProjQtnItem ON SrcgProjQtnItemUUID = _SrcgProjQtnItem.SrcgProjQtnItemUUID  -- association [1..1]
LEFT OUTER JOIN I_IncotermsClassification AS _IncotermsClassification ON IncotermsClassification = _IncotermsClassification.IncotermsClassification  -- association [0..1]
LEFT OUTER JOIN I_IncotermsVersion AS _IncotermsVersion ON IncotermsVersion = _IncotermsVersion.IncotermsVersion  -- association [0..1]
;