C_PersSettlmtDocDEX

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_PersSettlmtDocDEX.
-- 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_PersSettlmtDocDEX AS
SELECT
  PersonnelSettlementDocument,
  PersSettlmtDocItem,
  PersSettlmtDocDEX.SettlmtDocType AS SettlmtDocType,
  PersSettlmtDocDEX.SettlmtDocCat AS SettlmtDocCat,
  PersSettlmtDocDEX.SettlmtProcessType AS SettlmtProcessType,
  PersSettlmtDocDEX.LogisticsDataEntryCat AS LogisticsDataEntryCat,
  PersSettlmtDocDEX.SettlmtProcessCat AS SettlmtProcessCat,
  PersSettlmtDocDEX.PostingDate AS PostingDate,
  PersSettlmtDocDEX.PersSettlmtAcctgTransfSts AS PersSettlmtAcctgTransfSts,
  PersSettlmtDocDEX.DocumentDate AS DocumentDate,
  PersSettlmtDocDEX.DocumentReferenceID AS DocumentReferenceID,
  PersSettlmtDocDEX.AssignmentReference AS AssignmentReference,
  PersSettlmtDocDEX.SettlmtApplSts AS SettlmtApplSts,
  PersSettlmtDocDEX.SettlmtApplStsGrp AS SettlmtApplStsGrp,
  PersSettlmtDocDEX.PricingProcedure AS PricingProcedure,
  PersSettlmtDocDEX.PricingDocument AS PricingDocument,
  PersSettlmtDocDEX.PersonWorkAgreement AS PersonWorkAgreement,
  PersSettlmtDocDEX.PersonnelCostCenter AS PersonnelCostCenter,
  PersSettlmtDocDEX.PersonnelControllingArea AS PersonnelControllingArea,
  PersSettlmtDocDEX.CompanyCode AS CompanyCode,
  PersSettlmtDocDEX.SalesOrganization AS SalesOrganization,
  PersSettlmtDocDEX.DistributionChannel AS DistributionChannel,
  PersSettlmtDocDEX.Division AS Division,
  PersSettlmtDocDEX.SalesOffice AS SalesOffice,
  PersSettlmtDocDEX.SalesGroup AS SalesGroup,
  PersSettlmtDocDEX.CreatedByUser AS CreatedByUser,
  PersSettlmtDocDEX.CreationDate AS CreationDate,
  PersSettlmtDocDEX.CreationTime AS CreationTime,
  PersSettlmtDocDEX.LastChangeDate AS LastChangeDate,
  PersSettlmtDocDEX.PersSettlmtDocCurrency AS PersSettlmtDocCurrency,
  PersSettlmtDocDEX.ExchangeRate AS ExchangeRate,
  PersSettlmtDocDEX.ExchangeRateType AS ExchangeRateType,
  PersSettlmtDocDEX.ExchangeRateIsFixed AS ExchangeRateIsFixed,
  PersSettlmtDocDEX.ExchangeRateDate AS ExchangeRateDate,
  PersSettlmtDocDEX.PersSettlmtDocTotalNetAmount AS PersSettlmtDocTotalNetAmount,
  PersSettlmtDocDEX.PersSettlmtDocIsReversed AS PersSettlmtDocIsReversed,
  PersSettlmtDocDEX.RvsdPersSettlmtDoc AS RvsdPersSettlmtDoc,
  PersSettlmtDocDEX.PersSettlmtDocActivityReason AS PersSettlmtDocActivityReason,
  PersSettlmtDocDEX.PaymentReference AS PaymentReference,
  PersSettlmtDocDEX.CndnContrType AS CndnContrType,
  PersSettlmtDocDEX.SettlmtReltdCndnContr AS SettlmtReltdCndnContr,
  PersSettlmtDocDEX.CndnContrProcVar AS CndnContrProcVar,
  PersSettlmtDocDEX.FiscalPeriod AS FiscalPeriod,
  PersSettlmtDocDEX.SettlmtDateCat AS SettlmtDateCat,
  PersSettlmtDocDEX.ActualSettlmtDate AS ActualSettlmtDate,
  PersSettlmtDocDEX.SettlmtDateSequentialID AS SettlmtDateSequentialID,
  PersSettlmtDocDEX.SettlmtDate AS SettlmtDate,
  PersSettlmtDocDEX.PersSettlmtDocIncmpltnsRsn AS PersSettlmtDocIncmpltnsRsn,
  PersSettlmtDocDEX.SettlmtBusProcVar AS SettlmtBusProcVar,
  PersSettlmtDocDEX.SettlmtBusProcCat AS SettlmtBusProcCat,
  PersSettlmtDocDEX.TotalSettlmtQuantity AS TotalSettlmtQuantity,
  PersSettlmtDocDEX.TotalSettlmtQuantityUnit AS TotalSettlmtQuantityUnit,
  PersSettlmtDocDEX.TotalSettlmtNetWeight AS TotalSettlmtNetWeight,
  PersSettlmtDocDEX.TotalSettlmtGrossWeight AS TotalSettlmtGrossWeight,
  PersSettlmtDocDEX.TotalSettlmtWeightUnit AS TotalSettlmtWeightUnit,
  PersSettlmtDocDEX.TotalSettlmtVolume AS TotalSettlmtVolume,
  PersSettlmtDocDEX.TotalSettlmtVolumeUnit AS TotalSettlmtVolumeUnit,
  PersSettlmtDocDEX.SettlmtPeriodStartDate AS SettlmtPeriodStartDate,
  PersSettlmtDocDEX.SettlmtPeriodEndDate AS SettlmtPeriodEndDate,
  PersSettlmtDocDEX.CndnContrProcessCategory AS CndnContrProcessCategory,
  PersSettlmtDocDEX.PostingPartnerCat AS PostingPartnerCat,
  PersSettlmtDocDEX.JournalEntryCreationDate AS JournalEntryCreationDate,
  PersSettlmtDocDEX.JournalEntryCreationTime AS JournalEntryCreationTime,
  PersSettlmtDocDEX.SettlmtCompensationReason AS SettlmtCompensationReason,
  PersSettlmtDocDEX.SettlmtCompnVar AS SettlmtCompnVar,
  PersSettlmtDocDEX.Product AS Product,
  PersSettlmtDocDEX.ProductGroup AS ProductGroup,
  PersSettlmtDocDEX.Plant AS Plant,
  PersSettlmtDocDEX.PricingDate AS PricingDate,
  PersSettlmtDocDEX.SettlmtQuantity AS SettlmtQuantity,
  PersSettlmtDocDEX.SettlmtQuantityUnit AS SettlmtQuantityUnit,
  PersSettlmtDocDEX.NetPriceAmount AS NetPriceAmount,
  PersSettlmtDocDEX.NetPriceQuantity AS NetPriceQuantity,
  PersSettlmtDocDEX.NetPriceQuantityUnit AS NetPriceQuantityUnit,
  PersSettlmtDocDEX.SettlmtToBaseQuantityNmrtr AS SettlmtToBaseQuantityNmrtr,
  PersSettlmtDocDEX.SettlmtToBaseQuantityDnmntr AS SettlmtToBaseQuantityDnmntr,
  PersSettlmtDocDEX.SettlmtToNetPriceQtyNmrtr AS SettlmtToNetPriceQtyNmrtr,
  PersSettlmtDocDEX.SettlmtToNetPriceQtyDnmntr AS SettlmtToNetPriceQtyDnmntr,
  PersSettlmtDocDEX.BaseUnit AS BaseUnit,
  PersSettlmtDocDEX.ItemNetWeight AS ItemNetWeight,
  PersSettlmtDocDEX.ItemGrossWeight AS ItemGrossWeight,
  PersSettlmtDocDEX.ItemWeightUnit AS ItemWeightUnit,
  PersSettlmtDocDEX.ItemVolume AS ItemVolume,
  PersSettlmtDocDEX.ItemVolumeUnit AS ItemVolumeUnit,
  PersSettlmtDocDEX.PersSettlmtDocItemNetAmount AS PersSettlmtDocItemNetAmount,
  PersSettlmtDocDEX.PersSettlmtDocSubtotal1Amount AS PersSettlmtDocSubtotal1Amount,
  PersSettlmtDocDEX.PersSettlmtDocSubtotal2Amount AS PersSettlmtDocSubtotal2Amount,
  PersSettlmtDocDEX.PersSettlmtDocSubtotal3Amount AS PersSettlmtDocSubtotal3Amount,
  PersSettlmtDocDEX.PersSettlmtDocSubtotal4Amount AS PersSettlmtDocSubtotal4Amount,
  PersSettlmtDocDEX.PersSettlmtDocSubtotal5Amount AS PersSettlmtDocSubtotal5Amount,
  PersSettlmtDocDEX.PersSettlmtDocSubtotal6Amount AS PersSettlmtDocSubtotal6Amount,
  PersSettlmtDocDEX.PersSettlmtDocRbteBasisAmount AS PersSettlmtDocRbteBasisAmount,
  PersSettlmtDocDEX.PersSettlmtDocItmStstclPrpty AS PersSettlmtDocItmStstclPrpty,
  PersSettlmtDocDEX.PersSettlmtDocItmActyReason AS PersSettlmtDocItmActyReason,
  PersSettlmtDocDEX.PersSettlmtDocItemText AS PersSettlmtDocItemText,
  PersSettlmtDocDEX.BusinessArea AS BusinessArea,
  PersSettlmtDocDEX.ControllingArea AS ControllingArea,
  PersSettlmtDocDEX.CostCenter AS CostCenter,
  PersSettlmtDocDEX.ProfitCenter AS ProfitCenter,
  PersSettlmtDocDEX.WBSElementInternalID AS WBSElementInternalID,
  PersSettlmtDocDEX.PersSettlmtDocOrder AS PersSettlmtDocOrder,
  PersSettlmtDocDEX.PrcDetnIsIncmplt AS PrcDetnIsIncmplt,
  PersSettlmtDocDEX.PersSettlmtDocItemCat AS PersSettlmtDocItemCat,
  PersSettlmtDocDEX.SettlmtItemReltdCndnContr AS SettlmtItemReltdCndnContr,
  PersSettlmtDocDEX.PersSettlmtDocItemStatus AS PersSettlmtDocItemStatus,
  PersSettlmtDocDEX.PersSettlmtDocItemRvsd AS PersSettlmtDocItemRvsd,
  PersSettlmtDocDEX.ServicesRenderedDate AS ServicesRenderedDate,
  PersSettlmtDocDEX.SettlementFiscalYear AS SettlementFiscalYear,
  PersSettlmtDocDEX.GLAccount AS GLAccount,
  PersSettlmtDocDEX.ProductHierarchy AS ProductHierarchy,
  PersSettlmtDocDEX.SalesSpcfcProductGroup1 AS SalesSpcfcProductGroup1,
  PersSettlmtDocDEX.SalesSpcfcProductGroup2 AS SalesSpcfcProductGroup2,
  PersSettlmtDocDEX.SalesSpcfcProductGroup3 AS SalesSpcfcProductGroup3,
  PersSettlmtDocDEX.SalesSpcfcProductGroup4 AS SalesSpcfcProductGroup4,
  PersSettlmtDocDEX.SalesSpcfcProductGroup5 AS SalesSpcfcProductGroup5,
  PersSettlmtDocDEX.BusTransDocReferenceID AS BusTransDocReferenceID,
  PersSettlmtDocDEX.BusTransDocReferenceItemID AS BusTransDocReferenceItemID,
  PersSettlmtDocDEX._PersonWorkAgreement AS _PersonWorkAgreement
FROM R_PersSettlmtDocDEX AS PersSettlmtDocDEX
;