What is I_PurInfCndHelpr in SAP S/4HANA?

I_PurInfCndHelpr is a basic CDS view in SAP S/4HANA. Helper View For CDS It contains 9 fields.

Which tables does I_PurInfCndHelpr read from?

I_PurInfCndHelpr reads data from: a017, a018, a025, a028, I_PurgInfoRecdOrgPlantData.

What VDM layer is I_PurInfCndHelpr?

I_PurInfCndHelpr is classified as a Basic (interface) view providing a 1:1 representation of a database table.

I_PurInfCndHelpr

DDL: I_PURINFCNDHELPR SQL: IPURINFCNDHLPRV Type: view BASIC

9 Fields 5 Data Sources

Helper View For CDS

I_PurInfCndHelpr is a Basic CDS View that provides data about "Helper View For CDS" in SAP S/4HANA. It reads from 5 data sources (a017, a018, a025, a028, I_PurgInfoRecdOrgPlantData) and exposes 9 fields with key fields knumhelseNULLendasConditionRecord, PurchasingInfoRecord, datsendasConditionValidityEndDate.

Data Sources (5)

Source	Alias	Join Type
a017	i_a017	left_outer
a018	i_a018	left_outer
a025	i_a025	left_outer
a028	i_a028	left_outer
I_PurgInfoRecdOrgPlantData	inf_org	inner

Annotations (10)

Name	Value	Level
AbapCatalog.sqlViewName	IPURINFCNDHLPRV	view
AbapCatalog.compiler.compareFilter	true	view
AccessControl.authorizationCheck	#CHECK	view
EndUserText.label	Helper View For CDS	view
VDM.viewType	#BASIC	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#L	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
VDM.lifecycle.contract.type	#SAP_INTERNAL_API	view

Fields (9)

Key	Field	Source Table	Source Field	Description
KEY	knumhelseNULLendasConditionRecord
KEY	PurchasingInfoRecord	inf_gen	PurchasingInfoRecord	Info Record
KEY	datsendasConditionValidityEndDate
	Supplier	inf_gen	Supplier	Supplier
	PurchasingOrganization	I_PurgInfoRecdOrgPlantData	PurchasingOrganization	Purchasing Organization
	Plant	I_PurgInfoRecdOrgPlantData	Plant	Valuation Area
	PurchasingInfoRecordCategory	I_PurgInfoRecdOrgPlantData	PurchasingInfoRecordCategory	Infotype
	datsendasConditionValidityStartDate
	char4endasConditionTable

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_PurInfCndHelpr.
-- 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: IPURINFCNDHLPRV

