I_USFedTreasuryFormat

DDL: I_USFEDTREASURYFORMAT Type: view_entity BASIC
10 Fields 1 Data Sources 1 Associations

US Fed Treasury Combined X Format

I_USFedTreasuryFormat is a Basic CDS View that provides data about "US Fed Treasury Combined X Format" in SAP S/4HANA. It reads from 1 data source (fmfg_trsy_format) and exposes 10 fields with key fields USFedTreasuryLayoutID, USFedTreasuryVersionID, USFedTreasurySectionID, USFedTreasuryStepID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
fmfg_trsy_format Format from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_USFedTreasuryLayout _Layout _Layout.USFedTreasuryLayoutID = Format.fmfg_layout_id and _Layout.USFedTreasuryVersionID = Format.fmfg_version_id

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label US Fed Treasury Combined X Format view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY USFedTreasuryLayoutID fmfg_trsy_format fmfg_layout_id Layout ID
KEY USFedTreasuryVersionID fmfg_trsy_format fmfg_version_id Version ID
KEY USFedTreasurySectionID fmfg_trsy_format fmfg_section_id Section ID
KEY USFedTreasuryStepID fmfg_trsy_format fmfg_step_id Step ID
USFedTreasuryStepType fmfg_trsy_format fmfg_step_type Line Type
USFedTreasuryLink fmfg_trsy_format fmfg_link Line Item No.
USFedTreasuryStepDesc fmfg_trsy_format fmfg_step_desc Line item desc
USFedIsHideZero fmfg_trsy_format fmfg_hide_zero Hide Zero
USFedTreasuryLayoutDesc _Layout USFedTreasuryLayoutDesc
_Layout _Layout

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_USFedTreasuryFormat.
-- 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.

CREATE VIEW I_USFedTreasuryFormat AS
SELECT
  Format.fmfg_layout_id AS USFedTreasuryLayoutID,
  Format.fmfg_version_id AS USFedTreasuryVersionID,
  Format.fmfg_section_id AS USFedTreasurySectionID,
  Format.fmfg_step_id AS USFedTreasuryStepID,
  Format.fmfg_step_type AS USFedTreasuryStepType,
  Format.fmfg_link AS USFedTreasuryLink,
  Format.fmfg_step_desc AS USFedTreasuryStepDesc,
  Format.fmfg_hide_zero AS USFedIsHideZero,
  _Layout.USFedTreasuryLayoutDesc AS USFedTreasuryLayoutDesc
FROM fmfg_trsy_format AS Format
LEFT OUTER JOIN I_USFedTreasuryLayout AS _Layout ON _Layout.USFedTreasuryLayoutID = Format.fmfg_layout_id AND _Layout.USFedTreasuryVersionID = Format.fmfg_version_id  -- association [1..1]
;

Learn More