SAP table T049E (Control Data for Swiss ISR Procedure)

SAP table T049E 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
BUFLG Leading Company Code CHAR 1 0 BUFLG
SAKOZ Bank Statement: Account Modification CHAR 10 0 EB_KOMOK
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
OFKND Offset of Customer Number in the ISR Reference Number NUMC 2 0 OFKND_49E
01 Allowed Area
LKDNR Length of Customer Number NUMC 2 0 LKDNR_49E
03 Allowed Area
VKORG Sales Organization CHAR 4 0 TVKO VKORG_49E
BANKL Bank No.for Billing Document and Dunning Printout with ISR CHAR 15 0 BANKL_49E
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
APPLK Application Indicator CHAR 6 0 TBE11 APPLK_49E

T049E foreign key relationships

Table Field Check Table Check Field
0 T049E BLART T003 Document Types MANDT
1 T049E BUKRS T001 Company Codes BUKRS
0 T049E MANDT T000 Clients MANDT
1 T049E SAKOV SKB1 G/L account master (company code) MANDT
1 T049E SAKOV SKB1 G/L account master (company code) BUKRS
0 T049E VKORG TVKO Organizational Unit: Sales Organizations MANDT
0 T049E VKORG TVKO Organizational Unit: Sales Organizations VKORG