C_FinInvoiceHouseBankFDP

DDL: C_FININVOICEHOUSEBANKFDP Type: view_entity CONSUMPTION Package: FINS_OUTPUT_MGMT_FO_FICUS_INV
30 Fields 1 Data Sources 1 Associations

House Bank for FI Invoice

C_FinInvoiceHouseBankFDP is a Consumption CDS View that provides data about "House Bank for FI Invoice" in SAP S/4HANA. It reads from 1 data source (I_Housebank) and exposes 30 fields with key fields CompanyCode, HouseBank. It has 1 association to related views. Part of development package FINS_OUTPUT_MGMT_FO_FICUS_INV.

Data Sources (1)

SourceAliasJoin Type
I_Housebank I_Housebank from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_BankAccount _BankAccount $projection.BankInternalID = _BankAccount.BankAccountInternalID

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label House Bank for FI Invoice view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #CONSUMPTION view

Fields (30)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode Receiver Company Code
KEY HouseBank HouseBank House Bank
BankCountry BankCountry Bank Ctry/Rgn. Key
BankInternalID BankInternalID Bank Key
PhoneNumber1 PhoneNumber1 Telephone 1
TaxID1 TaxID1 Tax Number 1
ContactPersonName ContactPersonName Full Name
Language Language Report Text Language
BusinessPlace BusinessPlace Business place
EDIPartner EDIPartner Partner No.
EDISignatureType EDISignatureType Ty.
DataMediumExchangeBank DataMediumExchangeBank Altern.Bank ID
DataMediumReceivingBank DataMediumReceivingBank Bank No. Receiver
CustomerByHouseBank CustomerByHouseBank Customer Number
BankControlKey BankControlKey Control Key
ExecutionLeadDays ExecutionLeadDays Lead Days
CentralBankReportIsRequired CentralBankReportIsRequired Create Central Bank Report
RegionByCentralBank RegionByCentralBank Area Number
PaymentIsForwardedToCentralBk PaymentIsForwardedToCentralBk Forward Pay. Data
ChargeAccountCurrencyISOCode ChargeAccountCurrencyISOCode ISO Currency Cde
ChargeAccountBank ChargeAccountBank Bank Number
OrderingCompanyByBank OrderingCompanyByBank Company Number
DefaultPartnerValidToDate DefaultPartnerValidToDate Vers.Valid To
DefaultPartnerValidFromDate DefaultPartnerValidFromDate Vers.Valid From
DefaultPartnerNo DefaultPartnerNo
RiskPartnerValidToDate RiskPartnerValidToDate Valid To
RiskPartnerValidFromDate RiskPartnerValidFromDate Valid From
RiskPartnerNo RiskPartnerNo Busn. Partner
_Bank _Bank
_CompanyCode _CompanyCode

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_FinInvoiceHouseBankFDP.
-- 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_FinInvoiceHouseBankFDP AS
SELECT
  CompanyCode,
  HouseBank,
  BankCountry,
  BankInternalID,
  PhoneNumber1,
  TaxID1,
  ContactPersonName,
  Language,
  BusinessPlace,
  EDIPartner,
  EDISignatureType,
  DataMediumExchangeBank,
  DataMediumReceivingBank,
  CustomerByHouseBank,
  BankControlKey,
  ExecutionLeadDays,
  CentralBankReportIsRequired,
  RegionByCentralBank,
  PaymentIsForwardedToCentralBk,
  ChargeAccountCurrencyISOCode,
  ChargeAccountBank,
  OrderingCompanyByBank,
  DefaultPartnerValidToDate,
  DefaultPartnerValidFromDate,
  DefaultPartnerNo,
  RiskPartnerValidToDate,
  RiskPartnerValidFromDate,
  RiskPartnerNo
FROM I_Housebank
LEFT OUTER JOIN I_BankAccount AS _BankAccount ON BankInternalID = _BankAccount.BankAccountInternalID  -- association [1..1]
;

Learn More