I_Housebank

Master data for House Bank | view: IFIHOUSEBANK | ATTR | Extraction: Full only | Component: SAP Cash Management
Column Name Description
CompanyCode FK Company Code
HouseBank Short Key for a House Bank
Column Name Description
Column Name Description
Column Name Description
DefaultPartnerValidToDate Valid To
DefaultPartnerValidFromDate Valid From
RiskPartnerValidToDate Valid To
RiskPartnerValidFromDate Valid From
Column Name Description
EDISignatureType Type of Signature Show values
CentralBankReportIsRequired Create Central Bank Report Show values
PaymentIsForwardedToCentralBk Forward Payment Data to the Central Bank Show values
Column Name Description Domain name
BankInternalID Bank Keys BANKK
PhoneNumber1 First telephone number TEXT16
TaxID1 Tax Number 1 STCD1
ContactPersonName Name of contact person TEXT30
EDIPartner House Bank Partner Number EDI_PARNUM
DataMediumExchangeBank DME Bank Identification CHAR5
DataMediumReceivingBank Bank Number of the Bank Receiving the Data Medium BANKL
CustomerByHouseBank Customer ID at House Bank CHAR18
BankControlKey Bank Control Key BKONT
ExecutionLeadDays Lead Days for Date of Execution NUMC02
RegionByCentralBank Area Number NUMC02
ChargeAccountCurrencyISOCode ISO Currency Code for Charge Account CHAR3
ChargeAccount Account Number of the Charge Account BANKN35
ChargeAccountBank Charge Account Bank Number BANKL
OrderingCompanyByBank Company Number of Ordering Party CHAR20
Master Data Relations Join Conditions
Country/Region Key of Bank
  • Country/Region Key of Bank
  • Client
  • I_HOUSEBANK.BANKCOUNTRY == T005.LAND1
  • I_HOUSEBANK.MANDT == T005.MANDT
Company Code
  • Company Code
  • Client
  • I_HOUSEBANK.COMPANYCODE == T001.BUKRS
  • I_HOUSEBANK.MANDT == T001.MANDT
Instruction Key for Data Medium Exchange
  • Country/Region Key of Bank
  • Instruction Key for Data Medium Exchange
  • Instruction Key for Data Medium Exchange
  • ?
  • Client
  • I_HOUSEBANK.BANKCOUNTRY == T015W.BANKS
  • I_HOUSEBANK.DATAEXCHANGEINSTRUCTION == T015W.DTAWS
  • I_HOUSEBANK.DATAEXCHANGEINSTRUCTIONKEY == T015W.DTAWS
  • I_HOUSEBANK.[column in domain "DZLSCH"] == T015W.ZLSCH
  • I_HOUSEBANK.MANDT == T015W.MANDT
Instruction Key for Data Medium Exchange
  • Country/Region Key of Bank
  • Instruction Key for Data Medium Exchange
  • Instruction Key for Data Medium Exchange
  • ?
  • Client
  • I_HOUSEBANK.BANKCOUNTRY == T015W.BANKS
  • I_HOUSEBANK.DATAEXCHANGEINSTRUCTION == T015W.DTAWS
  • I_HOUSEBANK.DATAEXCHANGEINSTRUCTIONKEY == T015W.DTAWS
  • I_HOUSEBANK.[column in domain "DZLSCH"] == T015W.ZLSCH
  • I_HOUSEBANK.MANDT == T015W.MANDT
Business Partner Number
  • Client
  • Business Partner Number
  • Business Partner Number
  • I_HOUSEBANK.MANDT == BUT000.CLIENT
  • I_HOUSEBANK.DEFAULTPARTNERNO == BUT000.PARTNER
  • I_HOUSEBANK.RISKPARTNERNO == BUT000.PARTNER
Language Key I_HOUSEBANK.LANGUAGE == T002.SPRAS
Business Partner Number
  • Client
  • Business Partner Number
  • Business Partner Number
  • I_HOUSEBANK.MANDT == BUT000.CLIENT
  • I_HOUSEBANK.DEFAULTPARTNERNO == BUT000.PARTNER
  • I_HOUSEBANK.RISKPARTNERNO == BUT000.PARTNER