UPOV_DEFERMENTEVENT_BA

DDL: UPO_INT_V_DEFERMENTEVENT_BA SQL: UPOS_PR_DEFEVTBA Type: view
6 Fields 7 Data Sources

Deferment Event Before After image

UPOV_DEFERMENTEVENT_BA is a CDS View that provides data about "Deferment Event Before After image" in SAP S/4HANA. It reads from 7 data sources and exposes 6 fields with key fields EVENT_UUID, seq_no.

Data Sources (7)

SourceAliasJoin Type
pcdpos changeitems left_outer
gho_dm_code_t defercode_desc_new left_outer
gho_dm_code_t defercode_desc_old left_outer
UPOV_NETOBJS netobjid_data left_outer
gho_ppa_request ppa_request from
upot_int_ppnuuid ppn_ids left_outer
upov_pr_processtype_fieldlist ppnlabels left_outer

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName UPOS_PR_DEFEVTBA view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
EndUserText.label Deferment Event Before After image view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY EVENT_UUID upot_int_ppnuuid event_uuid Event UUID
KEY seq_no upov_pr_processtype_fieldlist Seqnr Tank ID
GRP
DTL_LAB_NM
value_oldelseendasDTL_OLD_CD
value_newelseendasDTL_NEW_CD

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 UPOV_DEFERMENTEVENT_BA.
-- 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: UPOS_PR_DEFEVTBA

CREATE VIEW UPOV_DEFERMENTEVENT_BA AS
SELECT
  ppn_ids.event_uuid AS EVENT_UUID,
  ppnlabels.Seqnr AS seq_no,
  cast('0000' as abap.numc(4)) AS GRP,
  cast(ppnlabels.FieldText as abap.char( 25 )) AS DTL_LAB_NM,
  case when ppnlabels.fieldname = 'TPLNR' then netobjid_data.strno when ppnlabels.fieldname = 'DEF_CODE' or ppnlabels.fieldname = 'DUR_VAL_PERC' or ppnlabels.fieldname = 'EFFECT_UNIT' or ppnlabels.fieldname = 'EFFECT_VAL' or ppnlabels.fieldname = 'EVENT_TYPE' or ppnlabels.fieldname = 'STRT_PERIOD' or ppnlabels.fieldname = 'END_PERIOD' then changeitems.value_old else '' end as DTL_OLD_CD AS value_oldelseendasDTL_OLD_CD,
  case when ppnlabels.fieldname = 'TPLNR' then netobjid_data.strno when ppnlabels.fieldname = 'DEF_CODE' or ppnlabels.fieldname = 'DUR_VAL_PERC' or ppnlabels.fieldname = 'EFFECT_UNIT' or ppnlabels.fieldname = 'EFFECT_VAL' or ppnlabels.fieldname = 'EVENT_TYPE' or ppnlabels.fieldname = 'STRT_PERIOD' or ppnlabels.fieldname = 'END_PERIOD' then changeitems.value_new else '' end as DTL_NEW_CD AS value_newelseendasDTL_NEW_CD
FROM gho_ppa_request AS ppa_request
LEFT OUTER JOIN upot_int_ppnuuid AS ppn_ids ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN upov_pr_processtype_fieldlist AS ppnlabels ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN UPOV_NETOBJS AS netobjid_data ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN pcdpos AS changeitems ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN gho_dm_code_t AS defercode_desc_new ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN gho_dm_code_t AS defercode_desc_old ON /* join condition not captured in parsed metadata */
;

Learn More