CREATE VIEW I_PurInfCndHelpr AS
SELECT
  case when inf_gen.Supplier <> '' and inf_gen.Material <> '' and inf_org.PurchasingOrganization <> '' and inf_org.Plant <> '' and inf_org.PurchasingInfoRecordCategory <> '' then i_a017.knumh when inf_gen.Supplier <> '' and inf_gen.Material <> '' and inf_org.PurchasingOrganization <> '' and inf_org.PurchasingInfoRecordCategory <> '' then i_a018.knumh when inf_gen.Supplier <> '' and inf_org.PurchasingOrganization <> '' and inf_gen.MaterialGroup <> '' and inf_gen.PurchasingInfoRecord <> '' and inf_org.Plant <> '' and inf_org.PurchasingInfoRecordCategory <> '' then i_a025.knumh when inf_gen.Supplier <> '' and inf_org.PurchasingOrganization <> '' and inf_gen.MaterialGroup <> '' and inf_gen.PurchasingInfoRecord <> '' and inf_org.PurchasingInfoRecordCategory <> '' then i_a028.knumh else 'NULL' end as ConditionRecord AS knumhelseNULLendasConditionRecord,
  inf_gen.PurchasingInfoRecord AS PurchasingInfoRecord,
  case when inf_gen.Supplier <> '' and inf_gen.Material <> '' and inf_org.PurchasingOrganization <> '' and inf_org.Plant <> '' and inf_org.PurchasingInfoRecordCategory <> '' then i_a017.datbi when inf_gen.Supplier <> '' and inf_gen.Material <> '' and inf_org.PurchasingOrganization <> '' and inf_org.PurchasingInfoRecordCategory <> '' then i_a018.datbi when inf_gen.Supplier <> '' and inf_org.PurchasingOrganization <> '' and inf_gen.MaterialGroup <> '' and inf_gen.PurchasingInfoRecord <> '' and inf_org.Plant <> '' and inf_org.PurchasingInfoRecordCategory <> '' then i_a025.datbi when inf_gen.Supplier <> '' and inf_org.PurchasingOrganization <> '' and inf_gen.MaterialGroup <> '' and inf_gen.PurchasingInfoRecord <> '' and inf_org.PurchasingInfoRecordCategory <> '' then i_a028.datbi else cast( '00000000' as abap.dats ) end as ConditionValidityEndDate AS datsendasConditionValidityEndDate,
  inf_gen.Supplier AS Supplier,
  inf_org.PurchasingOrganization AS PurchasingOrganization,
  inf_org.Plant AS Plant,
  inf_org.PurchasingInfoRecordCategory AS PurchasingInfoRecordCategory,
  case when inf_gen.Supplier <> '' and inf_gen.Material <> '' and inf_org.PurchasingOrganization <> '' and inf_org.Plant <> '' and inf_org.PurchasingInfoRecordCategory <> '' then i_a017.datab when inf_gen.Supplier <> '' and inf_gen.Material <> '' and inf_org.PurchasingOrganization <> '' and inf_org.PurchasingInfoRecordCategory <> '' then i_a018.datab when inf_gen.Supplier <> '' and inf_org.PurchasingOrganization <> '' and inf_gen.MaterialGroup <> '' and inf_gen.PurchasingInfoRecord <> '' and inf_org.Plant <> '' and inf_org.PurchasingInfoRecordCategory <> '' then i_a025.datab when inf_gen.Supplier <> '' and inf_org.PurchasingOrganization <> '' and inf_gen.MaterialGroup <> '' and inf_gen.PurchasingInfoRecord <> '' and inf_org.PurchasingInfoRecordCategory <> '' then i_a028.datab else cast( '00000000' as abap.dats ) end as ConditionValidityStartDate AS datsendasConditionValidityStartDate,
  case when inf_gen.Supplier <> '' and inf_gen.Material <> '' and inf_org.PurchasingOrganization <> '' and inf_org.Plant <> '' and inf_org.PurchasingInfoRecordCategory <> '' then cast('A017' as abap.char(4)) when inf_gen.Supplier <> '' and inf_gen.Material <> '' and inf_org.PurchasingOrganization <> '' and inf_org.PurchasingInfoRecordCategory <> '' then cast ('A018' as abap.char(4)) when inf_gen.Supplier <> '' and inf_org.PurchasingOrganization <> '' and inf_gen.MaterialGroup <> '' and inf_gen.PurchasingInfoRecord <> '' and inf_org.Plant <> '' and inf_org.PurchasingInfoRecordCategory <> '' then cast ('A025' as abap.char(4)) when inf_gen.Supplier <> '' and inf_org.PurchasingOrganization <> '' and inf_gen.MaterialGroup <> '' and inf_gen.PurchasingInfoRecord <> '' and inf_org.PurchasingInfoRecordCategory <> '' then cast ('A028' as abap.char(4)) else cast ('Annn' as abap.char(4)) end as ConditionTable AS char4endasConditionTable
INNER JOIN I_PurgInfoRecdOrgPlantData AS inf_org ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN a017 AS i_a017 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN a018 AS i_a018 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN a025 AS i_a025 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN a028 AS i_a028 ON /* join condition not captured in parsed metadata */
;

Depth:

I_PurInfCndHelpr view