I_FRCELMNTORGBASIC

CDS View

Basic View - Force Element Organization

I_FRCELMNTORGBASIC is a CDS View in S/4HANA. Basic View - Force Element Organization. It contains 34 fields. 4 CDS views read from this table.

Used by 4 CDS view(s) 34 fields

CDS Views using this table (4)

ViewTypeJoinVDMDescription
I_DFS_SenstvyClfnFrcElmnt view_entity from BASIC Classification for FE Sensitivity
I_FrcElmntOrg view from BASIC Interface View of FrcElmnt Organization
I_FrcElmntWithAuthznForAssgmt view from COMPOSITE Authorized FE for Assgmt
I_FrcElmntWithAuthznForAssgmt view union COMPOSITE Authorized FE for Assgmt

Fields (34)

KeyField CDS FieldsUsed in Views
KEY ForceElementOrgID ForceElementOrgID 1
ForceElementOrgUUID ForceElementOrgUUID 2
FrcElmntOrgCreatedByUser FrcElmntOrgCreatedByUser 1
FrcElmntOrgCreationDate FrcElmntOrgCreationDate 1
FrcElmntOrgInfrstrucPlant FrcElmntOrgInfrstrucPlant 1
FrcElmntOrgInitSupSts FrcElmntOrgInitSupSts 1
FrcElmntOrgIsAccountable FrcElmntOrgIsAccountable 1
FrcElmntOrgIsInfrstrucMaterial FrcElmntOrgIsInfrstrucMaterial 1
FrcElmntOrgIsRefFrcElmntOrg FrcElmntOrgIsRefFrcElmntOrg 1
FrcElmntOrgIsStockHolding FrcElmntOrgIsStockHolding 1
FrcElmntOrgLastChgdByUser FrcElmntOrgLastChgdByUser 1
FrcElmntOrgLastChgdDate FrcElmntOrgLastChgdDate 1
FrcElmntOrgLastChgdDteTme FrcElmntOrgLastChgdDteTme 1
FrcElmntOrgLogicalSystem FrcElmntOrgLogicalSystem 1
FrcElmntOrgLogsLevel FrcElmntOrgLogsLevel 1
FrcElmntOrgMaterialSuplrUUID FrcElmntOrgMaterialSuplrUUID 1
FrcElmntOrgMatlRdnssPct FrcElmntOrgMatlRdnssPct 1
FrcElmntOrgMRPStockArea FrcElmntOrgMRPStockArea 1
FrcElmntOrgPlanVersion FrcElmntOrgPlanVersion 1
FrcElmntOrgPriority FrcElmntOrgPriority 1
FrcElmntOrgProvisionsPlant FrcElmntOrgProvisionsPlant 1
FrcElmntOrgProvisionStorageLoc FrcElmntOrgProvisionStorageLoc 1
FrcElmntOrgPrsnlRdnssPct FrcElmntOrgPrsnlRdnssPct 1
FrcElmntOrgPrvsnMRPArea FrcElmntOrgPrvsnMRPArea 1
FrcElmntOrgPurgGroup FrcElmntOrgPurgGroup 1
FrcElmntOrgPurgOrg FrcElmntOrgPurgOrg 1
FrcElmntOrgStockPlant FrcElmntOrgStockPlant 1
FrcElmntOrgStockStorageLoc FrcElmntOrgStockStorageLoc 1
FrcElmntOrgTrngRdnssPct FrcElmntOrgTrngRdnssPct 1
FrcElmntOrgType FrcElmntOrgType 1
FrcElmntOrgWBSElement FrcElmntOrgWBSElement 1
FrcElmOrgInfrMRPArea FrcElmOrgInfrMRPArea 1
FrcElmOrgInfrStorLoc FrcElmOrgInfrStorLoc 1
NumberOfForceElementOrg NumberOfForceElementOrg 1 
@AbapCatalog.sqlViewName: 'IFEORGBAS'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Basic View - Force Element Organization'
@VDM.viewType: #BASIC
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #L
define view I_FrcElmntOrgBasic
  as select from P_FrcElmntOrg as FrcElmntOrg
{
  key FrcElmntOrg.ForceElementOrgID,
      FrcElmntOrg.ForceElementOrgUUID,
      FrcElmntOrg.NumberOfForceElementOrg,
      FrcElmntOrg.FrcElmntOrgPlanVersion,
      FrcElmntOrg.FrcElmntOrgType,
      FrcElmntOrg.FrcElmntOrgWBSElement,
      FrcElmntOrg.FrcElmntOrgStockPlant,
      FrcElmntOrg.FrcElmntOrgMRPStockArea,
      FrcElmntOrg.FrcElmntOrgIsAccountable,
      FrcElmntOrg.FrcElmntOrgProvisionsPlant,
      FrcElmntOrg.FrcElmntOrgProvisionStorageLoc,
      FrcElmntOrg.FrcElmntOrgPrvsnMRPArea,
      FrcElmntOrg.FrcElmntOrgIsStockHolding,
      FrcElmntOrg.FrcElmntOrgInitSupSts,
      FrcElmntOrg.FrcElmntOrgPurgOrg,
      FrcElmntOrg.FrcElmntOrgPurgGroup,
      FrcElmntOrg.FrcElmntOrgStockStorageLoc,
      FrcElmntOrg.FrcElmntOrgMatlRdnssPct,
      FrcElmntOrg.FrcElmntOrgPrsnlRdnssPct,
      FrcElmntOrg.FrcElmntOrgTrngRdnssPct,
      FrcElmntOrg.FrcElmntOrgPriority,
      FrcElmntOrg.FrcElmntOrgLastChgdDteTme,
      FrcElmntOrg.FrcElmntOrgLogsLevel,
      FrcElmntOrg.FrcElmntOrgInfrstrucPlant, //Infrastructure Plant

      FrcElmntOrg.FrcElmOrgInfrMRPArea,      //Infrastructure MRP Area

      FrcElmntOrg.FrcElmntOrgIsInfrstrucMaterial,    //Infrastructure Material Management

      FrcElmntOrg.FrcElmOrgInfrStorLoc,      //Infrastructure Storage Location

      FrcElmntOrg.FrcElmntOrgLastChgdByUser,
      FrcElmntOrg.FrcElmntOrgLastChgdDate,
      FrcElmntOrg.FrcElmntOrgCreatedByUser,
      FrcElmntOrg.FrcElmntOrgCreationDate,
      FrcElmntOrg.FrcElmntOrgLogicalSystem,
      FrcElmntOrg.FrcElmntOrgMaterialSuplrUUID,
      FrcElmntOrg.FrcElmntOrgIsRefFrcElmntOrg,
      
      cast (concat(FrcElmntOrgPlanVersion, concat_with_space(FrcElmntOrgType, ForceElementOrgID, 1) ) as cuobn) as ClfnObjectID
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_FRCELMNTORG"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More