C_FinancialChainTP

DDL: C_FINANCIALCHAINTP Type: view_entity CONSUMPTION
25 Fields 1 Data Sources

Financial Chain

C_FinancialChainTP is a Consumption CDS View that provides data about "Financial Chain" in SAP S/4HANA. It reads from 1 data source (R_FinancialChainTP) and exposes 25 fields with key field FinancialChain.

Data Sources (1)

SourceAliasJoin Type
R_FinancialChainTP R_FinancialChainTP projection

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Financial Chain view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY FinancialChain FinancialChain
FinancialChainName FinancialChainName
CompanyCode CompanyCode Receiver Company Code
FinancialChainCategory FinancialChainCategory
FinancialChainLifeCycleStatus FinancialChainLifeCycleStatus
FinChainEffctvLifeCycleStatus FinChainEffctvLifeCycleStatus
FinChainLfcycStsCriticality FinChainLfcycStsCriticality
DeliveringPlant DeliveringPlant Delivering Plant
DeliveringPlantName _DeliveringPlant PlantName Plant Name
ReceivingPlant ReceivingPlant Receiving Plant
ReceivingPlantName _ReceivingPlant PlantName Plant Name
FinChainValidityStartDate FinChainValidityStartDate
FinChainValidityEndDate FinChainValidityEndDate
CreatedByUser CreatedByUser User Name
CreatedByUserFullName _CreatedByContactCard FullName Name
UserFullName
LastChangedByUser LastChangedByUser User Name
LastChangedByUserFullName _ChangedByContactCard FullName Name
LastChangedByUserName
CreationDateTime CreationDateTime Timestamp
LastChangeDateTime LastChangeDateTime Timestamp
LocalLastChangedDateTime LocalLastChangedDateTime Time Stamp
_EffctvLifeCycleStatus _EffctvLifeCycleStatus
_CreatedByContactCard _CreatedByContactCard
_ChangedByContactCard _ChangedByContactCard

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 C_FinancialChainTP.
-- 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 C_FinancialChainTP AS
SELECT
  FinancialChain,
  FinancialChainName,
  CompanyCode,
  FinancialChainCategory,
  FinancialChainLifeCycleStatus,
  FinChainEffctvLifeCycleStatus,
  FinChainLfcycStsCriticality,
  DeliveringPlant,
  _DeliveringPlant.PlantName AS DeliveringPlantName,
  ReceivingPlant,
  _ReceivingPlant.PlantName AS ReceivingPlantName,
  FinChainValidityStartDate,
  FinChainValidityEndDate,
  CreatedByUser,
  _CreatedByContactCard.FullName AS CreatedByUserFullName,
  _CreatedByUser._UserAddress._PersonName.PersonFullName AS UserFullName,
  LastChangedByUser,
  _ChangedByContactCard.FullName AS LastChangedByUserFullName,
  _LastChangedByUser._UserAddress._PersonName.PersonFullName AS LastChangedByUserName,
  CreationDateTime,
  LastChangeDateTime,
  LocalLastChangedDateTime
FROM R_FinancialChainTP
;

Learn More