A_PurchasingSource

DDL: A_PURCHASINGSOURCE SQL: APURGSRCE Type: view COMPOSITE Package: ODATA_MM_PUR_SL_API

Purchasing Source Type

A_PurchasingSource is a Composite 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. It has 1 association to related views. Part of development package ODATA_MM_PUR_SL_API.

1 data source(s) 19 fields

Data Sources (1)

SourceAliasJoin Type
I_MPPurchasingSourceItem I_MPPurchasingSourceItem from

Associations (1)

CardinalityTargetAliasCondition
[0..1] E_MPPurchasingSourceItem _Extension $projection.Material = _Extension.Material and $projection.Plant = _Extension.Plant and $projection.SourceListRecord = _Extension.SourceListRecord

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 #COMPOSITE 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
KEY Plant I_MPPurchasingSourceItem Plant
KEY SourceListRecord I_MPPurchasingSourceItem SourceListRecord
CreationDate I_MPPurchasingSourceItem CreationDate
CreatedByUserName I_MPPurchasingSourceItem CreatedByUserName
ValidityStartDate I_MPPurchasingSourceItem ValidityStartDate
ValidityEndDate I_MPPurchasingSourceItem ValidityEndDate
Supplier I_MPPurchasingSourceItem Supplier
SupplierIsFixed I_MPPurchasingSourceItem SupplierIsFixed
PurchaseOutlineAgreement I_MPPurchasingSourceItem PurchaseOutlineAgreement
PurchaseOutlineAgreementItem I_MPPurchasingSourceItem PurchaseOutlineAgreementItem
SupplyingPlant I_MPPurchasingSourceItem SupplyingPlant
SourceOfSupplyIsBlocked I_MPPurchasingSourceItem SourceOfSupplyIsBlocked
PurchasingOrganization I_MPPurchasingSourceItem PurchasingOrganization
MRPSourcingControl I_MPPurchasingSourceItem MRPSourcingControl
OrderQuantityUnit I_MPPurchasingSourceItem OrderQuantityUnit
LastChangeDateTime I_MPPurchasingSourceItem LastChangeDateTime
IssgPlantIsFixed I_MPPurchasingSourceItem IssgPlantIsFixed
PurOutlineAgreementIsFixed I_MPPurchasingSourceItem PurOutlineAgreementIsFixed 
@AbapCatalog.sqlViewName: 'APURGSRCE'
@AbapCatalog.compiler.compareFilter: true

@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true

@ObjectModel.usageType: {
  dataClass: #MASTER,
  serviceQuality: #B,
  sizeCategory: #M
}
@ObjectModel: {
  compositionRoot:true,
  createEnabled: true,
  updateEnabled: true,
  deleteEnabled: true
}
@VDM.viewType:#COMPOSITE
@EndUserText.label: 'Purchasing Source Type'
@VDM.lifecycle.contract.type:#PUBLIC_REMOTE_API

define view A_PurchasingSource
  as select from I_MPPurchasingSourceItem
  
  association [0..1] to E_MPPurchasingSourceItem as  _Extension on $projection.Material = _Extension.Material
                                                                and $projection.Plant    = _Extension.Plant  
                                                                and $projection.SourceListRecord = _Extension.SourceListRecord
{

      @ObjectModel.mandatory: true
  key I_MPPurchasingSourceItem.Material,

      @ObjectModel.mandatory: true
  key I_MPPurchasingSourceItem.Plant,

      @ObjectModel.readOnly: true
  key I_MPPurchasingSourceItem.SourceListRecord,

      @ObjectModel.readOnly: true
      I_MPPurchasingSourceItem.CreationDate,

      @ObjectModel.readOnly: true
      I_MPPurchasingSourceItem.CreatedByUserName,

      @ObjectModel.mandatory: true
      I_MPPurchasingSourceItem.ValidityStartDate,

      @ObjectModel.mandatory: true
      I_MPPurchasingSourceItem.ValidityEndDate,

      @ObjectModel.mandatory: true
      I_MPPurchasingSourceItem.Supplier,

      @ObjectModel.readOnly: true
      I_MPPurchasingSourceItem.SupplierIsFixed,

      I_MPPurchasingSourceItem.PurchaseOutlineAgreement,

      I_MPPurchasingSourceItem.PurchaseOutlineAgreementItem,

      I_MPPurchasingSourceItem.SupplyingPlant,

      I_MPPurchasingSourceItem.SourceOfSupplyIsBlocked,

      @ObjectModel.mandatory: true
      I_MPPurchasingSourceItem.PurchasingOrganization,

      I_MPPurchasingSourceItem.MRPSourcingControl,

      I_MPPurchasingSourceItem.OrderQuantityUnit,

      @ObjectModel.readOnly: true
      I_MPPurchasingSourceItem.LastChangeDateTime,

      @ObjectModel.readOnly: true
      I_MPPurchasingSourceItem.IssgPlantIsFixed,

      @ObjectModel.readOnly: true
      I_MPPurchasingSourceItem.PurOutlineAgreementIsFixed,

      @ObjectModel.readOnly: true
      cast( case
       when  ( I_MPPurchasingSourceItem.IssgPlantIsFixed = 'X' or
               I_MPPurchasingSourceItem.PurOutlineAgreementIsFixed  = 'X' or
               I_MPPurchasingSourceItem.SupplierIsFixed  = 'X' )
            then 'X'
            else ' '
       end as feskz preserving type ) as SourceOfSupplyIsFixed

}

Learn More