I_FrcElmntOrgNtwkGraphWarTme

DDL: I_FRCELMNTORGNTWKGRAPHWARTME SQL: IFEORGNWGHWARTME Type: view BASIC
24 Fields 6 Data Sources

Interface View of Force Element Wartime

I_FrcElmntOrgNtwkGraphWarTme is a Basic CDS View that provides data about "Interface View of Force Element Wartime" in SAP S/4HANA. It reads from 6 data sources and exposes 24 fields with key fields FrcElmntOrgPlanVersion, FrcElmntOrgType, ForceElementOrgID, FrcElmntOrgSubType, FrcElmntOrgPlngStatus.

Data Sources (6)

SourceAliasJoin Type
I_FrcElmntOrgWithAuthorization _auth inner
I_FrcElmntOrgWithAuthorization _auth inner
I_FrcElmntOrgWithAuthorization _auth1 inner
I_FrcElmntOrgWithAuthorization _auth1 inner
P_FrcElmntOrgNtwkGraphWarTme FrcElmntOrgNtwkGraphWarTme from
P_FrcElmntOrgNtwkGraphWarTme FrcElmntOrgNtwkGraphWarTme union_all

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IFEORGNWGHWARTME view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #M view
EndUserText.label Interface View of Force Element Wartime view

Fields (24)

KeyFieldSource TableSource FieldDescription
KEY FrcElmntOrgPlanVersion P_FrcElmntOrgNtwkGraphWarTme FrcElmntOrgPlanVersion Plan version
KEY FrcElmntOrgType P_FrcElmntOrgNtwkGraphWarTme FrcElmntOrgType Object type
KEY ForceElementOrgID P_FrcElmntOrgNtwkGraphWarTme ForceElementOrgID ID rel.object
KEY FrcElmntOrgSubType P_FrcElmntOrgNtwkGraphWarTme FrcElmntOrgSubType Subtype
KEY FrcElmntOrgPlngStatus P_FrcElmntOrgNtwkGraphWarTme FrcElmntOrgPlngStatus Planning status
KEY FrcElmntOrgValdtyStartDate P_FrcElmntOrgNtwkGraphWarTme FrcElmntOrgValdtyStartDate Start date
KEY FrcElmntOrgValdtyEndDate P_FrcElmntOrgNtwkGraphWarTme FrcElmntOrgValdtyEndDate End Date
KEY NumberOfForceElementOrg P_FrcElmntOrgNtwkGraphWarTme NumberOfForceElementOrg IT record no.
FrcElmntOrgInfoType P_FrcElmntOrgNtwkGraphWarTme FrcElmntOrgInfoType Infotype
FrcElmntOrgRelatedOrgType P_FrcElmntOrgNtwkGraphWarTme FrcElmntOrgRelatedOrgType Rel.obj.type
FrcElmntOrgRelatedOrgID P_FrcElmntOrgNtwkGraphWarTme FrcElmntOrgRelatedOrgID Object ID Processor
FrcElmntOrgRelshpPriority P_FrcElmntOrgNtwkGraphWarTme FrcElmntOrgRelshpPriority Priority
FrcElmntOrgPlanVersion Plan version
KEY FrcElmntOrgType P_FrcElmntOrgNtwkGraphWarTme FrcElmntOrgType Object type
KEY ForceElementOrgID P_FrcElmntOrgNtwkGraphWarTme FrcElmntOrgRelatedOrgID ID rel.object
KEY FrcElmntOrgSubType P_FrcElmntOrgNtwkGraphWarTme FrcElmntOrgSubType Subtype
KEY FrcElmntOrgPlngStatus P_FrcElmntOrgNtwkGraphWarTme FrcElmntOrgPlngStatus Planning status
KEY FrcElmntOrgValdtyStartDate P_FrcElmntOrgNtwkGraphWarTme FrcElmntOrgValdtyStartDate Start date
KEY FrcElmntOrgValdtyEndDate P_FrcElmntOrgNtwkGraphWarTme FrcElmntOrgValdtyEndDate End Date
KEY NumberOfForceElementOrg P_FrcElmntOrgNtwkGraphWarTme NumberOfForceElementOrg IT record no.
FrcElmntOrgInfoType P_FrcElmntOrgNtwkGraphWarTme FrcElmntOrgInfoType Infotype
FrcElmntOrgRelatedOrgType P_FrcElmntOrgNtwkGraphWarTme FrcElmntOrgRelatedOrgType Rel.obj.type
FrcElmntOrgRelatedOrgID P_FrcElmntOrgNtwkGraphWarTme ForceElementOrgID Object ID Processor
FrcElmntOrgRelshpPriority P_FrcElmntOrgNtwkGraphWarTme FrcElmntOrgRelshpPriority Priority

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_FrcElmntOrgNtwkGraphWarTme.
-- 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: IFEORGNWGHWARTME

CREATE VIEW I_FrcElmntOrgNtwkGraphWarTme AS
SELECT
  FrcElmntOrgNtwkGraphWarTme.FrcElmntOrgPlanVersion AS FrcElmntOrgPlanVersion,
  FrcElmntOrgNtwkGraphWarTme.FrcElmntOrgType AS FrcElmntOrgType,
  FrcElmntOrgNtwkGraphWarTme.ForceElementOrgID AS ForceElementOrgID,
  FrcElmntOrgNtwkGraphWarTme.FrcElmntOrgSubType AS FrcElmntOrgSubType,
  FrcElmntOrgNtwkGraphWarTme.FrcElmntOrgPlngStatus AS FrcElmntOrgPlngStatus,
  FrcElmntOrgNtwkGraphWarTme.FrcElmntOrgValdtyStartDate AS FrcElmntOrgValdtyStartDate,
  FrcElmntOrgNtwkGraphWarTme.FrcElmntOrgValdtyEndDate AS FrcElmntOrgValdtyEndDate,
  FrcElmntOrgNtwkGraphWarTme.NumberOfForceElementOrg AS NumberOfForceElementOrg,
  FrcElmntOrgNtwkGraphWarTme.FrcElmntOrgInfoType AS FrcElmntOrgInfoType,
  FrcElmntOrgNtwkGraphWarTme.FrcElmntOrgRelatedOrgType AS FrcElmntOrgRelatedOrgType,
  FrcElmntOrgNtwkGraphWarTme.FrcElmntOrgRelatedOrgID AS FrcElmntOrgRelatedOrgID,
  FrcElmntOrgNtwkGraphWarTme.FrcElmntOrgRelshpPriority AS FrcElmntOrgRelshpPriority
FROM P_FrcElmntOrgNtwkGraphWarTme AS FrcElmntOrgNtwkGraphWarTme
INNER JOIN I_FrcElmntOrgWithAuthorization AS _auth ON /* join condition not captured in parsed metadata */
INNER JOIN I_FrcElmntOrgWithAuthorization AS _auth1 ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): P_FrcElmntOrgNtwkGraphWarTme
;

Learn More