P_PurReqnItmHierNodeRltnDrft

DDL: P_PURREQNITMHIERNODERLTNDRFT SQL: PPRITMHIERDFTRN Type: view BASIC
102 Fields 1 Data Sources 2 Associations

P_PurReqnItmHierNodeRltnDrft is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (purreqnitm_d) and exposes 102 fields with key fields PurchaseRequisitionItem, PurReqnDraftUUID. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
purreqnitm_d purreqnitm_d from

Associations (2)

CardinalityTargetAliasCondition
[1..1] P_PurchaseReqnDraft _PurchaseReqnDrft $projection.PurReqnDraftUUID = _PurchaseReqnDrft.PurReqnDraftUUID
[0..1] P_PurReqnItmHierNodeRltnDrft _Parent $projection.PurchasingParentItem = _Parent.PurchaseRequisitionItem and $projection.PurReqnDraftUUID = _Parent.PurReqnDraftUUID

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PPRITMHIERDFTRN view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.viewType #BASIC view
VDM.private true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (102)

KeyFieldSource TableSource FieldDescription
KEY PurchaseRequisitionItem purchaserequisitionitem Requisn. item
KEY PurReqnDraftUUID parentdraftuuid NodeID
PurchaseRequisition purchaserequisition Requisition
PurchaseRequisitionItemUUID draftuuid UUID
PurchasingParentItem purchasingparentitem Parent Item No
PurgConfigurableItemNumber purgconfigurableitemnumber Hierarchy Number
PurgExternalSortNumber purgexternalsortnumber External Sort No.
PurchaseRequisitionItemText purchaserequisitionitemtext Short Text
PurchaseRequisitionType purchaserequisitiontype Order Type
PurReqnReleaseStatus purreqnreleasestatus Proc.state
Material material Vehicle Model
MaterialGroup materialgroup Product Group
PurchasingGroup purchasinggroup Purchasing Group
Plant plant Valuation Area
Supplier supplier Supplier
AccountAssignmentCategory accountassignmentcategory Acct Assgmt Cat
PurchaseRequisitionPrice purchaserequisitionprice Valuation Price
PurReqnPriceQuantity purreqnpricequantity Price unit
OrderedQuantity orderedquantity Quantity
BaseUnit baseunit Unit of Measure
MRPController mrpcontroller MRP Controller
DeliveryDate deliverydate Delivery Date
CreationDate creationdate Time Stamp
IsClosed isclosed Closed
PurchaseRequisitionIsFixed purchaserequisitionisfixed "Fixed" ind.
PurReqnItemCurrency purreqnitemcurrency Currency
PurchasingDocument purchasingdocument Purchasing Document
PurchasingDocumentItem purchasingdocumentitem Purchasing Doc. Item
PurchaseRequisitionReleaseDate purchaserequisitionreleasedate Release Date
StorageLocation storagelocation StorageLocation
ProductType producttype Product Type Group
GoodsReceiptIsExpected goodsreceiptisexpected Goods Receipt
InvoiceIsExpected invoiceisexpected Invoice Receipt
PurchasingDocumentItemCategory purchasingdocumentitemcategory Item Category
ManufacturerMaterial manufacturermaterial MPN: Material
ManufacturerPartProfile manufacturerpartprofile Mfr Part Profile
ManufacturerPartNmbr manufacturerpartnmbr Mfr Part Number
PurchasingDocumentCategory purchasingdocumentcategory Doc. Category
RequestedQuantity requestedquantity Requested Quantity
MaterialGoodsReceiptDuration materialgoodsreceiptduration GR proc. time
ReleaseCode releasecode Release ind.
PurchasingOrganization purchasingorganization Purchasing Organization
SourceOfSupplyIsAssigned sourceofsupplyisassigned Assigned
SupplyingPlant supplyingplant Supplying Plant
PurReqnLimitConsumptionAmt purreqnlimitconsumptionamt Consumption Value
ProcessingStatus processingstatus Worklist Status
PurchasingInfoRecord purchasinginforecord Info Record
IsDeleted isdeleted TRUE
FixedSupplier fixedsupplier Fixed Vendor
RequisitionerName requisitionername Requisitioner
PurReqnSSPRequestor purreqnssprequestor Requestor
CreatedByUser createdbyuser User Name
PurReqCreationDate purreqcreationdate Requisn Date
ManualDeliveryAddressID manualdeliveryaddressid Address Number
ItemDeliveryAddressID itemdeliveryaddressid Address
DeliveryAddressID deliveryaddressid Address
MaterialPlannedDeliveryDurn materialplanneddeliverydurn Pl. Deliv. Time
DelivDateCategory delivdatecategory Delivery Date
MultipleAcctAssgmtDistribution multipleacctassgmtdistribution Distribution
PartialInvoiceDistribution partialinvoicedistribution Partial invoice
PurchaseContract purchasecontract Purchasing Doc.
PurReqnSourceOfSupplyType purreqnsourceofsupplytype Doc. Category
PurchaseContractItem purchasecontractitem Item
ConsumptionPosting consumptionposting Consumption Posting
PurReqnOrigin purreqnorigin Creation ind.
IsPurReqnBlocked ispurreqnblocked Blocking Ind.
Language language Report Text Language
ReleaseIsNotCompleted releaseisnotcompleted Subj.to Release
ServicePerformer serviceperformer Service Performer
ProductTypeCode producttype Product Type Group
PurchaseRequisitionStatus purchaserequisitionstatus Release State
ReleaseStrategy releasestrategy Rel. strategy
PerformancePeriodStartDate performanceperiodstartdate Start of Performance Period
PerformancePeriodEndDate performanceperiodenddate End of Performance Period
SupplierMaterialNumber suppliermaterialnumber Supp. Mat. No.
Batch batch Lot No.
MaterialRevisionLevel Revision Level
MinRemainingShelfLife minremainingshelflife Rem. Shelf Life
GoodsReceiptIsNonValuated goodsreceiptisnonvaluated GR Non-Valuated
RequirementTracking requirementtracking Tracking Number
TaxCode taxcode Tax Code
PurchasingDocumentSubtype purchasingdocumentsubtype Control
PurReqnCatalog purreqncatalog Web Service ID
PurReqnCatalogItem purreqncatalogitem Catalog Item
PurReqnCrossCatalogItem purreqncrosscatalogitem Catalog Item Key
UserDescription userdescription Full Name
ExpectedOverallLimitAmount expectedoveralllimitamount Expected Value
OverallLimitAmount overalllimitamount Overall Limit
PurchaseReqnItemUniqueID purchasereqnitemuniqueid Purch. Doc. ID
PurchaseOrderPriceType purchaseorderpricetype PO price
IsPurReqnOvrlRel ispurreqnovrlrel Overall req. rel.
ItemNetAmount itemnetamount Tot. val. rel.
ExternalApprovalStatus externalapprovalstatus Ext Prcsng. Status
IsOutline isoutline Item Set
PurReqnItemOutlineType purreqnitemoutlinetype Outline Type
DraftEntityCreationDateTime draftentitycreationdatetime Draft Created On
DraftEntityLastChangeDateTime draftentitylastchangedatetime Draft Last Changed On
HasActiveEntity hasactiveentity TRUE
DraftAdministrativeDataUUID draftadministrativedatauuid UUID
DraftEntityOperationCode draftentityoperationcode Draft - Operation Code
_PurchaseReqnDrft _PurchaseReqnDrft
_Parent _Parent

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 P_PurReqnItmHierNodeRltnDrft.
-- 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.
-- SQL view name: PPRITMHIERDFTRN

