FAA_UPA_MIG_DI_DOCIT_SPLT
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)
| Source | Alias | Join Type |
|---|---|---|
| FAA_CFG_DEPR_AREA | cfg_depr_area | inner |
| faat_doc_it | doc_it | from |
Annotations (6)
| Name | Value | Level | Field |
|---|---|---|---|
| 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)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| 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 */
;
Learn More
- CDS View Annotations — A Complete Guide
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA
- 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
- BW Extractor to CDS View Migration Guide
- S/4HANA CDS View Deprecation: What You Need to Know
- ABAP CDS View Tutorial — From Basics to Real-World Examples
- RAP and CDS Views — Building Transactional Apps in SAP S/4HANA
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA