A_PurchasingInfoRecord

DDL: A_PURCHASINGINFORECORD SQL: APURINFREC Type: view BASIC

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 32 fields with key field PurchasingInfoRecord. It has 1 association to related views.

1 data source(s) 32 fields

Data Sources (1)

SourceAliasJoin Type
I_PurchasingInfoRecord I_PurchasingInfoRecord from

Associations (1)

CardinalityTargetAliasCondition
[1..*] A_PurgInfoRecdOrgPlantData _PurgInfoRecdOrgPlantData $projection.PurchasingInfoRecord = _PurgInfoRecdOrgPlantData.PurchasingInfoRecord

Annotations (15)

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
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 (32)

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
_PurgInfoRecdOrgPlantData _PurgInfoRecdOrgPlantData 
@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
}

@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

{
  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,

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

}
//where

//     IsEndOfPurposeBlocked <> 'X'

//  or IsEndOfPurposeBlocked is null

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PURCHASINGINFORECORD"
],
"ASSOCIATED":
[
"A_PURGINFORECDORGPLANTDATA"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More