A_PurchasingSource

DDL: A_PURCHASINGSOURCE SQL: APURGSRCE Type: view BASIC
19 Fields 1 Data Sources

Purchasing Source Type

A_PurchasingSource is a Basic CDS View that provides data about "Purchasing Source Type" in SAP S/4HANA. It reads from 1 data source (I_MPPurchasingSourceItem) and exposes 19 fields with key fields Material, Plant, SourceListRecord.

Data Sources (1)

SourceAliasJoin Type
I_MPPurchasingSourceItem I_MPPurchasingSourceItem from

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName APURGSRCE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.compositionRoot true view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
VDM.viewType #BASIC view
EndUserText.label Purchasing Source Type view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY Material I_MPPurchasingSourceItem Material Vehicle Model
KEY Plant I_MPPurchasingSourceItem Plant Valuation Area
KEY SourceListRecord I_MPPurchasingSourceItem SourceListRecord Number
CreationDate I_MPPurchasingSourceItem CreationDate Time Stamp
CreatedByUserName I_MPPurchasingSourceItem CreatedByUserName Person Resp.
ValidityStartDate I_MPPurchasingSourceItem ValidityStartDate Validity Start Date
ValidityEndDate I_MPPurchasingSourceItem ValidityEndDate ValidTo
Supplier I_MPPurchasingSourceItem Supplier Supplier
SupplierIsFixed I_MPPurchasingSourceItem SupplierIsFixed Fixed Supplier
PurchaseOutlineAgreement I_MPPurchasingSourceItem PurchaseOutlineAgreement Agreement
PurchaseOutlineAgreementItem I_MPPurchasingSourceItem PurchaseOutlineAgreementItem Item
SupplyingPlant I_MPPurchasingSourceItem SupplyingPlant Supplying Plant
SourceOfSupplyIsBlocked I_MPPurchasingSourceItem SourceOfSupplyIsBlocked Blocked
PurchasingOrganization I_MPPurchasingSourceItem PurchasingOrganization Purchasing Organization
MRPSourcingControl I_MPPurchasingSourceItem MRPSourcingControl MRP
OrderQuantityUnit I_MPPurchasingSourceItem OrderQuantityUnit Sales Unit
LastChangeDateTime I_MPPurchasingSourceItem LastChangeDateTime Timestamp
IssgPlantIsFixed I_MPPurchasingSourceItem IssgPlantIsFixed Fixed iss.plant
PurOutlineAgreementIsFixed I_MPPurchasingSourceItem PurOutlineAgreementIsFixed Fixed Agmt Item

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 A_PurchasingSource.
-- 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: APURGSRCE

CREATE VIEW A_PurchasingSource AS
SELECT
  I_MPPurchasingSourceItem.Material AS Material,
  I_MPPurchasingSourceItem.Plant AS Plant,
  I_MPPurchasingSourceItem.SourceListRecord AS SourceListRecord,
  I_MPPurchasingSourceItem.CreationDate AS CreationDate,
  I_MPPurchasingSourceItem.CreatedByUserName AS CreatedByUserName,
  I_MPPurchasingSourceItem.ValidityStartDate AS ValidityStartDate,
  I_MPPurchasingSourceItem.ValidityEndDate AS ValidityEndDate,
  I_MPPurchasingSourceItem.Supplier AS Supplier,
  I_MPPurchasingSourceItem.SupplierIsFixed AS SupplierIsFixed,
  I_MPPurchasingSourceItem.PurchaseOutlineAgreement AS PurchaseOutlineAgreement,
  I_MPPurchasingSourceItem.PurchaseOutlineAgreementItem AS PurchaseOutlineAgreementItem,
  I_MPPurchasingSourceItem.SupplyingPlant AS SupplyingPlant,
  I_MPPurchasingSourceItem.SourceOfSupplyIsBlocked AS SourceOfSupplyIsBlocked,
  I_MPPurchasingSourceItem.PurchasingOrganization AS PurchasingOrganization,
  I_MPPurchasingSourceItem.MRPSourcingControl AS MRPSourcingControl,
  I_MPPurchasingSourceItem.OrderQuantityUnit AS OrderQuantityUnit,
  I_MPPurchasingSourceItem.LastChangeDateTime AS LastChangeDateTime,
  I_MPPurchasingSourceItem.IssgPlantIsFixed AS IssgPlantIsFixed,
  I_MPPurchasingSourceItem.PurOutlineAgreementIsFixed AS PurOutlineAgreementIsFixed
FROM I_MPPurchasingSourceItem
;

Learn More