I_LiquidityTransferItemTP

DDL: I_LIQUIDITYTRANSFERITEMTP Type: view_entity TRANSACTIONAL
29 Fields 1 Data Sources 9 Associations

Make Liquidity Transfer Item - TP

I_LiquidityTransferItemTP is a Transactional CDS View that provides data about "Make Liquidity Transfer Item - TP" in SAP S/4HANA. It reads from 1 data source (I_LiquidityTransferItem) and exposes 29 fields with key fields LiquidityItemTransferUUID, LiquidityTransferItemUUID. It has 9 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_LiquidityTransferItem I_LiquidityTransferItem from

Associations (9)

CardinalityTargetAliasCondition
[0..1] I_Currency _Currency $projection.LiquidityTransferCurrency = _Currency.Currency
[0..1] I_Currency _BaseCurrency $projection.LiquidityTransferBaseCurrency = _BaseCurrency.Currency
[0..1] I_CompanyCode _CompanyCode $projection.companycode = _CompanyCode.CompanyCode
[0..*] I_CostCenter _CostCenter $projection.CostCenter = _CostCenter.CostCenter and $projection.controllingarea = _CostCenter.ControllingArea
[0..*] I_ProfitCenter _ProfitCenter $projection.ProfitCenter = _ProfitCenter.ProfitCenter and $projection.controllingarea = _ProfitCenter.ControllingArea
[0..1] I_LiquidityItem _LiquidityItem $projection.LiquidityItem = _LiquidityItem.LiquidityItem
[0..1] I_Customer _Customer $projection.Customer = _Customer.Customer
[0..1] I_Supplier _Supplier $projection.Supplier = _Supplier.Supplier
[0..1] I_Partnercompany _PartnerCompany $projection.PartnerCompany = _PartnerCompany.PartnerCompany and _PartnerCompany.Language = $session.system_language

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
EndUserText.label Make Liquidity Transfer Item - TP view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view

Fields (29)

KeyFieldSource TableSource FieldDescription
KEY LiquidityItemTransferUUID LiquidityItemTransferUUID Transf. UUID
KEY LiquidityTransferItemUUID LiquidityTransferItemUUID Transf. UUID
LiquidityItemTransferID LiquidityItemTransferID Transfer ID
LiquidityTransferItemID LiquidityTransferItemID Transfer Item ID
LiquidityItem LiquidityItem Liquidity Item
PostingDate PostingDate Posting Date for GR
ValueDate ValueDate Value Date
LiquidityTransferAmount LiquidityTransferAmount Value Amount
LiquidityTransferCurrency LiquidityTransferCurrency Valuation Crcy
LiquidityTransferBaseAmount LiquidityTransferBaseAmount TxBaseAmt CoCodeCrcy
LiquidityTransferBaseCurrency LiquidityTransferBaseCurrency Currency
LiquidityTransferItemDesc LiquidityTransferItemDesc Well Code Des.
PartnerCompany TradingPartner Trading Partner
Customer Customer Sold-to Party
Supplier Supplier Supplier
ProfitCenter ProfitCenter Profit Center
CostCenter CostCenter Cost Center
CompanyCode _Transfer CompanyCode Receiver Company Code
ControllingArea
_Currency _Currency
_BaseCurrency _BaseCurrency
_LiquidityItem _LiquidityItem
_CompanyCode _CompanyCode
_ProfitCenter _ProfitCenter
_CostCenter _CostCenter
_Customer _Customer
_Supplier _Supplier
_PartnerCompany _PartnerCompany
_Transfer _Transfer

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_LiquidityTransferItemTP.
-- 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_LiquidityTransferItemTP AS
SELECT
  LiquidityItemTransferUUID,
  LiquidityTransferItemUUID,
  LiquidityItemTransferID,
  LiquidityTransferItemID,
  LiquidityItem,
  PostingDate,
  ValueDate,
  LiquidityTransferAmount,
  LiquidityTransferCurrency,
  LiquidityTransferBaseAmount,
  LiquidityTransferBaseCurrency,
  LiquidityTransferItemDesc,
  TradingPartner AS PartnerCompany,
  Customer,
  Supplier,
  ProfitCenter,
  CostCenter,
  _Transfer.CompanyCode AS CompanyCode,
  _Transfer._CompanyCode.ControllingArea AS ControllingArea
FROM I_LiquidityTransferItem
LEFT OUTER JOIN I_Currency AS _Currency ON LiquidityTransferCurrency = _Currency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _BaseCurrency ON LiquidityTransferBaseCurrency = _BaseCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON companycode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_CostCenter AS _CostCenter ON CostCenter = _CostCenter.CostCenter AND controllingarea = _CostCenter.ControllingArea  -- association [0..*]
LEFT OUTER JOIN I_ProfitCenter AS _ProfitCenter ON ProfitCenter = _ProfitCenter.ProfitCenter AND controllingarea = _ProfitCenter.ControllingArea  -- association [0..*]
LEFT OUTER JOIN I_LiquidityItem AS _LiquidityItem ON LiquidityItem = _LiquidityItem.LiquidityItem  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _Customer ON Customer = _Customer.Customer  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_Partnercompany AS _PartnerCompany ON PartnerCompany = _PartnerCompany.PartnerCompany AND _PartnerCompany.Language = $session.system_language  -- association [0..1]
;

Learn More