R_PersSettlmtDoc

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_PersSettlmtDoc.
-- 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_PersSettlmtDoc AS
SELECT
  cast( SettlmtMgmtDoc as wlf_pers_settlmt_doc preserving type ) AS PersonnelSettlementDocument,
  SettlmtDocType,
  SettlmtDocCat,
  SettlmtProcessType,
  SettlmtProcessCat,
  LogisticsDataEntryCat,
  PostingDate,
  SettlmtMgmtAcctgTransfSts AS PersSettlmtAcctgTransfSts,
  DocumentDate,
  DocumentReferenceID,
  AssignmentReference,
  SettlmtApplSts,
  SettlmtApplStsGrp,
  cast( SupplierPricingProcedure as wlf_kalsm preserving type ) AS PricingProcedure,
  cast( SupplierPricingDocument as wlf_knumv preserving type ) AS PricingDocument,
  PersonWorkAgreement,
  PersonnelCostCenter,
  PersonnelControllingArea,
  cast( CompanyCode as fis_bukrs preserving type ) AS CompanyCode,
  SalesOrganization,
  DistributionChannel,
  Division,
  SalesOffice,
  SalesGroup,
  CreatedByUser,
  CreationDate,
  CreationTime,
  LastChangeDate,
  SettlmtDocCurrency AS PersSettlmtDocCurrency,
  ExchangeRate,
  ExchangeRateType,
  ExchangeRateIsFixed,
  ExchangeRateDate,
  cast( SupplierTotalNetAmount as netwr_lf preserving type ) AS PersSettlmtDocTotalNetAmount,
  cast( SettlmtMgmtDocIsCancelled as wlf_fksto_psdoc preserving type ) AS PersSettlmtDocIsReversed,
  CancelledSettlmtMgmtDoc AS RvsdPersSettlmtDoc,
  SettlmtDocActivityReason AS PersSettlmtDocActivityReason,
  PaymentReference,
  SettlmtReltdRefDocCat,
  SettlmtReltdRefDoc,
  CndnContrType,
  SettlmtReltdCndnContr,
  CndnContrProcVar,
  FiscalPeriod,
  SettlmtDateCat,
  ActualSettlmtDate,
  SettlmtDateSequentialID,
  SettlmtDate,
  SettlmtMgmtDocIncmpltnsRsn AS PersSettlmtDocIncmpltnsRsn,
  SettlmtBusProcVar,
  SettlmtBusProcCat,
  TotalSettlmtQuantity,
  TotalSettlmtQuantityUnit,
  TotalSettlmtNetWeight,
  TotalSettlmtGrossWeight,
  TotalSettlmtWeightUnit,
  TotalSettlmtVolume,
  TotalSettlmtVolumeUnit,
  SettlmtPeriodStartDate,
  SettlmtPeriodEndDate,
  CndnContrProcessCategory,
  PostingPartnerCat,
  JournalEntryCreationDate,
  JournalEntryCreationTime,
  SettlmtCompensationReason,
  SettlmtCompnVar,
  ApplElmntBehaviorGrp,
  SettlmtMgmtDocChangeState AS PersSettlmtDocChangeState
FROM R_SettlmtMgmtDoc
LEFT OUTER JOIN R_PersSettlmtDocItem AS _PersSettlmtDocItem ON PersonnelSettlementDocument = _PersSettlmtDocItem.PersonnelSettlementDocument  -- association [0..*]
LEFT OUTER JOIN I_PersSettlmtAcctgTransfSts AS _PersSettlmtAcctgTransfSts ON PersSettlmtAcctgTransfSts = _PersSettlmtAcctgTransfSts.PersSettlmtAcctgTransfSts  -- association [0..1]
LEFT OUTER JOIN R_PersSettlmtDocPrcgElmnt AS _PersSettlmtDocPrcgElmnt ON PersonnelSettlementDocument = _PersSettlmtDocPrcgElmnt.PersonnelSettlementDocument  -- association [0..*]
LEFT OUTER JOIN I_Currency AS _PersSettlmtDocCurrency ON PersSettlmtDocCurrency = _PersSettlmtDocCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN R_PersSettlmtDoc AS _RvsdPersSettlmtDoc ON RvsdPersSettlmtDoc = _RvsdPersSettlmtDoc.PersonnelSettlementDocument  -- association [0..1]
LEFT OUTER JOIN I_SettlmtActivityReasonCode AS _PersSettlmtDocActivityReason ON PersSettlmtDocActivityReason = _PersSettlmtDocActivityReason.SettlmtActivityReason  -- association [0..1]
LEFT OUTER JOIN I_SettlmtMgmtDocIncmpltnsRsnCd AS _PersSettlmtDocIncmpltnsRsn ON PersSettlmtDocIncmpltnsRsn = _PersSettlmtDocIncmpltnsRsn.SettlmtMgmtDocIncmpltnsRsn  -- association [0..1]
LEFT OUTER JOIN I_SettlmtCompnRsn AS _SettlmtCompensationReason ON SettlmtCompensationReason = _SettlmtCompensationReason.SettlmtCompensationReason  -- association [0..1]
LEFT OUTER JOIN I_CostCenter AS _PersonnelCostCenter ON PersonnelCostCenter = _PersonnelCostCenter.CostCenter AND PersonnelControllingArea = _PersonnelCostCenter.ControllingArea AND _PersonnelCostCenter.ValidityEndDate >= PostingDate AND _PersonnelCostCenter.ValidityStartDate <= PostingDate  -- association [0..1]
LEFT OUTER JOIN I_ControllingArea AS _PersonnelControllingArea ON PersonnelControllingArea = _PersonnelControllingArea.ControllingArea  -- association [0..1]
LEFT OUTER JOIN E_SettlmtMgmtDoc AS _Extension ON PersonnelSettlementDocument = _Extension.SettlmtMgmtDoc  -- association [1..1]
;