A_PurchaseRequisitionItem_2

DDL: A_PURCHASEREQUISITIONITEM_2 Type: view_entity CONSUMPTION
88 Fields 1 Data Sources

Item

A_PurchaseRequisitionItem_2 is a Consumption CDS View that provides data about "Item" in SAP S/4HANA. It reads from 1 data source (R_PurchaseRequisitionItemTP) and exposes 88 fields with key fields PurchaseRequisition, PurchaseRequisitionItem.

Data Sources (1)

SourceAliasJoin Type
R_PurchaseRequisitionItemTP R_PurchaseRequisitionItemTP projection

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Item view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
Metadata.ignorePropagatedAnnotations true view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view

Fields (88)

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
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
BaseUnitISOCode _UnitOfMeasure UnitOfMeasureISOCode
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
PurchaseRequisitionReleaseDate PurchaseRequisitionReleaseDate Release 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
PurReqnSSPRequestor PurReqnSSPRequestor Requestor
PurReqnSSPAuthor PurReqnSSPAuthor Author
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
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
Reservation Reservation Reservation
ItemDeliveryAddressID ItemDeliveryAddressID Address
PurReqnReceivingCustomer PurReqnReceivingCustomer
Subcontractor Subcontractor Supplier
ExpectedOverallLimitAmount ExpectedOverallLimitAmount Expected Value
OverallLimitAmount OverallLimitAmount Overall Limit
PurContractForOverallLimit PurContractForOverallLimit Contract For Limit
PurContractItemForOverallLimit PurContractItemForOverallLimit PurCon Itm for Limit
PurReqnExternalReference PurReqnExternalReference Purchase Req.
PurReqnItemExternalReference PurReqnItemExternalReference Requisn. item
PurReqnExternalSystemId PurReqnExternalSystemId External System ID
ProcurementHubSourceSystem ProcurementHubSourceSystem Connected System ID
SSPAuthorExternalBPIdnNumber SSPAuthorExternalBPIdnNumber Author
SSPReqrUserId SSPReqrUserId
PurchaseRequisitionType PurchaseRequisitionType Order Type

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 A_PurchaseRequisitionItem_2.
-- 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 A_PurchaseRequisitionItem_2 AS
SELECT
  PurchaseRequisition,
  PurchaseRequisitionItem,
  PurchasingDocument,
  PurchasingDocumentItem,
  PurReqnReleaseStatus,
  PurchasingDocumentSubtype,
  PurchasingDocumentItemCategory,
  PurchaseRequisitionItemText,
  AccountAssignmentCategory,
  Material,
  MaterialGroup,
  RequestedQuantity,
  BaseUnit,
  _UnitOfMeasure.UnitOfMeasureISOCode AS BaseUnitISOCode,
  PurchaseRequisitionPrice,
  PurReqnPriceQuantity,
  MaterialGoodsReceiptDuration,
  PurchasingOrganization,
  PurchasingGroup,
  Plant,
  CompanyCode,
  SourceOfSupplyIsAssigned,
  SupplyingPlant,
  OrderedQuantity,
  DeliveryDate,
  PurchaseRequisitionReleaseDate,
  ProcessingStatus,
  ExternalApprovalStatus,
  PurchasingInfoRecord,
  Supplier,
  IsDeleted,
  FixedSupplier,
  RequisitionerName,
  CreatedByUser,
  PurReqCreationDate,
  PurReqnItemCurrency,
  MaterialPlannedDeliveryDurn,
  DelivDateCategory,
  MultipleAcctAssgmtDistribution,
  StorageLocation,
  PurReqnSSPRequestor,
  PurReqnSSPAuthor,
  PurchaseContract,
  PurReqnSourceOfSupplyType,
  PurchaseContractItem,
  ConsumptionPosting,
  PurReqnOrigin,
  PurReqnSSPCatalog,
  PurReqnSSPCatalogItem,
  PurReqnSSPCrossCatalogItem,
  PurReqnItemBlockingStatus,
  PurReqnItemBlockingReasonText,
  Language,
  IsClosed,
  ReleaseIsNotCompleted,
  ServicePerformer,
  ProductTypeCode,
  PerformancePeriodStartDate,
  PerformancePeriodEndDate,
  PurchaseOrderPriceType,
  SupplierMaterialNumber,
  Batch,
  MaterialRevisionLevel,
  MinRemainingShelfLife,
  ItemNetAmount,
  TaxCode,
  GoodsReceiptIsExpected,
  InvoiceIsExpected,
  GoodsReceiptIsNonValuated,
  RequirementTracking,
  MRPController,
  PurchaseRequisitionIsFixed,
  LastChangeDateTime,
  Reservation,
  ItemDeliveryAddressID,
  PurReqnReceivingCustomer,
  Subcontractor,
  ExpectedOverallLimitAmount,
  OverallLimitAmount,
  PurContractForOverallLimit,
  PurContractItemForOverallLimit,
  PurReqnExternalReference,
  PurReqnItemExternalReference,
  PurReqnExternalSystemId,
  ProcurementHubSourceSystem,
  SSPAuthorExternalBPIdnNumber,
  SSPReqrUserId,
  PurchaseRequisitionType
FROM R_PurchaseRequisitionItemTP
;

Learn More