C_ChrgPlnTechResourceTP

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_ChrgPlnTechResourceTP.
-- 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: CCHPLTRESTP

CREATE VIEW C_ChrgPlnTechResourceTP AS
SELECT
  ChrgPlnTechResource.ChrgPlanTechnicalResourceUUID AS ChrgPlanTechnicalResourceUUID,
  ChrgPlnTechResource.CreatedByUser AS CreatedByUser,
  ChrgPlnTechResource.CreationDateTime AS CreationDateTime,
  ChrgPlnTechResource.LastChangedByUser AS LastChangedByUser,
  ChrgPlnTechResource.LastChangeDateTime AS LastChangeDateTime,
  ChrgPlnTechResource.ChargePlanAssignmentUUID AS ChargePlanAssignmentUUID,
  ChrgPlnTechResource.SubscrpnProdSpecUUID AS SubscrpnProdSpecUUID,
  ChrgPlnTechResource.ChargePlanTechnicalResourceID AS ChargePlanTechnicalResourceID,
  ChrgPlnTechResource.ChrgPlnTechResourceDescription AS ChrgPlnTechResourceDescription,
  ChrgPlnTechResource.CATechnicalResourceIDType AS CATechnicalResourceIDType,
  ChrgPlnTechResource.ChrgPlnTechResourceLocation AS ChrgPlnTechResourceLocation,
  ChrgPlnTechResource.ChrgPlnTechServiceDescription AS ChrgPlnTechServiceDescription,
  ChrgPlnTechResource.BRFFunctionUUID AS BRFFunctionUUID,
  cast( '' as fdt_text ) AS BRFFunctionText,
  _CATechResourceIDTypeText.CATechnicalResourceIDTypeName AS CATechnicalResourceIDTypeName,
  _SubscrpnProdSpecTP.SubscrpnProdTechRsceSchema AS SubscrpnProdTechRsceSchema,
  ChrgPlnTechResource._CreatedByUser.UserDescription AS CreatedByUserName,
  ChrgPlnTechResource._LastChangedByUser.UserDescription AS LastChangedByUserName
FROM I_ChrgPlnTechResourceTP AS ChrgPlnTechResource
LEFT OUTER JOIN C_SubscrpnProdSpecTP AS _SubscrpnProdSpecTP ON _SubscrpnProdSpecTP.SubscrpnProdSpecUUID = SubscrpnProdSpecUUID  -- association [1..1]
LEFT OUTER JOIN C_ChargePlanAssignmentTP AS _ChargePlanAssignmentTP ON _ChargePlanAssignmentTP.ChargePlanAssignmentUUID = ChargePlanAssignmentUUID  -- association [1..1]
LEFT OUTER JOIN C_ChrgPlnTechServiceTP AS _ChrgPlnTechServiceTP ON _ChrgPlnTechServiceTP.ChrgPlanTechnicalResourceUUID = ChrgPlanTechnicalResourceUUID  -- association [0..*]
LEFT OUTER JOIN I_CATechResourceIDTypeText AS _CATechResourceIDTypeText ON _CATechResourceIDTypeText.CATechnicalResourceIDType = CATechnicalResourceIDType AND _CATechResourceIDTypeText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN C_SOM_ChrgPlnTechRsceLocVH AS _SOM_ChrgPlnTechRsceLocVH ON _SOM_ChrgPlnTechRsceLocVH.ChrgPlnTechResourceLocation = ChrgPlnTechResourceLocation  -- association [0..1]
LEFT OUTER JOIN C_ChrgPlnTechRsceIDTypeVH AS _ChrgPlnTechRsceIDTypeVH ON _ChrgPlnTechRsceIDTypeVH.CATechnicalResourceIDType = CATechnicalResourceIDType AND _ChrgPlnTechRsceIDTypeVH.SubscrpnProdTechRsceSchema = subscrpnprodtechrsceschema  -- association [0..1]
;