C_FrtCostAlcItmPrcgElmnt_F6215

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_FrtCostAlcItmPrcgElmnt_F6215.
-- 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 C_FrtCostAlcItmPrcgElmnt_F6215 AS
SELECT
  FreightCostAllocationDocument,
  FrtCostAllocDocumentItem,
  PricingProcedureStep,
  PricingProcedureCounter,
  ConditionType,
  cast( '' as wlf_prcg_element_description ) AS PriceElementDescription,
  ConditionRateAmount,
  ConditionRateRatio,
  ConditionBaseAmount,
  cast ( ConditionBaseQuantity as wlf_prcg_element_base_quantity preserving type ) AS ConditionBaseQuantity,
  ConditionQuantity,
  ConditionAmount,
  IsRelevantForAccrual,
  ConditionCurrency,
  TransactionCurrency,
  ConditionQuantityUnit,
  ConditionRateRatioUnit,
  ConditionIsForStatistics,
  ConditionIsManuallyChanged,
  ConditionInactiveReason,
  cast ( 0 as int1 preserving type ) AS UICT_ConditionTypeCriticality,
  cast ( '' as boolean preserving type ) AS UICT_CndPricingUnitHidden,
  cast ( '' as boolean preserving type ) AS UICT_ValueIsHidden,
  cast ( '' as boolean preserving type ) AS UICT_BaseAmountIsHidden,
  cast ( '' as boolean preserving type ) AS UICT_BaseQuantityIsHidden,
  cast ( '' as boolean preserving type ) AS UICT_CndRateValueIsNotAmount,
  cast ( '' as boolean preserving type ) AS UICT_CndRateValueIsNotRatio,
  cast ( '' as boolean preserving type ) AS UICT_ScaleValuesEmpty,
  cast ( '' as boolean preserving type ) AS UICT_ScaleBaseAmountIsEmpty,
  cast ( '' as boolean preserving type ) AS UICT_ScaleBaseQuantityIsEmpty,
  cast ( '' as boolean preserving type ) AS UICT_IsOnCalculatedItemPage,
  ConditionApplication,
  ConditionClass,
  ConditionCalculationType,
  ConditionCategory,
  ConditionControl,
  ConditionOrigin,
  CndnRoundingOffDiffAmount,
  FactorForConditionBasisValue,
  IsGroupCondition,
  PeriodFactorForCndnBasisValue,
  PriceConditionDeterminationDte,
  CndnIsRelevantForInvoiceList,
  ConditionIsForConfiguration,
  StructureCondition,
  PricingScaleBasis,
  PricingScaleType,
  ConditionScaleBaseAmount,
  ConditionScaleBaseQuantity,
  ConditionScaleBasisUnit,
  ConditionScaleBasisCurrency,
  _ConditionApplication._Text[1: Language = $session.system_language].ConditionApplicationName AS ConditionApplicationName,
  _ConditionCalculationType._Text[1: Language = $session.system_language].ConditionCalculationTypeName AS ConditionCalculationTypeName,
  _ConditionCategory._Text[1: Language = $session.system_language].ConditionCategoryName AS ConditionCategoryName,
  _ConditionClass._Text[1: Language = $session.system_language].ConditionClassName AS ConditionClassName,
  _ConditionControl._Text[1: Language = $session.system_language].ConditionControlName AS ConditionControlName,
  _ConditionOrigin._Text[1: Language = $session.system_language].ConditionOriginName AS ConditionOriginName,
  _ConditionInactiveReason._Text[1: Language = $session.system_language].ConditionInactiveReasonName AS ConditionInactiveReasonName,
  _PricingScaleBasis._Text[1: Language = $session.system_language].PricingScaleBasisName AS PricingScaleBasisName,
  _StructureCondition._Text[1: Language = $session.system_language].StructureConditionName AS StructureConditionName,
  cast( '' as fis_mwskz_name ) AS TaxCodeName,
  cast( '' as kmein ) AS ConditionToBaseQtyDnmntrUnit,
  cast( '' as meins ) AS ConditionToBaseQtyNmrtrUnit,
  cast( 0 as wlf_ukurs_curr_no_cnext ) AS ExchangeRate,
  AccountKeyForGLAccount,
  GLAccount,
  AcctKeyForAccrualsGLAccount,
  AccrualsGLAccount
FROM R_FrtCostAllocItmPrcgElmnt
LEFT OUTER JOIN C_MngFrtCostAllocDoc AS _FrtCostAllocDoc ON FreightCostAllocationDocument = _FrtCostAllocDoc.FreightCostAllocationDocument  -- association [1..1]
LEFT OUTER JOIN C_MngFrtCostAllocDocItem AS _FrtCostAllocItm ON FreightCostAllocationDocument = _FrtCostAllocItm.FreightCostAllocationDocument AND FrtCostAllocDocumentItem = _FrtCostAllocItm.FrtCostAllocDocumentItem  -- association [1..1]
;