C_PersSettlmtDocOPgItem

DDL: C_PERSSETTLMTDOCOPGITEM Type: view_entity CONSUMPTION
93 Fields 1 Data Sources

Personnel Settlement Document Object Page Item

C_PersSettlmtDocOPgItem is a Consumption CDS View that provides data about "Personnel Settlement Document Object Page Item" in SAP S/4HANA. It reads from 1 data source (R_PersSettlmtDocItemTP) and exposes 93 fields with key fields PersonnelSettlementDocument, PersSettlmtDocItem.

Data Sources (1)

SourceAliasJoin Type
R_PersSettlmtDocItemTP R_PersSettlmtDocItemTP projection

Annotations (9)

NameValueLevelField
EndUserText.label Personnel Settlement Document Object Page Item view
AccessControl.authorizationCheck #MANDATORY view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #NONE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #XXL view

Fields (93)

KeyFieldSource TableSource FieldDescription
KEY PersonnelSettlementDocument PersonnelSettlementDocument Personnel Settlement Document
KEY PersSettlmtDocItem PersSettlmtDocItem Item
PersSettlmtDocCurrency PersSettlmtDocCurrency Doc. Currency
PricingDocument PricingDocument Document Condition
Product Product Product Sold
ProductNamelocalized
ProductGroup ProductGroup Product Sold Group
ProductGroupNamelocalized
Plant Plant Valuation Area
PlantName _Plant PlantName Plant Name
PricingDate PricingDate Pricing Date
SettlmtQuantity SettlmtQuantity SettlmtQuantity
SettlmtQuantityUnit SettlmtQuantityUnit Settlement Unit
NetPriceAmount NetPriceAmount Net Price
NetPriceQuantity NetPriceQuantity Price Unit
NetPriceQuantityUnit NetPriceQuantityUnit SettlmtPrcUnit
SettlmtToBaseQuantityNmrtr SettlmtToBaseQuantityNmrtr Numerator Settlement UoM to Base UoM
SettlmtToBaseQuantityDnmntr SettlmtToBaseQuantityDnmntr Denominator Settlement UoM to Base UoM
SettlmtToNetPriceQtyNmrtr SettlmtToNetPriceQtyNmrtr Numerator: Sett. UoM to Sett. Price UoM
SettlmtToNetPriceQtyDnmntr SettlmtToNetPriceQtyDnmntr Denominator: Sett. UoM to Sett. PriceUoM
BaseUnit BaseUnit Unit of Measure
ItemNetWeight ItemNetWeight Net Weight
ItemGrossWeight ItemGrossWeight Gross Weight
ItemWeightUnit ItemWeightUnit Unit of Weight
ItemVolume ItemVolume Volume
ItemVolumeUnit ItemVolumeUnit Volume Unit
ItemNetAmount ItemNetAmount Tot. val. rel.
Subtotal1Amount Subtotal1Amount Subtotal 1 Amount
Subtotal2Amount Subtotal2Amount Subtotal 2 Amount
Subtotal3Amount Subtotal3Amount Subtotal 3 Amount
Subtotal4Amount Subtotal4Amount Subtotal 4 Amount
Subtotal5Amount Subtotal5Amount Subtotal 5 Amount
Subtotal6Amount Subtotal6Amount Subtotal 6 Amount
RebateBasisAmount RebateBasisAmount Rebate Basis Amount
PersSettlmtDocItmStstclPrpty PersSettlmtDocItmStstclPrpty Statistical Prpty
SettlmtItmStatisticalPrptyNamelocalized
CreatedByUser CreatedByUser User Name
CreationDate CreationDate Time Stamp
CreationTime CreationTime Time of Change
PersSettlmtDocItmActyReason PersSettlmtDocItmActyReason Activity Reason
SettlmtActivityReasonDesclocalized
PersSettlmtDocItemText PersSettlmtDocItemText Short Text
BusinessArea BusinessArea Business Area
BusinessAreaNamelocalized
ControllingArea ControllingArea Controlling Area
ControllingAreaName _ControllingArea ControllingAreaName Long Text
CostCenter CostCenter Cost Center
ProfitCenter ProfitCenter Profit Center
PrcDetnIsIncmplt PrcDetnIsIncmplt Price Determination Is Incomplete
PersSettlmtDocItemCat PersSettlmtDocItemCat Item Category
SettlmtItemReltdCndnContr SettlmtItemReltdCndnContr ItmRelatedCndnContr
PersSettlmtDocItemStatus PersSettlmtDocItemStatus Status
PersSettlmtDocItemRvsd PersSettlmtDocItemRvsd Item Canceled
PersSettlmtDocOrder PersSettlmtDocOrder Order Acct Assgmt
ServicesRenderedDate ServicesRenderedDate Services Rendered Date
CompanyCode CompanyCode Receiver Company Code
CompanyCodeName _CompanyCode CompanyCodeName Company Name
GLAccount GLAccount General Ledger
GLAccountLongNamelocalized
SettlementFiscalYear SettlementFiscalYear Fiscal Year of Settlement
WBSElementInternalID WBSElementInternalID WBS Internal ID
BusTransDocReferenceID BusTransDocReferenceID Item Ref. Doc.
BusTransDocReferenceItemID BusTransDocReferenceItemID Item RefItemID
ProductHierarchy ProductHierarchy Prod.hierarchy
SalesSpcfcProductGroup1 SalesSpcfcProductGroup1 Sales-Specific Product Group 1
SalesSpcfcProductGroup2 SalesSpcfcProductGroup2 Sales-Specific Product Group 2
SalesSpcfcProductGroup3 SalesSpcfcProductGroup3 Sales-Specific Product Group 3
SalesSpcfcProductGroup4 SalesSpcfcProductGroup4 Sales-Specific Product Group 4
SalesSpcfcProductGroup5 SalesSpcfcProductGroup5 Sales-Specific Product Group 5
_BaseUnit _BaseUnit
_BusinessArea _BusinessArea
_CompanyCode _CompanyCode
_ControllingArea _ControllingArea
_GLAccountInCompanyCode _GLAccountInCompanyCode
_ItemVolumeUnit _ItemVolumeUnit
_ItemWeightUnit _ItemWeightUnit
_NetPriceQuantityUnit _NetPriceQuantityUnit
_PersSettlmtDocCurrency _PersSettlmtDocCurrency
_PersSettlmtDocItemCat _PersSettlmtDocItemCat
_PersSettlmtDocItemRvsd _PersSettlmtDocItemRvsd
_PersSettlmtDocItemStatus _PersSettlmtDocItemStatus
_Plant _Plant
_Product _Product
_SalesSpcfcProductGroup1 _SalesSpcfcProductGroup1
_SalesSpcfcProductGroup2 _SalesSpcfcProductGroup2
_SalesSpcfcProductGroup3 _SalesSpcfcProductGroup3
_SalesSpcfcProductGroup4 _SalesSpcfcProductGroup4
_SalesSpcfcProductGroup5 _SalesSpcfcProductGroup5
_PersSettlmtDocItmActyReason _PersSettlmtDocItmActyReason
_SettlmtItemReltdCndnContr _SettlmtItemReltdCndnContr
_PersSettlmtDocItmStstclPrpty _PersSettlmtDocItmStstclPrpty
_SettlmtQuantityUnit _SettlmtQuantityUnit
_WBSElementBasicData _WBSElementBasicData

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_PersSettlmtDocOPgItem.
-- 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_PersSettlmtDocOPgItem AS
SELECT
  PersonnelSettlementDocument,
  PersSettlmtDocItem,
  PersSettlmtDocCurrency,
  PricingDocument,
  Product,
  _Product._Text.ProductName : localized AS ProductNamelocalized,
  ProductGroup,
  _ProductGroup._ProductGroupText.ProductGroupName : localized AS ProductGroupNamelocalized,
  Plant,
  _Plant.PlantName AS PlantName,
  PricingDate,
  SettlmtQuantity,
  SettlmtQuantityUnit,
  NetPriceAmount,
  NetPriceQuantity,
  NetPriceQuantityUnit,
  SettlmtToBaseQuantityNmrtr,
  SettlmtToBaseQuantityDnmntr,
  SettlmtToNetPriceQtyNmrtr,
  SettlmtToNetPriceQtyDnmntr,
  BaseUnit,
  ItemNetWeight,
  ItemGrossWeight,
  ItemWeightUnit,
  ItemVolume,
  ItemVolumeUnit,
  ItemNetAmount,
  Subtotal1Amount,
  Subtotal2Amount,
  Subtotal3Amount,
  Subtotal4Amount,
  Subtotal5Amount,
  Subtotal6Amount,
  RebateBasisAmount,
  PersSettlmtDocItmStstclPrpty,
  _PersSettlmtDocItmStstclPrpty._Text.SettlmtItmStatisticalPrptyName : localized AS SettlmtItmStatisticalPrptyNamelocalized,
  CreatedByUser,
  CreationDate,
  CreationTime,
  PersSettlmtDocItmActyReason,
  _PersSettlmtDocItmActyReason._Text.SettlmtActivityReasonDesc : localized AS SettlmtActivityReasonDesclocalized,
  PersSettlmtDocItemText,
  BusinessArea,
  _BusinessArea._Text.BusinessAreaName : localized AS BusinessAreaNamelocalized,
  ControllingArea,
  _ControllingArea.ControllingAreaName AS ControllingAreaName,
  CostCenter,
  ProfitCenter,
  PrcDetnIsIncmplt,
  PersSettlmtDocItemCat,
  SettlmtItemReltdCndnContr,
  PersSettlmtDocItemStatus,
  PersSettlmtDocItemRvsd,
  PersSettlmtDocOrder,
  ServicesRenderedDate,
  CompanyCode,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  GLAccount,
  _GLAccountInCompanyCode._Text.GLAccountLongName : localized AS GLAccountLongNamelocalized,
  SettlementFiscalYear,
  WBSElementInternalID,
  BusTransDocReferenceID,
  BusTransDocReferenceItemID,
  ProductHierarchy,
  SalesSpcfcProductGroup1,
  SalesSpcfcProductGroup2,
  SalesSpcfcProductGroup3,
  SalesSpcfcProductGroup4,
  SalesSpcfcProductGroup5
FROM R_PersSettlmtDocItemTP
;

Learn More