How many fields does I_FrcElmntOrg have?

I_FrcElmntOrg has 36 fields. Key fields: ForceElementOrgID.

I_FrcElmntOrg

Q: Which tables does I_FrcElmntOrg use?

I_FrcElmntOrg reads from 2 data source(s): I_FrcElmntOrgWithAuthorization, I_FrcElmntOrgBasic.

DDL: I_FRCELMNTORG SQL: IFEORG Type: view BASIC

Interface View of FrcElmnt Organization

I_FrcElmntOrg is a Basic CDS View that provides data about "Interface View of FrcElmnt Organization" in SAP S/4HANA. It reads from 2 data sources (I_FrcElmntOrgWithAuthorization, I_FrcElmntOrgBasic) and exposes 36 fields with key field ForceElementOrgID. It has 1 association to related views.

Data Sources (2)

Source	Alias	Join Type
I_FrcElmntOrgWithAuthorization	_auth	inner
I_FrcElmntOrgBasic	FrcElmntOrg	from

Associations (1)

Cardinality	Target	Alias	Condition
[1..*]	I_DFS_SenstvyClfnFrcElmnt	_SenstvyClfn	`$projection.ForceElementOrgID = _SenstvyClfn.ForceElementOrgID`

Annotations (10)

Name	Value	Level
AbapCatalog.sqlViewName	IFEORG	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.preserveKey	true	view
AccessControl.authorizationCheck	#CHECK	view
EndUserText.label	Interface View of FrcElmnt Organization	view
VDM.viewType	#BASIC	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
ObjectModel.usageType.dataClass	#MIXED	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#L	view

Fields (36)

Key	Field	Source Table	Source Field
KEY	ForceElementOrgID	I_FrcElmntOrgBasic	ForceElementOrgID
	ForceElementOrgUUID	I_FrcElmntOrgBasic	ForceElementOrgUUID
	NumberOfForceElementOrg	I_FrcElmntOrgBasic	NumberOfForceElementOrg
	FrcElmntOrgPlanVersion	I_FrcElmntOrgBasic	FrcElmntOrgPlanVersion
	FrcElmntOrgType	I_FrcElmntOrgBasic	FrcElmntOrgType
	FrcElmntOrgWBSElement	I_FrcElmntOrgBasic	FrcElmntOrgWBSElement
	FrcElmntOrgStockPlant	I_FrcElmntOrgBasic	FrcElmntOrgStockPlant
	FrcElmntOrgMRPStockArea	I_FrcElmntOrgBasic	FrcElmntOrgMRPStockArea
	FrcElmntOrgIsAccountable	I_FrcElmntOrgBasic	FrcElmntOrgIsAccountable
	FrcElmntOrgProvisionsPlant	I_FrcElmntOrgBasic	FrcElmntOrgProvisionsPlant
	FrcElmntOrgProvisionStorageLoc	I_FrcElmntOrgBasic	FrcElmntOrgProvisionStorageLoc
	FrcElmntOrgPrvsnMRPArea	I_FrcElmntOrgBasic	FrcElmntOrgPrvsnMRPArea
	FrcElmntOrgIsStockHolding	I_FrcElmntOrgBasic	FrcElmntOrgIsStockHolding
	FrcElmntOrgInitSupSts	I_FrcElmntOrgBasic	FrcElmntOrgInitSupSts
	FrcElmntOrgPurgOrg	I_FrcElmntOrgBasic	FrcElmntOrgPurgOrg
	FrcElmntOrgPurgGroup	I_FrcElmntOrgBasic	FrcElmntOrgPurgGroup
	FrcElmntOrgStockStorageLoc	I_FrcElmntOrgBasic	FrcElmntOrgStockStorageLoc
	FrcElmntOrgMatlRdnssPct	I_FrcElmntOrgBasic	FrcElmntOrgMatlRdnssPct
	FrcElmntOrgPrsnlRdnssPct	I_FrcElmntOrgBasic	FrcElmntOrgPrsnlRdnssPct
	FrcElmntOrgTrngRdnssPct	I_FrcElmntOrgBasic	FrcElmntOrgTrngRdnssPct
	FrcElmntOrgPriority	I_FrcElmntOrgBasic	FrcElmntOrgPriority
	FrcElmntOrgLastChgdDteTme	I_FrcElmntOrgBasic	FrcElmntOrgLastChgdDteTme
	FrcElmntOrgLogsLevel	I_FrcElmntOrgBasic	FrcElmntOrgLogsLevel
	FrcElmntOrgInfrstrucPlant	I_FrcElmntOrgBasic	FrcElmntOrgInfrstrucPlant
	FrcElmOrgInfrMRPArea	I_FrcElmntOrgBasic	FrcElmOrgInfrMRPArea
	FrcElmntOrgIsInfrstrucMaterial	I_FrcElmntOrgBasic	FrcElmntOrgIsInfrstrucMaterial
	FrcElmOrgInfrStorLoc	I_FrcElmntOrgBasic	FrcElmOrgInfrStorLoc
	FrcElmntOrgLastChgdByUser	I_FrcElmntOrgBasic	FrcElmntOrgLastChgdByUser
	FrcElmntOrgLastChgdDate	I_FrcElmntOrgBasic	FrcElmntOrgLastChgdDate
	FrcElmntOrgCreatedByUser	I_FrcElmntOrgBasic	FrcElmntOrgCreatedByUser
	FrcElmntOrgCreationDate	I_FrcElmntOrgBasic	FrcElmntOrgCreationDate
	FrcElmntOrgLogicalSystem	I_FrcElmntOrgBasic	FrcElmntOrgLogicalSystem
	FrcElmntOrgMaterialSuplrUUID	I_FrcElmntOrgBasic	FrcElmntOrgMaterialSuplrUUID
	DfsFrcElmntIsChangeable	I_FrcElmntOrgWithAuthorization	DfsFrcElmntIsChangeable
	FrcElmntOrgIsRefFrcElmntOrg	I_FrcElmntOrgBasic	FrcElmntOrgIsRefFrcElmntOrg
	_SenstvyClfn		_SenstvyClfn

