SAP StackSAP FICOSAP HRSAP MMSAP SDSAP PMSAP PSSAP ABAPSAP NetWeaverSAP TablesSAP Tcodes ☰MENU

SEPA_MANDATE Table in SAP | SEPA Mandate Table & Fields List

SEPA_MANDATE is a SAP table coming under CA module and SAP_ABA component.View details, Fields & related tables of SEPA_MANDATE in SAP.

  • Table description : SEPA Mandate
  • Module : CA-BK
  • Parent Module : CA
  • Package : BF_SEPA
  • Software Component : SAP_ABA
SEPA_MANDATE table in SAP

Here is some free PDF files that you can download free for your reference.
Download Now

Search For SAP Tables

Definitions

What is SAP ?

SAP is the short form of Systems, Applications & Products in Data Processing. It is one of the largest business process related software. This software focused on business processes on ERP & CRM.

What is table in SAP ?

Like most other software, SAP also using database tables to store the data. In SAP thousands of tables are there to store different data. A table contains several fields and some of the fields will be key fields.

SAP SEPA_MANDATE Table Fields structure

FieldNoteData ElementDomain
MANDTClientMANDTMANDT
MGUIDSEPA Mandate: GUID of MandateSEPA_MGUID  
.INCLUDESEPA Mandate: Standard Fields (Cannot be Enhanced)    
MNDIDUnique Referene to Mandate per Payment RecipientSEPA_MNDIDID035
MVERSSEPA Mandate: Version of Mandate (0 = Current Version)SEPA_MVERSNUM04
.INCLUDESEPA Mandate: Management Data    
.INCLUDESEPA Mandate: Management Data (External Fields)    
SIGN_CITYLocation of SignatureSEPA_SIGN_CITYTEXT40
SIGN_DATEDate of SignatureSEPA_SIGN_DATEDATUM
PAY_TYPESEPA: Payment TypeSEPA_PAY_TYPESEPA_PAY_TYPE
VAL_FROM_DATESEPA: Validity Date of Mandate (From)SEPA_VAL_FROM_DATEDATUM
VAL_TO_DATESEPA: Validity Date of Mandate (To)SEPA_VAL_TO_DATEDATUM
STATUSSEPA: Mandate StatusSEPA_STATUSSEPA_STATUS
B2BSEPA-Mandate: B2B MandateSEPA_B2BXFELD
REASON_CODEReason Code for Status ChangeSEPA_REASON_CODESEPA_REASON_CODE
.INCLUDESEPA Mandate: Management Data (Internal Data)    
ERNAMUser who Created the Current Version of the MandateSEPA_ERNAMSYCHAR12
ERDATDate on Which the Current Mandate Version was CreatedSEPA_ERDATDATUM
ERTIMTime at Which the Current Mandate Version was CreatedSEPA_ERTIMUZEIT
CHG_REASONSEPA: Reason for ChangeSEPA_CHG_REASONSEPA_CHG_REASON
ORIGINSingle-Character FlagCHAR1CHAR1
ORIGIN_REC_CRDIDSEPA Mandate: Original Creditor ID of MandateSEPA_CRDID_ORIGINID035
ORIGIN_MNDIDSEPA Mandate: Original Mandate of MandateSEPA_MNDID_ORIGINID035
GLOCKGlobal Lock Set in MandateSEPA_GLOCKBOOLEAN
GLOCK_VAL_FROMGlobal Mandate Lock - Valid FromSEPA_GLOCK_VAL_FROM_DATEDATUM
GLOCK_VAL_TOGlobal Mandate Lock - Valid UntilSEPA_GLOCK_VAL_TO_DATEDATUM
ANWNDSEPA: Application for Which Mandate RelevantSEPA_ANWNDSEPA_ANWND
ORI_ERNAMUser who Created the Original MandateSEPA_ORI_ERNAMSYCHAR12
ORI_ERDATDate on Which Original Mandate CreatedSEPA_ORI_ERDATDATUM
ORI_ERTIMTime when Original Mandate Was CreatedSEPA_ORI_ERTIMUZEIT
.INCLUDESEPA Mandate: Data for Referencing to Other Objects    
.INCLUDESEPA Mandate: ID of Referenced Object    
REF_TYPESEPA Mandate: Reference TypeSEPA_REF_TYPEOJ_NAME
REF_IDSEPA Mandate: Reference IDSEPA_REF_IDSWO_TYPEID
.INCLUDESEPA Mandate: Data of Referenced Object    
REF_DESCText FieldTEXT50TEXT50
.INCLUDESEPA Mandate: Sender Data (Debited Bank Account)    
.INCLUDESEPA Mandate: ID of Sender    
SND_TYPESEPA Mandate: Sender TypeSEPA_SND_TYPEOJ_NAME
SND_IDSEPA Mandate: Sender IDSEPA_SND_IDSWO_TYPEID
.INCLUDESEPA Mandate: Sender Data    
SND_NAME1Last name of business partner (person)BU_NAMEP_LBU_NAME
SND_NAME2First name of business partner (person)BU_NAMEP_FBU_NAME
SND_STREETStreetAD_STREETTEXT60
SND_HOUSENUMHouse NumberAD_HSNM1TEXT10
SND_POSTALCity postal codeAD_PSTCD1CHAR10
SND_CITYCityAD_CITY1TEXT40
SND_COUNTRYCountry KeyLAND1LAND1
SND_IBANIBAN (International Bank Account Number)IBANIBAN
SND_BICSWIFT/BIC for International PaymentsSWIFTSWIFT
SND_DIR_NAMESEPA: Name of Alternative DebtorSEPA_PAYMENT_FORBU_NAME
SND_LANGUAGELanguage KeyLANGUSPRAS
SND_DIR_IDSEPA: ID of Alternative DebtorSEPA_SND_DIR_IDSWO_TYPEID
SND_DEBTOR_IDSEPA: ID Number of Sender (External Reference)SEPA_SND_DEBTOR_IDID035
.INCLUDESEPA Mandate: Recipient Data (Beneficiary Bank Account)    
.INCLUDESEPA Mandate: ID of Recipient    
REC_TYPESEPA Mandate: Recipient TypeSEPA_REC_TYPEOJ_NAME
REC_IDSEPA Mandate: Recipient IDSEPA_REC_IDSWO_TYPEID
.INCLUDESEPA Mandate: Recipient Data    
REC_NAME1Name 1 of organizationBU_NAMEOR1BU_NAME
REC_NAME2Name 2 of organizationBU_NAMEOR2BU_NAME
REC_CRDIDCreditor Identification NumberSEPA_CRDIDID035
REC_STREETStreetAD_STREETTEXT60
REC_HOUSENUMHouse NumberAD_HSNM1TEXT10
REC_POSTALCity postal codeAD_PSTCD1CHAR10
REC_CITYCityAD_CITY1TEXT40
REC_COUNTRYCountry KeyLAND1LAND1
REC_DIR_NAMESEPA: Name of Alternative PayeeSEPA_REC_DIR_NAMEBU_NAME
REC_DIR_IDSEPA: ID of Alternative PayeeSEPA_REC_DIR_IDSWO_TYPEID
.INCLUDESEPA Mandate: Usage Data    
FIRSTUSE_DATESEPA Mandate: Date of First UseSEPA_FIRSTUSE_DATEDATUM
FIRSTUSE_DOCTYPESEPA Mandate: Type of First UsageSEPA_FIRSTUSE_DOCTYPEOJ_NAME
FIRSTUSE_DOCIDSEPA Mandate: ID of First UsageSEPA_FIRSTUSE_DOCIDSWO_TYPEID
LASTUSE_DATESEPA Mandate: Date of Last UseSEPA_LASTUSE_DATEDATUM
LASTUSE_DOCTYPESEPA Mandate: Type of Last UsageSEPA_LASTUSE_DOCTYPEOJ_NAME
LASTUSE_DOCIDSEPA Mandate: ID of Last UsageSEPA_LASTUSE_DOCIDSWO_TYPEID
FIRSTUSE_PAYRUNSEPA Mandate: ID of Payment Run of First UseSEPA_FIRSTUSE_PAYRUNIDCHAR16
.INCLUDESEPA Mandate: Internal Organizational Data    
ORGF1SEPA Mandate: Internal Organizational DataSEPA_ORG_IDCHAR20
ORGF2SEPA Mandate: Internal Organizational DataSEPA_ORG_IDCHAR20
ORGF3SEPA Mandate: Internal Organizational DataSEPA_ORG_ID_LONGCHAR35
ORGF4SEPA Mandate: Internal Organizational DataSEPA_ORG_ID_LONGCHAR35

