I_PurchasingInfoRecordTP

DDL: I_PURCHASINGINFORECORDTP Type: view_entity TRANSACTIONAL Package: APPL_MM_PUR_INFORECORD_TR
36 Fields 1 Data Sources

Purchasing Information Record - TP

I_PurchasingInfoRecordTP is a Transactional CDS View that provides data about "Purchasing Information Record - TP" in SAP S/4HANA. It reads from 1 data source (R_PurchasingInfoRecordTP) and exposes 36 fields with key field PurchasingInfoRecord. Part of development package APPL_MM_PUR_INFORECORD_TR.

Data Sources (1)

SourceAliasJoin Type
R_PurchasingInfoRecordTP R_PurchasingInfoRecordTP projection

Annotations (11)

NameValueLevelField
EndUserText.label Purchasing Information Record - TP view
AccessControl.authorizationCheck #CHECK view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
VDM.viewType #TRANSACTIONAL view
ObjectModel.modelingPattern #TRANSACTIONAL_INTERFACE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.sapObjectNodeType.name PurchasingInfoRecord view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
Metadata.ignorePropagatedAnnotations true view

Fields (36)

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.
_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 I_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 I_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 R_PurchasingInfoRecordTP
;

Learn More