fac_cds_bsec_ev

One Time Account | view: FISV_BSEC_EV | Extraction: Not supported | Component: Fiori UI for General Ledger Accounting
Tables used: BSECTIBAN
Column Name Description
bukrs FK Company Code
belnr Document Number of an Accounting Document
gjahr Fiscal Year
buzei null
Column Name Description
Column Name Description
Column Name Description
_dataaging Data Filter Value for Data Aging
iban_valid_from Validity Start of IBAN
Column Name Description
stkzu Liable for VAT Show values
stkza Indicator: Business Partner Subject to Equalization Tax? Show values
dtams Report key for data medium exchange Show values
xcpdk Indicator: Is the account a one-time account? Show values
stkzn Natural Person Show values
xrguh Indicator: Bank Details from REGUH Show values
po_box_num Flag: PO Box Without Number Show values
Column Name Description Domain name
name1 Name 1 NAME
name2 Name 2 NAME
name3 Name 3 NAME
name4 Name 4 NAME
pstlz Postal Code PSTLZ
ort01 City TEXT35
stras Street and House Number TEXT35
pfach PO Box PFACH
pstl2 P.O. Box Postal Code PSTLZ
pskto PO Bank Current Acct No. or Building Society Ref. No. PSKTO
bankn Bank account number BANKN
bankl Bank Keys BANKK
stcd1 Tax Number 1 STCD1
stcd2 Tax Number 2 STCD2
bkont Bank Control Key BKONT
dtaws Instruction Key for Data Medium Exchange DTAWS
empfg Payment Recipient Code EMPFG
stcd3 Tax Number 3 CHAR18
stcd4 Tax Number 4 CHAR18
bkref Reference Details for Bank Details CHAR20
j_1kfrepre Name of Representative REPRES
anred Title TEXT15
adrnr Address ADRNR
begru Authorization Group BEGRU
glo_re1_ot Ctry/Reg. Specific Reference in the One Time Account Data FAC_GLO_REF1_OT
iban IBAN (International Bank Account Number) IBAN
Master Data Relations | to Other Relations ↓ Join Conditions
Country/Region Key of Bank
  • Client
  • Country/Region Key of Bank
  • FAC_CDS_BSEC_EV.MANDT == T005.MANDT
  • FAC_CDS_BSEC_EV.BANKS == T005.LAND1
Company Code
  • Client
  • Company Code
  • FAC_CDS_BSEC_EV.MANDT == T001.MANDT
  • FAC_CDS_BSEC_EV.BUKRS == T001.BUKRS
Tax type
  • ?
  • Client
  • Tax type
  • FAC_CDS_BSEC_EV.[column in domain "KOART"] == J_1AFITP.KOART
  • FAC_CDS_BSEC_EV.MANDT == J_1AFITP.MANDT
  • FAC_CDS_BSEC_EV.FITYP == J_1AFITP.J_1AFITP
Country/Region Key
  • Client
  • Country/Region Key
  • FAC_CDS_BSEC_EV.MANDT == T005.MANDT
  • FAC_CDS_BSEC_EV.LAND1 == T005.LAND1
Region (State, Province, County)
  • Client
  • Region (State, Province, County)
  • Country/Region Key
  • FAC_CDS_BSEC_EV.MANDT == T005S.MANDT
  • FAC_CDS_BSEC_EV.REGIO == T005S.BLAND
  • FAC_CDS_BSEC_EV.LAND1 == T005S.LAND1
Language Key FAC_CDS_BSEC_EV.SPRAS == T002.SPRAS
J_1ATODC
  • Client
  • Tax Number Type
  • FAC_CDS_BSEC_EV.MANDT == J_1ATODC.MANDT
  • FAC_CDS_BSEC_EV.STCDT == J_1ATODC.J_1ATODC
Other Relations | to Master Data Relations ↑ Join Conditions
Type of Business
  • Type of Business
  • Client
  • FAC_CDS_BSEC_EV.J_1KFTBUS == BUSTYPE.GESTYP
  • FAC_CDS_BSEC_EV.MANDT == BUSTYPE.MANDT
Type of Industry
  • Type of Industry
  • Client