I_POSupplierConfirmationAPI01

DDL: I_POSUPPLIERCONFIRMATIONAPI01 SQL: IPOCONFAPI Type: view BASIC Package: VDM_MM_PUR_PO_PUBLIC

Supplier Confirmation Data in PurOrd

I_POSupplierConfirmationAPI01 is a Basic CDS View that provides data about "Supplier Confirmation Data in PurOrd" in SAP S/4HANA. It reads from 2 data sources (R_PurchaseOrder, R_PurOrdSupplierConfirmation) and exposes 32 fields with key fields PurchaseOrder, PurchaseOrderItem, SequentialNmbrOfSuplrConf. It has 2 associations to related views. Part of development package VDM_MM_PUR_PO_PUBLIC.

2 data source(s) 32 fields

Data Sources (2)

SourceAliasJoin Type
R_PurchaseOrder PurchaseOrder inner
R_PurOrdSupplierConfirmation SupplierConfirmation from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_PurchaseOrderAPI01 _PurchaseOrder $projection.PurchaseOrder = _PurchaseOrder.PurchaseOrder
[1..1] I_PurchaseOrderItemAPI01 _PurchaseOrderItem $projection.PurchaseOrder = _PurchaseOrderItem.PurchaseOrder and $projection.PurchaseOrderItem = _PurchaseOrderItem.PurchaseOrderItem

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName IPOCONFAPI view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
ObjectModel.representativeKey SequentialNmbrOfSuplrConf view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
EndUserText.label Supplier Confirmation Data in PurOrd view

Fields (32)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder R_PurOrdSupplierConfirmation PurchaseOrder
KEY PurchaseOrderItem PurchaseOrderItem
KEY SequentialNmbrOfSuplrConf SequentialNmbrOfSuplrConf
SupplierConfirmationCategory SupplierConfirmationCategory
DeliveryDate DeliveryDate
DelivDateCategory DelivDateCategory
DeliveryTime DeliveryTime
CreationDate R_PurOrdSupplierConfirmation CreationDate
CreationTime CreationTime
ConfirmedQuantity ConfirmedQuantity
MRPRelevantQuantity MRPRelevantQuantity
SuplrConfCreationCategory SuplrConfCreationCategory
IsDeleted IsDeleted
ConfIsRelevantToMRP ConfIsRelevantToMRP
SupplierConfirmationExtNumber ExternalReferenceDocumentID
DeliveryDocument DeliveryDocument
DeliveryDocumentItem DeliveryDocumentItem
ManufacturerPartProfile ManufacturerPartProfile
ManufacturerMaterial ManufacturerMaterial
NumberOfReminders NumberOfReminders
Batch Batch
DeliveryIsInPlant DeliveryIsInPlant
HandoverDate HandoverDate
HandoverTime HandoverTime
PerformancePeriodStartDate PerformancePeriodStartDate
PerformancePeriodEndDate PerformancePeriodEndDate
ServicePerformer ServicePerformer
OrderQuantityUnit OrderQuantityUnit
SupplierConfirmation SupplierConfirmation
SupplierConfirmationItem SupplierConfirmationItem
_PurchaseOrder _PurchaseOrder
_PurchaseOrderItem _PurchaseOrderItem 
@AbapCatalog.sqlViewName: 'IPOCONFAPI'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK

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

@ObjectModel.representativeKey: 'SequentialNmbrOfSuplrConf'
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.supportedCapabilities: [ #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE, #CDS_MODELING_ASSOCIATION_TARGET ]
@VDM.viewType : #BASIC
@VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API
@EndUserText.label: 'Supplier Confirmation Data in PurOrd'
define view I_POSupplierConfirmationAPI01 


  as select from R_PurOrdSupplierConfirmation as SupplierConfirmation inner join R_PurchaseOrder as PurchaseOrder
                                              on SupplierConfirmation.PurchaseOrder = PurchaseOrder.PurchaseOrder 

    association [1..1] to I_PurchaseOrderAPI01     as _PurchaseOrder     on  $projection.PurchaseOrder     = _PurchaseOrder.PurchaseOrder
    association [1..1] to I_PurchaseOrderItemAPI01 as _PurchaseOrderItem on  $projection.PurchaseOrder     = _PurchaseOrderItem.PurchaseOrder
                                                                    and $projection.PurchaseOrderItem = _PurchaseOrderItem.PurchaseOrderItem
  
{

      @ObjectModel.foreignKey.association: '_PurchaseOrder'
  key SupplierConfirmation.PurchaseOrder,
      @ObjectModel.foreignKey.association: '_PurchaseOrderItem'
  key PurchaseOrderItem,
  key SequentialNmbrOfSuplrConf,
      SupplierConfirmationCategory,
      DeliveryDate,
      DelivDateCategory,
      DeliveryTime,
      SupplierConfirmation.CreationDate,
      CreationTime,
      @Semantics.quantity.unitOfMeasure: 'OrderQuantityUnit'      
      ConfirmedQuantity,
      @Semantics.quantity.unitOfMeasure: 'OrderQuantityUnit'      
      MRPRelevantQuantity,
      SuplrConfCreationCategory,
      @Semantics.booleanIndicator: true
      IsDeleted,
      ConfIsRelevantToMRP,
      ExternalReferenceDocumentID  as SupplierConfirmationExtNumber,
      DeliveryDocument,
      DeliveryDocumentItem,
      ManufacturerPartProfile,
      ManufacturerMaterial,
      NumberOfReminders,
      Batch,
      DeliveryIsInPlant,
      HandoverDate,
      HandoverTime,
      PerformancePeriodStartDate,
      PerformancePeriodEndDate,
      ServicePerformer,
      @Semantics.unitOfMeasure: true 
      OrderQuantityUnit,
      SupplierConfirmation,
      SupplierConfirmationItem,
      
    

      _PurchaseOrder,
      _PurchaseOrderItem
  
}

Learn More