R_PurchasingInfoRecordTP

DDL: R_PURCHASINGINFORECORDTP Type: view_entity TRANSACTIONAL
37 Fields 1 Data Sources 1 Associations

Purchase Info Record

R_PurchasingInfoRecordTP is a Transactional CDS View that provides data about "Purchase Info Record" in SAP S/4HANA. It reads from 1 data source (I_PurchasingInfoRecord) and exposes 37 fields with key field PurchasingInfoRecord. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_PurchasingInfoRecord I_PurchasingInfoRecord from

Associations (1)

CardinalityTargetAliasCondition
[1..*] R_PurgInfoRecdOrgPlntDataTP _PurgInfoRecdOrgPlntData

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Purchase Info Record view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.sapObjectNodeType.name PurchasingInfoRecord view

Fields (37)

KeyFieldSource TableSource FieldDescription
KEY PurchasingInfoRecord PurchasingInfoRecord Info Record
Supplier Supplier Supplier
Material Material Vehicle Model
MaterialGroup MaterialGroup Product Group
CreationDate CreationDate Time Stamp
IsDeleted IsDeleted TRUE
PurchasingInfoRecordDesc PurchasingInfoRecordDesc Info Short Text
PurgInfoRecNonStockItmSortTerm PurgInfoRecNonStockItmSortTerm Sort Term
PurgDocOrderQuantityUnit PurgDocOrderQuantityUnit Purchasing Document Order Qty Unit
OrderItemQtyToBaseQtyNmrtr OrderItemQtyToBaseQtyNmrtr Equal To
OrderItemQtyToBaseQtyDnmntr OrderItemQtyToBaseQtyDnmntr Denominator
SupplierMaterialNumber SupplierMaterialNumber Supp. Mat. No.
SupplierRespSalesPersonName SupplierRespSalesPersonName Salesperson
SupplierPhoneNumber SupplierPhoneNumber Telephone
BaseUnit BaseUnit Unit of Measure
SupplierMaterialGroup SupplierMaterialGroup Suppl. Mat. Grp
PriorSupplier PriorSupplier Prior Supplier
AvailabilityStartDate AvailabilityStartDate Available from
AvailabilityEndDate AvailabilityEndDate Available to
VarblPurOrdUnitIsActive VarblPurOrdUnitIsActive Var. Order Unit
Manufacturer Manufacturer Manufacturer
IsRegularSupplier IsRegularSupplier Reg. Supplier
SupplierSubrange SupplierSubrange Suppl. Subrange
NoDaysReminder1 NoDaysReminder1 1st Rem./Exped.
NoDaysReminder2 NoDaysReminder2 2nd Rem./Exped.
NoDaysReminder3 NoDaysReminder3 3rd Rem./Exped.
ProductPurchasePointsQty ProductPurchasePointsQty Points
ProductPurchasePointsQtyUnit ProductPurchasePointsQtyUnit Points Unit
SupplierSubrangeSortNumber SupplierSubrangeSortNumber SSR Sort No.
LastChangeDateTime LastChangeDateTime Timestamp
IsEndOfPurposeBlocked IsEndOfPurposeBlocked Busin. Purp. Cmpltd.
_PurgInfoRecdOrgPlntData _PurgInfoRecdOrgPlntData
_BaseUnit _BaseUnit
_Material _Material
_MaterialGroup _MaterialGroup
_PurgDocOrderQuantityUnit _PurgDocOrderQuantityUnit
_Supplier _Supplier

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view R_PurchasingInfoRecordTP.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW R_PurchasingInfoRecordTP AS
SELECT
  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,
  ProductPurchasePointsQty,
  ProductPurchasePointsQtyUnit,
  SupplierSubrangeSortNumber,
  LastChangeDateTime,
  IsEndOfPurposeBlocked
FROM I_PurchasingInfoRecord
LEFT OUTER JOIN R_PurgInfoRecdOrgPlntDataTP AS _PurgInfoRecdOrgPlntData ON /* condition not available in parsed metadata */  -- association [1..*]
;

Learn More