V_FDES_MIG

DDL: V_FDES_MIG SQL: VFDESMIG Type: view
48 Fields 1 Data Sources

Migration CDS view for FDES

V_FDES_MIG is a CDS View that provides data about "Migration CDS view for FDES" in SAP S/4HANA. It reads from 1 data source (V_FDES_DDL) and exposes 48 fields.

Data Sources (1)

SourceAliasJoin Type
V_FDES_DDL V_FDES_DDL from

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName VFDESMIG view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
EndUserText.label Migration CDS view for FDES view

Fields (48)

KeyFieldSource TableSource FieldDescription
mandt mandt Editing Client
ARCHK ARCHK Not Used
BUKRS BUKRS Value
BNKKO BNKKO G/L account
GRUPP GRUPP Planning group
EBENE EBENE Planning Level
DISPW DISPW Planned currency
DATUM DATUM Valid to
IDENR IDENR ID number
GSBER GSBER Business Area
DMSHB DMSHB Local Curr. Amount
WRSHB WRSHB Amount in FC
KURST KURST Fix.rate type (EMU)
XINVR XINVR Invoice
DSART DSART Memo Recd Type
USRID USRID System ID
HZDAT HZDAT Entry Date
AENUS AENUS Changed:
AENDT AENDT Date
AVDAT AVDAT Archiving date
MERKM MERKM Characteristics
ZUONR ZUONR Finance Project
REFER REFER Reference
SGTXT SGTXT Text
GGRUP GGRUP Offsetting acct
GBUKR GBUKR Offsetting CC
GVALT GVALT Offset. val. dt
AUSNR AUSNR Statement No.
AUSTG AUSTG Statement Date
VOART VOART Trans. type
ZINSS ZINSS Interest rate
KLART KLART Class Type
STKNZ STKNZ Statistics Ind.
SDATM SDATM Start date
KLIDR KLIDR ID number (grp)
KLGND KLGND CM pairing
AUTH_REL AUTH_REL Auth. and Release
SEGMENT SEGMENT Segment number
PRCTR PRCTR Profit Centers
GEBER GEBER Fund
GRANT_NBR GRANT_NBR Receiver Grant
HBKID HBKID House Bank
HKTID HKTID House Bank Account
ZLSCH ZLSCH Pymt Meth.
LQPOS LQPOS Liquidity Item
ACC_ID ACC_ID Technical ID
GACCID GACCID Offset.Bank Acc
BS_ESNUM BS_ESNUM Memo Record No.

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_FDES_MIG.
-- 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: VFDESMIG

CREATE VIEW V_FDES_MIG AS
SELECT
  mandt,
  ARCHK,
  BUKRS,
  BNKKO,
  GRUPP,
  EBENE,
  DISPW,
  DATUM,
  IDENR,
  GSBER,
  DMSHB,
  WRSHB,
  KURST,
  XINVR,
  DSART,
  USRID,
  HZDAT,
  AENUS,
  AENDT,
  AVDAT,
  MERKM,
  ZUONR,
  REFER,
  SGTXT,
  GGRUP,
  GBUKR,
  GVALT,
  AUSNR,
  AUSTG,
  VOART,
  ZINSS,
  KLART,
  STKNZ,
  SDATM,
  KLIDR,
  KLGND,
  AUTH_REL,
  SEGMENT,
  PRCTR,
  GEBER,
  GRANT_NBR,
  HBKID,
  HKTID,
  ZLSCH,
  LQPOS,
  ACC_ID,
  GACCID,
  BS_ESNUM
FROM V_FDES_DDL
;

Learn More