P_Bsec_Glo

One Time partner Data | view: PBSECGLO | Extraction: Not supported | Component: Localization Financials (generic parts)
Tables used: BSEC
Column Name Description
bukrs FK Company Code
belnr Document Number of an Accounting Document
gjahr Fiscal Year
buzei Number of Line Item Within Accounting Document
Column Name Description
Column Name Description
Column Name Description
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
FirstName Name 1 NAME
LastName Name 2 NAME
name1 null
name2 null
name null
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
Master Data Relations | to Other Relations ↓ Join Conditions
Country/Region Key of Bank
  • Country/Region Key of Bank
  • Client
  • P_BSEC_GLO.BANKS == T005.LAND1
  • P_BSEC_GLO.MANDT == T005.MANDT
Company Code
  • Company Code
  • Client
  • P_BSEC_GLO.BUKRS == T001.BUKRS
  • P_BSEC_GLO.MANDT == T001.MANDT
Tax type
  • ?
  • Client
  • Tax type
  • P_BSEC_GLO.[column in domain "KOART"] == J_1AFITP.KOART
  • P_BSEC_GLO.MANDT == J_1AFITP.MANDT
  • P_BSEC_GLO.FITYP == J_1AFITP.J_1AFITP
Country/Region Key
  • Country/Region Key
  • Client
  • P_BSEC_GLO.LAND1 == T005.LAND1
  • P_BSEC_GLO.MANDT == T005.MANDT
Region (State, Province, County)
  • Country/Region Key
  • Client
  • Region (State, Province, County)
  • P_BSEC_GLO.LAND1 == T005S.LAND1
  • P_BSEC_GLO.MANDT == T005S.MANDT
  • P_BSEC_GLO.REGIO == T005S.BLAND
Language Key P_BSEC_GLO.SPRAS == T002.SPRAS
J_1ATODC
  • Client
  • Tax Number Type
Other Relations | to Master Data Relations ↑ Join Conditions
Type of Business
  • Type of Business
  • Client
  • P_BSEC_GLO.J_1KFTBUS == BUSTYPE.GESTYP
  • P_BSEC_GLO.MANDT == BUSTYPE.MANDT
Type of Industry
  • Type of Industry
  • Client