I_DirectDebitMandtInstructions

DDL: I_DIRECTDEBITMANDTINSTRUCTIONS Type: view_entity BASIC
23 Fields 1 Data Sources

Direct Debit Mandate Instructions

I_DirectDebitMandtInstructions is a Basic CDS View that provides data about "Direct Debit Mandate Instructions" in SAP S/4HANA. It reads from 1 data source (ddma_bkinst) and exposes 23 fields with key fields DirectDebitMandateUUID, MandateInstructionSqncNumber.

Data Sources (1)

SourceAliasJoin Type
ddma_bkinst ddma_bkinst from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Direct Debit Mandate Instructions view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #BASIC view

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY DirectDebitMandateUUID mguid Mandate GUID
KEY MandateInstructionSqncNumber seqnr Tank ID
SortingField srt1 Sorting
MandateInstructionType bkinsty Instruction Type
DirectDebitMandate mndid Mandate Ref.
MandateApplication anwnd Application
MandateCreditor rec_crdid Creditor ID
MandateVersion mvers_prev Mandate Version
MandateInstructionStatus bkinstat Mandate Instr.Status
CompanyCodeAutomPaymentTrans pybuk Paying Co. Code
ShortKeyHouseBank hbkid House Bank
AccountDetails hktid House Bank Account
MandateInstructionCrtedByUser created_by Version Created By
MandtInstructionCrtedOnDteTime created_on Variant created on
MandateInstructionChgdByUser changed_by User Name
MandtInstructionChgdOnDateTime changed_on Variant Changed on
MandateInstructionRunDate laufd Run On
MandateRunIdentification laufi Settlement ID
SequentialNumberRun laufn Sequential Number
MandateInstructionExtSqncNmbr out_seqn External seq. number
MandateInstructionOutDate out_date Output Date
MandateInstructionOutTime out_time Output Time
MandateInstructionOutByUser out_uname Output generated by

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_DirectDebitMandtInstructions.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW I_DirectDebitMandtInstructions AS
SELECT
  mguid AS DirectDebitMandateUUID,
  seqnr AS MandateInstructionSqncNumber,
  srt1 AS SortingField,
  bkinsty AS MandateInstructionType,
  mndid AS DirectDebitMandate,
  anwnd AS MandateApplication,
  rec_crdid AS MandateCreditor,
  mvers_prev AS MandateVersion,
  bkinstat AS MandateInstructionStatus,
  pybuk AS CompanyCodeAutomPaymentTrans,
  hbkid AS ShortKeyHouseBank,
  hktid AS AccountDetails,
  created_by AS MandateInstructionCrtedByUser,
  created_on AS MandtInstructionCrtedOnDteTime,
  changed_by AS MandateInstructionChgdByUser,
  changed_on AS MandtInstructionChgdOnDateTime,
  laufd AS MandateInstructionRunDate,
  laufi AS MandateRunIdentification,
  laufn AS SequentialNumberRun,
  out_seqn AS MandateInstructionExtSqncNmbr,
  out_date AS MandateInstructionOutDate,
  out_time AS MandateInstructionOutTime,
  out_uname AS MandateInstructionOutByUser
FROM ddma_bkinst
;

Learn More