SAP ABAP Table IHC_STR_CD_IHC_DB_PN (Mirror Structure for IHC_DB_PN Change Documents)
Hierarchy
EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   FIN-FSCM-IHC (Application Component) FSCM In-House Cash
     FIN_IHC (Package) Payment Order In-House Cash
Basic Data
Table Category INTTAB    Structure 
Structure IHC_STR_CD_IHC_DB_PN   Table Relationship Diagram
Short Description Mirror Structure for IHC_DB_PN Change Documents    
Delivery and Maintenance
Pool/cluster      
Delivery Class      
Data Browser/Table View Maintenance     Display/Maintenance Allowed with Restrictions 
Components
     
Field Key Data Element Domain Data
Type
Length Decimal
Places
Short Description Check
table
1 MANDT MANDT MANDT CLNT 3   0   Client T000
2 GUID GUID_16 SYSUUID RAW 16   0   GUID in 'RAW' format  
3 UNIT IHC_DTE_UNIT IHC_DOM_UNIT CHAR 4   0   Bank Area  
4 PN_NUMBER IHC_DTE_PN_NUMBER IHC_DOM_PN_NUMBER NUMC 10   0   Payment Order Number  
5 PN_YEAR IHC_DTE_PN_JAHR JAHR NUMC 4   0   Fiscal Year of IHC Payment Order  
6 STATUS_CNT IHC_DTE_COUNTER NUMC6 NUMC 6   0   Counter (includ. Status)  
7 BLOCK IHC_DTE_PN_BLOCK XFELD CHAR 1   0   Item Is Locked for Automatic Processing  
8 ERROR IHC_DTE_PN_ERROR XFELD CHAR 1   0   Error in Processing  
9 LAST_GUI_STATUS IHC_DTE_GUI_STATUS IHC_DOM_GUI_STATUS CHAR 2   0   Status of the Payment Order  
10 PAY_PRI_BNKID IHC_DTE_PN_PAY_PRI_BNKID BANKL CHAR 15   0   Payer Primary Bank ID  
11 PAY_PRI_IDQUAL IHC_DTE_PN_PRI_IDQUAL CHAR6 CHAR 6   0   Qualifier for Primary Bank ID  
12 PAY_SEC_BNKID IHC_DTE_PN_PAY_SEC_BNKID BANKL CHAR 15   0   Payer Secondary Bank ID  
13 PAY_SEC_IDQUAL IHC_DTE_PN_SEC_IDQUAL CHAR6 CHAR 6   0   Qualifier for Secondary Bank ID  
14 PAY_BKONT IHC_DTE_PN_PAY_BKONT BKONT CHAR 2   0   Payer Bank Control Key  
15 PAY_BANK_NAME IHC_DTE_PN_PAY_BANK_NAME TEXT60 CHAR 60   0   Payer Name of Financial Institution  
16 PAY_BANK_CNTRY IHC_DTE_PN_PAY_BANK_CNTRY LAND1 CHAR 3   0   Payer Bank Country *
17 PAY_ACCHO_NAME IHC_DTE_PN_PAY_ACCHO_NAME KOINH CHAR 60   0   Name of Account Holder for Payer Account  
18 PAY_ACCHO_CNTRY IHC_DTE_PN_PAY_ACCHO_CNTRY LAND1 CHAR 3   0   Payer Country Key *
19 PAY_ACCTNO IHC_DTE_PN_PAY_ACCTNO CHAR35 CHAR 35   0   Payer Account Number  
20 PAY_IBAN IHC_DTE_PN_PAY_IBAN IBAN CHAR 34   0   Payer IBAN  
21 PAY_ACCTCURR IHC_DTE_PN_PAY_ACCTCURR WAERS CUKY 5   0   Payer Account Currency *
22 PAY_AMOUNT IHC_DTE_PN_PAY_AMOUNT   CURR 17   2   Payer Amount in Account Currency  
23 PAY_VALUE_DATE IHC_DTE_PN_PAY_VALUE_DATE DATUM DATS 8   0   Payer Value Date  
24 PAY_EXRATE IHC_DTE_PN_PAY_EXRATE NIHC_EXRATE DEC 9   5   Payer Exchange Rate  
25 PAY_AMOUNT_PRIM IHC_DTE_PN_PAY_AMOUNT_EXT   CURR 17   2   Payer Amount in Account Currency  
26 PAY_EXRATE_PRIM IHC_DTE_PN_PAY_EXRATE_EXT NIHC_EXRATE DEC 9   5   Payer Exchange Rate  
27 OPAY_PRI_BNKID IHC_DTE_PN_OPAY_PRI_BNKID BANKL CHAR 15   0   Original Payer Primary Bank ID  
28 OPAY_PRI_IDQUAL IHC_DTE_PN_PRI_IDQUAL CHAR6 CHAR 6   0   Qualifier for Primary Bank ID  
29 OPAY_SEC_BNKID IHC_DTE_PN_OPAY_SEC_BNKID BANKL CHAR 15   0   Original Payer Secondary Bank ID  
30 OPAY_SEC_IDQUAL IHC_DTE_PN_SEC_IDQUAL CHAR6 CHAR 6   0   Qualifier for Secondary Bank ID  
31 OPAY_BKONT IHC_DTE_PN_OPAY_BKONT BKONT CHAR 2   0   Original Payer Bank Control Key  
32 OPAY_BANK_NAME IHC_DTE_PN_OPAY_BANK_NAME TEXT60 CHAR 60   0   Original Payer Name of Financial Institution  
33 OPAY_BANK_CNTRY IHC_DTE_PN_OPAY_BANK_CNTRY LAND1 CHAR 3   0   Original Payer Bank Country Key *
34 OPAY_ACCHO_NAME IHC_DTE_PN_OPAY_ACCHO_NAME KOINH CHAR 60   0   Original Payer Name of Account Holder  
35 OPAY_ACCHO_CNTRY IHC_DTE_PN_OPAY_ACCHO_CNTRY LAND1 CHAR 3   0   Original Payer Country Key *
36 OPAY_ACCTNO IHC_DTE_PN_OPAY_ACCTNO CHAR35 CHAR 35   0   Original Payer Account Number  
37 OPAY_IBAN IHC_DTE_PN_OPAY_IBAN IBAN CHAR 34   0   Original Payer IBAN  
38 OPAY_ACCTCURR IHC_DTE_PN_OPAY_ACCTCURR WAERS CUKY 5   0   Original Payer Account Currency *
39 OPAY_VALUE_DATE IHC_DTE_PN_OPAY_VALUE_DATE DATUM DATS 8   0   Original Payer Value Date  
40 OPAY_EXRATE IHC_DTE_PN_OPAY_EXRATE NIHC_EXRATE DEC 9   5   Original Payer Exchange Rate  
41 REC_BANKL IHC_DTE_PN_REC_BANKL BANKK CHAR 15   0   Recipient Bank Key  
42 REC_PRI_BNKID IHC_DTE_PN_REC_PRI_BNKID BANKL CHAR 15   0   Recipient Primary Bank ID  
43 REC_PRI_IDQUAL IHC_DTE_PN_PRI_IDQUAL CHAR6 CHAR 6   0   Qualifier for Primary Bank ID  
44 REC_SEC_BNKID IHC_DTE_PN_REC_SEC_BNKID BANKL CHAR 15   0   Recipient Secondary Bank ID  
45 REC_SEC_IDQUAL IHC_DTE_PN_SEC_IDQUAL CHAR6 CHAR 6   0   Qualifier for Secondary Bank ID  
46 REC_BKONT IHC_DTE_PN_REC_BKONT BKONT CHAR 2   0   Recipient Bank Control Key  
47 REC_BANK_NAME IHC_DTE_PN_REC_BANK_NAME TEXT60 CHAR 60   0   Recipient Name of Financial Insitution  
48 REC_BANK_CNTRY IHC_DTE_PN_REC_BANK_CNTRY LAND1 CHAR 3   0   Recipient Bank Country *
49 REC_BANK_REF IHC_DTE_PN_REC_BANK_REF CHAR20 CHAR 20   0   Recipient Reference Info for Bank Details  
50 REC_ACCHO_NAME IHC_DTE_PN_REC_ACCHO_NAME KOINH CHAR 60   0   Name of Account Holder for Recipient Account  
51 REC_ACCHO_CNTRY IHC_DTE_PN_REC_ACCHO_CNTRY LAND1 CHAR 3   0   Recipient Country Key *
52 REC_ACCTNO IHC_DTE_PN_REC_ACCTNO CHAR35 CHAR 35   0   Account Number of Recipient  
53 REC_IBAN IHC_DTE_PN_REC_IBAN IBAN CHAR 34   0   Recipient IBAN  
54 REC_ACCTCURR IHC_DTE_PN_REC_ACCTCURR WAERS CUKY 5   0   Recipient Account Currency *
55 REC_AMOUNT IHC_DTE_PN_REC_AMNT   CURR 17   2   Recipient Amount in Account Currency  
56 REC_VALUE_DATE IHC_DTE_PN_REC_VALUE_DATE DATUM DATS 8   0   Recipient Value Date  
57 REC_EXRATE IHC_DTE_PN_REC_EXRATE NIHC_EXRATE DEC 9   5   Recipient Exchange Rate  
58 REC_AMOUNT_PRIM IHC_DTE_PN_REC_AMNT_EXT   CURR 17   2   Recipient Amount in Account Currency  
59 REC_EXRATE_PRIM IHC_DTE_PN_REC_EXRATE_EXT NIHC_EXRATE DEC 9   5   Recipient Exchange Rate  
60 REC_UNIT IHC_DTE_PN_REC_UNIT IHC_DOM_UNIT CHAR 4   0   Bank Area Recipient  
61 CLR_PRI_BNKID IHC_DTE_PN_CLR_PRI_BNKID BANKL CHAR 15   0   Clearing Partner Primary Bank ID  
62 CLR_PRI_IDQUAL IHC_DTE_PN_PRI_IDQUAL CHAR6 CHAR 6   0   Qualifier for Primary Bank ID  
63 CLR_SEC_BNKID IHC_DTE_PN_CLR_SEC_BNKID BANKL CHAR 15   0   Clearing Partner Secondary Bank ID  
64 CLR_SEC_IDQUAL IHC_DTE_PN_SEC_IDQUAL CHAR6 CHAR 6   0   Qualifier for Secondary Bank ID  
65 CLR_BKONT IHC_DTE_PN_CLR_BKONT BKONT CHAR 2   0   Clearing Partner Bank Control Key  
66 CLR_BANK_NAME IHC_DTE_PN_CLR_BANK_NAME TEXT60 CHAR 60   0   Clearing Partner Name of Financial Institution  
67 CLR_BANK_CNTRY IHC_DTE_PN_CLR_BANK_CNTRY LAND1 CHAR 3   0   Clearing Partner Country Key of Bank *
68 CLR_ACCHO_NAME IHC_DTE_PN_CLR_ACCHO_NAME KOINH CHAR 60   0   Clearing Partner Name of Account Holder  
69 CLR_ACCHO_CNTRY IHC_DTE_PN_CLR_ACCHO_CNTRY LAND1 CHAR 3   0   Clearing Partner Country Key *
70 CLR_ACCTNO IHC_DTE_PN_CLR_ACCTNO CHAR35 CHAR 35   0   Clearing Partner Account Number  
71 CLR_IBAN IHC_DTE_PN_CLR_IBAN IBAN CHAR 34   0   Clearing Partner IBAN  
72 CLR_ACCTCURR IHC_DTE_PN_CLR_ACCTCURR WAERS CUKY 5   0   Clearing Partner Account Currency *
73 CLR_AMOUNT IHC_DTE_PN_CLR_AMOUNT   CURR 17   2   Clearing Partner Amount in Account Currency  
74 CLR_VALUE_DATE IHC_DTE_PN_CLR_VALUE_DATE DATUM DATS 8   0   Clearing Partner Value Date  
75 CLR_EXRATE IHC_DTE_PN_CLR_EXRATE NIHC_EXRATE DEC 9   5   Clearing Partner Exchange Rate  
76 CLR_AMOUNT_PRIM IHC_DTE_PN_CLR_AMOUNT_EXT   CURR 17   2   Clearing Partner Amount in Account Currency  
77 CLR_EXRATE_PRIM IHC_DTE_PN_CLR_EXRATE_EXT NIHC_EXRATE DEC 9   5   Clearing Partner Exchange Rate  
78 CLR_PRTNR_TYPE IHC_DTE_PN_CLR_TYPE IHC_DOM_PN_CLR_TYPE CHAR 3   0   Clearing Partner Type  
79 TRNS_TYPE IHC_DTE_PN_TRNS_TYPE IHC_DOM_TRANSACTION_TYPE CHAR 6   0   Transaction Type IHC_TAB_TRANS
80 TRNS_DIRECTION IHC_DTE_PN_DIRECTION XFELD CHAR 1   0   Bank Transfer  
81 TRNS_AMOUNT IHC_DTE_TRANSACTION_AMOUNT   CURR 17   2   Transaction Amount  
82 TRNS_CURR IHC_DTE_TRANSACTION_CURRENCY WAERS CUKY 5   0   Transaction Currency *
83 PL_PROC_DATE IHC_DTE_PN_PROC_DATE DATUM DATS 8   0   Date Executed  
84 PL_POST_DATE IHC_DTE_PN_POST_DATE DATUM DATS 8   0   Posting Date  
85 EXEC_INSTRUCT IHC_DTE_PN_INSTRUCT IHC_DOM_INSTRUCTION CHAR 8   0   Execution Instruction *
86 CRUSR IHC_DTE_CREATE_USER USNAM CHAR 12   0   Created By  
87 CRDAT IHC_DTE_CREATE_DATE DATUM DATS 8   0   Created On  
88 CRTIM IHC_DTE_CREATE_TIME UZEIT TIMS 6   0   Created At  
89 INPUT_CHANNEL IHC_DTE_CHANNEL IHC_DOM_CHANNEL CHAR 8   0   Input Channel  
90 CHUSR IHC_DTE_CHANGE_USER USNAM CHAR 12   0   Changed By  
91 CHDAT IHC_DTE_CHANGE_DATE DATUM DATS 8   0   Changed On  
92 CHTIM IHC_DTE_CHANGE_TIME UZEIT TIMS 6   0   Changed At  
93 REUSR IHC_DTE_RELEASE_USER USNAM CHAR 12   0   Released By  
94 REDAT IHC_DTE_RELEASE_DATE DATUM DATS 8   0   Released On  
95 RETIM IHC_DTE_RELEASE_TIME UZEIT TIMS 6   0   Released At  
96 CS_PAY_FLAG IHC_DTE_FLG_CS_SND XFELD CHAR 1   0   Currency Conversion for Sender Item  
97 CS_REC_FLAG IHC_DTE_FLG_CS_RCV XFELD CHAR 1   0   Currency Conversion for Recipient Item  
98 RCV_EXTERN IHC_DTE_PN_RCV_EXTERN CHAR1 CHAR 1   0   Indicator: Enter External Forward  
99 CLR_PRTNR_ID IHC_DTE_PN_PRTNR_ID   CHAR 4   0   Clearing Partner  
100 EXT_PAY IHC_DTE_PN_EXTPAY IHC_DOM_PN_EXTPAY CHAR 1   0   External Payment  
101 CHECK_PAY IHC_DTE_PN_CHECK_PAY CHAR1 CHAR 1   0   This is a check payment  
102 SINGLE_PAY IHC_DTE_PN_SINGLE_PAY CHAR1 CHAR 1   0   IHC: Flag for Single Payment  
103 IN_IDOC_NUMBER EDI_DOCNUM EDI_DOCNUM NUMC 16   0   IDoc number  
104 OUT_IDOC_NUMBER EDI_DOCNUM EDI_DOCNUM NUMC 16   0   IDoc number  
105 IN_RZAWE IHC_DTE_IN_RZAWE ZLSCH CHAR 1   0   Delivered Payment Method *
106 IN_UZAWE IHC_DTE_IN_UZAWE UZAWE CHAR 2   0   Delivered Payment Method Supplement *
107 OUT_RZAWE RZAWE ZLSCH CHAR 1   0   Payment Method for This Payment *
108 OUT_UZAWE UZAWE UZAWE CHAR 2   0   Payment method supplement *
109 PAYRQ_NO PRQ_KEYNO PRQ_KEYNO CHAR 10   0   Key Number for Payment Request *
110 IN_IDOC_MESTYP EDI_MESTYP EDI_MESTYP CHAR 30   0   Message Type *
111 OUT_IDOC_MESTYP EDI_MESTYP EDI_MESTYP CHAR 30   0   Message Type *
112 INSTRUCTION_CODE IHC_DTE_INSTRUCTION_CODE IHC_DOM_INSTRUCTION_KEY CHAR 16   0   IHC Instruction Key IHC_TAB_INST_KEY
113 INSTRUCTION1 IHC_DTE_PN_INSTRUCT1 IHC_DOM_INSTRUCTION CHAR 8   0   Execution Instruction 1 IHC_TAB_INST
114 INSTRUCTION2 IHC_DTE_PN_INSTRUCT2 IHC_DOM_INSTRUCTION CHAR 8   0   Execution Instruction 2 IHC_TAB_INST
115 INSTRUCTION3 IHC_DTE_PN_INSTRUCT3 IHC_DOM_INSTRUCTION CHAR 8   0   Execution Instruction 3 IHC_TAB_INST
116 INSTRUCTION4 IHC_DTE_PN_INSTRUCT4 IHC_DOM_INSTRUCTION CHAR 8   0   Execution Instruction 4 IHC_TAB_INST
117 XBS_NUMBER BF_AZNUMEB NUM5 NUMC 5   0   Statement Number  
118 XBS_POSITION BF_ESNUMEB NUM5 NUMC 5   0   Memo record number (line item number in bank statement)  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 IHC_STR_CD_IHC_DB_PN INSTRUCTION1 IHC_TAB_INST INST_CODE    
2 IHC_STR_CD_IHC_DB_PN INSTRUCTION2 IHC_TAB_INST INST_CODE    
3 IHC_STR_CD_IHC_DB_PN INSTRUCTION3 IHC_TAB_INST INST_CODE    
4 IHC_STR_CD_IHC_DB_PN INSTRUCTION4 IHC_TAB_INST INST_CODE    
5 IHC_STR_CD_IHC_DB_PN INSTRUCTION_CODE IHC_TAB_INST_KEY INSTR_KEY    
6 IHC_STR_CD_IHC_DB_PN MANDT T000 MANDT KEY    
7 IHC_STR_CD_IHC_DB_PN TRNS_TYPE IHC_TAB_TRANS TRANSACTION_TYPE    
History
Last changed by/on SAP  20110901 
SAP Release Created in 500