V_T012k_Mig_Ddl

DDL: V_T012K_MIG_DDL SQL: V_T012K_MIG Type: view
21 Fields 1 Data Sources

CDS View for the Migration of House Bank Accounts

V_T012k_Mig_Ddl is a CDS View that provides data about "CDS View for the Migration of House Bank Accounts" in SAP S/4HANA. It reads from 1 data source (t012k) and exposes 21 fields.

Data Sources (1)

SourceAliasJoin Type
t012k t012k from

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName V_T012K_MIG view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
EndUserText.label CDS View for the Migration of House Bank Accounts view

Fields (21)

KeyFieldSource TableSource FieldDescription
mandt mandt Editing Client
bukrs bukrs Value
hbkid hbkid House Bank
hktid hktid House Bank Account
bankn bankn Bank acct
bkont bkont To Account
waers waers Transaction Currency
refzl refzl Reference info.
dtaai dtaai DME identifictn
bnkn2 bnkn2 Bank Account
fdgrp fdgrp Planning group
abwae abwae Settlement cur.
hkont hkont Transfer acct
wekon wekon Discount Acct
mindt mindt Minimum Days
hbid1 hbid1 House bank 1
hkid1 hkid1 Account ID 1
hbid2 hbid2 House bank 2
hkid2 hkid2 Account ID 2
wkkon wkkon Returned BoE Py
wikon wikon Collection Acct

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 V_T012k_Mig_Ddl.
-- 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.
-- SQL view name: V_T012K_MIG

CREATE VIEW V_T012k_Mig_Ddl AS
SELECT
  mandt,
  bukrs,
  hbkid,
  hktid,
  bankn,
  bkont,
  waers,
  refzl,
  dtaai,
  bnkn2,
  fdgrp,
  abwae,
  hkont,
  wekon,
  mindt,
  hbid1,
  hkid1,
  hbid2,
  hkid2,
  wkkon,
  wikon
FROM t012k
;

Learn More