C_PersSetlDocPrgElm_F3808A

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_PersSetlDocPrgElm_F3808A.
-- 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_PersSetlDocPrgElm_F3808A AS
SELECT
  PersonnelSettlementDocument,
  PricingProcedureStep,
  PricingProcedureCounter,
  ConditionApplication,
  _ConditionApplication._Text[1: Language = $session.system_language].ConditionApplicationName AS ConditionApplicationName,
  ConditionType,
  cast ( '' as wlf_prcg_element_description ) AS PriceElementDescription,
  PriceConditionDeterminationDte,
  ConditionCalculationType,
  _ConditionCalculationType._Text[1: Language = $session.system_language].ConditionCalculationTypeName AS ConditionCalculationTypeName,
  cast( ConditionBaseAmount as wlf_prcg_element_base_amount preserving type ) AS ConditionBaseAmount,
  cast ( ConditionBaseQuantity as wlf_prcg_element_base_quantity preserving type ) AS ConditionBaseQuantity,
  ConditionRateAmount,
  cast( ConditionRateRatio as wlf_prcg_element_ratio preserving type ) AS ConditionRateRatio,
  ConditionRateRatioUnit,
  ConditionCurrency,
  ConditionQuantity,
  ConditionQuantityUnit,
  ConditionCategory,
  _ConditionCategory._Text[1: Language = $session.system_language].ConditionCategoryName AS ConditionCategoryName,
  ConditionIsForStatistics,
  IsRelevantForAccrual,
  ConditionOrigin,
  _ConditionOrigin._Text[1: Language = $session.system_language].ConditionOriginName AS ConditionOriginName,
  IsGroupCondition,
  ConditionRecord,
  ConditionSequentialNumber,
  CndnRoundingOffDiffAmount,
  ConditionAmount,
  TransactionCurrency,
  ConditionControl,
  _ConditionControl._Text[1: Language = $session.system_language].ConditionControlName AS ConditionControlName,
  ConditionInactiveReason,
  _ConditionInactiveReason._Text[1: Language = $session.system_language].ConditionInactiveReasonName AS ConditionInactiveReasonName,
  ConditionClass,
  _ConditionClass._Text[1: Language = $session.system_language].ConditionClassName AS ConditionClassName,
  PrcgProcedureCounterForHeader,
  FactorForConditionBasisValue,
  StructureCondition,
  PeriodFactorForCndnBasisValue,
  PricingScaleType,
  PricingScaleBasis,
  ConditionScaleBaseAmount,
  ConditionScaleBaseQuantity,
  ConditionScaleBasisUnit,
  ConditionScaleBasisCurrency,
  ConditionIsManuallyChanged,
  ConditionIsForConfiguration,
  VariantCondition,
  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
FROM R_PersSettlmtDocPrcgElmnt
LEFT OUTER JOIN C_PersSettlmtDoc_F3808A AS _PersSettlmtDoc ON PersonnelSettlementDocument = _PersSettlmtDoc.PersonnelSettlementDocument  -- association [1..1]
;