I_FrcElmntOrgCharcs

DDL: I_FRCELMNTORGCHARCS SQL: IFEORGCHARCS Type: view BASIC
26 Fields 1 Data Sources

Interface View of Force Element Org Characteristics

I_FrcElmntOrgCharcs is a Basic CDS View that provides data about "Interface View of Force Element Org Characteristics" in SAP S/4HANA. It reads from 1 data source (P_FrcElmntOrgCharcs) and exposes 26 fields with key fields FrcElmntOrgPlanVersion, FrcElmntOrgType, ForceElementOrgID, FrcElmntOrgSubType, FrcElmntOrgPlngStatus.

Data Sources (1)

SourceAliasJoin Type
P_FrcElmntOrgCharcs FrcElmntOrgCharcs from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IFEORGCHARCS view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Interface View of Force Element Org Characteristics view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY FrcElmntOrgPlanVersion P_FrcElmntOrgCharcs FrcElmntOrgPlanVersion Plan version
KEY FrcElmntOrgType P_FrcElmntOrgCharcs FrcElmntOrgType Object type
KEY ForceElementOrgID P_FrcElmntOrgCharcs ForceElementOrgID Object ID Processor
KEY FrcElmntOrgSubType P_FrcElmntOrgCharcs FrcElmntOrgSubType Subtype
KEY FrcElmntOrgPlngStatus P_FrcElmntOrgCharcs FrcElmntOrgPlngStatus Planning status
KEY FrcElmntOrgValdtyStartDate P_FrcElmntOrgCharcs FrcElmntOrgValdtyStartDate Start date
KEY FrcElmntOrgValdtyEndDate P_FrcElmntOrgCharcs FrcElmntOrgValdtyEndDate End Date
KEY NumberOfForceElementOrg P_FrcElmntOrgCharcs NumberOfForceElementOrg IT record no.
FrcElmntOrgInfoType P_FrcElmntOrgCharcs FrcElmntOrgInfoType Infotype
FrcElmntOrgCountry P_FrcElmntOrgCharcs FrcElmntOrgCountry Country/Reg.
FrcElmntOrgArea P_FrcElmntOrgCharcs FrcElmntOrgArea Org. Area
FrcElmntOrgStrucType P_FrcElmntOrgCharcs FrcElmntOrgStrucType Structure Type
FrcElmntOrgStrucLevel P_FrcElmntOrgCharcs FrcElmntOrgStrucLevel Strct. Level
FrcElmntOrgBranch P_FrcElmntOrgCharcs FrcElmntOrgBranch Branch
FrcElmntOrgUsageType P_FrcElmntOrgCharcs FrcElmntOrgUsageType Usage Type
FrcElmntOrgIsAgency
FrcElmntOrgAreaType P_FrcElmntOrgCharcs FrcElmntOrgAreaType OrgArType
FrcElmntOrgBranchAddition P_FrcElmntOrgCharcs FrcElmntOrgBranchAddition BA
FrcElmntOrgSymbol P_FrcElmntOrgCharcs FrcElmntOrgSymbol SC
FrcElmntOrgUIC P_FrcElmntOrgCharcs FrcElmntOrgUIC Unit Idn Code
FrcElmntOrgReferenceID P_FrcElmntOrgCharcs FrcElmntOrgReferenceID Object ID
FrcElmntOrgServiceType P_FrcElmntOrgCharcs FrcElmntOrgServiceType Service Type
FrcElmntOrgActivity P_FrcElmntOrgCharcs FrcElmntOrgActivity Activity Code Char
FrcElmntOrgUICParagraph P_FrcElmntOrgCharcs FrcElmntOrgUICParagraph UIC Paragraph
FrcElmntOrgSensitivity
FrcElmntOrgSensitivityPrio

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_FrcElmntOrgCharcs.
-- 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: IFEORGCHARCS

CREATE VIEW I_FrcElmntOrgCharcs AS
SELECT
  FrcElmntOrgCharcs.FrcElmntOrgPlanVersion AS FrcElmntOrgPlanVersion,
  FrcElmntOrgCharcs.FrcElmntOrgType AS FrcElmntOrgType,
  FrcElmntOrgCharcs.ForceElementOrgID AS ForceElementOrgID,
  FrcElmntOrgCharcs.FrcElmntOrgSubType AS FrcElmntOrgSubType,
  FrcElmntOrgCharcs.FrcElmntOrgPlngStatus AS FrcElmntOrgPlngStatus,
  FrcElmntOrgCharcs.FrcElmntOrgValdtyStartDate AS FrcElmntOrgValdtyStartDate,
  FrcElmntOrgCharcs.FrcElmntOrgValdtyEndDate AS FrcElmntOrgValdtyEndDate,
  FrcElmntOrgCharcs.NumberOfForceElementOrg AS NumberOfForceElementOrg,
  FrcElmntOrgCharcs.FrcElmntOrgInfoType AS FrcElmntOrgInfoType,
  FrcElmntOrgCharcs.FrcElmntOrgCountry AS FrcElmntOrgCountry,
  FrcElmntOrgCharcs.FrcElmntOrgArea AS FrcElmntOrgArea,
  FrcElmntOrgCharcs.FrcElmntOrgStrucType AS FrcElmntOrgStrucType,
  FrcElmntOrgCharcs.FrcElmntOrgStrucLevel AS FrcElmntOrgStrucLevel,
  FrcElmntOrgCharcs.FrcElmntOrgBranch AS FrcElmntOrgBranch,
  FrcElmntOrgCharcs.FrcElmntOrgUsageType AS FrcElmntOrgUsageType,
  cast(FrcElmntOrgCharcs.FrcElmntOrgIsAgency as boolean) AS FrcElmntOrgIsAgency,
  FrcElmntOrgCharcs.FrcElmntOrgAreaType AS FrcElmntOrgAreaType,
  FrcElmntOrgCharcs.FrcElmntOrgBranchAddition AS FrcElmntOrgBranchAddition,
  FrcElmntOrgCharcs.FrcElmntOrgSymbol AS FrcElmntOrgSymbol,
  FrcElmntOrgCharcs.FrcElmntOrgUIC AS FrcElmntOrgUIC,
  FrcElmntOrgCharcs.FrcElmntOrgReferenceID AS FrcElmntOrgReferenceID,
  FrcElmntOrgCharcs.FrcElmntOrgServiceType AS FrcElmntOrgServiceType,
  FrcElmntOrgCharcs.FrcElmntOrgActivity AS FrcElmntOrgActivity,
  FrcElmntOrgCharcs.FrcElmntOrgUICParagraph AS FrcElmntOrgUICParagraph,
  case FrcElmntOrgCharcs.FrcElmntOrgSensitivity when '00' then '' else FrcElmntOrgCharcs.FrcElmntOrgSensitivity end AS FrcElmntOrgSensitivity,
  case FrcElmntOrgCharcs.FrcElmntOrgSensitivityPrio when '00' then '' else FrcElmntOrgCharcs.FrcElmntOrgSensitivityPrio end AS FrcElmntOrgSensitivityPrio
FROM P_FrcElmntOrgCharcs AS FrcElmntOrgCharcs
;

Learn More