C_PurchaseReqnHeader

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 C_PurchaseReqnHeader.
-- 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: CPURREQN

CREATE VIEW C_PurchaseReqnHeader AS
SELECT
  Document.PurchaseRequisition AS PurchaseRequisition,
  Document.PurchaseRequisitionForEdit AS PurchaseRequisitionForEdit,
  Document.PurchaseRequisitionType AS PurchaseRequisitionType,
  cast('' as abap.char( 20 )) AS PurchasingDocumentTypeName,
  Document.PurReqnDescription AS PurReqnDescription,
  cast('' as abap.char( 40 )) AS PurReqnDisplayDescription,
  Document.SourceDetermination AS SourceDetermination,
  cast(0 as abap.int8 ) AS NumberOfItems,
  Document.PurchasingDocumentSubtype AS PurchasingDocumentSubtype,
  Document.LastChangeDateTime AS LastChangeDateTime,
  cast('' as boolean) AS PurReqnHasAdvncdUsrInterface,
  cast ( ('00') as abap.curr(15,2) ) AS TotalNetAmount,
  cast ( ('') as abap.cuky( 5 ) ) AS Currency,
  cast( '' as abap.char( 2 ) ) AS PurReqnLifeCycleStatus,
  cast( '' as abap.char( 2 ) ) AS PurchaseConfStatusCriticality,
  cast( '' as abap.char( 60 ) ) AS PurReqnLifeCycleStatusName,
  cast( '' as xfeld ) AS PurReqnIsItemCrtnSupported,
  cast( '' as xfeld ) AS PurReqnIsLimitItemSupported,
  cast( '' as xfeld ) AS PurReqnIsStandardItemSupported,
  cast ( '' as estkz preserving type ) AS PurReqnOrigin,
  cast ( '' as abap.char( 60 ) ) AS PurReqnOriginDesc,
  cast ( '' as abap.char(10) ) AS WorkflowScenarioDefinition,
  cast( '' as xfeld ) AS IsPurReqnOvrlRel,
  cast( '' as xfeld ) AS PurReqnHasCommitmentItem,
  cast( '' as xfeld ) AS PurReqnPriceIsHidden,
  cast( '' as mmpur_req_d_pr_rework_ind ) AS PurReqnIsApplicableForRework,
  _PurchaseReqnRwrkComments.PurReqnApproverCommentText AS PurReqnApproverCommentText,
  Document.PurReqnReworkCommentText AS PurReqnReworkCommentText,
  cast ( '' as abap.char( 60 ) ) AS PurReqnHdrCurrencySourceDesc,
  cast( '' as mmpur_item_hier_exists ) AS PurchasingItemHasHierarchy,
  PurgDocItemHasHierForEdit,
  cast ('' as boolean) AS SrvcProcmtItmHierIsEnbld,
  cast( ' ' as matkl preserving type ) AS MaterialGroup,
  cast( ' ' as dispo preserving type ) AS MRPController,
  cast( ' ' as ekgrp preserving type ) AS PurchasingGroup,
  cast( ' ' as saknr preserving type ) AS GLAccount,
  cast( ' ' as kostl preserving type ) AS CostCenter,
  cast( ' ' as ernam preserving type ) AS CreatedByUser,
  cast( ' ' as mmpur_mps_id ) AS ModelProductSpecification
FROM T_PurchaseReqn AS Document
LEFT OUTER JOIN C_PurchaseReqnItem AS _PurchaseReqnItem ON _PurchaseReqnItem.PurchaseRequisition = PurchaseRequisition  -- association [1..*]
LEFT OUTER JOIN C_PurchaseReqnCommitment AS _PurchaseReqnCommitment ON _PurchaseReqnCommitment.PurchaseRequisition = PurchaseRequisition  -- association [0..*]
LEFT OUTER JOIN R_PurchaseReqnRwrkComments AS _PurchaseReqnRwrkComments ON _PurchaseReqnRwrkComments.PurchaseRequisition = '' AND _PurchaseReqnRwrkComments.PurchaseRequisition <> ''  -- association [0..1]
LEFT OUTER JOIN C_PurchaseReqnItemHierTP AS _PurchaseReqnHierItem ON _PurchaseReqnHierItem.PurchaseRequisition = PurchaseRequisition  -- association [1..*]
LEFT OUTER JOIN C_PurchaseReqnHeaderNotes AS _PurchaseReqnHeaderNotes ON _PurchaseReqnHeaderNotes.PurchaseRequisition = PurchaseRequisition  -- association [0..*]
;