I_DFS_UNIVERSALASSIGNMENTDRAFT

@AbapCatalog.sqlViewName: 'IDFSASSGMTDRAFT'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Basic Intf. View for Assignment'

@ObjectModel.representativeKey: 'DraftUUID'
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL

@VDM.viewType: #BASIC
@Metadata.allowExtensions: true

define view I_DFS_UniversalAssignmentDraft
  as select from idfsassgmttp_d as AssignmentDraft
{
       // key  AssignmentDraft.activeuuid                      as  DfsAssgmtUUID,

  key  AssignmentDraft.dfsassgmtuuid                  as DraftUUID,
       AssignmentDraft.activeuuid                     as ActiveDfsAssgmtUUID,
       // ----------------- Assignment Source Attributes ----------------------

       AssignmentDraft.forceelementorgsrceuuid        as ForceElementOrgSrceUUID,
       AssignmentDraft.forceelementorgsrceid          as ForceElementOrgSrceID,

       AssignmentDraft.dfscapabilityobjectuuid        as DfsCapabilityObjectUUID,
       AssignmentDraft.dfscapabilityobjectid          as DfsCapabilityObjectID,

       AssignmentDraft.dfspositionsourceuuid          as DfsPositionSourceUUID,
       AssignmentDraft.dfspositionsourceid            as DfsPositionSourceID,

       AssignmentDraft.dfsjobid                       as DfsJobID,


       // ----------------- Assignment Target Attributes ----------------------

       AssignmentDraft.forceelementorgtargetuuid      as ForceElementOrgTargetUUID,
       AssignmentDraft.forceelementorgtargetid        as ForceElementOrgTargetID,
       AssignmentDraft.flxblmatlplngobjectuuid        as FlxblMatlPlngObjectUUID,
       AssignmentDraft.flxblmatlplngobjectid          as FlxblMatlPlngObjectID,
       AssignmentDraft.flxblmatlplngobjvariantuuid    as FlxblMatlPlngObjVariantUUID,
       AssignmentDraft.flxblmatlplngobjvariantid      as FlxblMatlPlngObjVariantID,
       AssignmentDraft.product                        as Product,
       AssignmentDraft.dfscapabilitystatementuuid     as DfsCapabilityStatementUUID,
       AssignmentDraft.dfscapabilitystatementid       as DfsCapabilityStatementID,
       AssignmentDraft.missionessentialtaskuuid       as MissionEssentialTaskUUID,
       AssignmentDraft.missionessentialtaskid         as MissionEssentialTaskID,
       AssignmentDraft.dfscapabilityobjecttargetuuid  as DfsCapabilityObjectTargetUUID,
       AssignmentDraft.dfscapabilityobjecttargetid    as DfsCapabilityObjectTargetID,
       AssignmentDraft.frcelmntorgmaintcapblt         as FrcElmntOrgMaintCapblt,
       AssignmentDraft.equipment                      as Equipment,
       AssignmentDraft.frcelmntorgrotationkey         as FrcElmntOrgRotationKey,
       AssignmentDraft.frcelmntorgopexerciseid        as FrcElmntOrgOpExerciseID,
       AssignmentDraft.frcelmntorgforceproviderid     as FrcElmntOrgForceProviderID,
       AssignmentDraft.frcelmntorginitialmatlsuplrid  as FrcElmntOrgInitialMatlSuplrID,
       AssignmentDraft.frcelmntorginitialperssuplrid  as FrcElmntOrgInitialPersSuplrID,

       // ----------------- Assignment General Attributes ----------------------

       AssignmentDraft.dfsassgmtusagetype             as DfsAssgmtUsageType,
       AssignmentDraft.dfsassgmtsourcetype            as DfsAssgmtSourceType,
       AssignmentDraft.dfsassgmttype                  as DfsAssgmtType,
       AssignmentDraft.dfsassgmtvaldtystrtdate        as DfsAssgmtValdtyStrtDate,
       AssignmentDraft.dfsassgmtvaldtystrttime        as DfsAssgmtValdtyStrtTime,
       AssignmentDraft.dfsassgmtvaldtyenddate         as DfsAssgmtValdtyEndDate,
       AssignmentDraft.dfsassgmtvaldtyendtime         as DfsAssgmtValdtyEndTime,
       AssignmentDraft.dfsassgmtvaldtytimezone        as DfsAssgmtValdtyTimeZone,
       AssignmentDraft.dfsassgmtstatusobject          as DfsAssgmtStatusObject,
       AssignmentDraft.dfsassgmtstatuscode            as DfsAssgmtStatusCode,
       AssignmentDraft.dfsassgmtlogicalsystem         as DfsAssgmtLogicalSystem,
       AssignmentDraft.dfsassgmtcomment               as DfsAssgmtComment,
       AssignmentDraft.dfsassgmtpriority              as DfsAssgmtPriority,
       @Semantics.systemDateTime.createdAt
       AssignmentDraft.dfsassgmtcreationdatetime      as DfsAssgmtCreationDateTime,
       AssignmentDraft.dfsassgmtcreatedbyuser         as DfsAssgmtCreatedByUser,
       @Semantics.systemDateTime.lastChangedAt: true
       AssignmentDraft.dfsassgmtchangedatetime        as DfsAssgmtChangeDateTime,
       AssignmentDraft.dfsassgmtlastchgdbyuser        as DfsAssgmtLastChgdByUser,
       AssignmentDraft.dfsassgmtsourceobjectuuid      as DfsAssgmtSourceObjectUUID,
       AssignmentDraft.dfsassgmtsourceobjecttype      as DfsAssgmtSourceObjectType,

       // ----------------- Assignment MM Attributes ----------------------

       AssignmentDraft.dfsassgmtnmbrofassgdmatl       as DfsAssgmtNmbrOfAssgdMatl,
       AssignmentDraft.dfsassgmtminnmbrofassgdmatl    as DfsAssgmtMinNmbrOfAssgdMatl,
       AssignmentDraft.dfsassgmtmaxnmbrofassgdmatl    as DfsAssgmtMaxNmbrOfAssgdMatl,
       AssignmentDraft.dfsassgmtmaterialindicatorcode as DfsAssgmtMaterialIndicatorCode,
       AssignmentDraft.dfsassgmtcorrectionvalue       as DfsAssgmtCorrectionValue,
       AssignmentDraft.dfsassgmtcorrectionreason      as DfsAssgmtCorrectionReason,
       AssignmentDraft.dfsassgmtmaterialweightingrate as DfsAssgmtMaterialWeightingRate,
       AssignmentDraft.dfsassgmtismandforrdnsscalc    as DfsAssgmtIsMandForRdnssCalc,
       AssignmentDraft.dfsassgmtisusedformassmatlplng as DfsAssgmtIsUsedForMassMatlPlng,
       AssignmentDraft.dfsassgmtmaterialcategory      as DfsAssgmtMaterialCategory,
       AssignmentDraft.dfsassgmtinitialsupplystatus   as DfsAssgmtInitialSupplyStatus,
       AssignmentDraft.dfsassgmtisownprovision        as DfsAssgmtIsOwnProvision,

       // ----------------- Assignment Force Element Attributes ----------------------

       AssignmentDraft.dfsassgmtisdefaultassignment   as DfsAssgmtIsDefaultAssignment,

       // ----------------- Assignment Maintenance Attributes ----------------------

       AssignmentDraft.dfsassgmtdamagetype            as DfsAssgmtDamageType,

       // ----------------- Assignment Supply Attributes ----------------------

       AssignmentDraft.dfsassgmtexternalproductgroup  as DfsAssgmtExternalProductGroup,

       // ----------------- Capability Statement Attributes ----------------------


       AssignmentDraft.dfscapbltstmntsqncnmbr         as DfsCapbltStmntSqncNmbr,
       AssignmentDraft.dfscapbltstmnttype             as DfsCapbltStmntType,

       // ------------------ METL Attributes -------------------------

       AssignmentDraft.dfsassgmtfrcelmnttrngassmtdte  as DfsAssgmtFrcElmntTrngAssmtDte,
       AssignmentDraft.dfsassgmtfrcelmnttrngassmtby   as DfsAssgmtFrcElmntTrngAssmtBy,
       AssignmentDraft.dfsisaccreditingmsnesnltsk     as DfsIsAccreditingMsnEsnlTsk,

       AssignmentDraft.hasactiveentity                as HasActiveEntity,
       
       AssignmentDraft.dfsassgmtplanstatusobject      as DfsAssgmtPlanStatusObject,
       AssignmentDraft.dfsassgmtplanoperationcode     as DfsAssgmtPlanOperationCode,
       AssignmentDraft.dfsassgmtplandelimitdate       as DfsAssgmtPlanDelimitDate,
       AssignmentDraft.dfsassgmtplandelimittime       as DfsAssgmtPlanDelimitTime
       

}