C_FlxMtPlObjVariantTP

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_FlxMtPlObjVariantTP.
-- 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: CFMPOVARIANTTP

CREATE VIEW C_FlxMtPlObjVariantTP AS
SELECT
  FlxblMatlPlngObjVariantUUID,
  FlxblMatlPlngObjectUUID,
  _HeaderTP.FlxblMatlPlngObjectID AS FlxblMatlPlngObjectID,
  FlxblMatlPlngObjVariantID,
  _LangDescription.FlxblMatlPlngObjVariantDesc AS FlxblMatlPlngObjVariantDesc,
  FlxblMatlPlngObjVarDescFoEd,
  DfsAssgmtStatusObject,
  FlxMtPlObjVarStatusCode,
  cast(Criticality as int2) AS Criticality,
  _StatusAttributes._SystemStatusText[1:Language = $session.system_language].SystemStatusName AS FlxMtPlObjVarStatusDescription,
  _StatusObject.StatusProfile AS StatusProfile,
  MaterialGroup,
  FlxMtPlObjVarExternalProdGroup,
  FlxMtPlObjVarProduct,
  FlxMtPlObjVarIsRelocRlvt,
  FlxMtPlObjVarIsSerialNmbrRlvt,
  FlxMtPlObjVarRespPlnrObjType,
  FlxMtPlObjVarRespPlnrObjectID,
  cast( ' ' as emnam ) AS FlxMtPlObjVarRespPlnrName,
  FlxMtPlObjVarOwnerObjectType,
  FlxMtPlObjVarOwnerObjectID,
  cast( ' ' as emnam ) AS FlxMtPlObjVarMatlOwnrName,
  FlxMtPlObjVarCreationDateTime,
  FlxMtPlObjVariantCreatedByUser,
  FlxMtPlObjVarLastChangedDteTme,
  FlxMtPlObjVariantLastChangedBy,
  PackingInstructionSystemUUID,
  PackingInstructionNumber,
  PackingInstructionText,
  cast( ' ' as char05 preserving type) AS DfsUserStatusIsHidden
FROM I_FlxMtPlObjVariantTP AS _VariantTP
LEFT OUTER JOIN C_FlxMtPlObjTP AS _HeaderTP ON FlxblMatlPlngObjectUUID = _HeaderTP.FlxblMatlPlngObjectUUID  -- association [1..1]
LEFT OUTER JOIN C_FlxMtPlObjVarModelTP AS _ModelTP ON FlxblMatlPlngObjVariantUUID = _ModelTP.FlxblMatlPlngObjVariantUUID  -- association [1..*]
LEFT OUTER JOIN C_FlxMtPlObjVarAccogPartProdTP AS _AccPartsProdTP ON FlxblMatlPlngObjVariantUUID = _AccPartsProdTP.FlxblMatlPlngObjVariantUUID  -- association [0..*]
LEFT OUTER JOIN C_FlxMtPlObjVarAccogPartOthTP AS _AccPartsOthTP ON FlxblMatlPlngObjVariantUUID = _AccPartsOthTP.FlxblMatlPlngObjVariantUUID  -- association [0..*]
LEFT OUTER JOIN C_FlxMtPlObjVariantOrgAreaTP AS _OrgAreaTP ON FlxblMatlPlngObjVariantUUID = _OrgAreaTP.FlxblMatlPlngObjVariantUUID  -- association [0..*]
LEFT OUTER JOIN C_FlxMtPlObjVarProjWBSElmntsTP AS _WBSElementsTP ON FlxblMatlPlngObjVariantUUID = _WBSElementsTP.FlxblMatlPlngObjVariantUUID  -- association [0..*]
LEFT OUTER JOIN C_FlxMtPlObjVarProjNtwkActyTP AS _NtwkActyTP ON FlxblMatlPlngObjVariantUUID = _NtwkActyTP.FlxblMatlPlngObjVariantUUID  -- association [0..*]
LEFT OUTER JOIN C_FlxMtPlObjVarRespPlnrTypeVH AS _RespPlnrObjTypeVH ON FlxMtPlObjVarRespPlnrObjType = _RespPlnrObjTypeVH.FrcElmntOrgType  -- association [0..1]
LEFT OUTER JOIN C_FlxMtPlObjVarRespPlnrObjIDVH AS _RespPlnrObjIDVH ON FlxMtPlObjVarRespPlnrObjType = _RespPlnrObjIDVH.FrcElmntOrgType AND FlxMtPlObjVarRespPlnrObjectID = _RespPlnrObjIDVH.ForceElementOrgID  -- association [0..1]
LEFT OUTER JOIN C_FlxMtPlObjVarOwnrObjTypeVH AS _MatlOwnrObjTypeVH ON FlxMtPlObjVarOwnerObjectType = _MatlOwnrObjTypeVH.FrcElmntOrgType  -- association [0..1]
LEFT OUTER JOIN C_FlxMtPlObjVarOwnrObjIdVH AS _MatlOwnrObjIDVH ON FlxMtPlObjVarOwnerObjectType = _MatlOwnrObjIDVH.FrcElmntOrgType AND FlxMtPlObjVarOwnerObjectID = _MatlOwnrObjIDVH.ForceElementOrgID  -- association [0..1]
LEFT OUTER JOIN C_DFS_AssgmtFlxMtPlObjToFe AS _AssgmtFlxMtPlObjToFe ON FlxblMatlPlngObjVariantUUID = _AssgmtFlxMtPlObjToFe.FlxblMatlPlngObjVariantUUID  -- association [0..*]
LEFT OUTER JOIN C_DFS_AssgmtFlxMtPlObjToCap AS _AssgmtFlxMtPlObjToCap ON FlxblMatlPlngObjVariantUUID = _AssgmtFlxMtPlObjToCap.FlxblMatlPlngObjVariantUUID  -- association [0..*]
LEFT OUTER JOIN C_DFS_AssgmtFlxMtPlObjToPos AS _AssgmtFlxMtPlObjToPos ON FlxblMatlPlngObjVariantUUID = _AssgmtFlxMtPlObjToPos.FlxblMatlPlngObjVariantUUID  -- association [0..*]
LEFT OUTER JOIN C_FlxMtPlObjVarWeightsAndMsr AS _FlxMtPlObjVarWeightsAndMsr ON FlxblMatlPlngObjVariantUUID = _FlxMtPlObjVarWeightsAndMsr.FlxblMatlPlngObjVariantUUID  -- association [1..*]
LEFT OUTER JOIN I_DFS_StatusObjectUserStatus AS _StatusObjectUserStatus ON DfsAssgmtStatusObject = _StatusObjectUserStatus.StatusObject  -- association [0..*]
LEFT OUTER JOIN C_DFS_FlxMtPlObjUserStatusVH AS _UserStatusVH ON statusprofile = _UserStatusVH.StatusProfile  -- association [0..*]
LEFT OUTER JOIN C_FlxMtPlObjVarDescriptionTP AS _DescriptionTP ON FlxblMatlPlngObjVariantUUID = _DescriptionTP.FlxblMatlPlngObjVariantUUID  -- association [1..*]
LEFT OUTER JOIN C_FlxMtPlObjVarDescriptionTP AS _LangDescription ON FlxblMatlPlngObjVariantUUID = _LangDescription.FlxblMatlPlngObjVariantUUID AND _LangDescription.Language = $session.system_language  -- association [1..1]
;