C_PersSettlmtDocItem_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_PersSettlmtDocItem_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_PersSettlmtDocItem_F5084 AS
SELECT
  PersonnelSettlementDocument,
  PersSettlmtDocItem,
  PersSettlmtDocItemText,
  PersSettlmtDocCurrency,
  PricingDocument,
  Product,
  ProductGroup,
  _ProductGroup._ProductGroupText.ProductGroupName : localized AS ProductGroupNamelocalized,
  Plant,
  _Plant.PlantName AS PlantName,
  PricingDate,
  SettlmtQuantity,
  SettlmtQuantityUnit,
  NetPriceAmount,
  NetPriceQuantity,
  NetPriceQuantityUnit,
  BaseUnit,
  ItemNetWeight,
  ItemGrossWeight,
  ItemWeightUnit,
  ItemVolume,
  ItemVolumeUnit,
  ItemNetAmount,
  Subtotal1Amount,
  Subtotal2Amount,
  Subtotal3Amount,
  Subtotal4Amount,
  Subtotal5Amount,
  Subtotal6Amount,
  RebateBasisAmount,
  PersSettlmtDocItmStstclPrpty,
  _PersSettlmtDocItmStstclPrpty._Text.SettlmtItmStatisticalPrptyName : localized AS SettlmtItmStatisticalPrptyNamelocalized,
  CreatedByUser,
  _CreatedByUser.UserDescription AS CreatedByUserFullName,
  CreationDate,
  CreationTime,
  PersSettlmtDocItmActyReason,
  _PersSettlmtDocItmActyReason._Text.SettlmtActivityReasonDesc : localized AS SettlmtActivityReasonDesclocalized,
  BusinessArea,
  _BusinessArea._Text.BusinessAreaName : localized AS BusinessAreaNamelocalized,
  ControllingArea,
  _ControllingArea.ControllingAreaName AS ControllingAreaName,
  CostCenter,
  _CostCenter._Text.CostCenterDescription : localized AS CostCenterDescriptionlocalized,
  ProfitCenter,
  _ProfitCenter._Text.ProfitCenterLongName : localized AS ProfitCenterLongNamelocalized,
  WBSElementInternalID,
  _WBSElementBasicData.WBSDescription AS WBSDescription,
  PersSettlmtDocOrder,
  _PersSettlmtDocOrder.InternalOrderDescription AS InternalOrderDescription,
  PrcDetnIsIncmplt,
  PersSettlmtDocItemCat,
  _PersSettlmtDocItemCat._Text.SettlmtMgmtDocItemCatName : localized AS SettlmtMgmtDocItemCatNamelocalized,
  PersSettlmtDocItemStatus,
  _PersSettlmtDocItemStatus._Text.SettlmtMgmtDocItemStatusName : localized AS SettlmtMgmtDocItemStatusNamelocalized,
  PersSettlmtDocItemRvsd,
  _PersSettlmtDocItemRvsd._Text.SettlmtMgmtDocItemCancldName : localized AS SettlmtMgmtDocItemCancldNamelocalized,
  ServicesRenderedDate,
  CompanyCode,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  GLAccount,
  _GLAccountInCompanyCode._Text.GLAccountLongName : localized AS GLAccountLongNamelocalized,
  SettlementFiscalYear,
  BusTransDocReferenceID,
  BusTransDocReferenceItemID,
  ProductHierarchy,
  SalesSpcfcProductGroup1,
  SalesSpcfcProductGroup2,
  SalesSpcfcProductGroup3,
  SalesSpcfcProductGroup4,
  SalesSpcfcProductGroup5,
  _PersSettlmtDoc.SettlmtDocType AS SettlmtDocType,
  _PersSettlmtDoc.ApplElmntBehaviorGrp AS ApplElmntBehaviorGrp,
  _PersSettlmtDoc.CndnContrProcessCategory AS CndnContrProcessCategory,
  virtual UICT_HDR_STATUS : boolean AS virtualUICT_HDR_STATUSboolean,
  virtual UICT_HDR_PRODUCTINFO : boolean AS virtualUICT_HDR_PRODUCTINFOboolean,
  virtual UICT_HDR_ITEMNETAMOUNT : boolean AS virtualUICT_HDR_ITEMNETAMOUNTboolean,
  virtual UICT_HDR_BUSTRANSDOCREFID : boolean AS virtualUICT_HDR_BUSTRANSDOCREFIDboolean,
  virtual UICT_COLL_GENERALINFO : boolean AS virtualUICT_COLL_GENERALINFOboolean,
  virtual UICT_FLDGRP_BASICDATA : boolean AS virtualUICT_FLDGRP_BASICDATAboolean,
  virtual UICT_COLL_SETTLMTDATA : boolean AS virtualUICT_COLL_SETTLMTDATAboolean,
  virtual UICT_FLDGRP_PRODUCTDATA : boolean AS virtualUICT_FLDGRP_PRODUCTDATAboolean,
  virtual UICT_FLDGRP_VOLUMEWEIGHT : boolean AS virtualUICT_FLDGRP_VOLUMEWEIGHTboolean,
  virtual UICT_COLL_ACCOUNTING : boolean AS virtualUICT_COLL_ACCOUNTINGboolean,
  virtual UICT_LNITM_PRCG_ELMNT : boolean AS virtualUICT_LNITM_PRCG_ELMNTboolean
FROM R_PersSettlmtDocItemTP
LEFT OUTER JOIN C_PersSetlDocItmPrgElm_F5084 AS _PersSetlDocItmPrcgElmnt ON PersonnelSettlementDocument = _PersSetlDocItmPrcgElmnt.PersonnelSettlementDocument AND PersSettlmtDocItem = _PersSetlDocItmPrcgElmnt.PersSettlmtDocItem  -- association [0..*]
;