I_PurchaseReqnItemTP

DDL: I_PURCHASEREQNITEMTP Type: view_entity TRANSACTIONAL
110 Fields 1 Data Sources

Purchase Requisition Item - TP

I_PurchaseReqnItemTP is a Transactional CDS View that provides data about "Purchase Requisition Item - TP" in SAP S/4HANA. It reads from 1 data source (R_PurchaseRequisitionItemTP) and exposes 110 fields with key fields PurchaseRequisition, PurchaseRequisitionItem.

Data Sources (1)

SourceAliasJoin Type
R_PurchaseRequisitionItemTP R_PurchaseRequisitionItemTP projection

Annotations (11)

NameValueLevelField
EndUserText.label Purchase Requisition Item - 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.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.representativeKey PurchaseRequisitionItem view
Metadata.ignorePropagatedAnnotations true view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view

Fields (110)

KeyFieldSource TableSource FieldDescription
KEY PurchaseRequisition PurchaseRequisition Requisition
KEY PurchaseRequisitionItem PurchaseRequisitionItem Requisn. item
PurchasingDocument PurchasingDocument Purchasing Document
PurchasingDocumentItem PurchasingDocumentItem Purchasing Doc. Item
PurReqnReleaseStatus PurReqnReleaseStatus Proc.state
PurchaseRequisitionType PurchaseRequisitionType Order Type
PurchasingDocumentSubtype PurchasingDocumentSubtype Control
PurchasingDocumentItemCategory PurchasingDocumentItemCategory Item Category
PurchaseRequisitionItemText PurchaseRequisitionItemText Short Text
AccountAssignmentCategory AccountAssignmentCategory Acct Assgmt Cat
Material Material Vehicle Model
MaterialGroup MaterialGroup Product Group
RequestedQuantity RequestedQuantity Requested Quantity
BaseUnit BaseUnit Unit of Measure
PurchaseRequisitionPrice PurchaseRequisitionPrice Valuation Price
PurReqnPriceQuantity PurReqnPriceQuantity Price unit
MaterialGoodsReceiptDuration MaterialGoodsReceiptDuration GR proc. time
PurchasingOrganization PurchasingOrganization Purchasing Organization
PurchasingGroup PurchasingGroup Purchasing Group
Plant Plant Valuation Area
CompanyCode CompanyCode Receiver Company Code
SourceOfSupplyIsAssigned SourceOfSupplyIsAssigned Assigned
SupplyingPlant SupplyingPlant Supplying Plant
OrderedQuantity OrderedQuantity Quantity
DeliveryDate DeliveryDate Delivery Date
ProcessingStatus ProcessingStatus Worklist Status
ExternalApprovalStatus ExternalApprovalStatus Ext Prcsng. Status
PurchasingInfoRecord PurchasingInfoRecord Info Record
Supplier Supplier Supplier
IsDeleted IsDeleted TRUE
FixedSupplier FixedSupplier Fixed Vendor
RequisitionerName RequisitionerName Requisitioner
CreatedByUser CreatedByUser User Name
PurReqCreationDate PurReqCreationDate Requisn Date
PurReqnItemCurrency PurReqnItemCurrency Currency
MaterialPlannedDeliveryDurn MaterialPlannedDeliveryDurn Pl. Deliv. Time
DelivDateCategory DelivDateCategory Delivery Date
MultipleAcctAssgmtDistribution MultipleAcctAssgmtDistribution Distribution
StorageLocation StorageLocation StorageLocation
PurchaseContract PurchaseContract Purchasing Doc.
PurReqnSourceOfSupplyType PurReqnSourceOfSupplyType Doc. Category
PurchaseContractItem PurchaseContractItem Item
ConsumptionPosting ConsumptionPosting Consumption Posting
PurReqnOrigin PurReqnOrigin Creation ind.
PurReqnSSPCatalog PurReqnSSPCatalog Web Service ID
PurReqnSSPCatalogItem PurReqnSSPCatalogItem Catalog Item
PurReqnSSPCrossCatalogItem PurReqnSSPCrossCatalogItem Catalog item key
PurReqnItemBlockingStatus PurReqnItemBlockingStatus Blocking Ind.
PurReqnItemBlockingReasonText PurReqnItemBlockingReasonText
ItemDeliveryAddressID ItemDeliveryAddressID Address
Language Language Report Text Language
IsClosed IsClosed Closed
ReleaseIsNotCompleted ReleaseIsNotCompleted Subj.to Release
ServicePerformer ServicePerformer Service Performer
ProductTypeCode ProductTypeCode Product Type Group
PerformancePeriodStartDate PerformancePeriodStartDate Start of Performance Period
PerformancePeriodEndDate PerformancePeriodEndDate End of Performance Period
PurchaseOrderPriceType PurchaseOrderPriceType PO price
SupplierMaterialNumber SupplierMaterialNumber Supp. Mat. No.
Batch Batch Lot No.
MaterialRevisionLevel MaterialRevisionLevel Revision Level
MinRemainingShelfLife MinRemainingShelfLife Rem. Shelf Life
ItemNetAmount ItemNetAmount Tot. val. rel.
TaxCode TaxCode Tax Code
GoodsReceiptIsExpected GoodsReceiptIsExpected Goods Receipt
InvoiceIsExpected InvoiceIsExpected Invoice Receipt
GoodsReceiptIsNonValuated GoodsReceiptIsNonValuated GR Non-Valuated
RequirementTracking RequirementTracking Tracking Number
MRPController MRPController MRP Controller
PurchaseRequisitionIsFixed PurchaseRequisitionIsFixed "Fixed" ind.
LastChangeDateTime LastChangeDateTime Timestamp
ExpectedOverallLimitAmount ExpectedOverallLimitAmount Expected Value
OverallLimitAmount OverallLimitAmount Overall Limit
PurContractForOverallLimit PurContractForOverallLimit Contract For Limit
PurReqnExternalReference PurReqnExternalReference Purchase Req.
PurReqnItemExternalReference PurReqnItemExternalReference Requisn. item
PurReqnExternalSystemId PurReqnExternalSystemId External System ID
ExtMaterialForPurg ExtMaterialForPurg Material
ExtFixedSupplierForPurg ExtFixedSupplierForPurg Fixed Supplier
ExtDesiredSupplierForPurg ExtDesiredSupplierForPurg Desired Supplier
ExtContractForPurg ExtContractForPurg Contract
ExtContractItemForPurg ExtContractItemForPurg Item
ExtInfoRecordForPurg ExtInfoRecordForPurg Info Record
ExtPlantForPurg ExtPlantForPurg Plant
ExtCompanyCodeForPurg ExtCompanyCodeForPurg Company Code
ExtPurgOrgForPurg ExtPurgOrgForPurg Purch. Organization
ProcurementHubSourceSystem ProcurementHubSourceSystem Connected System ID
ProcmtHubPurReqnItmIsChanged ProcmtHubPurReqnItmIsChanged
SSPAuthorExternalBPIdnNumber SSPAuthorExternalBPIdnNumber Author
SSPReqrUserId SSPReqrUserId
PurReqnSSPRequestor PurReqnSSPRequestor Requestor
PurReqnSSPAuthor PurReqnSSPAuthor Author
IsOnBehalfCart IsOnBehalfCart Shop On Behalf Ind.
Subcontractor Subcontractor Supplier
PurReqnReceivingCustomer PurReqnReceivingCustomer
IsPurReqnCmplt IsPurReqnCmplt Incomplete
IsPurReqnOvrlRel IsPurReqnOvrlRel Overall req. rel.
LastChangedDate LastChangedDate Created On
ManufacturerMaterial ManufacturerMaterial MPN: Material
ManufacturerPartProfile ManufacturerPartProfile Mfr Part Profile
PurchaseReqnItemUniqueID PurchaseReqnItemUniqueID Purch. Doc. ID
PurReqnCmpltnsCat PurReqnCmpltnsCat Incompl. Cat.
MaterialOrderUnit MaterialOrderUnit
MaterialShortageQuantity MaterialShortageQuantity Shortage Qty
MRPArea MRPArea MRP Area
PartialInvoiceDistribution PartialInvoiceDistribution Partial invoice
ProcuringPlant ProcuringPlant Procuring Plant
PurchaseOrderDate PurchaseOrderDate PO Date
_UnitOfMeasure _UnitOfMeasure
_Currency _Currency

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_PurchaseReqnItemTP.
-- 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_PurchaseReqnItemTP AS
SELECT
  PurchaseRequisition,
  PurchaseRequisitionItem,
  PurchasingDocument,
  PurchasingDocumentItem,
  PurReqnReleaseStatus,
  PurchaseRequisitionType,
  PurchasingDocumentSubtype,
  PurchasingDocumentItemCategory,
  PurchaseRequisitionItemText,
  AccountAssignmentCategory,
  Material,
  MaterialGroup,
  RequestedQuantity,
  BaseUnit,
  PurchaseRequisitionPrice,
  PurReqnPriceQuantity,
  MaterialGoodsReceiptDuration,
  PurchasingOrganization,
  PurchasingGroup,
  Plant,
  CompanyCode,
  SourceOfSupplyIsAssigned,
  SupplyingPlant,
  OrderedQuantity,
  DeliveryDate,
  ProcessingStatus,
  ExternalApprovalStatus,
  PurchasingInfoRecord,
  Supplier,
  IsDeleted,
  FixedSupplier,
  RequisitionerName,
  CreatedByUser,
  PurReqCreationDate,
  PurReqnItemCurrency,
  MaterialPlannedDeliveryDurn,
  DelivDateCategory,
  MultipleAcctAssgmtDistribution,
  StorageLocation,
  PurchaseContract,
  PurReqnSourceOfSupplyType,
  PurchaseContractItem,
  ConsumptionPosting,
  PurReqnOrigin,
  PurReqnSSPCatalog,
  PurReqnSSPCatalogItem,
  PurReqnSSPCrossCatalogItem,
  PurReqnItemBlockingStatus,
  PurReqnItemBlockingReasonText,
  ItemDeliveryAddressID,
  Language,
  IsClosed,
  ReleaseIsNotCompleted,
  ServicePerformer,
  ProductTypeCode,
  PerformancePeriodStartDate,
  PerformancePeriodEndDate,
  PurchaseOrderPriceType,
  SupplierMaterialNumber,
  Batch,
  MaterialRevisionLevel,
  MinRemainingShelfLife,
  ItemNetAmount,
  TaxCode,
  GoodsReceiptIsExpected,
  InvoiceIsExpected,
  GoodsReceiptIsNonValuated,
  RequirementTracking,
  MRPController,
  PurchaseRequisitionIsFixed,
  LastChangeDateTime,
  ExpectedOverallLimitAmount,
  OverallLimitAmount,
  PurContractForOverallLimit,
  PurReqnExternalReference,
  PurReqnItemExternalReference,
  PurReqnExternalSystemId,
  ExtMaterialForPurg,
  ExtFixedSupplierForPurg,
  ExtDesiredSupplierForPurg,
  ExtContractForPurg,
  ExtContractItemForPurg,
  ExtInfoRecordForPurg,
  ExtPlantForPurg,
  ExtCompanyCodeForPurg,
  ExtPurgOrgForPurg,
  ProcurementHubSourceSystem,
  ProcmtHubPurReqnItmIsChanged,
  SSPAuthorExternalBPIdnNumber,
  SSPReqrUserId,
  PurReqnSSPRequestor,
  PurReqnSSPAuthor,
  IsOnBehalfCart,
  Subcontractor,
  PurReqnReceivingCustomer,
  IsPurReqnCmplt,
  IsPurReqnOvrlRel,
  LastChangedDate,
  ManufacturerMaterial,
  ManufacturerPartProfile,
  PurchaseReqnItemUniqueID,
  PurReqnCmpltnsCat,
  MaterialOrderUnit,
  MaterialShortageQuantity,
  MRPArea,
  PartialInvoiceDistribution,
  ProcuringPlant,
  PurchaseOrderDate
FROM R_PurchaseRequisitionItemTP
;

Learn More