@AbapCatalog.sqlViewName: 'IFEORG'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Interface View of FrcElmnt Organization'
@VDM.viewType: #BASIC
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L



define view I_FrcElmntOrg
  //Structural Authorization

  as select from I_FrcElmntOrgBasic             as FrcElmntOrg
  //Structural Authorization

    inner join   I_FrcElmntOrgWithAuthorization as _auth on FrcElmntOrg.ForceElementOrgID = _auth.ForceElementOrgID
  // association [1..1] to I_FrcElmntOrgSuplmntyAttrib as _FrcElmntOrgSuplmntyAttrib on FrcElmntOrg.ForceElementOrgID = _FrcElmntOrgSuplmntyAttrib.ForceElementOrgID

 // Sensitivity  Authorization

    association [1..*] to I_DFS_SenstvyClfnFrcElmnt  as _SenstvyClfn    on $projection.ForceElementOrgID = _SenstvyClfn.ForceElementOrgID  
{
  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,
      _auth.DfsFrcElmntIsChangeable as DfsFrcElmntIsChangeable,
      //      concat(concat(concat('1',FrcElmntOrg.FrcElmntOrgPlanVersion),concat(FrcElmntOrg.FrcElmntOrgType,' ')),concat(concat(FrcElmntOrg.ForceElementOrgID,FrcElmntOrg.ForceElementOrgUUID),FrcElmntOrg.NumberOfForceElementOrg)) as ChgeDocumnentObjID,


      // concat_with_space(concat(concat('1',FrcElmntOrg.FrcElmntOrgPlanVersion),FrcElmntOrg.FrcElmntOrgType),concat(FrcElmntOrg.ForceElementOrgID,concat(FrcElmntOrg.ForceElementOrgUUID,FrcElmntOrg.NumberOfForceElementOrg)),1) as chnagedocobjectid,


      FrcElmntOrg.FrcElmntOrgIsRefFrcElmntOrg,
      //      _FrcElmntOrgSuplmntyAttrib.FrcElmntOrgName,

      //      _FrcElmntOrgSuplmntyAttrib

      //    _FrcElmntOrgCharcs

      _SenstvyClfn 

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_FRCELMNTORGBASIC",
"I_FRCELMNTORGWITHAUTHORIZATION"
],
"ASSOCIATED":
[
"I_DFS_SENSTVYCLFNFRCELMNT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Depth:

I_FrcElmntOrg view

I_FrcElmntOrgBasic view
I_FrcElmntOrgWithAuthorization view