CREATE VIEW P_PurReqnItmHierNodeRltnDrft AS
SELECT
  PurchaseRequisitionItem,
  parentdraftuuid AS PurReqnDraftUUID,
  PurchaseRequisition,
  draftuuid AS PurchaseRequisitionItemUUID,
  PurchasingParentItem,
  PurgConfigurableItemNumber,
  PurgExternalSortNumber,
  PurchaseRequisitionItemText,
  PurchaseRequisitionType,
  PurReqnReleaseStatus,
  Material,
  MaterialGroup,
  PurchasingGroup,
  Plant,
  Supplier,
  AccountAssignmentCategory,
  PurchaseRequisitionPrice,
  PurReqnPriceQuantity,
  OrderedQuantity,
  BaseUnit,
  MRPController,
  DeliveryDate,
  CreationDate,
  IsClosed,
  PurchaseRequisitionIsFixed,
  PurReqnItemCurrency,
  PurchasingDocument,
  PurchasingDocumentItem,
  PurchaseRequisitionReleaseDate,
  StorageLocation,
  ProductType,
  GoodsReceiptIsExpected,
  InvoiceIsExpected,
  PurchasingDocumentItemCategory,
  ManufacturerMaterial,
  ManufacturerPartProfile,
  ManufacturerPartNmbr,
  PurchasingDocumentCategory,
  RequestedQuantity,
  MaterialGoodsReceiptDuration,
  ReleaseCode,
  PurchasingOrganization,
  SourceOfSupplyIsAssigned,
  SupplyingPlant,
  PurReqnLimitConsumptionAmt,
  ProcessingStatus,
  PurchasingInfoRecord,
  IsDeleted,
  FixedSupplier,
  RequisitionerName,
  PurReqnSSPRequestor,
  CreatedByUser,
  PurReqCreationDate,
  ManualDeliveryAddressID,
  ItemDeliveryAddressID,
  DeliveryAddressID,
  MaterialPlannedDeliveryDurn,
  DelivDateCategory,
  MultipleAcctAssgmtDistribution,
  PartialInvoiceDistribution,
  PurchaseContract,
  PurReqnSourceOfSupplyType,
  PurchaseContractItem,
  ConsumptionPosting,
  PurReqnOrigin,
  IsPurReqnBlocked,
  Language,
  ReleaseIsNotCompleted,
  ServicePerformer,
  producttype AS ProductTypeCode,
  PurchaseRequisitionStatus,
  ReleaseStrategy,
  PerformancePeriodStartDate,
  PerformancePeriodEndDate,
  SupplierMaterialNumber,
  Batch,
  cast( materialrevisionlevel as vdm_qm_revlv preserving type ) AS MaterialRevisionLevel,
  MinRemainingShelfLife,
  GoodsReceiptIsNonValuated,
  RequirementTracking,
  TaxCode,
  PurchasingDocumentSubtype,
  PurReqnCatalog,
  PurReqnCatalogItem,
  PurReqnCrossCatalogItem,
  UserDescription,
  ExpectedOverallLimitAmount,
  OverallLimitAmount,
  PurchaseReqnItemUniqueID,
  PurchaseOrderPriceType,
  IsPurReqnOvrlRel,
  ItemNetAmount,
  ExternalApprovalStatus,
  IsOutline,
  PurReqnItemOutlineType,
  DraftEntityCreationDateTime,
  DraftEntityLastChangeDateTime,
  HasActiveEntity,
  DraftAdministrativeDataUUID,
  DraftEntityOperationCode
FROM purreqnitm_d
LEFT OUTER JOIN P_PurchaseReqnDraft AS _PurchaseReqnDrft ON PurReqnDraftUUID = _PurchaseReqnDrft.PurReqnDraftUUID  -- association [1..1]
LEFT OUTER JOIN P_PurReqnItmHierNodeRltnDrft AS _Parent ON PurchasingParentItem = _Parent.PurchaseRequisitionItem AND PurReqnDraftUUID = _Parent.PurReqnDraftUUID  -- association [0..1]
;

Learn More