C_SourcesOfSupply

DDL: C_SOURCESOFSUPPLY SQL: CMMSOSSIMULATE Type: view CONSUMPTION
36 Fields 1 Data Sources 2 Associations

Sources of Supply

C_SourcesOfSupply is a Consumption CDS View that provides data about "Sources of Supply" in SAP S/4HANA. It reads from 1 data source (I_SourcesOfSupply) and exposes 36 fields with key fields SourceDocument, SourceDocumentItem, Material, Plant, SourceListRecord. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_SourcesOfSupply _SOS from

Associations (2)

CardinalityTargetAliasCondition
[0..1] C_MM_MaterialValueHelp _MaterialValueHelp _MaterialValueHelp.Material = $projection.Material and _MaterialValueHelp.Plant = $projection.Plant
[0..1] I_Plant _Plant _Plant.Plant = $projection.Plant or _Plant.DefaultPurchasingOrganization = $projection.PurchasingOrganization

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CMMSOSSIMULATE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Sources of Supply view
Search.searchable true view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (36)

KeyFieldSource TableSource FieldDescription
KEY SourceDocument I_SourcesOfSupply SourceDocument Document
KEY SourceDocumentItem I_SourcesOfSupply SourceDocumentItem Purchasing Doc. Item
KEY Material I_SourcesOfSupply Material Vehicle Model
KEY Plant I_SourcesOfSupply Plant Valuation Area
KEY SourceListRecord I_SourcesOfSupply SourceListRecord Number
KEY PurchasingInfoRecordCategory I_SourcesOfSupply PurchasingInfoRecordCategory Infotype
PurchasingSourceType I_SourcesOfSupply PurchasingSourceType
Supplier I_SourcesOfSupply Supplier Supplier
SupplierName I_SourcesOfSupply SupplierName Supplier Name
AuthorizationGroup I_SourcesOfSupply AuthorizationGroup AuthorizGroup
ValidityStartDate I_SourcesOfSupply ValidityStartDate Validity Start Date
ValidityEndDate I_SourcesOfSupply ValidityEndDate ValidTo
ValidFrom I_SourcesOfSupply ValidFrom Vers.Valid From
ValidTo I_SourcesOfSupply ValidTo Vers.Valid To
PurOutlineAgreementIsFixed I_SourcesOfSupply PurOutlineAgreementIsFixed Fixed Agmt Item
SourceOfSupplyIsFixed I_SourcesOfSupply SourceOfSupplyIsFixed Indicator
SourceOfSupplyIsBlocked I_SourcesOfSupply SourceOfSupplyIsBlocked Blocked
QuotaInPercent I_SourcesOfSupply QuotaInPercent Quota in Prcent
SupplierRank I_SourcesOfSupply SupplierRank
PurchasingGroup I_SourcesOfSupply PurchasingGroup Purchasing Group
PurchasingDocumentType I_SourcesOfSupply PurchasingDocumentType RFQ Type
StorageLocation I_SourcesOfSupply StorageLocation StorageLocation
PurchasingOrganization I_SourcesOfSupply PurchasingOrganization Purchasing Organization
DataControllerSet DataControllerSet Data Ctrlr. Set
DataController1 DataController1 Data Controller
DataController2 DataController2 Data Controller
DataController3 DataController3 Data Controller
DataController4 DataController4 Data Controller
DataController5 DataController5 Data Controller
DataController6 DataController6 Data Controller
DataController7 DataController7 Data Controller
DataController8 DataController8 Data Controller
DataController9 DataController9 Data Controller
DataController10 DataController10 Data Controller
_MaterialValueHelp _MaterialValueHelp
_Plant _Plant

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 C_SourcesOfSupply.
-- 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: CMMSOSSIMULATE

CREATE VIEW C_SourcesOfSupply AS
SELECT
  _SOS.SourceDocument AS SourceDocument,
  _SOS.SourceDocumentItem AS SourceDocumentItem,
  _SOS.Material AS Material,
  _SOS.Plant AS Plant,
  _SOS.SourceListRecord AS SourceListRecord,
  _SOS.PurchasingInfoRecordCategory AS PurchasingInfoRecordCategory,
  _SOS.PurchasingSourceType AS PurchasingSourceType,
  _SOS.Supplier AS Supplier,
  _SOS.SupplierName AS SupplierName,
  _SOS.AuthorizationGroup AS AuthorizationGroup,
  _SOS.ValidityStartDate AS ValidityStartDate,
  _SOS.ValidityEndDate AS ValidityEndDate,
  _SOS.ValidFrom AS ValidFrom,
  _SOS.ValidTo AS ValidTo,
  _SOS.PurOutlineAgreementIsFixed AS PurOutlineAgreementIsFixed,
  _SOS.SourceOfSupplyIsFixed AS SourceOfSupplyIsFixed,
  _SOS.SourceOfSupplyIsBlocked AS SourceOfSupplyIsBlocked,
  _SOS.QuotaInPercent AS QuotaInPercent,
  _SOS.SupplierRank AS SupplierRank,
  _SOS.PurchasingGroup AS PurchasingGroup,
  _SOS.PurchasingDocumentType AS PurchasingDocumentType,
  _SOS.StorageLocation AS StorageLocation,
  _SOS.PurchasingOrganization AS PurchasingOrganization,
  DataControllerSet,
  DataController1,
  DataController2,
  DataController3,
  DataController4,
  DataController5,
  DataController6,
  DataController7,
  DataController8,
  DataController9,
  DataController10
FROM I_SourcesOfSupply AS _SOS
LEFT OUTER JOIN C_MM_MaterialValueHelp AS _MaterialValueHelp ON _MaterialValueHelp.Material = Material AND _MaterialValueHelp.Plant = Plant  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _Plant ON _Plant.Plant = Plant OR _Plant.DefaultPurchasingOrganization = PurchasingOrganization  -- association [0..1]
;

Learn More