P_Comfpopenbillingplan

DDL: P_COMFPOPENBILLINGPLAN SQL: PCOMFPOPENBP Type: view BASIC Package: VDM_CPM_WS
7 Fields 1 Data Sources 2 Associations

Fixed Plan Open Billing Plan

P_Comfpopenbillingplan is a Basic CDS View that provides data about "Fixed Plan Open Billing Plan" in SAP S/4HANA. It reads from 1 data source (P_Comfpbilling) and exposes 7 fields. It has 2 associations to related views. Part of development package VDM_CPM_WS.

Data Sources (1)

SourceAliasJoin Type
P_Comfpbilling P_Comfpbilling from

Associations (2)

CardinalityTargetAliasCondition
[0..1] ad01dli _ad01 P_Comfpbilling.ReferenceObjectID = _ad01.objnr
[0..1] ad01dli _ad02 P_Comfpbilling.dliid = _ad02.cpd_dliid

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PCOMFPOPENBP view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #BASIC view
VDM.private true view

Fields (7)

KeyFieldSource TableSource FieldDescription
dliid P_Comfpbilling dliid Unique ID
SalesOrder P_Comfpbilling SalesOrder SD Document
SalesOrderItem P_Comfpbilling SalesOrderItem Sales Order Item
BillingDate P_Comfpbilling BillingDate Billing Date
OrganizationDivision P_Comfpbilling OrganizationDivision Org. Division
ReferenceObjectID P_Comfpbilling ReferenceObjectID Reference Object ID
dlinrthenOPENelseendasstatus

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 P_Comfpopenbillingplan.
-- 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: PCOMFPOPENBP

CREATE VIEW P_Comfpopenbillingplan AS
SELECT
  P_Comfpbilling.dliid AS dliid,
  P_Comfpbilling.SalesOrder AS SalesOrder,
  P_Comfpbilling.SalesOrderItem AS SalesOrderItem,
  P_Comfpbilling.BillingDate AS BillingDate,
  P_Comfpbilling.OrganizationDivision AS OrganizationDivision,
  P_Comfpbilling.ReferenceObjectID AS ReferenceObjectID,
  case when (P_Comfpbilling.dlinr = ' ') then 'OPEN' else ' ' end as status AS dlinrthenOPENelseendasstatus
FROM P_Comfpbilling
LEFT OUTER JOIN ad01dli AS _ad01 ON P_Comfpbilling.ReferenceObjectID = _ad01.objnr  -- association [0..1]
LEFT OUTER JOIN ad01dli AS _ad02 ON P_Comfpbilling.dliid = _ad02.cpd_dliid  -- association [0..1]
;

Learn More