P_CKIS

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_CKIS.
-- 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_CKIS AS
SELECT
  c.lednr AS ControllingLedger,
  c.bzobj AS CostingReferenceObject,
  cast(c.kalnr as fis_kalnr preserving type) AS CostEstimate,
  c.kalka AS CostingType,
  c.kadky AS CostingDate,
  c.tvers AS CostingVersion,
  c.bwvar AS ValuationVariant,
  c.kkzma AS CostIsEnteredManually,
  c.posnr AS CostingItem,
  c.typps AS CostingItemCategory,
  c.kstar AS CostElement,
  c.hrkft AS CostOriginGroup,
  c.elemt AS CostComponent,
  cast(c.elemtns as ck_elemns preserving type) AS AuxiliaryCostComponent,
  c.bukrs AS CompanyCode,
  c.werks AS Plant,
  cast(c.matnr as productnumber preserving type) AS Product,
  c.bwtar AS ValuationType,
  c.lifnr AS Creditor,
  k.ControllingAreaCurrency AS ControllingAreaCurrency,
  cast(c.gpreis as fpc_vdm_totpr_ca preserving type) AS TotalPriceInInCtrlgAreaCrcy,
  cast(c.fpreis as fpc_vdm_fxdpr_ca preserving type) AS FixedPriceInCtrlgAreaCrcy,
  cast(c.fwaer_kpf as fis_hwaer preserving type) AS CompanyCodeCurrency,
  cast(c.wrtfw_kpf as ck_gwbk preserving type) AS TotalAmountInCoCodeCrcy,
  cast(c.wrtfw_kfx as ck_fwbk preserving type) AS FixedAmountInCoCodeCrcy,
  cast(c.opreis as fpc_vdm_totpr_cc preserving type) AS TotalPriceInCompanyCodeCrcy,
  cast(c.opreifx as fpc_vdm_fxdpr_cc preserving type) AS FixedPriceInCompanyCodeCrcy,
  c.meeht AS BaseUnit,
  c.menge AS QuantityInBaseUnit,
  c.ausmg AS AssyScrapQuantityInValnQtyUnit,
  c.ausmgko AS CompScrapQuantityInValnQtyUnit,
  c.peinh AS CostingPriceUnitQty,
  c.pmeht AS CostingPriceQtyUnit,
  c.umrez AS ProdCostEstItmToBaseQtyNmrtr,
  c.umren AS ProdCostEstItmToBaseQtyDnmntr,
  cast(c.ukaln as fpc_transfer_cost_est preserving type) AS TransferCostEstimate,
  cast(c.ukalka as fpc_transfer_costing_type preserving type) AS TransferCostingType,
  cast(c.ukadky as fpc_transfer_costing_date preserving type) AS TransferCostingDate,
  cast(c.utvers as fpc_transfer_costing_version preserving type) AS TransferCostingVersion,
  cast(c.ubwvar as fpc_transfer_valuation_variant preserving type) AS TransferValuationVariant,
  cast(c.wertn as fpc_vdm_cawaer_total preserving type) AS TotalAmountInCtrlgAreaCrcy,
  cast(c.wrtfx as fpc_vdm_cawaer_fixed preserving type) AS FixedAmountInCtrlgAreaCrcy,
  c.lstar AS CostCtrActivityType,
  c.kalnr_ba AS ProcmtAltvCostEstimate,
  c.arbid AS CostingObject,
  cast(c.kostl as fis_kostl preserving type) AS CostCenter,
  cast(c.vornr as vdm_vornr preserving type) AS Operation,
  c.infnr AS PurchasingInfoRecord,
  c.ekorg AS PurchasingOrganization,
  c.esokz AS PurchasingInfoRecordCategory,
  c.ebeln AS PurchasingDocument,
  c.ebelp AS PurchasingDocumentItem,
  c.mkalk AS CostEstIsMixedCosting,
  c.misch_verh AS CostgMixingRatioValue,
  c.nlag AS nlag,
  cast(c.strat as ck_bwsma preserving type) AS CostingValuationStrategy,
  c.substrat AS ProductValnPurgInfoRecdStrgy,
  cast(c.sposn as ck_sposn preserving type) AS BillOfMaterialItemNumber,
  cast(c.baugr as ck_baukz preserving type) AS CostingItemIsAssembly,
  c.psknz AS IsLotSizeIndependent,
  cast(c.prctr as fis_prctr preserving type) AS ProfitCenter,
  c.segunit AS ValuationSegmentation,
  c.gsber AS BusinessArea,
  cast(c.pspnr as ps_s4_pspnr preserving type) AS WBSElementInternalID,
  c.disst AS LowLevelCode,
  c.schkz AS CostCompSplitIsExisting,
  c.fehlkz AS HasError,
  c.ucb_id AS ComponentBreakdown
FROM ckis AS c
;