SAP table TIV9I (RE: Owner POR Data (Switzerland))

SAP table TIV9I has 4 primary key fields being MANDT,TEILN,KUNID,BUKRS.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
TEILN ISR Subscriber Number NUMC 9 0 TEILN_49E
KUNID Customer ID Number CHAR 15 0 KUNID_49E
BUKRS Company Code of ISR Subscriber CHAR 4 0 T001 BUKRS_49E
SAKOZ Incoming Payments Account, Post Office or Bank CHAR 10 0 SKB1 SAKOZ_49E
SAKOV Payment Clearing Account Post Office or Bank CHAR 10 0 SKB1 SAKOV_49E
BLART Document Type for ISR/QR-IBAN Posting CHAR 2 0 T003 BLART_49E
OFSET Offset of Document Number in the ISR Reference Number NUMC 2 0 OFSET_49E
01 Allowed area
LBLNR Document Number Length NUMC 2 0 LBLNR_49E
03 Allowed area
NOTAKT Indicator: Do Not Print ISR CHAR 1 0 NOTAKT_49E
VERFA ISR Procedure NUMC 2 0 VERFA_49E
03 ISR with 9-digit subscriber number and 27-digit ref.no.
04 B.ISR with 9-digit subscriber number and 27-digit ref.no.
07 ISR+ with 9-digit subscriber number and 27-digit ref.no.
08 B.ISR+ with 9-digit subscriber number and 27-digit ref.no.
XMESR Indicator: Printing of Dunning Notices with ISR CHAR 1 0 XMESR_49E

TIV9I foreign key relationships

Table Field Check Table Check Field
0 TIV9I BLART T003 Document Types MANDT
1 TIV9I BUKRS T001 Company Codes BUKRS
0 TIV9I SAKOV SKB1 G/L account master (company code) MANDT
0 TIV9I SAKOV SKB1 G/L account master (company code) BUKRS
1 TIV9I SAKOZ SKB1 G/L account master (company code) MANDT
1 TIV9I SAKOZ SKB1 G/L account master (company code) BUKRS