P_ProfitabilitySegment

DDL: P_PROFITABILITYSEGMENT Type: view_entity BASIC Package: FINS_COPA_PROF_SEGMENT
104 Fields 3 Data Sources

Profitability Segment

P_ProfitabilitySegment is a Basic CDS View that provides data about "Profitability Segment" in SAP S/4HANA. It reads from 3 data sources (ce4a000, ce4a000_acct, fcopa_prof_seg) and exposes 104 fields with key field paobjnr. Part of development package FINS_COPA_PROF_SEGMENT.

Data Sources (3)

SourceAliasJoin Type
ce4a000 ce4a000 union_all
ce4a000_acct ce4a000_acct union_all
fcopa_prof_seg fcopa_prof_seg from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Profitability Segment view
VDM.private true view
VDM.viewType #BASIC view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
Metadata.ignorePropagatedAnnotations true view

Fields (104)

KeyFieldSource TableSource FieldDescription
KEY paobjnr paobjnr Profit. segment
bukrs bukrs Value
copa_kostl copa_kostl Cost center
fkber fkber Functional Area
gsber gsber Business Area
kaufn kaufn SettlementOrder
kdpos kdpos Sales Ord. Item
kndnr kndnr Customer
kokrs kokrs Org. Value
kstrg kstrg Cost Objects
pprctr pprctr Partner PC
prctr prctr Profit Centers
pspnr pspnr WBS Element
segment segment Segment number
vtkey vtkey Contract
vtpos vtpos Item
werks werks Receiving Plant
AUFNR rkaufnr Order
artnr artnr Product
brsch brsch Industry
bzirk bzirk Sales District
fkart fkart Ship. cost type
kdgrp kdgrp Customer group
kunre kunre Bill-to Party
kunwe kunwe Ship-to Party
land1 land1 Trip Ctry/Reg
matkl matkl Product Sold Group
spart spart Source supplier
vkorg vkorg SD Sales Org.
vtweg vtweg RefDistCh-Cust/Mat.
meinh meinh Unit of Measure
qunit1 qunit1 Add Unit Meas 1
qunit2 qunit2 Add Unit Meas 2
qunit3 qunit3 Add Unit Meas 3
timestamp timestamp UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
bukrs bukrs Value
copa_kostl copa_kostl Cost center
fkber fkber Functional Area
gsber gsber Business Area
kaufn kaufn SettlementOrder
kdpos kdpos Sales Ord. Item
kndnr kndnr Customer
kokrs kokrs Org. Value
kstrg kstrg Cost Objects
pprctr pprctr Partner PC
prctr prctr Profit Centers
pspnr pspnr WBS Element
segment segment Segment number
vtkey vtkey Contract
vtpos vtpos Item
werks werks Receiving Plant
aufnr aufnr SettlementOrder
artnr artnr Product
brsch brsch Industry
bzirk bzirk Sales District
fkart fkart Ship. cost type
kdgrp kdgrp Customer group
kunre kunre Bill-to Party
kunwe kunwe Ship-to Party
land1 land1 Trip Ctry/Reg
matkl matkl Product Sold Group
spart spart Source supplier
vkorg vkorg SD Sales Org.
vtweg vtweg RefDistCh-Cust/Mat.
meinh meinh Unit of Measure
QUNIT1
QUNIT2
QUNIT3
timestamp 0 UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
bukrs bukrs Value
copa_kostl copa_kostl Cost center
fkber fkber Functional Area
gsber gsber Business Area
kaufn kaufn SettlementOrder
kdpos kdpos Sales Ord. Item
kndnr kndnr Customer
kokrs kokrs Org. Value
kstrg kstrg Cost Objects
pprctr pprctr Partner PC
prctr prctr Profit Centers
pspnr pspnr WBS Element
segment segment Segment number
vtkey vtkey Contract
vtpos vtpos Item
werks werks Receiving Plant
aufnr aufnr SettlementOrder
artnr artnr Product
brsch brsch Industry
bzirk bzirk Sales District
fkart fkart Ship. cost type
kdgrp kdgrp Customer group
kunre kunre Bill-to Party
kunwe kunwe Ship-to Party
land1 land1 Trip Ctry/Reg
matkl matkl Product Sold Group
spart spart Source supplier
vkorg vkorg SD Sales Org.
vtweg vtweg RefDistCh-Cust/Mat.
meinh meinh Unit of Measure
qunit1 qunit1 Add Unit Meas 1
qunit2 qunit2 Add Unit Meas 2
qunit3 qunit3 Add Unit Meas 3
timestamp 0 UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
Origin

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_ProfitabilitySegment.
-- 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.

CREATE VIEW P_ProfitabilitySegment AS
SELECT
  paobjnr,
  bukrs,
  copa_kostl,
  fkber,
  gsber,
  kaufn,
  kdpos,
  kndnr,
  kokrs,
  kstrg,
  pprctr,
  prctr,
  pspnr,
  segment,
  vtkey,
  vtpos,
  werks,
  rkaufnr AS AUFNR,
  artnr,
  brsch,
  bzirk,
  fkart,
  kdgrp,
  kunre,
  kunwe,
  land1,
  matkl,
  spart,
  vkorg,
  vtweg,
  meinh,
  qunit1,
  qunit2,
  qunit3,
  timestamp,
  cast( '4' as abap.char(1) ) AS Origin
FROM fcopa_prof_seg
-- UNION ALL with additional select branch(es): ce4a000_acct, ce4a000
;

Learn More