I_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 I_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: IFMPOVARIANTTP

CREATE VIEW I_FlxMtPlObjVariantTP AS
SELECT
  FlxblMatlPlngObjVariantUUID,
  FlxblMatlPlngObjectUUID,
  _HeaderTP.FlxblMatlPlngObjectID AS FlxblMatlPlngObjectID,
  FlxblMatlPlngObjVariantID,
  cast (' ' as abap.char( 60 )) AS FlxblMatlPlngObjVariantDesc,
  FlxblMatlPlngObjVariantDesc AS FlxblMatlPlngObjVarDescFoEd,
  DfsAssgmtStatusObject,
  FlxMtPlObjVarStatusCode,
  MaterialGroup,
  FlxMtPlObjVarExternalProdGroup,
  FlxMtPlObjVarProduct,
  FlxMtPlObjVarIsRelocRlvt,
  FlxMtPlObjVarIsSerialNmbrRlvt,
  FlxMtPlObjVarRespPlnrObjType,
  FlxMtPlObjVarRespPlnrObjectID,
  FlxMtPlObjVarOwnerObjectType,
  FlxMtPlObjVarOwnerObjectID,
  FlxMtPlObjVarCreationDateTime,
  FlxMtPlObjVariantCreatedByUser,
  FlxMtPlObjVarLastChangedDteTme,
  FlxMtPlObjVariantLastChangedBy,
  PackingInstructionSystemUUID,
  DfsIsStrucAuthznEnabled,
  _PackingInstructionHeader.PackingInstructionNumber AS PackingInstructionNumber,
  _PackingInstructionHeader.PackingInstructionText AS PackingInstructionText
FROM I_FlxMtPlObjVariant
LEFT OUTER JOIN I_FlxMtPlObjTP AS _HeaderTP ON FlxblMatlPlngObjectUUID = _HeaderTP.FlxblMatlPlngObjectUUID  -- association [1..1]
LEFT OUTER JOIN I_FlxMtPlObjVarModelTP AS _ModelTP ON FlxblMatlPlngObjVariantUUID = _ModelTP.FlxblMatlPlngObjVariantUUID  -- association [1..*]
LEFT OUTER JOIN I_FlxMtPlObjVarAccogPartProdTP AS _AccPartsProdTP ON FlxblMatlPlngObjVariantUUID = _AccPartsProdTP.FlxblMatlPlngObjVariantUUID  -- association [0..*]
LEFT OUTER JOIN I_FlxMtPlObjVarAccogPartOthTP AS _AccPartsOthTP ON FlxblMatlPlngObjVariantUUID = _AccPartsOthTP.FlxblMatlPlngObjVariantUUID  -- association [0..*]
LEFT OUTER JOIN I_FlxMtPlObjVariantOrgAreaTP AS _OrgAreaTP ON FlxblMatlPlngObjVariantUUID = _OrgAreaTP.FlxblMatlPlngObjVariantUUID  -- association [0..*]
LEFT OUTER JOIN I_FlxMtPlObjVarProjWBSElmntsTP AS _WBSElementsTP ON FlxblMatlPlngObjVariantUUID = _WBSElementsTP.FlxblMatlPlngObjVariantUUID  -- association [0..*]
LEFT OUTER JOIN I_FlxMtPlObjVarProjNtwkActyTP AS _NtwkActyTP ON FlxblMatlPlngObjVariantUUID = _NtwkActyTP.FlxblMatlPlngObjVariantUUID  -- association [0..*]
LEFT OUTER JOIN E_FlxMtPlObjVariant AS _Extension ON FlxblMatlPlngObjVariantUUID = _Extension.FlxblMatlPlngObjVariantUUID  -- association [0..1]
LEFT OUTER JOIN I_FlxMtPlObjVarDescriptionTP AS _DescriptionTP ON FlxblMatlPlngObjVariantUUID = _DescriptionTP.FlxblMatlPlngObjVariantUUID  -- association [0..*]
LEFT OUTER JOIN I_DFS_PackingInstructionObjVH AS _PackingInstructionHeader ON _PackingInstructionHeader.PackingInstructionSystemUUID = PackingInstructionSystemUUID  -- association [1..1]
LEFT OUTER JOIN I_FlxMtPlObjVarDescriptionTP AS _LangDescription ON FlxblMatlPlngObjVariantUUID = _LangDescription.FlxblMatlPlngObjVariantUUID AND _LangDescription.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_DFS_SenstvyClfnFlxMtPlObj AS _SenstvyClfn ON FlxblMatlPlngObjectUUID = _SenstvyClfn.FlxblMatlPlngObjectUUID AND FlxblMatlPlngObjVariantUUID = _SenstvyClfn.FlxblMatlPlngObjVariantUUID AND _SenstvyClfn.DfsSensitivity is not initial  -- association [1..*]
;