I_AuthzdActlFlxMtPlObjVarInfo

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_AuthzdActlFlxMtPlObjVarInfo.
-- 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.

CREATE VIEW I_AuthzdActlFlxMtPlObjVarInfo AS
SELECT
  FlxblMatlPlngObjVariantUUID,
  FlxblMatlPlngObjectUUID,
  FlxblMatlPlngObjVariantID,
  DfsAssgmtStatusObject,
  FlxMtPlObjVarStatusCode,
  cast(materialgroup as productgroup preserving type ) AS MaterialGroup,
  cast(flxmtplobjvarexternalprodgroup as externalproductgroup preserving type ) AS FlxMtPlObjVarExternalProdGroup,
  FlxMtPlObjVarProduct,
  FlxMtPlObjVarIsRelocRlvt,
  FlxMtPlObjVarIsSerialNmbrRlvt,
  _VarDescrip.FlxblMatlPlngObjVariantDesc AS FlxblMatlPlngObjVariantDesc,
  FlxMtPlObjVarRespPlnrObjType,
  FlxMtPlObjVarRespPlnrObjectID,
  FlxMtPlObjVarOwnerObjectType,
  FlxMtPlObjVarOwnerObjectID,
  FlxMtPlObjVarCreationDateTime,
  FlxMtPlObjVariantCreatedByUser,
  FlxMtPlObjVarLastChangedDteTme,
  FlxMtPlObjVariantLastChangedBy,
  cast (packinginstructionsystemuuid as pl_packnr preserving type ) AS PackingInstructionSystemUUID
FROM dfs_fmpo_varnt
LEFT OUTER JOIN I_FlxMtPlObjVarDescription AS _VarDescrip ON FlxblMatlPlngObjVariantUUID = _VarDescrip.FlxblMatlPlngObjVariantUUID AND _VarDescrip.Language = $session.system_language  -- association [1..1]
;