CIC_SOURCE_OF_SUPPLY_JOIN

DDL: CIC_SOURCE_OF_SUPPLY_JOIN Type: view
29 Fields 3 Data Sources

Source of Supply for valid partners

CIC_SOURCE_OF_SUPPLY_JOIN is a CDS View that provides data about "Source of Supply for valid partners" in SAP S/4HANA. It reads from 3 data sources (I_Customer, I_Supplier, CIC_SOURCE_OF_SUPPLY_UNION) and exposes 29 fields with key fields Supplier, Receiver, Product, SourceOfSupplyType, ProductGroup.

Data Sources (3)

SourceAliasJoin Type
I_Customer _Customer left_outer
I_Supplier _Supplier left_outer
CIC_SOURCE_OF_SUPPLY_UNION sos from

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName CIC_SOS_JN view
AbapCatalog.compiler.compareFilter true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Source of Supply for valid partners view
AccessControl.personalData.blocking #REQUIRED view

Fields (29)

KeyFieldSource TableSource FieldDescription
KEY Supplier CIC_SOURCE_OF_SUPPLY_UNION Supplier Supplier
KEY Receiver CIC_SOURCE_OF_SUPPLY_UNION Receiver Recipient
KEY Product CIC_SOURCE_OF_SUPPLY_UNION Product Product Sold
KEY SourceOfSupplyType CIC_SOURCE_OF_SUPPLY_UNION SourceOfSupplyType
KEY ProductGroup CIC_SOURCE_OF_SUPPLY_UNION ProductGroup Product Sold Group
KEY PurchasingOrganization CIC_SOURCE_OF_SUPPLY_UNION PurchasingOrganization Purchasing Organization
KEY Category CIC_SOURCE_OF_SUPPLY_UNION Category Violation Category
KEY ValidityStartDate CIC_SOURCE_OF_SUPPLY_UNION ValidityStartDate Validity Start Date
KEY ValidityEndDate CIC_SOURCE_OF_SUPPLY_UNION ValidityEndDate ValidTo
ReceivingTimeZone CIC_SOURCE_OF_SUPPLY_UNION ReceivingTimeZone
SupplyingPlant CIC_SOURCE_OF_SUPPLY_UNION SupplyingPlant Supplying Plant
ReceivingPlant CIC_SOURCE_OF_SUPPLY_UNION ReceivingPlant Receiving Plant
Priority CIC_SOURCE_OF_SUPPLY_UNION Priority Workflow priority
IsPurchasingBlocked CIC_SOURCE_OF_SUPPLY_UNION IsPurchasingBlocked
PurchasingInfoRecord CIC_SOURCE_OF_SUPPLY_UNION PurchasingInfoRecord Info Record
SupplierSubRange CIC_SOURCE_OF_SUPPLY_UNION SupplierSubRange Suppl. Subrange
OrderQuantityUnit CIC_SOURCE_OF_SUPPLY_UNION OrderQuantityUnit Sales Unit
OrderCurrency CIC_SOURCE_OF_SUPPLY_UNION OrderCurrency
MinimumOrderQuantity CIC_SOURCE_OF_SUPPLY_UNION MinimumOrderQuantity Minimum Order Quantity
PlannedDeliveryTimeDays CIC_SOURCE_OF_SUPPLY_UNION PlannedDeliveryTimeDays
PurchasingGroup CIC_SOURCE_OF_SUPPLY_UNION PurchasingGroup Purchasing Group
IncotermsClassification CIC_SOURCE_OF_SUPPLY_UNION IncotermsClassification Incoterms
IncotermsTransferLocationName CIC_SOURCE_OF_SUPPLY_UNION IncotermsTransferLocationName
SourceListRecord CIC_SOURCE_OF_SUPPLY_UNION SourceListRecord Number
NetPriceAmount CIC_SOURCE_OF_SUPPLY_UNION NetPriceAmount Net Price
NetPriceQuantity CIC_SOURCE_OF_SUPPLY_UNION NetPriceQuantity Price Unit
NetPriceUnit CIC_SOURCE_OF_SUPPLY_UNION NetPriceUnit
InfoRecordIsMarkedForDeletion CIC_SOURCE_OF_SUPPLY_UNION InfoRecordIsMarkedForDeletion
LogisticalRoundingProfile CIC_SOURCE_OF_SUPPLY_UNION LogisticalRoundingProfile

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 CIC_SOURCE_OF_SUPPLY_JOIN.
-- 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 CIC_SOURCE_OF_SUPPLY_JOIN AS
SELECT
  sos.Supplier AS Supplier,
  sos.Receiver AS Receiver,
  sos.Product AS Product,
  sos.SourceOfSupplyType AS SourceOfSupplyType,
  sos.ProductGroup AS ProductGroup,
  sos.PurchasingOrganization AS PurchasingOrganization,
  sos.Category AS Category,
  sos.ValidityStartDate AS ValidityStartDate,
  sos.ValidityEndDate AS ValidityEndDate,
  sos.ReceivingTimeZone AS ReceivingTimeZone,
  sos.SupplyingPlant AS SupplyingPlant,
  sos.ReceivingPlant AS ReceivingPlant,
  sos.Priority AS Priority,
  sos.IsPurchasingBlocked AS IsPurchasingBlocked,
  sos.PurchasingInfoRecord AS PurchasingInfoRecord,
  sos.SupplierSubRange AS SupplierSubRange,
  sos.OrderQuantityUnit AS OrderQuantityUnit,
  sos.OrderCurrency AS OrderCurrency,
  sos.MinimumOrderQuantity AS MinimumOrderQuantity,
  sos.PlannedDeliveryTimeDays AS PlannedDeliveryTimeDays,
  sos.PurchasingGroup AS PurchasingGroup,
  sos.IncotermsClassification AS IncotermsClassification,
  sos.IncotermsTransferLocationName AS IncotermsTransferLocationName,
  sos.SourceListRecord AS SourceListRecord,
  sos.NetPriceAmount AS NetPriceAmount,
  sos.NetPriceQuantity AS NetPriceQuantity,
  sos.NetPriceUnit AS NetPriceUnit,
  sos.InfoRecordIsMarkedForDeletion AS InfoRecordIsMarkedForDeletion,
  sos.LogisticalRoundingProfile AS LogisticalRoundingProfile
FROM CIC_SOURCE_OF_SUPPLY_UNION AS sos
LEFT OUTER JOIN I_Supplier AS _Supplier ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Customer AS _Customer ON /* join condition not captured in parsed metadata */
;

Learn More