R_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 R_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 R_PersSettlmtDocItem AS
SELECT
  cast( SettlmtMgmtDoc as wlf_pers_settlmt_doc preserving type ) AS PersonnelSettlementDocument,
  SettlmtMgmtDocItem AS PersSettlmtDocItem,
  SettlmtDocCurrency AS PersSettlmtDocCurrency,
  cast( SupplierPricingDocument as wlf_knumv preserving type ) AS PricingDocument,
  Product,
  ProductGroup,
  Plant,
  PricingDate,
  SettlmtQuantity,
  SettlmtQuantityUnit,
  NetPriceAmount,
  NetPriceQuantity,
  NetPriceQuantityUnit,
  SettlmtToBaseQuantityNmrtr,
  SettlmtToBaseQuantityDnmntr,
  SettlmtToNetPriceQtyNmrtr,
  SettlmtToNetPriceQtyDnmntr,
  BaseUnit,
  ItemNetWeight,
  ItemGrossWeight,
  ItemWeightUnit,
  ItemVolume,
  ItemVolumeUnit,
  cast( SupplierItemNetAmount as wlf_itm_net_amt preserving type ) AS PersSettlmtDocItemNetAmount,
  cast( SupplierSubtotal1Amount as wlf_kzwi1 preserving type ) AS PersSettlmtDocSubtotal1Amount,
  cast( SupplierSubtotal2Amount as wlf_kzwi2 preserving type ) AS PersSettlmtDocSubtotal2Amount,
  cast( SupplierSubtotal3Amount as wlf_kzwi3 preserving type ) AS PersSettlmtDocSubtotal3Amount,
  cast( SupplierSubtotal4Amount as wlf_kzwi4 preserving type ) AS PersSettlmtDocSubtotal4Amount,
  cast( SupplierSubtotal5Amount as wlf_kzwi5 preserving type ) AS PersSettlmtDocSubtotal5Amount,
  cast( SupplierSubtotal6Amount as wlf_kzwi6 preserving type ) AS PersSettlmtDocSubtotal6Amount,
  cast( SupplierRebateBasisAmount as wlf_bonba preserving type ) AS PersSettlmtDocRbteBasisAmount,
  cast( SettlmtItmStatisticalPrpty as wlf_wkowrr preserving type ) AS PersSettlmtDocItmStstclPrpty,
  CreatedByUser,
  CreationDate,
  CreationTime,
  SettlmtItemActivityReason AS PersSettlmtDocItmActyReason,
  SettlmtMgmtDocItemText AS PersSettlmtDocItemText,
  SuplrSettlmtBusinessArea AS BusinessArea,
  SuplrSettlmtControllingArea AS ControllingArea,
  SuplrSettlmtCostCenter AS CostCenter,
  SuplrSettlmtProfitCenter AS ProfitCenter,
  SuplrSettlmtWBSElmntInternalID AS WBSElementInternalID,
  cast( SupplierSettlementOrder as wlf_aufnr preserving type ) AS PersSettlmtDocOrder,
  cast( SupplierPrcDetnIsIncmplt as wlf_wuvprs preserving type ) AS PrcDetnIsIncmplt,
  SettlmtMgmtDocItemCat AS PersSettlmtDocItemCat,
  SettlmtItemReltdRefDocCat,
  SettlmtItemReltdRefDoc,
  SettlmtItemReltdCndnContr,
  SettlmtMgmtDocItemStatus AS PersSettlmtDocItemStatus,
  SettlmtMgmtDocItemCancld AS PersSettlmtDocItemRvsd,
  ServicesRenderedDate,
  SettlementFiscalYear,
  cast( CompanyCode as fis_bukrs preserving type ) AS CompanyCode,
  GLAccount,
  ProductHierarchy,
  SalesSpcfcProductGroup1,
  SalesSpcfcProductGroup2,
  SalesSpcfcProductGroup3,
  SalesSpcfcProductGroup4,
  SalesSpcfcProductGroup5,
  BusTransDocReferenceID,
  BusTransDocReferenceItemID
FROM R_SettlmtMgmtDocItem
LEFT OUTER JOIN R_PersSettlmtDoc AS _PersSettlmtDoc ON PersonnelSettlementDocument = _PersSettlmtDoc.PersonnelSettlementDocument  -- association [1..1]
LEFT OUTER JOIN I_ProductGroup_2 AS _ProductGroup ON ProductGroup = _ProductGroup.ProductGroup  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _PersSettlmtDocCurrency ON PersSettlmtDocCurrency = _PersSettlmtDocCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_SettlmtItmStatisticalPrpty AS _PersSettlmtDocItmStstclPrpty ON PersSettlmtDocItmStstclPrpty = _PersSettlmtDocItmStstclPrpty.SettlmtItmStatisticalPrpty  -- association [0..1]
LEFT OUTER JOIN I_SettlmtActivityReasonCode AS _PersSettlmtDocItmActyReason ON PersSettlmtDocItmActyReason = _PersSettlmtDocItmActyReason.SettlmtActivityReason  -- association [0..1]
LEFT OUTER JOIN R_PersSettlmtDocItmPrcgElmnt AS _PersSettlmtDocItmPrcgElmnt ON PersonnelSettlementDocument = _PersSettlmtDocItmPrcgElmnt.PersonnelSettlementDocument AND PersSettlmtDocItem = _PersSettlmtDocItmPrcgElmnt.PersSettlmtDocItem  -- association [0..*]
LEFT OUTER JOIN I_SettlmtMgmtDocItemCat AS _PersSettlmtDocItemCat ON PersSettlmtDocItemCat = _PersSettlmtDocItemCat.SettlmtMgmtDocItemCat  -- association [0..1]
LEFT OUTER JOIN I_SettlmtMgmtDocItemStatus AS _PersSettlmtDocItemStatus ON PersSettlmtDocItemStatus = _PersSettlmtDocItemStatus.SettlmtMgmtDocItemStatus  -- association [0..1]
LEFT OUTER JOIN I_SettlmtMgmtDocItemCancld AS _PersSettlmtDocItemRvsd ON PersSettlmtDocItemRvsd = _PersSettlmtDocItemRvsd.SettlmtMgmtDocItemCancld  -- association [0..1]
LEFT OUTER JOIN I_BusinessArea AS _BusinessArea ON BusinessArea = _BusinessArea.BusinessArea  -- association [0..1]
LEFT OUTER JOIN I_ControllingArea AS _ControllingArea ON ControllingArea = _ControllingArea.ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_CostCenter AS _CostCenter ON CostCenter = _CostCenter.CostCenter AND ControllingArea = _CostCenter.ControllingArea AND _CostCenter.ValidityEndDate >= CreationDate AND _CostCenter.ValidityStartDate <= CreationDate  -- association [0..1]
LEFT OUTER JOIN I_ProfitCenter AS _ProfitCenter ON ProfitCenter = _ProfitCenter.ProfitCenter AND ControllingArea = _ProfitCenter.ControllingArea AND _ProfitCenter.ValidityEndDate >= CreationDate AND _ProfitCenter.ValidityStartDate <= CreationDate  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElementBasicData ON WBSElementInternalID = _WBSElementBasicData.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_InternalOrder AS _PersSettlmtDocOrder ON PersSettlmtDocOrder = _PersSettlmtDocOrder.InternalOrder  -- association [0..1]
LEFT OUTER JOIN E_SettlmtMgmtDocItem AS _Extension ON PersonnelSettlementDocument = _Extension.SettlmtMgmtDoc AND PersSettlmtDocItem = _Extension.SettlmtMgmtDocItem  -- association [1..1]
;