Fdm_Coll_P2p

DDL: FDM_COLL_P2P SQL: FDM_COLL_PR_P2P Type: view

CDS-view für Zahlungsversprechen (Forderungen bearbeiten)

Fdm_Coll_P2p is a CDS View that provides data about "CDS-view für Zahlungsversprechen (Forderungen bearbeiten)" in SAP S/4HANA. It reads from 5 data sources (fdm_p2p_attr, fdm_instplan_tyt, Fdm_Coll_Inv_Helper, Coll_P2p_Attr, Fdm_Coll_P2pstatet) and exposes 16 fields with key field case_guid.

Data Sources (5)

SourceAliasJoin Type
fdm_p2p_attr _fdm_p2p_attr left_outer
fdm_instplan_tyt _insplan_tyt left_outer
Fdm_Coll_Inv_Helper _invoice from
Coll_P2p_Attr _p2p left_outer
Fdm_Coll_P2pstatet _p2pstatet left_outer

Parameters (1)

NameTypeDefault
language abap.lang

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName FDM_COLL_PR_P2P view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK 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 CDS-view für Zahlungsversprechen (Forderungen bearbeiten) view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY case_guid Coll_P2p_Attr case_guid UUID
ext_key Coll_P2p_Attr ext_key External key
ext_ref ext_ref External Reference
change_time change_time Time Stamp
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.
customer customer Sold-to Party
coll_debtor coll_debtor
comp_code comp_code Procuring Comp. Cde
invoice_no invoice_no Invoice No
fiscal_year fiscal_year Tax Item Fiscal Year
doc_item doc_item Item Number
billing_doc billing_doc Billing Doc.
xblnr xblnr Reference

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 Fdm_Coll_P2p.
-- 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: FDM_COLL_PR_P2P
-- Parameters: language : abap.lang

CREATE VIEW Fdm_Coll_P2p AS
SELECT
  _p2p.case_guid AS case_guid,
  _p2p.ext_key AS ext_key,
  ext_ref,
  change_time,
  fin_customer,
  fin_p2p_curr,
  fin_p2p_date,
  fin_paid_os,
  customer,
  coll_debtor,
  comp_code,
  invoice_no,
  fiscal_year,
  doc_item,
  billing_doc,
  xblnr
FROM Fdm_Coll_Inv_Helper AS _invoice
LEFT OUTER JOIN Coll_P2p_Attr AS _p2p ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN fdm_p2p_attr AS _fdm_p2p_attr ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN fdm_instplan_tyt AS _insplan_tyt ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN Fdm_Coll_P2pstatet AS _p2pstatet ON /* join condition not captured in parsed metadata */
;