SSACVD_F4_REF_SUBKEY

DDL: SSACVD_F4_REF_SUBKEY SQL: V_SSAC_RFSKEY_F4 Type: view Package: FI_GL_SSAC
9 Fields 3 Data Sources

Value help view: REF_SUBKEY for EBELN, EBELP and ZEKKN

SSACVD_F4_REF_SUBKEY is a CDS View that provides data about "Value help view: REF_SUBKEY for EBELN, EBELP and ZEKKN" in SAP S/4HANA. It reads from 3 data sources (acesobj, I_CFinPurchasingDocument, I_CFinPurgDocAccountAssignment) and exposes 9 fields with key fields comp, logsys, bukrs, ebeln, ebelp. Part of development package FI_GL_SSAC.

Data Sources (3)

SourceAliasJoin Type
acesobj acesobj from
I_CFinPurchasingDocument I_CFinPurchasingDocument inner
I_CFinPurgDocAccountAssignment I_CFinPurgDocAccountAssignment inner

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName V_SSAC_RFSKEY_F4 view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Value help view: REF_SUBKEY for EBELN, EBELP and ZEKKN view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
AbapCatalog.preserveKey true view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY comp acesobj comp Legal competence
KEY logsys acesobj logsys Source system
KEY bukrs acesobj bukrs Value
KEY ebeln
KEY ebelp
KEY zekkn I_CFinPurgDocAccountAssignment CFinPurgDocAccountAssignment
ref_key acesobj ref_key Source Reference Key
ref_subkey acesobj ref_subkey Ext Ref of Subobject
bstyp

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 SSACVD_F4_REF_SUBKEY.
-- 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_SSAC_RFSKEY_F4

CREATE VIEW SSACVD_F4_REF_SUBKEY AS
SELECT
  acesobj.comp AS comp,
  acesobj.logsys AS logsys,
  acesobj.bukrs AS bukrs,
  cast( I_CFinPurgDocAccountAssignment.CFinPurchasingDocument as ebeln preserving type ) AS ebeln,
  cast( I_CFinPurgDocAccountAssignment.CFinPurchasingDocumentItem as ebelp preserving type ) AS ebelp,
  I_CFinPurgDocAccountAssignment.CFinPurgDocAccountAssignment AS zekkn,
  acesobj.ref_key AS ref_key,
  acesobj.ref_subkey AS ref_subkey,
  cast( I_CFinPurchasingDocument.PurchasingDocumentCategory as ebstyp preserving type ) AS bstyp
FROM acesobj
INNER JOIN I_CFinPurgDocAccountAssignment ON /* join condition not captured in parsed metadata */
INNER JOIN I_CFinPurchasingDocument ON /* join condition not captured in parsed metadata */
;

Learn More