I_FunctionalLocationStatus

DDL: I_FUNCTIONALLOCATIONSTATUS SQL: IFUNCNLLOCSTATUS Type: view COMPOSITE

Functional Location Status

I_FunctionalLocationStatus is a Composite CDS View that provides data about "Functional Location Status" in SAP S/4HANA. It reads from 1 data source (P_FuncnlLocStatusAggrgn) and exposes 7 fields with key field FunctionalLocation.

1 data source(s) 7 fields

Data Sources (1)

SourceAliasJoin Type
P_FuncnlLocStatusAggrgn _FuncnlLocStatus from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IFUNCNLLOCSTATUS view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Functional Location Status view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY FunctionalLocation P_FuncnlLocStatusAggrgn FunctionalLocation
MaintObjectInternalID P_FuncnlLocStatusAggrgn MaintObjectInternalID
FuncnlLocIsMarkedForDeletion
FuncnlLocIsDeleted
FunctionalLocationIsActive
FunctionalLocationIsCreated
FuncnlLocIsDeactivated 
@AbapCatalog.sqlViewName: 'IFUNCNLLOCSTATUS'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@Metadata.ignorePropagatedAnnotations:true
@VDM.viewType: #COMPOSITE
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #XL, dataClass: #MIXED}
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Functional Location Status'
@ObjectModel.supportedCapabilities: [#SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE, #CDS_MODELING_ASSOCIATION_TARGET]
define view I_FunctionalLocationStatus
  as select from P_FuncnlLocStatusAggrgn as _FuncnlLocStatus
{
  key _FuncnlLocStatus.FunctionalLocation,
      _FuncnlLocStatus.MaintObjectInternalID,
      cast(_FuncnlLocStatus.FuncnlLocIsMarkedForDeletion as xfeld preserving type) as FuncnlLocIsMarkedForDeletion,
      cast(_FuncnlLocStatus.FuncnlLocIsDeleted as xfeld preserving type)           as FuncnlLocIsDeleted,
      cast(_FuncnlLocStatus.FunctionalLocationIsActive as xfeld preserving type)   as FunctionalLocationIsActive,
      cast(_FuncnlLocStatus.FunctionalLocationIsCreated as xfeld preserving type)  as FunctionalLocationIsCreated,   //Added : 2308 

      cast(_FuncnlLocStatus.FuncnlLocIsDeactivated as xfeld preserving type)       as FuncnlLocIsDeactivated
};

Learn More