SAP ABAP Table REGUH_LST (Payment data (neutral communication structure))
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷
CRM (Application Component) Customer Relationship Management
⤷
CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
⤷
FBZ (Package) Payments
⤷
⤷
⤷
Basic Data
| Table Category | INTTAB | Structure |
| Structure | REGUH_LST |
|
| Short Description | Payment data (neutral communication structure) |
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 | |
DZBUKR | BUKRS | CHAR | 4 | 0 | Paying company code | T001 | |
| 2 | |
LIFNR | LIFNR | CHAR | 10 | 0 | Account Number of Vendor or Creditor | * | |
| 3 | |
KUNNR | KUNNR | CHAR | 10 | 0 | Customer Number | * | |
| 4 | |
EMPFG | EMPFG | CHAR | 16 | 0 | Payee code | ||
| 5 | |
VBLNR | BELNR | CHAR | 10 | 0 | Document Number of the Payment Document | ||
| 6 | |
WAERS | WAERS | CUKY | 5 | 0 | Currency Key | TCURC | |
| 7 | |
GSBER | GSBER | CHAR | 4 | 0 | Business Area | * | |
| 8 | |
NAME1_GP | NAME | CHAR | 35 | 0 | Name 1 | ||
| 9 | |
NAME2_GP | NAME | CHAR | 35 | 0 | Name 2 | ||
| 10 | |
PSTLZ | PSTLZ | CHAR | 10 | 0 | Postal Code | ||
| 11 | |
PSTL2 | PSTLZ | CHAR | 10 | 0 | P.O. Box Postal Code | ||
| 12 | |
ORT01_GP | TEXT35 | CHAR | 35 | 0 | City | ||
| 13 | |
STRAS_GP | TEXT35 | CHAR | 35 | 0 | House number and street | ||
| 14 | |
PFACH | PFACH | CHAR | 10 | 0 | PO Box | ||
| 15 | |
LAND1 | LAND1 | CHAR | 3 | 0 | Country Key | T005 | |
| 16 | |
REGIO | REGIO | CHAR | 3 | 0 | Region (State, Province, County) | T005S | |
| 17 | |
DZNME1 | TEXT35 | CHAR | 35 | 0 | Name of the payee | ||
| 18 | |
DZNME1 | TEXT35 | CHAR | 35 | 0 | Name of the payee | ||
| 19 | |
DZPSTL | PSTLZ | CHAR | 10 | 0 | Postal code of the payee | ||
| 20 | |
DZPST2 | PSTLZ | CHAR | 10 | 0 | P.O. box postal code of the payee | ||
| 21 | |
DZORT1 | TEXT35 | CHAR | 35 | 0 | City of the payee | ||
| 22 | |
ORT02_Z | TEXT35 | CHAR | 35 | 0 | Location from payee's address | ||
| 23 | |
PFORT_Z | TEXT35 | CHAR | 35 | 0 | City of payee's PO box | ||
| 24 | |
DZSTRA | TEXT35 | CHAR | 35 | 0 | Street and house number of the payee | ||
| 25 | |
DZPFAC | PFACH | CHAR | 10 | 0 | P.O. box of the payee | ||
| 26 | |
DZLAND | LAND1 | CHAR | 3 | 0 | Country Key | T005 | |
| 27 | |
DZREGI | REGIO | CHAR | 3 | 0 | Regional code of the payee | T005S | |
| 28 | |
DZBNKS | LAND1 | CHAR | 3 | 0 | Country Key | T005 | |
| 29 | |
DZBNKY | BANKK | CHAR | 15 | 0 | Bank key of the payee's bank | ||
| 30 | |
DZBNKL | BANKL | CHAR | 15 | 0 | Bank number of the payee's bank | ||
| 31 | |
DZBNKN | BANKN | CHAR | 18 | 0 | Bank account number of the payee | ||
| 32 | |
DZBKON | BKONT | CHAR | 2 | 0 | Bank Control Key of the Payee's Bank | ||
| 33 | |
BKREF | CHAR20 | CHAR | 20 | 0 | Reference specifications for bank details | ||
| 34 | |
DZIBAN | IBAN | CHAR | 34 | 0 | IBAN of the Payee | ||
| 35 | |
DZBNKA | TEXT60 | CHAR | 60 | 0 | Name of the Payee's Bank | ||
| 36 | |
DZBORT | TEXT35 | CHAR | 35 | 0 | City of the Payee's Bank | ||
| 37 | |
KOINH_FI | KOINH | CHAR | 60 | 0 | Account Holder Name | ||
| 38 | |
DZSPRA | SPRAS | LANG | 1 | 0 | Language key of the payee | T002 | |
| 39 | |
ABSBU | BUKRS | CHAR | 4 | 0 | Sending company code | * | |
| 40 | |
HKTID | HKTID | CHAR | 5 | 0 | ID for account details | T012K | |
| 41 | |
HBKID | HBKID | CHAR | 5 | 0 | Short key for a house bank | T012 | |
| 42 | |
BANKS | LAND1 | CHAR | 3 | 0 | Bank country key | T005 | |
| 43 | |
UBNKY | BANKK | CHAR | 15 | 0 | Bank key of our bank | ||
| 44 | |
UBNKL | BANKL | CHAR | 15 | 0 | Bank number of our bank | ||
| 45 | |
UBKON | BKONT | CHAR | 2 | 0 | Bank control key at our bank | ||
| 46 | |
UBKNT | BANKN | CHAR | 18 | 0 | Our account number at the bank | ||
| 47 | |
UIBAN | IBAN | CHAR | 34 | 0 | IBAN at our House Bank | ||
| 48 | |
RZAWE | ZLSCH | CHAR | 1 | 0 | Payment Method for This Payment | T042Z | |
| 49 | |
TEXT1_042Z | TEXT30 | CHAR | 30 | 0 | Name of Payment Method in Language of the Country | ||
| 50 | |
UZAWE | UZAWE | CHAR | 2 | 0 | Payment method supplement | T042F | |
| 51 | |
TEXT1_042H | TEXT30 | CHAR | 30 | 0 | Meaning of Payment Method Supplement | ||
| 52 | |
EDIAV | EDIST | CHAR | 1 | 0 | EDI Payment Advice Status | ||
| 53 | |
EDIBN | EDIST | CHAR | 1 | 0 | EDI Payment Order Status | ||
| 54 | |
DZALDT_ZHL | DATUM | DATS | 8 | 0 | Posting date of the payment document | ||
| 55 | |
VALUT | DATUM | DATS | 8 | 0 | Fixed Value Date | ||
| 56 | |
AUSFD | DATUM | DATS | 8 | 0 | Due date of the paid items | ||
| 57 | |
RBETR | WRTV7 | CURR | 13 | 2 | Amount in Local Currency | ||
| 58 | |
RWBTR | WRTV7 | CURR | 13 | 2 | Amount Paid in the Payment Currency | ||
| 59 | |
RSKON | WRTV7 | CURR | 13 | 2 | Total Cash Discount for the Payment Trans. (Local Currency) | ||
| 60 | |
RWSKT | WRTV7 | CURR | 13 | 2 | Total Cash Discount for the Pmnt Transactn in Pmnt Currency | ||
| 61 | |
SKVHW | WERT7 | CURR | 13 | 2 | Lost Cash Discount in Local Currency | ||
| 62 | |
SKVFW | WERT7 | CURR | 13 | 2 | Lost Cash Discount in Payment Currency | ||
| 63 | |
QSTEV | WRTV7 | CURR | 13 | 2 | Withholding Tax Amount (+/-) in Local Currency | ||
| 64 | |
WQSTV | WRTV7 | CURR | 13 | 2 | Withholding Tax Amount (+/-) in Foreign Currency | ||
| 65 | |
ABZGV | WRTV7 | CURR | 13 | 2 | Total Deductions (+/-) in Local Currency | ||
| 66 | |
WABZV | WRTV7 | CURR | 13 | 2 | Total Deductions (+/-) in Foreign Currency | ||
| 67 | |
DMBTV | WRTV7 | CURR | 13 | 2 | Gross Amount in Local Currency with +/- Sign | ||
| 68 | |
WRBTV | WRTV7 | CURR | 13 | 2 | Gross Amount in Foreign Currency with +/- Signs | ||
| 69 | |
NETTV | WRTV7 | CURR | 13 | 2 | Net Amount in Local Currency with +/- Signs | ||
| 70 | |
WNETV | WRTV7 | CURR | 13 | 2 | Net Amount in Foreign Currency with +/- Signs | ||
| 71 | |
PAYGR | CHAR20 | CHAR | 20 | 0 | Grouping Field for Automatic Payments | ||
| 72 | |
RPOST | PACK3 | DEC | 5 | 0 | Number of Items Paid | ||
| 73 | |
RTEXT_D | PACK3 | DEC | 5 | 0 | Number of Text Lines for the Items Paid | ||
| 74 | |
BUSAB | BUSAB | CHAR | 2 | 0 | Accounting clerk | * | |
| 75 | |
EIKTO | CHAR12 | CHAR | 12 | 0 | Shipper's (Our) Account Number at the Customer or Vendor | ||
| 76 | |
KIDNO | CHAR30 | CHAR | 30 | 0 | Payment Reference | ||
| 77 | |
DTAWS | DTAWS | CHAR | 2 | 0 | Instruction key for data medium exchange | * | |
| 78 | |
DTAT16 | DTWSX | NUMC | 2 | 0 | Instruction key 1 | * | |
| 79 | |
DTAT17 | DTWSX | NUMC | 2 | 0 | Instruction key 2 | * | |
| 80 | |
DTAT18 | DTWSX | NUMC | 2 | 0 | Instruction key 3 | * | |
| 81 | |
DTAT19 | DTWSX | NUMC | 2 | 0 | Instruction key 4 | * | |
| 82 | |
PERNR_D | PERNR | NUMC | 8 | 0 | Personnel Number | ||
| 83 | |
0 | 0 | ||||||
| 84 | |
PFORT_Z | TEXT35 | CHAR | 35 | 0 | City of payee's PO box | ||
| 85 | |
SWIFT | SWIFT | CHAR | 11 | 0 | SWIFT/BIC for International Payments | ||
| 86 | |
BRNCH | TEXT40 | CHAR | 40 | 0 | Bank Branch | ||
| 87 | |
SEPA_MNDID | ID035 | CHAR | 35 | 0 | Unique Referene to Mandate per Payment Recipient | ||
| 88 | |
SEPA_SEQ_TYPE | SEPA_SEQ_TYPE | CHAR | 4 | 0 | SEPA: Sequence Type | ||
| 89 | |
FSEPA_INST_CODE | FSEPA_INST_CODE | CHAR | 4 | 0 | Local Instrument Code (Direct Debit Type) |
Foreign Keys
| |
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right |
|---|---|---|---|---|---|---|---|
| 1 | REGUH_LST | HBKID | |
|
|||
| 2 | REGUH_LST | HKTID | |
|
|||
| 3 | REGUH_LST | LAND1 | |
|
|||
| 4 | REGUH_LST | REGIO | |
|
|||
| 5 | REGUH_LST | RZAWE | |
|
|||
| 6 | REGUH_LST | UBNKS | |
|
|||
| 7 | REGUH_LST | UZAWE | |
|
|||
| 8 | REGUH_LST | WAERS | |
|
|||
| 9 | REGUH_LST | ZBNKS | |
|
|||
| 10 | REGUH_LST | ZBUKR | |
|
|||
| 11 | REGUH_LST | ZLAND | |
|
|||
| 12 | REGUH_LST | ZREGI | |
|
|||
| 13 | REGUH_LST | ZSPRA | |
|
History
| Last changed by/on | SAP | 20140121 |
| SAP Release Created in |