P_COSB_COM

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_COSB_COM.
-- 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: PFICOSBCOM

CREATE VIEW P_COSB_COM AS
SELECT
  objnr,
  gjahr,
  wrttp,
  versn,
  cast( abkat as fco_abkat) AS abkat,
  kstar,
  hrkft,
  vrgng,
  parob,
  beknz,
  meinh,
  sum(wkg001) AS wkg001,
  sum(wkg002) AS wkg002,
  sum(wkg003) AS wkg003,
  sum(wkg004) AS wkg004,
  sum(wkg005) AS wkg005,
  sum(wkg006) AS wkg006,
  sum(wkg007) AS wkg007,
  sum(wkg008) AS wkg008,
  sum(wkg009) AS wkg009,
  sum(wkg010) AS wkg010,
  sum(wkg011) AS wkg011,
  sum(wkg012) AS wkg012,
  sum(wkg013) AS wkg013,
  sum(wkg014) AS wkg014,
  sum(wkg015) AS wkg015,
  sum(wkg016) AS wkg016,
  sum(wkf001) AS wkf001,
  sum(wkf002) AS wkf002,
  sum(wkf003) AS wkf003,
  sum(wkf004) AS wkf004,
  sum(wkf005) AS wkf005,
  sum(wkf006) AS wkf006,
  sum(wkf007) AS wkf007,
  sum(wkf008) AS wkf008,
  sum(wkf009) AS wkf009,
  sum(wkf010) AS wkf010,
  sum(wkf011) AS wkf011,
  sum(wkf012) AS wkf012,
  sum(wkf013) AS wkf013,
  sum(wkf014) AS wkf014,
  sum(wkf015) AS wkf015,
  sum(wkf016) AS wkf016,
  sum(wog001) AS wog001,
  sum(wog002) AS wog002,
  sum(wog003) AS wog003,
  sum(wog004) AS wog004,
  sum(wog005) AS wog005,
  sum(wog006) AS wog006,
  sum(wog007) AS wog007,
  sum(wog008) AS wog008,
  sum(wog009) AS wog009,
  sum(wog010) AS wog010,
  sum(wog011) AS wog011,
  sum(wog012) AS wog012,
  sum(wog013) AS wog013,
  sum(wog014) AS wog014,
  sum(wog015) AS wog015,
  sum(wog016) AS wog016,
  sum(meg001) AS meg001,
  sum(meg002) AS meg002,
  sum(meg003) AS meg003,
  sum(meg004) AS meg004,
  sum(meg005) AS meg005,
  sum(meg006) AS meg006,
  sum(meg007) AS meg007,
  sum(meg008) AS meg008,
  sum(meg009) AS meg009,
  sum(meg010) AS meg010,
  sum(meg011) AS meg011,
  sum(meg012) AS meg012,
  sum(meg013) AS meg013,
  sum(meg014) AS meg014,
  sum(meg015) AS meg015,
  sum(meg016) AS meg016
FROM cosb
;