FINSCDS_F4_ACVTP

DDL: FINSVD_F4_ACT_VERSN_TP SQL: FINSV_F4_ACVTP Type: view Package: FINS_ACDOC_CUST

Actual Transfer Price Versions in Contr. Area

FINSCDS_F4_ACVTP is a CDS View that provides data about "Actual Transfer Price Versions in Contr. Area" in SAP S/4HANA. It reads from 2 data sources (tka09, tkt09) and exposes 4 fields with key fields mandt, kokrs, versn. Part of development package FINS_ACDOC_CUST.

Data Sources (2)

SourceAliasJoin Type
tka09 tka09 from
tkt09 tkt09 left_outer

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName FINSV_F4_ACVTP view
ClientDependent true view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Actual Transfer Price Versions in Contr. Area view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY mandt tka09 mandt Editing Client
KEY kokrs tka09 kokrs Org. Value
KEY versn tka09 versn Version
txt tkt09 txt Version Dscrptn

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 FINSCDS_F4_ACVTP.
-- 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: FINSV_F4_ACVTP

CREATE VIEW FINSCDS_F4_ACVTP AS
SELECT
  tka09.mandt AS mandt,
  tka09.kokrs AS kokrs,
  tka09.versn AS versn,
  tkt09.txt AS txt
FROM tka09
LEFT OUTER JOIN tkt09 ON /* join condition not captured in parsed metadata */
;