C_So_F0804_Pbs_Cds

DDL: C_SO_F0804_PBS_CDS SQL: C_SO_F0804PBSCDS Type: view CONSUMPTION
30 Fields 2 Data Sources 2 Associations

Maintain Sales order PBS - Fiori F0804

C_So_F0804_Pbs_Cds is a Consumption CDS View that provides data about "Maintain Sales order PBS - Fiori F0804" in SAP S/4HANA. It reads from 2 data sources (I_CustomerProjectItem, I_SalesOrder) and exposes 30 fields with key fields SalesOrder, CharacteristicValueInternalID. It has 2 associations to related views.

Data Sources (2)

SourceAliasJoin Type
I_CustomerProjectItem Project from
I_SalesOrder SOH inner

Parameters (1)

NameTypeDefault
P_Language sylangu

Associations (2)

CardinalityTargetAliasCondition
[0..*] i_sddoccompltpartwthaddldata _CompletePartners $projection.SalesOrder = _CompletePartners.SDDocument
[0..*] i_sddocumentpartwthaddldata _DocumentPartner $projection.SalesOrder = _DocumentPartner.SDDocument

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName C_SO_F0804PBSCDS view
VDM.viewType #CONSUMPTION view
EndUserText.label Maintain Sales order PBS - Fiori F0804 view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view

Fields (30)

KeyFieldSource TableSource FieldDescription
KEY SalesOrder I_SalesOrder SalesOrder SD Document
KEY CharacteristicValueInternalID
SalesOrderType I_SalesOrder SalesOrderType Sales Order Type
SalesOrganization I_SalesOrder SalesOrganization Sales Organization
DistributionChannel I_SalesOrder DistributionChannel RefDistCh-Cust/Mat.
OrganizationDivision I_SalesOrder OrganizationDivision Org. Division
SoldToParty I_SalesOrder SoldToParty Sold-to Party
CustomerName
PurchaseOrderByCustomer I_SalesOrder PurchaseOrderByCustomer Purchase Order Number
SalesOrderDate I_SalesOrder SalesOrderDate Document Date
TotalNetAmount I_SalesOrder TotalNetAmount Total Net Amount
TransactionCurrency I_SalesOrder TransactionCurrency Transaction Currency
CustomerProjectName
CustomerProject
OverallSDProcessStatus I_SalesOrder OverallSDProcessStatus
OverallSDProcessStatusDesc
HeaderBillingBlockReason I_SalesOrder HeaderBillingBlockReason Billing Block
BillingBlockReasonDescription
_ResponsibleEmployee
_DocResponsibleEmployee
_ShipToParty
_DocShipToParty
_ProjectManager
_DocProjectManager
_ProjectAccountant
_DocProjectAccountant
_ProjectController
_DocProjectController
_ProjectPartner
_DocProjectPartner

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 C_So_F0804_Pbs_Cds.
-- 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: C_SO_F0804PBSCDS
-- Parameters: P_Language : sylangu

CREATE VIEW C_So_F0804_Pbs_Cds AS
SELECT
  SOH.SalesOrder AS SalesOrder,
  '1' AS CharacteristicValueInternalID,
  SOH.SalesOrderType AS SalesOrderType,
  SOH.SalesOrganization AS SalesOrganization,
  SOH.DistributionChannel AS DistributionChannel,
  SOH.OrganizationDivision AS OrganizationDivision,
  SOH.SoldToParty AS SoldToParty,
  SOH._SoldToParty.CustomerName AS CustomerName,
  SOH.PurchaseOrderByCustomer AS PurchaseOrderByCustomer,
  SOH.SalesOrderDate AS SalesOrderDate,
  SOH.TotalNetAmount AS TotalNetAmount,
  SOH.TransactionCurrency AS TransactionCurrency,
  Project._CustomerProject.CustomerProjectName AS CustomerProjectName,
  Project._CustomerProject.CustomerProject AS CustomerProject,
  SOH.OverallSDProcessStatus AS OverallSDProcessStatus,
  SOH._OverallSDProcessStatus._Text[1: Language=$parameters.P_Language].OverallSDProcessStatusDesc AS OverallSDProcessStatusDesc,
  SOH.HeaderBillingBlockReason AS HeaderBillingBlockReason,
  SOH._HeaderBillingBlockReason._Text[1: Language=$parameters.P_Language].BillingBlockReasonDescription AS BillingBlockReasonDescription
FROM I_CustomerProjectItem AS Project
INNER JOIN I_SalesOrder AS SOH ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN i_sddoccompltpartwthaddldata AS _CompletePartners ON SalesOrder = _CompletePartners.SDDocument  -- association [0..*]
LEFT OUTER JOIN i_sddocumentpartwthaddldata AS _DocumentPartner ON SalesOrder = _DocumentPartner.SDDocument  -- association [0..*]
;

Learn More