SEPA_MANDATE related tables

TableNote
SEPA_MNDID_FM_TSEPA Mandate ID: Function Module for Generating Mandate IDs
B090SEPA Mandate - Payment Method
DFKK_SEPA_IDSSEPA: Short Key for Mandate Reference
FSEPA_REFTYPESEPA Mandate: Permitted Contract Types
FSEPA_REFTYPETSEPA Mandate: Text Table for Permitted Contract Types
REGUS_SEPASEPA Mandate Lock: Applications To Be Retrieved
SEPA_CTRLSEPA Mandate Management: System Control
SEPA_CTRLTSEPA Mandate Management: System Control
SEPA_CUSTSEPA Mandate Management: Customizing
SEPA_CUST_SDSEPA Mandate Management: Customizing SD
SEPA_FIELDSSEPA Mandate Management: Modifiable Fields
SEPA_MANDATESEPA Mandate
SEPA_MANDATE_ENQSEPA Mandate: Internal Table for ENQUEUE
SEPA_MANDATE_LCKSEPA Mandate Management: Global Locks
SEPA_MANDATE_USESEPA Mandate Management: Usages
Sepa mandate: guid of mandate TablesSepa mandate TablesFi - sepa mandate TablesSepa mandate in customer master TablesSepa mandate field in customer master TablesSepa TablesSepa: sequence type TablesSepa purpose code: classification of a payment/debit memo Tables

Latest Table Searches

Sap handling unit packaging material table in SAP
How to open handling unit table in SAP
What is the use of handling unit table in SAP
Configuration of handling unit table in SAP
How to print preview handling unit output table in SAP
Handling unit in outbound delivery sap table in SAP
Sap display handling unit output table in SAP

Popular Table Searches

Hdfc bank ltd company code for zinghr table in SAP
Link between sales order and production order f table in SAP
Teleperformance company code for zinghr table in SAP
Users list snc table in SAP
Business partner table in SAP
Country codes table in SAP
Shipping point table in SAP
SAP ALECRMSCMSRMSAP SolutionsSAP ReferencesSAP BasicsPP ModuleWMSAP Partners
HomeContact & Privacy PolicyTwitter
All of the product names here are trademarks of their respective companies. The site sapstack.com is not affiliated with SAP AG.
©2024 sapstack.com