I_LiquidityItemTransfer

DDL: I_LIQUIDITYITEMTRANSFER SQL: ILQTRHD Type: view BASIC
12 Fields 1 Data Sources 2 Associations

Liquidity Item Transfer Interface

I_LiquidityItemTransfer is a Basic CDS View that provides data about "Liquidity Item Transfer Interface" in SAP S/4HANA. It reads from 1 data source (fclm_lqt) and exposes 12 fields with key field LiquidityItemTransferUUID. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
fclm_lqt transfer from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_User _CreatedBy $projection.TransferCreatedByUser = _CreatedBy.UserID
[0..1] I_User _LastChangedBy $projection.TransferLastChangedByUser = _LastChangedBy.UserID

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName ILQTRHD view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Liquidity Item Transfer Interface view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY LiquidityItemTransferUUID fclm_lqt lqtr_uuid Transf. UUID
LiquidityItemTransferID fclm_lqt lqtr_id Transfer ID
CompanyCode fclm_lqt companycode Receiver Company Code
LiquidityTransferCurrency fclm_lqt currency Valuation Crcy
LiquidityItemTransferStatus fclm_lqt status Workflow Status
LiquidityItemTransferDesc fclm_lqt description Well Code Des.
TransferCreatedByUser fclm_lqt create_user User Name
TransferCreateDateTime fclm_lqt create_timestamp Time Stamp
TransferLastChangedByUser fclm_lqt last_change_user Last Changed By
TransferLastChangedDateTime fclm_lqt last_change_timestamp Timestamp
_CreatedBy _CreatedBy
_LastChangedBy _LastChangedBy

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_LiquidityItemTransfer.
-- 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: ILQTRHD

CREATE VIEW I_LiquidityItemTransfer AS
SELECT
  transfer.lqtr_uuid AS LiquidityItemTransferUUID,
  transfer.lqtr_id AS LiquidityItemTransferID,
  transfer.companycode AS CompanyCode,
  transfer.currency AS LiquidityTransferCurrency,
  transfer.status AS LiquidityItemTransferStatus,
  transfer.description AS LiquidityItemTransferDesc,
  transfer.create_user AS TransferCreatedByUser,
  transfer.create_timestamp AS TransferCreateDateTime,
  transfer.last_change_user AS TransferLastChangedByUser,
  transfer.last_change_timestamp AS TransferLastChangedDateTime
FROM fclm_lqt AS transfer
LEFT OUTER JOIN I_User AS _CreatedBy ON TransferCreatedByUser = _CreatedBy.UserID  -- association [0..1]
LEFT OUTER JOIN I_User AS _LastChangedBy ON TransferLastChangedByUser = _LastChangedBy.UserID  -- association [0..1]
;

Learn More