C_PrftCtrCompCodeAssgmtTP

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_PrftCtrCompCodeAssgmtTP.
-- 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: CFIPCTRCOMASTP

CREATE VIEW C_PrftCtrCompCodeAssgmtTP AS
SELECT
  ControllingArea,
  ProfitCenter,
  CompanyCode,
  ValidityEndDate,
  CompanyCodeName,
  PrftCtrIsAssignedToCompCode,
  JointVenture,
  _JointVentureMaster.JointVentureName AS JointVentureName,
  JointVentureRecoveryCode,
  _JointVentureRecovery._Text[1:Language = $session.system_language].JointVentureRecoveryCodeName AS JointVentureRecoveryCodeName,
  JointVentureEquityType,
  _JntVntrEquityTypeMaster._JntVntrEquityTypeDesc[1:Language = $session.system_language].JointVentureEquityTypeName AS JointVentureEquityTypeName,
  JointVentureObjectType,
  _JntVntrCostCtrType._JntVntrCostCtrTypeText[1:Language = $session.system_language].JntVntrCostCtrTypeText AS JntVntrCostCtrTypeText,
  JointVentureClass,
  _JntIntrstBillgClass._JntIntrstBillgClassText[1:Language = $session.system_language].JntIntrstBillgClassText AS JntIntrstBillgClassText,
  JointVentureSubClass,
  _JntIntrstBillgSubclass._JntIntrstBillgSubclassT[1:Language = $session.system_language].JntIntrstBillgSubClassText AS JntIntrstBillgSubClassText
FROM I_PrftCtrCompCodeAssgmtTP
LEFT OUTER JOIN C_ProfitCenterTP AS _ParentNode ON ControllingArea = _ParentNode.ControllingArea AND ProfitCenter = _ParentNode.ProfitCenter AND ValidityEndDate = _ParentNode.ValidityEndDate  -- association [1..1]
LEFT OUTER JOIN I_JointVentureMaster AS _JointVentureMaster ON JointVenture = _JointVentureMaster.JointVenture AND CompanyCode = _JointVentureMaster.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_JointVentureRecovery AS _JointVentureRecovery ON JointVentureRecoveryCode = _JointVentureRecovery.JointVentureRecoveryCode AND CompanyCode = _JointVentureRecovery.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_JntVntrEquityTypeMaster AS _JntVntrEquityTypeMaster ON JointVentureEquityType = _JntVntrEquityTypeMaster.JointVentureEquityType AND CompanyCode = _JntVntrEquityTypeMaster.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_JntVntrCostCtrType AS _JntVntrCostCtrType ON JointVentureObjectType = _JntVntrCostCtrType.JntVntrCostCtrType AND CompanyCode = _JntVntrCostCtrType.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_JntIntrstBillgClass AS _JntIntrstBillgClass ON JointVentureClass = _JntIntrstBillgClass.JntIntrstBillgClass AND CompanyCode = _JntIntrstBillgClass.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_JntIntrstBillgSubclass AS _JntIntrstBillgSubclass ON CompanyCode = _JntIntrstBillgSubclass.CompanyCode AND JointVentureClass = _JntIntrstBillgSubclass.JntIntrstBillgClass AND JointVentureSubClass = _JntIntrstBillgSubclass.JntIntrstBillgSubClass  -- association [0..1]
;