Deprecated PUBLIC_LOCAL_API
This CDS view is deprecated in S/4HANA. Use I_PurchasingDocument instead. View all deprecated CDS views →

I_PurDocHeader

DDL: I_PURDOCHEADER SQL: IPDHEADER Type: view BASIC

Purchasing Document Header

I_PurDocHeader is a Basic CDS View that provides data about "Purchasing Document Header" in SAP S/4HANA. It reads from 1 data source (ekko) and exposes 6 fields with key field PurchasingDocument.

Data Sources (1)

SourceAliasJoin Type
ekko ekko from

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IPDHEADER view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #BASIC view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Purchasing Document Header view
VDM.lifecycle.status #DEPRECATED view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
VDM.lifecycle.successor I_PurchasingDocument view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY PurchasingDocument ebeln Source PurchDoc
CustomerSupplierAccount lifnr Vendor no.
PurchasingDocumentCategory ekko bstyp Source doc.cat.
PurchasingDocumentType ekko bsart Stnd purch.ord.
PurchasingOrganization ekko ekorg Purchasing Org.
PurchasingGroup ekko ekgrp Sub. purchasing grp

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_PurDocHeader.
-- 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: IPDHEADER

CREATE VIEW I_PurDocHeader AS
SELECT
  ebeln AS PurchasingDocument,
  lifnr AS CustomerSupplierAccount,
  ekko.bstyp AS PurchasingDocumentCategory,
  ekko.bsart AS PurchasingDocumentType,
  ekko.ekorg AS PurchasingOrganization,
  ekko.ekgrp AS PurchasingGroup
FROM ekko
;