FIN_DD_VERS_D
Draft table for entity C_DirectDebitMandateVersionTP
FIN_DD_VERS_D is an SAP database table in S/4HANA. Draft table for entity C_DirectDebitMandateVersionTP. It contains 90 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| R_DirectDebitMandateVersDrft | view_entity | from | BASIC | Data for DDM Versions |
Fields (90)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | mandt | Client | |||
| KEY | directdebitmandateuuid | sepa_mguid | Mandate GUID | |||
| parentdraftuuid | sdraft_uuid | Draft Document ID | ||||
| mandateapplication | sepa_anwnd | Application | ||||
| originalmandate | sepa_mndid_origin | Orig. Mandate | ||||
| originalmandatecreditor | sepa_crdid_origin | Origin. Cred. | ||||
| 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_ernam | Creator | ||||
| 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 | Busn. Partner | ||||
| castandardcompanycode | sepa_cds_stdbk_kk | Standard Company Code | ||||
| cacontract | vtref_sepa_kk | Contract | ||||
| contractaccount | vkont_sepa_kk | Contract Acct | ||||
| casubapplication | subap_kk | Subapplication |
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_DirectDebitMandateVersionTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FIN_DD_VERS_D (
MANDT, -- Client [mandt]
DIRECTDEBITMANDATEUUID, -- Mandate GUID [sepa_mguid]
PARENTDRAFTUUID, -- Draft Document ID [sdraft_uuid]
MANDATEAPPLICATION, -- Application [sepa_anwnd]
ORIGINALMANDATE, -- Orig. Mandate [sepa_mndid_origin]
ORIGINALMANDATECREDITOR, -- Origin. Cred. [sepa_crdid_origin]
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, -- Creator [sepa_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, -- Busn. 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]
PRIMARY KEY (MANDT, DIRECTDEBITMANDATEUUID)
);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