FIN_DD_MANDATE_D
Draft table for entity C_DirectDebitMandateTP
FIN_DD_MANDATE_D is an SAP database table in S/4HANA. Draft table for entity C_DirectDebitMandateTP. It contains 97 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| R_DirectDebitMandateDraft | view_entity | from | BASIC | Data for Manage DDM |
Fields (97)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | MANDT | Client | |||
| KEY | mandateapplication | SEPA_ANWND | Application | |||
| KEY | originalmandate | SEPA_MNDID_ORIGIN | Orig. Mandate | |||
| KEY | originalmandatecreditor | SEPA_CRDID_ORIGIN | Origin. Cred. | |||
| KEY | draftuuid | SDRAFT_UUID | Draft Document ID | |||
| temporarymandateapplication | SEPA_ANWND | Application | ||||
| directdebitmandateuuid | SEPA_MGUID | Mandate GUID | ||||
| directdebitmandate | SEPA_MNDID | Mandate Ref. | ||||
| mandateversion | SEPA_MVERS | Mandate Version | ||||
| mandatesignaturelocation | SEPA_SIGN_CITY | Location | ||||
| mandatesignaturedate | SEPA_SIGN_DATE | Signature | ||||
| mandatepaymenttype | SEPA_PAY_TYPE | Payment Type | ||||
| mandatevaliditydatestartdate | SEPA_VAL_FROM_DATE | Valid From | ||||
| mandatevalidityenddate | SEPA_VAL_TO_DATE | Valid To | ||||
| mandatestatus | SEPA_STATUS | Status | ||||
| mandatestatuscriticality | abap.int1 | |||||
| mandatestatusname | VAL_TEXT | Short Description | ||||
| mandateisb2bmandate | SEPA_B2B | B2B Mandate | ||||
| mandatestatuschangereasonname | SEPA_REASON_CODE_DESC | Description | ||||
| mandatestatuschangereason | SEPA_REASON_CODE | ReasonForChange | ||||
| mandatecreatedbyuser | SEPA_CDS_ERNAM | Created By | ||||
| mandatecreationdate | SEPA_ERDAT | Created On | ||||
| mandatecreationtime | SEPA_ERTIM | Created At | ||||
| lastchangedatetime | TIMESTAMPL | Time Stamp | ||||
| locallastchangedatetime | TIMESTAMPL | Time Stamp | ||||
| directdebitmandatechangereason | SEPA_CHG_REASON | ReasonForChange | ||||
| mandateislocked | SEPA_GLOCK | Global Lock | ||||
| mandateapplicationtext | SEPA_ANWND_LTEXT | Name | ||||
| mandatepaymenttypename | FSEPA_PAYMENT_TYPE_NAME | Description | ||||
| idoriginalmandatecreatedbyuser | SEPA_ORI_ERNAM | Created (Orig) | ||||
| origlmandatecreationdate | SEPA_ORI_ERDAT | Created On | ||||
| origlmandatecreationtime | SEPA_ORI_ERTIM | Created At | ||||
| mandatereferencetype | SEPA_REF_TYPE | Reference Type | ||||
| mandatereference | SEPA_REF_ID | Reference ID | ||||
| mandatereferencedesc | TEXT50 | Explanation | ||||
| mandatesendertype | SEPA_CDS_SND_TYPE | Sender Type | ||||
| mandatesender | SEPA_SND_ID | ID of Sender | ||||
| senderlastname | BU_NAMEP_L | Last Name | ||||
| senderfirstname | BU_NAMEP_F | First Name | ||||
| senderstreetname | AD_STREET | Street | ||||
| senderhousenumber | AD_HSNM1 | House Number | ||||
| senderpostalcode | AD_PSTCD1 | Postal Code | ||||
| sendercityname | AD_CITY1 | City | ||||
| sendercountry | LAND1 | Country/Reg. | ||||
| mandatesenderiban | IBAN | IBAN | ||||
| mandatesenderbankswiftcode | SWIFT | SWIFT/BIC | ||||
| senderlanguage | LANGU | Language | ||||
| mandatealternativedebtor | SEPA_SND_DIR_ID | ID Alt. Debtor | ||||
| mandaterecipienttype | SEPA_REC_TYPE | Recipient Type | ||||
| mandaterecipient | SEPA_REC_ID | Recipient ID | ||||
| recipientname1 | BU_NAMEOR1 | Name 1 | ||||
| recipientname2 | BU_NAMEOR2 | Name 2 | ||||
| mandatecreditor | SEPA_CRDID | Creditor ID | ||||
| recipientstreetname | AD_STREET | Street | ||||
| recipienthousenumber | AD_HSNM1 | House Number | ||||
| recipientpostalcode | AD_PSTCD1 | Postal Code | ||||
| recipientcityname | AD_CITY1 | City | ||||
| recipientcountry | LAND1 | Country/Reg. | ||||
| mandatealternativepayeename | SEPA_REC_DIR_NAME | Name Alt. Payee | ||||
| mandatealternativepayee | SEPA_REC_DIR_ID | ID Alt. Payee | ||||
| mandatefirstusedate | SEPA_FIRSTUSE_DATE | Date | ||||
| mandatefirstuseobjtypecode | SEPA_FIRSTUSE_DOCTYPE | Type of First Usage | ||||
| mandatefirstuseinpaymentdoc | SEPA_FIRSTUSE_DOCID | Key | ||||
| mandatelastusedate | SEPA_LASTUSE_DATE | Date | ||||
| mandatelastuseobjtypecode | SEPA_LASTUSE_DOCTYPE | Type of Last Usage | ||||
| mandatelastuseinpaymentdoc | SEPA_LASTUSE_DOCID | ID of Last Usage | ||||
| mandatefirstusepaymentrun | SEPA_FIRSTUSE_PAYRUNID | First Payment Run | ||||
| mandateorganizationalunit1 | SEPA_ORG_ID | Organization ID | ||||
| mandateorganizationalunit2 | SEPA_ORG_ID | Organization ID | ||||
| mandateorganizationalunit3 | SEPA_ORG_ID_LONG | Organization | ||||
| mandateorganizationalunit4 | SEPA_ORG_ID_LONG | Organization | ||||
| sendercountryorregion | LAND1 | Country/Reg. | ||||
| mandatedirectdebitprocedure | DDMA_PROC | DD Procedure | ||||
| bankcountry | BANKS | Bank Ctry/Reg. | ||||
| payingbankkey | BANKK | Bank Key | ||||
| bankaccount | BANKN | Bank Account | ||||
| bankcontrolkey | BKONT | Control Key | ||||
| referencebankdetails | BKREF | Reference | ||||
| shortkeyhousebank | HBKID | House Bank | ||||
| accountdetails | HKTID | Account ID | ||||
| payingcompanycode | SEPA_CDS_DZBUKR | Paying Company Code | ||||
| customer | KUNNR | Customer | ||||
| mandatecontracttype | FSEPA_REF_TYPE | Contr. Type | ||||
| companycode | BUKRS | Company Code | ||||
| accountingdocument | BELNR_D | Document Number | ||||
| inputfiscalyear | GJAHR | Fiscal Year | ||||
| businesspartner | BU_PARTNER | Bus. Partner | ||||
| castandardcompanycode | SEPA_CDS_STDBK_KK | Standard Company Code | ||||
| cacontract | VTREF_SEPA_KK | Contract | ||||
| contractaccount | VKONT_SEPA_KK | Contract Acct | ||||
| casubapplication | SUBAP_KK | Subapplication | ||||
| draftentitycreationdatetime | SYCH_BDL_DRAFT_CREATED_AT | Draft Created | ||||
| draftentitylastchangedatetime | SYCH_BDL_DRAFT_LAST_CHANGED_AT | Draft Changed | ||||
| draftadministrativedatauuid | SYCH_BDL_DRAFT_ADMIN_UUID | Admin. UUID | ||||
| draftentityoperationcode | SYCH_BDL_DRAFT_OPERATION_CODE | Operation Code | ||||
| hasactiveentity | SYCH_BDL_DRAFT_HASACTIVE | Has active | ||||
| draftfieldchanges | SYCH_BDL_DRAFT_FIELD_CHANGES | Draft Changes |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- Draft table for entity C_DirectDebitMandateTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FIN_DD_MANDATE_D (
MANDT, -- Client [MANDT]
MANDATEAPPLICATION, -- Application [SEPA_ANWND]
ORIGINALMANDATE, -- Orig. Mandate [SEPA_MNDID_ORIGIN]
ORIGINALMANDATECREDITOR, -- Origin. Cred. [SEPA_CRDID_ORIGIN]
DRAFTUUID, -- Draft Document ID [SDRAFT_UUID]
TEMPORARYMANDATEAPPLICATION, -- Application [SEPA_ANWND]
DIRECTDEBITMANDATEUUID, -- Mandate GUID [SEPA_MGUID]
DIRECTDEBITMANDATE, -- Mandate Ref. [SEPA_MNDID]
MANDATEVERSION, -- Mandate Version [SEPA_MVERS]
MANDATESIGNATURELOCATION, -- Location [SEPA_SIGN_CITY]
MANDATESIGNATUREDATE, -- Signature [SEPA_SIGN_DATE]
MANDATEPAYMENTTYPE, -- Payment Type [SEPA_PAY_TYPE]
MANDATEVALIDITYDATESTARTDATE, -- Valid From [SEPA_VAL_FROM_DATE]
MANDATEVALIDITYENDDATE, -- Valid To [SEPA_VAL_TO_DATE]
MANDATESTATUS, -- Status [SEPA_STATUS]
MANDATESTATUSCRITICALITY, -- abap.int1
MANDATESTATUSNAME, -- Short Description [VAL_TEXT]
MANDATEISB2BMANDATE, -- B2B Mandate [SEPA_B2B]
MANDATESTATUSCHANGEREASONNAME, -- Description [SEPA_REASON_CODE_DESC]
MANDATESTATUSCHANGEREASON, -- ReasonForChange [SEPA_REASON_CODE]
MANDATECREATEDBYUSER, -- Created By [SEPA_CDS_ERNAM]
MANDATECREATIONDATE, -- Created On [SEPA_ERDAT]
MANDATECREATIONTIME, -- Created At [SEPA_ERTIM]
LASTCHANGEDATETIME, -- Time Stamp [TIMESTAMPL]
LOCALLASTCHANGEDATETIME, -- Time Stamp [TIMESTAMPL]
DIRECTDEBITMANDATECHANGEREASON, -- ReasonForChange [SEPA_CHG_REASON]
MANDATEISLOCKED, -- Global Lock [SEPA_GLOCK]
MANDATEAPPLICATIONTEXT, -- Name [SEPA_ANWND_LTEXT]
MANDATEPAYMENTTYPENAME, -- Description [FSEPA_PAYMENT_TYPE_NAME]
IDORIGINALMANDATECREATEDBYUSER, -- Created (Orig) [SEPA_ORI_ERNAM]
ORIGLMANDATECREATIONDATE, -- Created On [SEPA_ORI_ERDAT]
ORIGLMANDATECREATIONTIME, -- Created At [SEPA_ORI_ERTIM]
MANDATEREFERENCETYPE, -- Reference Type [SEPA_REF_TYPE]
MANDATEREFERENCE, -- Reference ID [SEPA_REF_ID]
MANDATEREFERENCEDESC, -- Explanation [TEXT50]
MANDATESENDERTYPE, -- Sender Type [SEPA_CDS_SND_TYPE]
MANDATESENDER, -- ID of Sender [SEPA_SND_ID]
SENDERLASTNAME, -- Last Name [BU_NAMEP_L]
SENDERFIRSTNAME, -- First Name [BU_NAMEP_F]
SENDERSTREETNAME, -- Street [AD_STREET]
SENDERHOUSENUMBER, -- House Number [AD_HSNM1]
SENDERPOSTALCODE, -- Postal Code [AD_PSTCD1]
SENDERCITYNAME, -- City [AD_CITY1]
SENDERCOUNTRY, -- Country/Reg. [LAND1]
MANDATESENDERIBAN, -- IBAN [IBAN]
MANDATESENDERBANKSWIFTCODE, -- SWIFT/BIC [SWIFT]
SENDERLANGUAGE, -- Language [LANGU]
MANDATEALTERNATIVEDEBTOR, -- ID Alt. Debtor [SEPA_SND_DIR_ID]
MANDATERECIPIENTTYPE, -- Recipient Type [SEPA_REC_TYPE]
MANDATERECIPIENT, -- Recipient ID [SEPA_REC_ID]
RECIPIENTNAME1, -- Name 1 [BU_NAMEOR1]
RECIPIENTNAME2, -- Name 2 [BU_NAMEOR2]
MANDATECREDITOR, -- Creditor ID [SEPA_CRDID]
RECIPIENTSTREETNAME, -- Street [AD_STREET]
RECIPIENTHOUSENUMBER, -- House Number [AD_HSNM1]
RECIPIENTPOSTALCODE, -- Postal Code [AD_PSTCD1]
RECIPIENTCITYNAME, -- City [AD_CITY1]
RECIPIENTCOUNTRY, -- Country/Reg. [LAND1]
MANDATEALTERNATIVEPAYEENAME, -- Name Alt. Payee [SEPA_REC_DIR_NAME]
MANDATEALTERNATIVEPAYEE, -- ID Alt. Payee [SEPA_REC_DIR_ID]
MANDATEFIRSTUSEDATE, -- Date [SEPA_FIRSTUSE_DATE]
MANDATEFIRSTUSEOBJTYPECODE, -- Type of First Usage [SEPA_FIRSTUSE_DOCTYPE]
MANDATEFIRSTUSEINPAYMENTDOC, -- Key [SEPA_FIRSTUSE_DOCID]
MANDATELASTUSEDATE, -- Date [SEPA_LASTUSE_DATE]
MANDATELASTUSEOBJTYPECODE, -- Type of Last Usage [SEPA_LASTUSE_DOCTYPE]
MANDATELASTUSEINPAYMENTDOC, -- ID of Last Usage [SEPA_LASTUSE_DOCID]
MANDATEFIRSTUSEPAYMENTRUN, -- First Payment Run [SEPA_FIRSTUSE_PAYRUNID]
MANDATEORGANIZATIONALUNIT1, -- Organization ID [SEPA_ORG_ID]
MANDATEORGANIZATIONALUNIT2, -- Organization ID [SEPA_ORG_ID]
MANDATEORGANIZATIONALUNIT3, -- Organization [SEPA_ORG_ID_LONG]
MANDATEORGANIZATIONALUNIT4, -- Organization [SEPA_ORG_ID_LONG]
SENDERCOUNTRYORREGION, -- Country/Reg. [LAND1]
MANDATEDIRECTDEBITPROCEDURE, -- DD Procedure [DDMA_PROC]
BANKCOUNTRY, -- Bank Ctry/Reg. [BANKS]
PAYINGBANKKEY, -- Bank Key [BANKK]
BANKACCOUNT, -- Bank Account [BANKN]
BANKCONTROLKEY, -- Control Key [BKONT]
REFERENCEBANKDETAILS, -- Reference [BKREF]
SHORTKEYHOUSEBANK, -- House Bank [HBKID]
ACCOUNTDETAILS, -- Account ID [HKTID]
PAYINGCOMPANYCODE, -- Paying Company Code [SEPA_CDS_DZBUKR]
CUSTOMER, -- Customer [KUNNR]
MANDATECONTRACTTYPE, -- Contr. Type [FSEPA_REF_TYPE]
COMPANYCODE, -- Company Code [BUKRS]
ACCOUNTINGDOCUMENT, -- Document Number [BELNR_D]
INPUTFISCALYEAR, -- Fiscal Year [GJAHR]
BUSINESSPARTNER, -- Bus. Partner [BU_PARTNER]
CASTANDARDCOMPANYCODE, -- Standard Company Code [SEPA_CDS_STDBK_KK]
CACONTRACT, -- Contract [VTREF_SEPA_KK]
CONTRACTACCOUNT, -- Contract Acct [VKONT_SEPA_KK]
CASUBAPPLICATION, -- Subapplication [SUBAP_KK]
DRAFTENTITYCREATIONDATETIME, -- Draft Created [SYCH_BDL_DRAFT_CREATED_AT]
DRAFTENTITYLASTCHANGEDATETIME, -- Draft Changed [SYCH_BDL_DRAFT_LAST_CHANGED_AT]
DRAFTADMINISTRATIVEDATAUUID, -- Admin. UUID [SYCH_BDL_DRAFT_ADMIN_UUID]
DRAFTENTITYOPERATIONCODE, -- Operation Code [SYCH_BDL_DRAFT_OPERATION_CODE]
HASACTIVEENTITY, -- Has active [SYCH_BDL_DRAFT_HASACTIVE]
DRAFTFIELDCHANGES, -- Draft Changes [SYCH_BDL_DRAFT_FIELD_CHANGES]
PRIMARY KEY (MANDT, MANDATEAPPLICATION, ORIGINALMANDATE, ORIGINALMANDATECREDITOR, DRAFTUUID)
);Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA