C_ChargePlanAssignmentTP

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_ChargePlanAssignmentTP.
-- 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: CCHPLASSIGNTP

CREATE VIEW C_ChargePlanAssignmentTP AS
SELECT
  ChargePlanAssignment.ChargePlanAssignmentUUID AS ChargePlanAssignmentUUID,
  ChargePlanAssignment.CreatedByUser AS CreatedByUser,
  ChargePlanAssignment.CreationDateTime AS CreationDateTime,
  ChargePlanAssignment.LastChangedByUser AS LastChangedByUser,
  ChargePlanAssignment.LastChangeDateTime AS LastChangeDateTime,
  ChargePlanAssignment.CrossCatalogMappingVersionUUID AS CrossCatalogMappingVersionUUID,
  ChargePlanAssignment.SubscrpnProdSpecUUID AS SubscrpnProdSpecUUID,
  ChargePlanAssignment.ChargePlanAssignmentID AS ChargePlanAssignmentID,
  ChargePlanAssignment.ChargePlanAssignmentType AS ChargePlanAssignmentType,
  ChargePlanAssignment.ChargePlanID AS ChargePlanID,
  ChargePlanAssignment.ChargePlanDescription AS ChargePlanDescription,
  ChargePlanAssignment.ChargePlanActivationCondition AS ChargePlanActivationCondition,
  ChargePlanAssignment.BRFFunctionUUID AS BRFFunctionUUID,
  cast( '' as fdt_text ) AS BRFFunctionText,
  ChargePlanAssignment.ChrgPlanAssignmentDescription AS ChrgPlanAssignmentDescription,
  ChargePlanAssignment._CreatedByUser.UserDescription AS CreatedByUserName,
  ChargePlanAssignment._LastChangedByUser.UserDescription AS LastChangedByUserName,
  ChargePlanAssignment.Characteristic AS Characteristic,
  cast( '' as atnam ) AS CharacteristicDescription,
  ChargePlanAssignment.CharacteristicValue AS CharacteristicValue,
  cast( '' as atwrt ) AS CharacteristicValueDescription,
  ChargePlanAssignment.SbsChrgPlnAssgmtIsRlvtForPrrtn AS SbsChrgPlnAssgmtIsRlvtForPrrtn,
  ChargePlanAssignment.SbsChrgPlanShrdAllwncIsCreated AS SbsChrgPlanShrdAllwncIsCreated,
  ChargePlanAssignment.SharedAllowanceReratingIsAllwd AS SharedAllowanceReratingIsAllwd
FROM I_ChargePlanAssignmentTP AS ChargePlanAssignment
LEFT OUTER JOIN C_SubscrpnProdSpecTP AS _SubscrpnProdSpecTP ON _SubscrpnProdSpecTP.SubscrpnProdSpecUUID = SubscrpnProdSpecUUID  -- association [1..1]
LEFT OUTER JOIN C_CrsCtlgMappingVersionTP AS _CrsCtlgMappingVersionTP ON _CrsCtlgMappingVersionTP.CrossCatalogMappingVersionUUID = CrossCatalogMappingVersionUUID  -- association [1..1]
LEFT OUTER JOIN C_ChargePlanAssignmentTTP AS _ChargePlanAssignmentTTP ON _ChargePlanAssignmentTTP.ChargePlanAssignmentUUID = ChargePlanAssignmentUUID  -- association [0..*]
LEFT OUTER JOIN C_ChrgPlanDateParameterTP AS _ChrgPlanDateParameterTP ON _ChrgPlanDateParameterTP.ChargePlanAssignmentUUID = ChargePlanAssignmentUUID  -- association [0..*]
LEFT OUTER JOIN C_ChrgPlanNmrcParameterTP AS _ChrgPlanNmrcParameterTP ON _ChrgPlanNmrcParameterTP.ChargePlanAssignmentUUID = ChargePlanAssignmentUUID  -- association [0..*]
LEFT OUTER JOIN C_ChrgPlnStringParameterTP AS _ChrgPlnStringParameterTP ON _ChrgPlnStringParameterTP.ChargePlanAssignmentUUID = ChargePlanAssignmentUUID  -- association [0..*]
LEFT OUTER JOIN C_ChrgPlanTableParameterTP AS _ChrgPlanTableParameterTP ON _ChrgPlanTableParameterTP.ChargePlanAssignmentUUID = ChargePlanAssignmentUUID  -- association [0..*]
LEFT OUTER JOIN C_ChrgPlnAllwncParameterTP AS _ChrgPlnAllwncParameterTP ON _ChrgPlnAllwncParameterTP.ChargePlanAssignmentUUID = ChargePlanAssignmentUUID  -- association [0..*]
LEFT OUTER JOIN C_ChrgPlnTechResourceTP AS _ChrgPlnTechResourceTP ON _ChrgPlnTechResourceTP.ChargePlanAssignmentUUID = ChargePlanAssignmentUUID  -- association [0..*]
LEFT OUTER JOIN C_SOM_ChrgPlnActvtnCndnVH AS _SOM_ChrgPlnActvtnCndnVH ON _SOM_ChrgPlnActvtnCndnVH.ChargePlanActivationCondition = ChargePlanActivationCondition  -- association [0..1]
LEFT OUTER JOIN C_ChrgPlnAcctAssignmentTP AS _ChrgPlnAcctAssignmentTP ON _ChrgPlnAcctAssignmentTP.ChargePlanAssignmentUUID = ChargePlanAssignmentUUID  -- association [0..*]
LEFT OUTER JOIN C_ChargePlanCountedObjectTP AS _ChargePlanCountedObjectTP ON _ChargePlanCountedObjectTP.ChargePlanAssignmentUUID = ChargePlanAssignmentUUID  -- association [0..*]
LEFT OUTER JOIN C_ChargePlanPriceParameterTP AS _ChargePlanPriceParameterTP ON _ChargePlanPriceParameterTP.ChargePlanAssignmentUUID = ChargePlanAssignmentUUID  -- association [0..*]
;