FAA_UPA_MIG_DI_DOCIT_SPLT

DDL: FAA_UPA_MIG_DI_DOCIT_SPLT Type: view_entity

Split DOC_IT-DRCRK

FAA_UPA_MIG_DI_DOCIT_SPLT is a CDS View that provides data about "Split DOC_IT-DRCRK" in SAP S/4HANA. It reads from 2 data sources (FAA_CFG_DEPR_AREA, faat_doc_it) and exposes 70 fields with key fields bukrs, anln1, anln2, gjahr, awtyp.

Data Sources (2)

SourceAliasJoin Type
FAA_CFG_DEPR_AREA cfg_depr_area inner
faat_doc_it doc_it from

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Split DOC_IT-DRCRK view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (70)

KeyFieldSource TableSource FieldDescription
KEY bukrs faat_doc_it bukrs Value
KEY anln1 faat_doc_it anln1 Asset
KEY anln2 faat_doc_it anln2 Sub-number
KEY gjahr faat_doc_it gjahr Settlement Year
KEY awtyp faat_doc_it awtyp Reference Document Type
KEY awref faat_doc_it awref Reference Doc.
KEY aworg faat_doc_it aworg Refer. Org.Unit
KEY awsys faat_doc_it awsys Logical System
KEY subta faat_doc_it subta Sub Transaction
KEY afabe faat_doc_it afabe Deprec. Area
KEY slalittype faat_doc_it slalittype SLALineItemType
KEY drcrk faat_doc_it drcrk Debit/Credit
ledger FAA_CFG_DEPR_AREA ledger Ledger
tech_ledger FAA_CFG_DEPR_AREA tech_ledger Technical Ledger
awitem faat_doc_it awitem Ref. Doc. Line Item
vorgn faat_doc_it vorgn Transaction
budat faat_doc_it budat Posting Date
bzdat faat_doc_it bzdat Reference date
poper faat_doc_it poper Posting periods
bwasl faat_doc_it bwasl Trans. Type
movcat faat_doc_it movcat Trans.Type Cat.
hsl faat_doc_it hsl Local Crcy Amt
ksl faat_doc_it ksl GrpCurr
osl faat_doc_it osl Other Crcy Amnt
vsl faat_doc_it vsl Amount in Currency 2
bsl faat_doc_it bsl Exchange Key
csl faat_doc_it csl Amount in Currency 4
dsl faat_doc_it dsl Amount in Currency 5
esl faat_doc_it esl Amount in Currency 6
fsl faat_doc_it fsl Amount in Currency 7
gsl faat_doc_it gsl Amount in Currency 8
rhcur faat_doc_it rhcur Local Currency
rkcur faat_doc_it rkcur Ledger curr.
rocur faat_doc_it rocur Free Defined Crcy 1
rvcur faat_doc_it rvcur Free Defined Crcy 4
rbcur faat_doc_it rbcur Free Defined Crcy 3
rccur faat_doc_it rccur Third Currency
rdcur faat_doc_it rdcur Free Defined Crcy 5
recur faat_doc_it recur Free Defined Crcy 6
rfcur faat_doc_it rfcur Free Defined Crcy 7
rgcur faat_doc_it rgcur Free Defined Crcy 8
xreversing faat_doc_it xreversing Reversal doc.
xreversed faat_doc_it xreversed Reversed
xsettling faat_doc_it xsettling Is Settling
xsettled faat_doc_it xsettled Is Settled
prec_awtyp faat_doc_it prec_awtyp PrecRefTransact
prec_aworg faat_doc_it prec_aworg PrecRefOrgUnit
prec_awref faat_doc_it prec_awref PrecRefDocument
prec_subta faat_doc_it prec_subta Sub Transaction
awtyp_rev faat_doc_it awtyp_rev ReversalRefTran
awref_rev faat_doc_it awref_rev Reversal Ref.
aworg_rev faat_doc_it aworg_rev Reversal Org.
subta_rev faat_doc_it subta_rev Reversal Sub Trans
anlkl faat_doc_it anlkl Asset Class
ktogr faat_doc_it ktogr Account Determ.
panl1 faat_doc_it panl1 Partner Asset
panl2 faat_doc_it panl2 Partner Sub-No.
mig_source faat_doc_it mig_source Migr. Source
recid faat_doc_it recid Statistical Key Figure Item
bldat faat_doc_it bldat Journal Entry Date
sgtxt faat_doc_it sgtxt Text
zuonr faat_doc_it zuonr Finance Project
obart faat_doc_it obart Object type
objid faat_doc_it objid Work Center
ubzdt_pn faat_doc_it ubzdt_pn Orig. Val. Dat
xvabg_pn faat_doc_it xvabg_pn Compl.Retiremnt
prozs_pn faat_doc_it prozs_pn Percentage Rate
sdm_status faat_doc_it sdm_status status value done
afabe_fi_doc faat_doc_it afabe_fi_doc FI Depreciation Area
has_fi_doc faat_doc_it has_fi_doc FI Doc. Exists

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 FAA_UPA_MIG_DI_DOCIT_SPLT.
-- 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 FAA_UPA_MIG_DI_DOCIT_SPLT AS
SELECT
  doc_it.bukrs AS bukrs,
  doc_it.anln1 AS anln1,
  doc_it.anln2 AS anln2,
  doc_it.gjahr AS gjahr,
  doc_it.awtyp AS awtyp,
  doc_it.awref AS awref,
  doc_it.aworg AS aworg,
  doc_it.awsys AS awsys,
  doc_it.subta AS subta,
  doc_it.afabe AS afabe,
  doc_it.slalittype AS slalittype,
  doc_it.drcrk AS drcrk,
  cfg_depr_area.ledger AS ledger,
  cfg_depr_area.tech_ledger AS tech_ledger,
  doc_it.awitem AS awitem,
  doc_it.vorgn AS vorgn,
  doc_it.budat AS budat,
  doc_it.bzdat AS bzdat,
  doc_it.poper AS poper,
  doc_it.bwasl AS bwasl,
  doc_it.movcat AS movcat,
  doc_it.hsl AS hsl,
  doc_it.ksl AS ksl,
  doc_it.osl AS osl,
  doc_it.vsl AS vsl,
  doc_it.bsl AS bsl,
  doc_it.csl AS csl,
  doc_it.dsl AS dsl,
  doc_it.esl AS esl,
  doc_it.fsl AS fsl,
  doc_it.gsl AS gsl,
  doc_it.rhcur AS rhcur,
  doc_it.rkcur AS rkcur,
  doc_it.rocur AS rocur,
  doc_it.rvcur AS rvcur,
  doc_it.rbcur AS rbcur,
  doc_it.rccur AS rccur,
  doc_it.rdcur AS rdcur,
  doc_it.recur AS recur,
  doc_it.rfcur AS rfcur,
  doc_it.rgcur AS rgcur,
  doc_it.xreversing AS xreversing,
  doc_it.xreversed AS xreversed,
  doc_it.xsettling AS xsettling,
  doc_it.xsettled AS xsettled,
  doc_it.prec_awtyp AS prec_awtyp,
  doc_it.prec_aworg AS prec_aworg,
  doc_it.prec_awref AS prec_awref,
  doc_it.prec_subta AS prec_subta,
  doc_it.awtyp_rev AS awtyp_rev,
  doc_it.awref_rev AS awref_rev,
  doc_it.aworg_rev AS aworg_rev,
  doc_it.subta_rev AS subta_rev,
  doc_it.anlkl AS anlkl,
  doc_it.ktogr AS ktogr,
  doc_it.panl1 AS panl1,
  doc_it.panl2 AS panl2,
  doc_it.mig_source AS mig_source,
  doc_it.recid AS recid,
  doc_it.bldat AS bldat,
  doc_it.sgtxt AS sgtxt,
  doc_it.zuonr AS zuonr,
  doc_it.obart AS obart,
  doc_it.objid AS objid,
  doc_it.ubzdt_pn AS ubzdt_pn,
  doc_it.xvabg_pn AS xvabg_pn,
  doc_it.prozs_pn AS prozs_pn,
  doc_it.sdm_status AS sdm_status,
  doc_it.afabe_fi_doc AS afabe_fi_doc,
  doc_it.has_fi_doc AS has_fi_doc
FROM faat_doc_it AS doc_it
INNER JOIN FAA_CFG_DEPR_AREA AS cfg_depr_area ON /* join condition not captured in parsed metadata */
;