A_PurchasingInfoRecord

DDL: A_PURCHASINGINFORECORD SQL: APURINFREC Type: view BASIC Package: ODATA_MM_PUR_INFOREC_API

Purchasing Info Record

A_PurchasingInfoRecord is a Basic CDS View that provides data about "Purchasing Info Record" in SAP S/4HANA. It reads from 1 data source (I_PurchasingInfoRecord) and exposes 35 fields with key field PurchasingInfoRecord. It has 4 associations to related views. Part of development package ODATA_MM_PUR_INFOREC_API.

1 data source(s) 35 fields

Data Sources (1)

SourceAliasJoin Type
I_PurchasingInfoRecord I_PurchasingInfoRecord from

Associations (4)

CardinalityTargetAliasCondition
[1..*] A_PurgInfoRecdOrgPlantData _PurgInfoRecdOrgPlantData $projection.PurchasingInfoRecord = _PurgInfoRecdOrgPlantData.PurchasingInfoRecord
[1..*] A_SupplierPurchasingOrg _SupplierPurchasingOrg $projection.Supplier = _SupplierPurchasingOrg.Supplier
[0..1] E_PurchasingInforecord _PurchasingInforecordExtension _PurchasingInforecordExtension.PurchasingInfoRecord = $projection.PurchasingInfoRecord
[0..*] A_PurchasingInfoRecordNote _PurchasingInfoRecordNote $projection.PurchasingInfoRecord = _PurchasingInfoRecordNote.PurchasingInfoRecord

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName APURINFREC view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #BASIC view
EndUserText.label Purchasing Info Record view
ObjectModel.compositionRoot true view
ObjectModel.representativeKey PurchasingInfoRecord view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view

Fields (35)

KeyFieldSource TableSource FieldDescription
KEY PurchasingInfoRecord PurchasingInfoRecord
Supplier Supplier
Material Material
MaterialGroup MaterialGroup
CreationDate CreationDate
IsDeleted IsDeleted
PurchasingInfoRecordDesc PurchasingInfoRecordDesc
PurgInfoRecNonStockItmSortTerm PurgInfoRecNonStockItmSortTerm
PurgDocOrderQuantityUnit PurgDocOrderQuantityUnit
OrderItemQtyToBaseQtyNmrtr OrderItemQtyToBaseQtyNmrtr
OrderItemQtyToBaseQtyDnmntr OrderItemQtyToBaseQtyDnmntr
SupplierMaterialNumber SupplierMaterialNumber
SupplierRespSalesPersonName SupplierRespSalesPersonName
SupplierPhoneNumber SupplierPhoneNumber
BaseUnit BaseUnit
SupplierMaterialGroup SupplierMaterialGroup
PriorSupplier PriorSupplier
AvailabilityStartDate AvailabilityStartDate
AvailabilityEndDate AvailabilityEndDate
VarblPurOrdUnitIsActive VarblPurOrdUnitIsActive
Manufacturer Manufacturer
IsRegularSupplier IsRegularSupplier
SupplierSubrange SupplierSubrange
NoDaysReminder1 NoDaysReminder1
NoDaysReminder2 NoDaysReminder2
NoDaysReminder3 NoDaysReminder3
ProductPurchasePointsQty ProductPurchasePointsQty
ProductPurchasePointsQtyUnit ProductPurchasePointsQtyUnit
SupplierSubrangeSortNumber SupplierSubrangeSortNumber
LastChangeDateTime LastChangeDateTime
IsEndOfPurposeBlocked IsEndOfPurposeBlocked
SupplierCertOriginCountry SupplierCertOriginCountry
_SupplierPurchasingOrg _SupplierPurchasingOrg
_PurgInfoRecdOrgPlantData _PurgInfoRecdOrgPlantData
_PurchasingInfoRecordNote _PurchasingInfoRecordNote 
@AbapCatalog.sqlViewName: 'APURINFREC'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType : #BASIC
@EndUserText.label: 'Purchasing Info Record'

@ObjectModel: {
  compositionRoot:true,
  representativeKey: 'PurchasingInfoRecord',
  createEnabled: true,
  updateEnabled: true
}


@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #L
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.lifecycle.contract.type:#PUBLIC_REMOTE_API

define view A_PurchasingInfoRecord
  as select from I_PurchasingInfoRecord

  association [1..*] to A_PurgInfoRecdOrgPlantData as _PurgInfoRecdOrgPlantData      on $projection.PurchasingInfoRecord = _PurgInfoRecdOrgPlantData.PurchasingInfoRecord
  association [1..*] to A_SupplierPurchasingOrg    as _SupplierPurchasingOrg         on $projection.Supplier = _SupplierPurchasingOrg.Supplier
  association [0..1] to E_PurchasingInforecord     as _PurchasingInforecordExtension on _PurchasingInforecordExtension.PurchasingInfoRecord = $projection.PurchasingInfoRecord
  association [0..*] to A_PurchasingInfoRecordNote as _PurchasingInfoRecordNote      on $projection.PurchasingInfoRecord = _PurchasingInfoRecordNote.PurchasingInfoRecord
{
  key PurchasingInfoRecord,

      Supplier,

      Material,

      MaterialGroup,

      CreationDate,

      IsDeleted,

      PurchasingInfoRecordDesc,

      PurgInfoRecNonStockItmSortTerm,

      PurgDocOrderQuantityUnit,

      OrderItemQtyToBaseQtyNmrtr,

      OrderItemQtyToBaseQtyDnmntr,

      SupplierMaterialNumber,

      SupplierRespSalesPersonName,

      SupplierPhoneNumber,

      BaseUnit,

      SupplierMaterialGroup,

      PriorSupplier,

      AvailabilityStartDate,

      AvailabilityEndDate,

      VarblPurOrdUnitIsActive,

      Manufacturer,

      IsRegularSupplier,

      SupplierSubrange,

      NoDaysReminder1,

      NoDaysReminder2,

      NoDaysReminder3,
      @Semantics.quantity.unitOfMeasure: 'ProductPurchasePointsQtyUnit'
      ProductPurchasePointsQty,

      ProductPurchasePointsQtyUnit,

      SupplierSubrangeSortNumber,

      LastChangeDateTime,

      IsEndOfPurposeBlocked,

      SupplierCertOriginCountry,

      _SupplierPurchasingOrg,

      @ObjectModel.association.type: [#TO_COMPOSITION_CHILD]
      _PurgInfoRecdOrgPlantData,
      
      _PurchasingInfoRecordNote

}
//where

//     IsEndOfPurposeBlocked <> 'X'

//  or IsEndOfPurposeBlocked is null

Learn More