I_IndependentRqmtClass

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_IndependentRqmtClass.
-- 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 I_IndependentRqmtClass AS
SELECT
  cast(bedar as vdm_bedar preserving type) AS IndependentRequirementClass,
  cast(bdtyp as vdm_bdtyp preserving type) AS IndependentRqmtCategory,
  vpzuo AS IndepRqmtAllocationStrategy,
  cast(auart as aufart preserving type) AS OrderType,
  cast(konfv as vdm_konfv preserving type) AS IndepRqmtConfignConsumption,
  mntga AS AssemblyProcessingType,
  cast(knttp as pph_knttp preserving type) AS AccountAssignmentCategory,
  cast(kzbws as pph_kzbws preserving type) AS InventorySpecialStockValnType,
  cast(abgrs as fco_abgr_schl preserving type) AS ResultAnalysisInternalID,
  cast(fkber as fkber preserving type) AS FunctionalArea,
  cast(kalvar as ck_klvar preserving type) AS CostingVariant,
  plnkz AS PlndIndepRqmtUsage,
  zuvkz AS PlndIndepRqmtConsumptionStrgy,
  atppr AS SchedLineIsProdAvailyCheckRlvt
FROM t459k
LEFT OUTER JOIN I_IndependentRqmtClassText AS _Text ON IndependentRequirementClass = _Text.IndependentRequirementClass  -- association [0..*]
LEFT OUTER JOIN I_IndependentRequirementType AS _RequirementType ON IndependentRequirementClass = _RequirementType.IndependentRequirementClass  -- association [0..*]
LEFT OUTER JOIN I_IndependentRqmtCategory AS _IndependentRqmtCategory ON IndependentRqmtCategory = _IndependentRqmtCategory.IndependentRqmtCategory  -- association [1..1]
LEFT OUTER JOIN I_OrderType AS _OrderType ON OrderType = _OrderType.OrderType  -- association [0..1]
;