FICA_MANDATE_STR_ITEM SAP (SEPA Mandate Positions) Structure details

Dictionary Type: Structure
Description: SEPA Mandate Positions




ABAP Code to SELECT data from FICA_MANDATE_STR_ITEM
Related tables to FICA_MANDATE_STR_ITEM
Access table FICA_MANDATE_STR_ITEM




Structure field list including key, data, relationships and ABAP select examples

FICA_MANDATE_STR_ITEM is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "SEPA Mandate Positions" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_FICA_MANDATE_STR_ITEM TYPE FICA_MANDATE_STR_ITEM.

The FICA_MANDATE_STR_ITEM table consists of various fields, each holding specific information or linking keys about SEPA Mandate Positions data available in SAP. These include MGUID (Globally Unique Identifier), MNDID (Unique Referene to Mandate per Payment Recipient), MVERS (SEPA Mandate: Version of Mandate (0 = Current Version)), SIGN_CITY (Location of Signature).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can Be Enhanced (Deep)


SAP FICA_MANDATE_STR_ITEM structure fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
WA_ITEM 0
MGUIDGlobally Unique Identifier GUIDRAW16
MNDIDUnique Referene to Mandate per Payment Recipient SEPA_MNDIDCHAR35ID035
MVERSSEPA Mandate: Version of Mandate (0 = Current Version) SEPA_MVERSNUMC4NUM04
SIGN_CITYLocation of Signature SEPA_SIGN_CITYCHAR40TEXT40
SIGN_DATEDate of Signature SEPA_SIGN_DATEDATS8DATUM
PAY_TYPESEPA: Transaction Type SEPA_PAY_TYPECHAR1SEPA_PAY_TYPE
VAL_FROM_DATESEPA: Validity Date of Mandate (From) SEPA_VAL_FROM_DATEDATS8DATUM
VAL_TO_DATESEPA: Validity Date of Mandate (To) SEPA_VAL_TO_DATEDATS8DATUM
STATUSSEPA: Mandate Status SEPA_STATUSCHAR1SEPA_STATUS
B2BSEPA-Mandate: B2B Mandate SEPA_B2BCHAR1XFELD
REASON_CODEReason Code for Status Change SEPA_REASON_CODECHAR3SEPA_REASON_CODE
ERNAMUser who Created the Current Version of the Mandate SEPA_ERNAMCHAR12SYCHAR12
ERDATDate on Which the Current Mandate Version was Created SEPA_ERDATDATS8DATUM
ERTIMTime at Which the Current Mandate Version was Created SEPA_ERTIMTIMS6UZEIT
CHG_REASONSEPA: Reason for Change SEPA_CHG_REASONCHAR5SEPA_CHG_REASON
ORIGINSingle-Character Indicator CHAR1CHAR1CHAR1
ORIGIN_REC_CRDIDSEPA Mandate: Original Creditor ID of Mandate SEPA_CRDID_ORIGINCHAR35ID035
ORIGIN_MNDIDSEPA Mandate: Original Mandate of Mandate SEPA_MNDID_ORIGINCHAR35ID035
GLOCKGlobal Lock Set in Mandate SEPA_GLOCKCHAR1BOOLEAN
GLOCK_VAL_FROMGlobal Mandate Lock - Valid From SEPA_GLOCK_VAL_FROM_DATEDATS8DATUM
GLOCK_VAL_TOGlobal Mandate Lock - Valid Until SEPA_GLOCK_VAL_TO_DATEDATS8DATUM
ANWNDSEPA: Application for Which Mandate Relevant SEPA_ANWNDCHAR1SEPA_ANWND
ORI_ERNAMUser who Created the Original Mandate SEPA_ORI_ERNAMCHAR12SYCHAR12
ORI_ERDATDate on Which Original Mandate Created SEPA_ORI_ERDATDATS8DATUM
ORI_ERTIMTime when Original Mandate Was Created SEPA_ORI_ERTIMTIMS6UZEIT
REF_TYPESEPA Mandate: Reference Type SEPA_REF_TYPECHAR10OJ_NAMEOBJ
REF_IDSEPA Mandate: Reference ID SEPA_REF_IDCHAR70SWO_TYPEID
REF_DESCText Field TEXT50CHAR50TEXT50
SND_TYPESEPA Mandate: Sender Type SEPA_SND_TYPECHAR10OJ_NAMEOBJ
SND_IDSEPA Mandate: Sender ID SEPA_SND_IDCHAR70SWO_TYPEID
SND_NAME1Last name of business partner (person) BU_NAMEP_LCHAR40BU_NAME
SND_NAME2First name of business partner (person) BU_NAMEP_FCHAR40BU_NAME
SND_STREETStreet AD_STREETCHAR60TEXT60CLSTRTNAME
SND_HOUSENUMHouse Number AD_HSNM1CHAR10TEXT10
SND_POSTALCity postal code AD_PSTCD1CHAR10CHAR10
SND_CITYCity AD_CITY1CHAR40TEXT40CLCITYNAME
SND_COUNTRYCountry Key LAND1CHAR3LAND1LND
SND_IBANIBAN (International Bank Account Number) IBANCHAR34IBAN
SND_BICSWIFT/BIC for International Payments SWIFTCHAR11SWIFT
SND_DIR_NAMESEPA: Name of Alternative Debtor SEPA_PAYMENT_FORCHAR40BU_NAME
SND_LANGUAGELanguage Key LANGULANG1ISOLASPRAS
SND_DIR_IDSEPA: ID of Alternative Debtor SEPA_SND_DIR_IDCHAR70SWO_TYPEID
SND_DEBTOR_IDSEPA: ID Number of Sender (External Reference) SEPA_SND_DEBTOR_IDCHAR35ID035
REC_TYPESEPA Mandate: Recipient Type SEPA_REC_TYPECHAR10OJ_NAMEOBJ
REC_IDSEPA Mandate: Recipient ID SEPA_REC_IDCHAR70SWO_TYPEID
REC_NAME1Name 1 of organization BU_NAMEOR1CHAR40BU_NAME
REC_NAME2Name 2 of organization BU_NAMEOR2CHAR40BU_NAME
REC_CRDIDCreditor Identification Number SEPA_CRDIDCHAR35ID035
REC_STREETStreet AD_STREETCHAR60TEXT60CLSTRTNAME
REC_HOUSENUMHouse Number AD_HSNM1CHAR10TEXT10
REC_POSTALCity postal code AD_PSTCD1CHAR10CHAR10
REC_CITYCity AD_CITY1CHAR40TEXT40CLCITYNAME
REC_COUNTRYCountry Key LAND1CHAR3LAND1LND
REC_DIR_NAMESEPA: Name of Alternative Payee SEPA_REC_DIR_NAMECHAR40BU_NAME
REC_DIR_IDSEPA: ID of Alternative Payee SEPA_REC_DIR_IDCHAR70SWO_TYPEID
FIRSTUSE_DATESEPA Mandate: Date of First Use SEPA_FIRSTUSE_DATEDATS8DATUM
FIRSTUSE_DOCTYPESEPA Mandate: Type of First Usage SEPA_FIRSTUSE_DOCTYPECHAR10OJ_NAMEOBJ
FIRSTUSE_DOCIDSEPA Mandate: ID of First Usage SEPA_FIRSTUSE_DOCIDCHAR70SWO_TYPEIDOBJ
LASTUSE_DATESEPA Mandate: Date of Last Use SEPA_LASTUSE_DATEDATS8DATUM
LASTUSE_DOCTYPESEPA Mandate: Type of Last Usage SEPA_LASTUSE_DOCTYPECHAR10OJ_NAMEOBJ
LASTUSE_DOCIDSEPA Mandate: ID of Last Usage SEPA_LASTUSE_DOCIDCHAR70SWO_TYPEIDOBJ
FIRSTUSE_PAYRUNSEPA Mandate: ID of Payment Run of First Use SEPA_FIRSTUSE_PAYRUNIDCHAR16CHAR16
VERSION_CHGVersion 0 changed in LUW SEPA_VERSION_CHGCHAR1BOOLEAN
ORGF1SEPA Mandate: Internal Organizational Data SEPA_ORG_IDCHAR20CHAR20
ORGF2SEPA Mandate: Internal Organizational Data SEPA_ORG_IDCHAR20CHAR20
ORGF3SEPA Mandate: Internal Organizational Data SEPA_ORG_ID_LONGCHAR35CHAR35
ORGF4SEPA Mandate: Internal Organizational Data SEPA_ORG_ID_LONGCHAR35CHAR35
REC_ID_CRDIDCreditor ID Without Business Code SEPA_ID_CRDIDCHAR35ID035
.INCLU--AP 0
/SAPF15/F15_BW /SAPF15/BEWIRTSCHAFTERCHAR8/SAPF15/BEWIRTSCHAFTER/SAPF15/BEWIRT
/SAPF15/F15_KZ /SAPF15/KASSENZEICHENCHAR12CHAR12
/SAPF15/GUID /SAPF15/GUIDRAW16SYSUUID
.INCLU--AP 0
CONTRACT_IDBKK: SEPA Mandate Contract ID BKK_DTE_MND_CONTRACT_IDCHAR50BKK_MANDATE_CONTRACT
CONTRACT_DESCBKK:SEPA Mandate Contract Description BKK_DTE_MND_CONTRACT_DESCCHAR50BKK_MANDATE_CONTRACT
BANK_CRDTRBank Is Creditor BKK_DTE_MND_BANK_CRDTRCHAR1XFELD
.INCLU--AP 0
LAUFDDate ID LAUFD_KKDATS8DATUM
LAUFIAdditional Identification Characteristic LAUFI_KKCHAR6LAUFI_KK

Key field Non-key field



How do I retrieve data from SAP structure FICA_MANDATE_STR_ITEM using ABAP code?

As FICA_MANDATE_STR_ITEM is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on FICA_MANDATE_STR_ITEM as there is no data to select.

How to access SAP table FICA_MANDATE_STR_ITEM

Within an ECC or HANA version of SAP you can also view further information about FICA_MANDATE_STR_ITEM and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!