/PF1/I_BIS_Item_Address

Enriched Item Data with BIS data requirement( address data) | view: /PF1/IV_BISPIADR | TRAN | Extraction: Not supported | Component: Payment Factory
Column Name Description
ItemGuid Globally Unique Identifier
Column Name Description
💲 Transaction Currency (tr_curr):
tr_amount Amount in Transaction Currency
Column Name Description
Column Name Description
pi_date Payment Item Date
Column Name Description
Column Name Description Domain name
pi_no Payment Item Number From Number Range /PF1/DOM_PO_PO_ID
AccountHolderName Substitute Account Holder Name /PF1/DOM_BPE_HOLDERNAME
department Address: Department /PF1/DOM_ISO_ADDR_LINE
sub_department Address: Sub-Department /PF1/DOM_ISO_ADDR_LINE
streetname Address: Street Name /PF1/DOM_ISO_ADDR_LINE
buildingnumber Address: Building Number /PF1/DOM_ISO_CHAR16
postalcode Address: Postal Code /PF1/DOM_ISO_CHAR16
townname Address: Town Name /PF1/DOM_ISO_CHAR35
countrysubdiv Address: SubDivision /PF1/DOM_ISO_CHAR35
country_addr ISO Country Code INTCA
addr_line1 Address Line /PF1/DOM_ISO_ADDR_LINE
addr_line2 Address Line /PF1/DOM_ISO_ADDR_LINE
addr_line3 Address Line /PF1/DOM_ISO_ADDR_LINE
addr_line4 Address Line /PF1/DOM_ISO_ADDR_LINE
addr_line5 Address Line /PF1/DOM_ISO_ADDR_LINE
addr_line6 Address Line /PF1/DOM_ISO_ADDR_LINE
addr_line7 Address Line /PF1/DOM_ISO_ADDR_LINE
acct_no Account Number /PF1/DOM_BPE_ACCT
iban IBAN After Account Substitution /PF1/DOM_BPE_IBAN
bankkey Bank Key BANKK
bic Bank Identifier Code (BIC) /PF1/DOM_BPE_BIC
clrsysidcd Clearing System Member ID Code /PF1/DOM_PO_CLRSYSMMBIDCD
Master Data Relations Join Conditions
Foreign Key for Clearing Area /PF1/I_BIS_ITEM_ADDRESS.MANDT == /PF1/T_CLAREA.MANDT
Bank Country/Region
  • Client
  • Bank Country/Region
  • /PF1/I_BIS_ITEM_ADDRESS.MANDT == T005.MANDT
  • /PF1/I_BIS_ITEM_ADDRESS.COUNTRY == T005.LAND1