SAP Table SEPA_S_SENDER
SEPA Mandate: Sender Data (Debited Bank Account)
SEPA_S_SENDER (SEPA Mandate: Sender Data (Debited Bank Account)) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link SEPA_S_SENDER to other SAP tables.
SEPA_S_SENDER table fields
Field | Data element | Checktable | Datatype | Length | Decimals | |||
---|---|---|---|---|---|---|---|---|
SND_TYPE | SEPA Mandate: Sender Type | SEPA_SND_TYPE | CHAR | 10 | 0 | |||
SND_ID | SEPA Mandate: Sender ID | SEPA_SND_ID | CHAR | 70 | 0 | |||
SND_NAME1 | Last name of business partner (person) | BU_NAMEP_L | CHAR | 40 | 0 | |||
SND_NAME2 | First name of business partner (person) | BU_NAMEP_F | CHAR | 40 | 0 | |||
SND_STREET | Street | AD_STREET | CHAR | 60 | 0 | |||
SND_HOUSENUM | House Number | AD_HSNM1 | CHAR | 10 | 0 | |||
SND_POSTAL | City postal code | AD_PSTCD1 | CHAR | 10 | 0 | |||
SND_CITY | City | AD_CITY1 | CHAR | 40 | 0 | |||
SND_COUNTRY | Country Key | LAND1 | T005 | CHAR | 3 | 0 | ||
SND_IBAN | IBAN (International Bank Account Number) | IBAN | CHAR | 34 | 0 | |||
SND_BIC | SWIFT/BIC for International Payments | SWIFT | CHAR | 11 | 0 | |||
SND_DIR_NAME | SEPA: Name of Alternative Debtor | SEPA_PAYMENT_FOR | CHAR | 40 | 0 | |||
SND_LANGUAGE | Language Key | LANGU | T002 | LANG | 1 | 0 | ||
SND_DIR_ID | SEPA: ID of Alternative Debtor | SEPA_SND_DIR_ID | CHAR | 70 | 0 | |||
SND_DEBTOR_ID | SEPA: ID Number of Sender (External Reference) | SEPA_SND_DEBTOR_ID | CHAR | 35 | 0 |
SEPA_S_SENDER foreign key relationships
Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
---|---|---|---|---|---|---|
SEPA_S_SENDER | SND_COUNTRY | SYST | MANDT | T005 | Countries | MANDT |
SEPA_S_SENDER | SND_COUNTRY | SEPA_S_SENDER | SND_COUNTRY | T005 | Countries | LAND1 |
SEPA_S_SENDER | SND_LANGUAGE | SEPA_S_SENDER | SND_LANGUAGE | T002 | Language Keys (Component BC-I18) | SPRAS |