P_ASSGBLSUPLRFORPROCMTPROD

CDS View

P_ASSGBLSUPLRFORPROCMTPROD is a CDS View in S/4HANA. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_AssgblSuplrForProcmtProd view from CONSUMPTION Assgbl Suplr for Procmt Prod Value Help 
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.sqlViewName: 'PASNSUPLPROCPROD'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY

@VDM.viewType: #CONSUMPTION

@VDM.private: true

define view P_AssgblSuplrForProcmtProd
  as select from    I_PurchasingInfoRecord as PurchasingInfoRecord
  // ensure to provide only real external supplier and no DCs; for real external supplier there is no entry in I_Plant

    left outer join I_Plant on PurchasingInfoRecord.Supplier = I_Plant.PlantSupplier

  association [1..1] to I_ActiveLogisticalProduct as _ActiveLogisticalProduct on $projection.Product = _ActiveLogisticalProduct.Product

{
  key PurchasingInfoRecord,
  key Material                                                                                    as Product,
  key Supplier,
      PurchasingInfoRecord._Supplier.SupplierName                                                 as SupplierName,
      // non existing dates are transformed to valid dates that provide the maximal time range

      case when AvailabilityStartDate = '00000000' then '00010101' else AvailabilityStartDate end as AvailabilityStartDate,
      case when AvailabilityEndDate = '00000000' then '99991231' else AvailabilityEndDate end     as AvailabilityEndDate,

      /*  Exposed associations  */
      _ActiveLogisticalProduct,
      PurchasingInfoRecord._Supplier
}
where
  // supplier is still in business

      PurchasingInfoRecord._Supplier.IsBusinessPurposeCompleted <> 'X'
  // and there is no corrresponding entry in I_Plant

  and I_Plant.Plant                                             is null
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PLANT",
"I_PURCHASINGINFORECORD",
"I_SUPPLIER"
],
"ASSOCIATED":
[
"I_ACTIVELOGISTICALPRODUCT",
"I_SUPPLIER"
],
"BASE":
[
"I_PURCHASINGINFORECORD"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More