CIC_SOURCE_LIST

DDL: CIC_SOURCE_LIST Type: view_entity
28 Fields 1 Data Sources

CIC Source of Supply Type A: Source List

CIC_SOURCE_LIST is a CDS View that provides data about "CIC Source of Supply Type A: Source List" in SAP S/4HANA. It reads from 1 data source (I_MPPurchasingSourceItem) and exposes 28 fields with key fields SupplierendasSupplier, Receiver, Product, SourceOfSupplyType, ProductGroup.

Data Sources (1)

SourceAliasJoin Type
I_MPPurchasingSourceItem sourcelist from

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label CIC Source of Supply Type A: Source List view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view

Fields (28)

KeyFieldSource TableSource FieldDescription
KEY SupplierendasSupplier
KEY Receiver _Plant PlantCustomer
KEY Product Material Vehicle Model
KEY SourceOfSupplyType
KEY ProductGroup
KEY PurchasingOrganization PurchasingOrganization Purchasing Organization
KEY ValidityStartDate ValidityStartDate Validity Start Date
KEY ValidityEndDate ValidityEndDate ValidTo
KEY Category SourceListRecordCategory Control
ReceivingTimeZone
SupplyingPlant SupplyingPlant Supplying Plant
ReceivingPlant Plant Valuation Area
IsPurchasingBlocked SourceOfSupplyIsBlocked Blocked
PurchasingInfoRecord
SupplierSubRange
OrderQuantityUnit OrderQuantityUnit Sales Unit
OrderCurrency
MinimumOrderQuantity
PlannedDeliveryTimeDays
PurchasingGroup
IncotermsClassification
IncotermsTransferLocationName
SourceListRecord SourceListRecord Number
NetPriceAmount
NetPriceQuantity
NetPriceUnit
InfoRecordIsMarkedForDeletion
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_LIST.
-- 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_LIST AS
SELECT
  case sourcelist.Supplier when '' then _SupplyingPlant.PlantSupplier else sourcelist.Supplier end as Supplier AS SupplierendasSupplier,
  _Plant.PlantCustomer AS Receiver,
  Material AS Product,
  cast ('A' as cic_source_of_supply_type ) AS SourceOfSupplyType,
  cast('' as matkl) AS ProductGroup,
  PurchasingOrganization,
  ValidityStartDate,
  ValidityEndDate,
  SourceListRecordCategory AS Category,
  _Plant._Address.AddressTimeZone AS ReceivingTimeZone,
  SupplyingPlant,
  Plant AS ReceivingPlant,
  SourceOfSupplyIsBlocked AS IsPurchasingBlocked,
  cast('' as infnr) AS PurchasingInfoRecord,
  cast('' as ltsnr) AS SupplierSubRange,
  OrderQuantityUnit,
  cast('' as waers) AS OrderCurrency,
  cast(0 as minbm) AS MinimumOrderQuantity,
  cast(0 as plifz) AS PlannedDeliveryTimeDays,
  cast('' as bkgrp) AS PurchasingGroup,
  cast('' as inco1) AS IncotermsClassification,
  cast('' as inco2) AS IncotermsTransferLocationName,
  SourceListRecord,
  cast(0 as netpr) AS NetPriceAmount,
  cast(0 as peinh) AS NetPriceQuantity,
  cast('' as bprme) AS NetPriceUnit,
  cast('' as iloea) AS InfoRecordIsMarkedForDeletion,
  cast('' as rdprf) AS LogisticalRoundingProfile
FROM I_MPPurchasingSourceItem AS sourcelist
;

Learn More