C_PersSettlmtDoc_F5084

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_PersSettlmtDoc_F5084.
-- 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_PersSettlmtDoc_F5084 AS
SELECT
  PersonnelSettlementDocument,
  SettlmtDocType,
  _SettlmtDocType._Text.SettlmtDocTypeDesc : localized AS SettlmtDocTypeDesclocalized,
  SettlmtDocCat,
  _SettlmtDocCat._Text.SettlmtDocCatName : localized AS SettlmtDocCatNamelocalized,
  SettlmtProcessType,
  _SettlmtProcessType._Text.SettlmtProcessTypeDesc : localized AS SettlmtProcessTypeDesclocalized,
  SettlmtProcessCat,
  _SettlmtProcessCat._Text.SettlmtProcessCatName : localized AS SettlmtProcessCatNamelocalized,
  LogisticsDataEntryCat,
  _LogisticsDataEntryCat._Text.LogisticsDataEntryCatName : localized AS LogisticsDataEntryCatNamelocalized,
  PostingDate,
  PersSettlmtAcctgTransfSts,
  _PersSettlmtAcctgTransfSts._Text.PersSettlmtAcctgTransfStsName : localized AS PersSettlmtAcctgTransfStsNamelocalized,
  DocumentDate,
  DocumentReferenceID,
  AssignmentReference,
  SettlmtApplSts,
  _SettlmtApplSts._Text.SettlmtApplStsDesc : localized AS SettlmtApplStsDesclocalized,
  SettlmtApplStsGrp,
  _SettlmtApplStsGrp._Text.SettlmtApplStsGrpDesc : localized AS SettlmtApplStsGrpDesclocalized,
  PricingProcedure,
  PricingDocument,
  PersonWorkAgreement,
  _PersonWorkAgreement.PersonFullName AS PersonFullName,
  PersonnelCostCenter,
  _PersonnelCostCenter._Text.CostCenterDescription : localized AS CostCenterDescriptionlocalized,
  PersonnelControllingArea,
  PersonnelSettlementDocument._PersonnelControllingArea.ControllingAreaName AS ControllingAreaName,
  CompanyCode,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  SalesOrganization,
  _SalesOrganization._Text.SalesOrganizationName : localized AS SalesOrganizationNamelocalized,
  DistributionChannel,
  _DistributionChannel._Text.DistributionChannelName : localized AS DistributionChannelNamelocalized,
  Division,
  _Division._Text.DivisionName : localized AS DivisionNamelocalized,
  SalesOffice,
  _SalesOffice._Text.SalesOfficeName : localized AS SalesOfficeNamelocalized,
  SalesGroup,
  _SalesGroup._Text.SalesGroupName : localized AS SalesGroupNamelocalized,
  CreatedByUser,
  cast( _CreatedByUser.UserDescription as wlf_created_by_fullname preserving type ) AS CreatedByUserFullName,
  CreationDate,
  CreationTime,
  LastChangeDate,
  PersSettlmtDocCurrency,
  _PersSettlmtDocCurrency._Text.CurrencyName : localized AS CurrencyNamelocalized,
  ExchangeRate,
  ExchangeRateType,
  _ExchangeRateType._Text.ExchangeRateTypeName : localized AS ExchangeRateTypeNamelocalized,
  ExchangeRateIsFixed,
  ExchangeRateDate,
  TotalNetAmount,
  PersSettlmtDocIsReversed,
  RvsdPersSettlmtDoc,
  PersSettlmtDocActivityReason,
  _PersSettlmtDocActivityReason._Text.SettlmtActivityReasonDesc : localized AS SettlmtActivityReasonDesclocalized,
  PaymentReference,
  CndnContrType,
  _CndnContrType._Text.CndnContrTypeDesc : localized AS CndnContrTypeDesclocalized,
  SettlmtReltdCndnContr,
  CndnContrProcVar,
  _CndnContrProcVar._Text.CndnContrProcVarDesc : localized AS CndnContrProcVarDesclocalized,
  _SettlmtReltdCndnContr.CndnContrActvtnStatus AS CndnContrActvtnStatus,
  _SettlmtReltdCndnContr._CndnContrActvtnStatus._Text.CndnContrActvtnStatusName : localized AS CndnContrActvtnStatusNamelocalized,
  FiscalPeriod,
  SettlmtDateCat,
  ActualSettlmtDate,
  SettlmtDateSequentialID,
  SettlmtDate,
  PersSettlmtDocIncmpltnsRsn,
  _PersSettlmtDocIncmpltnsRsn._Text.SettlmtMgmtDocIncmpltnsRsnDesc : localized AS SettlmtMgmtDocIncmpltnsRsnDesclocalized,
  _SettlmtReltdCndnContr.ExternalDocumentReferenceID AS ExternalDocumentReferenceID,
  SettlmtBusProcVar,
  _SettlmtBusProcVar._Text.SettlmtBusProcVarDesc : localized AS SettlmtBusProcVarDesclocalized,
  SettlmtBusProcCat,
  _SettlmtBusProcCat._Text.SettlmtBusProcCatName : localized AS SettlmtBusProcCatNamelocalized,
  TotalSettlmtQuantity,
  TotalSettlmtQuantityUnit,
  TotalSettlmtNetWeight,
  TotalSettlmtGrossWeight,
  TotalSettlmtWeightUnit,
  TotalSettlmtVolume,
  TotalSettlmtVolumeUnit,
  SettlmtPeriodStartDate,
  SettlmtPeriodEndDate,
  CndnContrProcessCategory,
  _CndnContrProcessCategory._Text.CndnContrProcessCategoryDesc : localized AS CndnContrProcessCategoryDesclocalized,
  PostingPartnerCat,
  _PostingPartnerCat._Text.PostingPartnerCatName : localized AS PostingPartnerCatNamelocalized,
  SettlmtCompensationReason,
  _SettlmtCompensationReason._Text.SettlmtCompnRsnDesc : localized AS SettlmtCompnRsnDesclocalized,
  SettlmtCompnVar,
  _SettlmtCompnVar._Text.SettlmtCompnVarDesc : localized AS SettlmtCompnVarDesclocalized,
  ApplElmntBehaviorGrp,
  JournalEntryCreationDate,
  JournalEntryCreationTime,
  PersSettlmtDocChangeState,
  virtual ChangeDocObject : char90 AS virtualChangeDocObjectchar90,
  virtual JournalEntry : farp_belnr_d AS virtualJournalEntryfarp_belnr_d,
  virtual FiscalYear : fis_gjahr_no_conv AS virtualFiscalYearfis_gjahr_no_conv,
  virtual UICT_HDR_Status : boolean AS virtualUICT_HDR_Statusboolean,
  virtual UICT_HDR_Accounting : boolean AS virtualUICT_HDR_Accountingboolean,
  virtual UICT_HDR_Amount : boolean AS virtualUICT_HDR_Amountboolean,
  virtual UICT_COLL_GEN_INFO : boolean AS virtualUICT_COLL_GEN_INFOboolean,
  virtual UICT_COLL_BASIC_DATA : boolean AS virtualUICT_COLL_BASIC_DATAboolean,
  virtual UICT_FLDGRP_SETTLMT_DETS : boolean AS virtualUICT_FLDGRP_SETTLMT_DETSboolean,
  virtual UICT_FLDGRP_PROC_DETS : boolean AS virtualUICT_FLDGRP_PROC_DETSboolean,
  virtual UICT_FLDGRP_REV_INFO : boolean AS virtualUICT_FLDGRP_REV_INFOboolean,
  virtual UICT_FLDGRP_REF_INFO : boolean AS virtualUICT_FLDGRP_REF_INFOboolean,
  virtual UICT_COLL_CRCY_POSTG : boolean AS virtualUICT_COLL_CRCY_POSTGboolean,
  virtual UICT_FLDGRP_CRCY_INFO : boolean AS virtualUICT_FLDGRP_CRCY_INFOboolean,
  virtual UICT_FLDGRP_DATES : boolean AS virtualUICT_FLDGRP_DATESboolean,
  virtual UICT_COLL_ADMIN : boolean AS virtualUICT_COLL_ADMINboolean,
  virtual UICT_FLDGRP_ORG_SLS : boolean AS virtualUICT_FLDGRP_ORG_SLSboolean,
  virtual UICT_FLDGRP_ADMIN : boolean AS virtualUICT_FLDGRP_ADMINboolean,
  virtual UICT_COLL_ACC_INFO : boolean AS virtualUICT_COLL_ACC_INFOboolean,
  virtual UICT_FLDGRP_JRNL_ENTRIES : boolean AS virtualUICT_FLDGRP_JRNL_ENTRIESboolean,
  virtual UICT_COLL_CNDN_CONTR : boolean AS virtualUICT_COLL_CNDN_CONTRboolean,
  virtual UICT_FLDGRP_CNDN_CONTR : boolean AS virtualUICT_FLDGRP_CNDN_CONTRboolean,
  virtual UICT_LNITM_Prcg_Elmnt : boolean AS virtualUICT_LNITM_Prcg_Elmntboolean
FROM R_PersSettlmtDocTP
LEFT OUTER JOIN C_PersSetlDocPrgElm_F5084 AS _PersSetlDocPrcgElmnt ON PersonnelSettlementDocument = _PersSetlDocPrcgElmnt.PersonnelSettlementDocument  -- association [0..*]
;