I_DFS_UniversalAssignmentBasic

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_DFS_UniversalAssignmentBasic.
-- 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: IDFSASSGMTBASIC

CREATE VIEW I_DFS_UniversalAssignmentBasic AS
SELECT
  AssignmentBasic.dfsassgmtuuid AS DfsAssgmtUUID,
  AssignmentBasic.forceelementorgsrceuuid AS ForceElementOrgSrceUUID,
  AssignmentBasic.forceelementorgsrceid AS ForceElementOrgSrceID,
  AssignmentBasic.dfscapabilityobjectuuid AS DfsCapabilityObjectUUID,
  AssignmentBasic.dfscapabilityobjectid AS DfsCapabilityObjectID,
  AssignmentBasic.dfspositionsourceuuid AS DfsPositionSourceUUID,
  AssignmentBasic.dfspositionsourceid AS DfsPositionSourceID,
  AssignmentBasic.dfsmaintplatformuuid AS DfsMaintPlatformUUID,
  AssignmentBasic.dfsmaintplatformid AS DfsMaintPlatformID,
  AssignmentBasic.forceelementorgtargetuuid AS ForceElementOrgTargetUUID,
  AssignmentBasic.forceelementorgtargetid AS ForceElementOrgTargetID,
  AssignmentBasic.flxblmatlplngobjectuuid AS FlxblMatlPlngObjectUUID,
  AssignmentBasic.flxblmatlplngobjectid AS FlxblMatlPlngObjectID,
  AssignmentBasic.flxblmatlplngobjvariantuuid AS FlxblMatlPlngObjVariantUUID,
  AssignmentBasic.flxblmatlplngobjvariantid AS FlxblMatlPlngObjVariantID,
  AssignmentBasic.product AS Product,
  AssignmentBasic.dfscapabilitystatementuuid AS DfsCapabilityStatementUUID,
  AssignmentBasic.dfscapabilitystatementid AS DfsCapabilityStatementID,
  AssignmentBasic.missionessentialtaskuuid AS MissionEssentialTaskUUID,
  AssignmentBasic.missionessentialtaskid AS MissionEssentialTaskID,
  AssignmentBasic.dfscapabilityobjecttargetuuid AS DfsCapabilityObjectTargetUUID,
  AssignmentBasic.dfscapabilityobjecttargetid AS DfsCapabilityObjectTargetID,
  AssignmentBasic.frcelmntorgmaintcapblt AS FrcElmntOrgMaintCapblt,
  AssignmentBasic.costcenter AS CostCenter,
  AssignmentBasic.wbselementinternalid AS WBSElementInternalID,
  AssignmentBasic.equipment AS Equipment,
  AssignmentBasic.frcelmntorgrotationkey AS FrcElmntOrgRotationKey,
  AssignmentBasic.frcelmntorgopexerciseid AS FrcElmntOrgOpExerciseID,
  AssignmentBasic.frcelmntorgforceproviderid AS FrcElmntOrgForceProviderID,
  AssignmentBasic.frcelmntorginitialmatlsuplrid AS FrcElmntOrgInitialMatlSuplrID,
  AssignmentBasic.frcelmntorginitialperssuplrid AS FrcElmntOrgInitialPersSuplrID,
  AssignmentBasic.dfsassgmtusagetype AS DfsAssgmtUsageType,
  AssignmentBasic.dfsassgmtsourcetype AS DfsAssgmtSourceType,
  AssignmentBasic.dfsassgmttype AS DfsAssgmtType,
  AssignmentBasic.dfsassgmtvaldtystrtdate AS DfsAssgmtValdtyStrtDate,
  AssignmentBasic.dfsassgmtvaldtystrttime AS DfsAssgmtValdtyStrtTime,
  AssignmentBasic.dfsassgmtvaldtyenddate AS DfsAssgmtValdtyEndDate,
  AssignmentBasic.dfsassgmtvaldtyendtime AS DfsAssgmtValdtyEndTime,
  AssignmentBasic.dfsassgmtvaldtytimezone AS DfsAssgmtValdtyTimeZone,
  AssignmentBasic.dfsassgmtstatusobject AS DfsAssgmtStatusObject,
  AssignmentBasic.dfsassgmtstatuscode AS DfsAssgmtStatusCode,
  AssignmentBasic.dfsassgmtstatusprofile AS DfsAssgmtStatusProfile,
  AssignmentBasic.dfsassgmtplanstatusobject AS DfsAssgmtPlanStatusObject,
  AssignmentBasic.dfsassgmtplanoperationcode AS DfsAssgmtPlanOperationCode,
  AssignmentBasic.dfsassgmtplandelimitdate AS DfsAssgmtPlanDelimitDate,
  AssignmentBasic.dfsassgmtplandelimittime AS DfsAssgmtPlanDelimitTime,
  AssignmentBasic.dfsassgmtsourceobjectuuid AS DfsAssgmtSourceObjectUUID,
  AssignmentBasic.dfsassgmtsourceobjecttype AS DfsAssgmtSourceObjectType,
  AssignmentBasic.dfsassgmtlogicalsystem AS DfsAssgmtLogicalSystem,
  AssignmentBasic.dfsassgmtcomment AS DfsAssgmtComment,
  AssignmentBasic.dfsassgmtpriority AS DfsAssgmtPriority,
  AssignmentBasic.dfsassgmtcreationdatetime AS DfsAssgmtCreationDateTime,
  AssignmentBasic.dfsassgmtcreatedbyuser AS DfsAssgmtCreatedByUser,
  AssignmentBasic.dfsassgmtchangedatetime AS DfsAssgmtChangeDateTime,
  AssignmentBasic.dfsassgmtlastchgdbyuser AS DfsAssgmtLastChgdByUser,
  AssignmentBasic.dfsassgmtnmbrofassgdmatl AS DfsAssgmtNmbrOfAssgdMatl,
  AssignmentBasic.dfsassgmtminnmbrofassgdmatl AS DfsAssgmtMinNmbrOfAssgdMatl,
  AssignmentBasic.dfsassgmtmaxnmbrofassgdmatl AS DfsAssgmtMaxNmbrOfAssgdMatl,
  AssignmentBasic.dfsassgmtmaterialindicatorcode AS DfsAssgmtMaterialIndicatorCode,
  AssignmentBasic.dfsassgmtcorrectionvalue AS DfsAssgmtCorrectionValue,
  AssignmentBasic.dfsassgmtcorrectionreason AS DfsAssgmtCorrectionReason,
  AssignmentBasic.dfsassgmtmaterialweightingrate AS DfsAssgmtMaterialWeightingRate,
  AssignmentBasic.dfsassgmtismandforrdnsscalc AS DfsAssgmtIsMandForRdnssCalc,
  AssignmentBasic.dfsassgmtisusedformassmatlplng AS DfsAssgmtIsUsedForMassMatlPlng,
  AssignmentBasic.dfsassgmtmaterialcategory AS DfsAssgmtMaterialCategory,
  AssignmentBasic.dfsassgmtinitialsupplystatus AS DfsAssgmtInitialSupplyStatus,
  AssignmentBasic.dfsassgmtisownprovision AS DfsAssgmtIsOwnProvision,
  AssignmentBasic.dfsassgmtisdefaultassignment AS DfsAssgmtIsDefaultAssignment,
  AssignmentBasic.dfsassgmtdamagetype AS DfsAssgmtDamageType,
  AssignmentBasic.dfsassgmtexternalproductgroup AS DfsAssgmtExternalProductGroup,
  AssignmentBasic.dfscapbltstmntsqncnmbr AS DfsCapbltStmntSqncNmbr,
  AssignmentBasic.dfscapbltstmnttype AS DfsCapbltStmntType,
  AssignmentBasic.dfsassgmtfrcelmnttrngassmtdte AS DfsAssgmtFrcElmntTrngAssmtDte,
  AssignmentBasic.dfsassgmtfrcelmnttrngassmtby AS DfsAssgmtFrcElmntTrngAssmtBy,
  AssignmentBasic.dfsisaccreditingmsnesnltsk AS DfsIsAccreditingMsnEsnlTsk,
  AssignmentBasic.dfsjobid AS DfsJobID,
  AssignmentBasic.dfsplatformdetailstext AS DfsPlatformDetailsText,
  AssignmentBasic.dfsplatformextension AS DfsPlatformExtension,
  AssignmentBasic.controllingarea AS ControllingArea,
  AssignmentBasic.dfsmaintpltfrmisleadpltfrm AS DfsMaintPltfrmIsLeadPltfrm
FROM dfs_assgmt AS AssignmentBasic
;