I_PersSettlmtDocItem

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 I_PersSettlmtDocItem.
-- 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 I_PersSettlmtDocItem AS
SELECT
  PersonnelSettlementDocument,
  PersSettlmtDocItem,
  PersSettlmtDocCurrency,
  PricingDocument,
  Product,
  ProductGroup,
  Plant,
  PricingDate,
  SettlmtQuantity,
  SettlmtQuantityUnit,
  NetPriceAmount,
  NetPriceQuantity,
  NetPriceQuantityUnit,
  SettlmtToBaseQuantityNmrtr,
  SettlmtToBaseQuantityDnmntr,
  SettlmtToNetPriceQtyNmrtr,
  SettlmtToNetPriceQtyDnmntr,
  BaseUnit,
  ItemNetWeight,
  ItemGrossWeight,
  ItemWeightUnit,
  ItemVolume,
  ItemVolumeUnit,
  PersSettlmtDocItemNetAmount AS ItemNetAmount,
  PersSettlmtDocSubtotal1Amount AS Subtotal1Amount,
  PersSettlmtDocSubtotal2Amount AS Subtotal2Amount,
  PersSettlmtDocSubtotal3Amount AS Subtotal3Amount,
  PersSettlmtDocSubtotal4Amount AS Subtotal4Amount,
  PersSettlmtDocSubtotal5Amount AS Subtotal5Amount,
  PersSettlmtDocSubtotal6Amount AS Subtotal6Amount,
  PersSettlmtDocRbteBasisAmount AS RebateBasisAmount,
  PersSettlmtDocItmStstclPrpty AS SettlmtItmStatisticalPrpty,
  CreatedByUser,
  CreationDate,
  CreationTime,
  PersSettlmtDocItmActyReason AS SettlmtItemActivityReason,
  PersSettlmtDocItemText,
  BusinessArea,
  ControllingArea,
  CostCenter,
  ProfitCenter,
  WBSElementInternalID,
  PersSettlmtDocOrder AS SettlementOrder,
  PrcDetnIsIncmplt,
  PersSettlmtDocItemCat,
  SettlmtItemReltdCndnContr,
  PersSettlmtDocItemStatus,
  PersSettlmtDocItemRvsd,
  ServicesRenderedDate,
  SettlementFiscalYear,
  CompanyCode,
  GLAccount,
  ProductHierarchy,
  SalesSpcfcProductGroup1,
  SalesSpcfcProductGroup2,
  SalesSpcfcProductGroup3,
  SalesSpcfcProductGroup4,
  SalesSpcfcProductGroup5,
  BusTransDocReferenceID,
  BusTransDocReferenceItemID,
  cast( ' ' as wlf_change_state_item preserving type ) AS PersSettlmtDocItemChangeState
FROM R_PersSettlmtDocItem
LEFT OUTER JOIN I_PersSettlmtDoc AS _PersSettlmtDoc ON PersonnelSettlementDocument = _PersSettlmtDoc.PersonnelSettlementDocument  -- association [1..1]
LEFT OUTER JOIN I_PersSettlmtDocItmPrcgElmnt AS _PersSettlmtDocItmPrcgElmnt ON PersonnelSettlementDocument = _PersSettlmtDocItmPrcgElmnt.PersonnelSettlementDocument AND PersSettlmtDocItem = _PersSettlmtDocItmPrcgElmnt.PersSettlmtDocItem  -- association [0..*]
LEFT OUTER JOIN I_ProductText AS _ProductText ON Product = _ProductText.Product  -- association [0..*]
LEFT OUTER JOIN I_SettlmtItmStatisticalPrpty AS _SettlmtItmStatisticalPrpty ON SettlmtItmStatisticalPrpty = _SettlmtItmStatisticalPrpty.SettlmtItmStatisticalPrpty  -- association [0..1]
LEFT OUTER JOIN I_SettlmtActivityReasonCode AS _SettlmtItemActivityReason ON SettlmtItemActivityReason = _SettlmtItemActivityReason.SettlmtActivityReason  -- association [0..1]
LEFT OUTER JOIN I_BusinessAreaText AS _BusinessAreaText ON BusinessArea = _BusinessAreaText.BusinessArea  -- association [0..*]
LEFT OUTER JOIN I_ConditionContract AS _SettlmtItemReltdCndnContr ON SettlmtItemReltdCndnContr = _SettlmtItemReltdCndnContr.ConditionContract  -- association [0..1]
LEFT OUTER JOIN E_SettlmtMgmtDocItem AS _Extension ON PersonnelSettlementDocument = _Extension.SettlmtMgmtDoc AND PersSettlmtDocItem = _Extension.SettlmtMgmtDocItem  -- association [1..1]
;