Coll_P2p_Attr

DDL: V_COLL_P2P_ATTR SQL: V_COLL_P2P_ATTR Type: view Package: ODATA_COLLECTION_WORKLIST
9 Fields 2 Data Sources

Zahlungsversprechen

Coll_P2p_Attr is a CDS View that provides data about "Zahlungsversprechen" in SAP S/4HANA. It reads from 2 data sources (scmg_t_case_attr, udm_p2p_attr) and exposes 9 fields with key field case_guid. Part of development package ODATA_COLLECTION_WORKLIST.

Data Sources (2)

SourceAliasJoin Type
scmg_t_case_attr scmg from
udm_p2p_attr udm inner

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName V_COLL_P2P_ATTR view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #P view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
EndUserText.label Zahlungsversprechen view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY case_guid scmg_t_case_attr case_guid UUID
ext_key ext_key External key
ext_ref ext_ref External Reference
change_time Time Stamp
stat_para stat_para System Status
fin_customer fin_customer Customer
fin_p2p_curr fin_p2p_curr Currency
fin_p2p_date fin_p2p_date Promised On
fin_paid_os fin_paid_os Paid on Sched.

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 Coll_P2p_Attr.
-- 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_COLL_P2P_ATTR

CREATE VIEW Coll_P2p_Attr AS
SELECT
  scmg.case_guid AS case_guid,
  ext_key,
  ext_ref,
  cast( change_time as tzntstmps ) AS change_time,
  stat_para,
  fin_customer,
  fin_p2p_curr,
  fin_p2p_date,
  fin_paid_os
FROM scmg_t_case_attr AS scmg
INNER JOIN udm_p2p_attr AS udm ON /* join condition not captured in parsed metadata */
;

Learn More