I_FrcElmntOrgSuplmntyAttrib

DDL: I_FRCELMNTORGSUPLMNTYATTRIB SQL: IFEORGSUPATT Type: view COMPOSITE
14 Fields 1 Data Sources 3 Associations

Force Element supplementary attributes

I_FrcElmntOrgSuplmntyAttrib is a Composite CDS View that provides data about "Force Element supplementary attributes" in SAP S/4HANA. It reads from 1 data source (I_FrcElmntOrgSuplmntyDteAttrib) and exposes 14 fields with key field ForceElementOrgID. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_FrcElmntOrgSuplmntyDteAttrib FrcElmntOrgSuplmntyDteAttrib from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_FrcElmntOrgSuplmntyName _FrcElmntOrgSuplmntyName FrcElmntOrgSuplmntyDteAttrib.ForceElementOrgID = _FrcElmntOrgSuplmntyName.ForceElementOrgID and FrcElmntOrgSuplmntyDteAttrib.FrcElmntOrgPlngStatus = _FrcElmntOrgSuplmntyName.FrcElmntOrgPlngStatus
[1..1] I_FrcElmntOrgPlngStsText _FrcElmntOrgPlngStsText FrcElmntOrgSuplmntyDteAttrib.FrcElmntOrgPlngStatus = _FrcElmntOrgPlngStsText.FrcElmntOrgPlngStatus
[1..1] I_FrcElmntOrgSuplmntySymCode _FrcElmntOrgSuplmntySymCode FrcElmntOrgSuplmntyDteAttrib.ForceElementOrgID = _FrcElmntOrgSuplmntySymCode.ForceElementOrgID

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IFEORGSUPATT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Force Element supplementary attributes view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY ForceElementOrgID I_FrcElmntOrgSuplmntyDteAttrib ForceElementOrgID Object ID Processor
FrcElmntOrgValdtyStartDate I_FrcElmntOrgSuplmntyDteAttrib FrcElmntOrgValdtyStartDateFoEd Start date
FrcElmntOrgValdtyEndDate I_FrcElmntOrgSuplmntyDteAttrib FrcElmntOrgValdtyEndDate End Date
FrcElmntOrgPlngStatus I_FrcElmntOrgSuplmntyDteAttrib FrcElmntOrgPlngStatus Planning status
FrcElmntOrgLanguage _FrcElmntOrgSuplmntyName FrcElmntOrgLanguage Language
FrcElmntOrgName _FrcElmntOrgSuplmntyName FrcElmntOrgName Name
FrcElmntOrgShortName _FrcElmntOrgSuplmntyName FrcElmntOrgShortName Object abbr.
FrcElmntOrgPlngStatusName _FrcElmntOrgPlngStsText FrcElmntOrgPlngStatusName Planning Status
FrcElmntOrgSymbol _FrcElmntOrgSuplmntySymCode FrcElmntOrgSymbol SC
FrcElmntOrgCountry _FrcElmntOrgSuplmntySymCode FrcElmntOrgCountry Country/Reg.
FrcElmntOrgArea _FrcElmntOrgSuplmntySymCode FrcElmntOrgArea Org. Area
FrcElmntOrgIsAgency _FrcElmntOrgSuplmntySymCode FrcElmntOrgIsAgency Boolean Variable (X = True, - = False, Space = Unknown)
FrcElmntOrgSubType _FrcElmntOrgSuplmntySymCode FrcElmntOrgSubType Subtype
FrcElmntOrgUsageType _FrcElmntOrgSuplmntySymCode FrcElmntOrgUsageType Usage Type

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_FrcElmntOrgSuplmntyAttrib.
-- 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: IFEORGSUPATT

CREATE VIEW I_FrcElmntOrgSuplmntyAttrib AS
SELECT
  FrcElmntOrgSuplmntyDteAttrib.ForceElementOrgID AS ForceElementOrgID,
  FrcElmntOrgSuplmntyDteAttrib.FrcElmntOrgValdtyStartDateFoEd AS FrcElmntOrgValdtyStartDate,
  FrcElmntOrgSuplmntyDteAttrib.FrcElmntOrgValdtyEndDate AS FrcElmntOrgValdtyEndDate,
  FrcElmntOrgSuplmntyDteAttrib.FrcElmntOrgPlngStatus AS FrcElmntOrgPlngStatus,
  _FrcElmntOrgSuplmntyName.FrcElmntOrgLanguage AS FrcElmntOrgLanguage,
  _FrcElmntOrgSuplmntyName.FrcElmntOrgName AS FrcElmntOrgName,
  _FrcElmntOrgSuplmntyName.FrcElmntOrgShortName AS FrcElmntOrgShortName,
  _FrcElmntOrgPlngStsText.FrcElmntOrgPlngStatusName AS FrcElmntOrgPlngStatusName,
  _FrcElmntOrgSuplmntySymCode.FrcElmntOrgSymbol AS FrcElmntOrgSymbol,
  _FrcElmntOrgSuplmntySymCode.FrcElmntOrgCountry AS FrcElmntOrgCountry,
  _FrcElmntOrgSuplmntySymCode.FrcElmntOrgArea AS FrcElmntOrgArea,
  _FrcElmntOrgSuplmntySymCode.FrcElmntOrgIsAgency AS FrcElmntOrgIsAgency,
  _FrcElmntOrgSuplmntySymCode.FrcElmntOrgSubType AS FrcElmntOrgSubType,
  _FrcElmntOrgSuplmntySymCode.FrcElmntOrgUsageType AS FrcElmntOrgUsageType
FROM I_FrcElmntOrgSuplmntyDteAttrib AS FrcElmntOrgSuplmntyDteAttrib
LEFT OUTER JOIN I_FrcElmntOrgSuplmntyName AS _FrcElmntOrgSuplmntyName ON FrcElmntOrgSuplmntyDteAttrib.ForceElementOrgID = _FrcElmntOrgSuplmntyName.ForceElementOrgID AND FrcElmntOrgSuplmntyDteAttrib.FrcElmntOrgPlngStatus = _FrcElmntOrgSuplmntyName.FrcElmntOrgPlngStatus  -- association [1..1]
LEFT OUTER JOIN I_FrcElmntOrgPlngStsText AS _FrcElmntOrgPlngStsText ON FrcElmntOrgSuplmntyDteAttrib.FrcElmntOrgPlngStatus = _FrcElmntOrgPlngStsText.FrcElmntOrgPlngStatus  -- association [1..1]
LEFT OUTER JOIN I_FrcElmntOrgSuplmntySymCode AS _FrcElmntOrgSuplmntySymCode ON FrcElmntOrgSuplmntyDteAttrib.ForceElementOrgID = _FrcElmntOrgSuplmntySymCode.ForceElementOrgID  -- association [1..1]
;

Learn More