What is I_PersSettlmtDocItem in SAP S/4HANA?

I_PersSettlmtDocItem is a basic CDS view in SAP S/4HANA. Personnel Settlement Document Item It contains 89 fields.

Which tables does I_PersSettlmtDocItem read from?

I_PersSettlmtDocItem reads data from: R_PersSettlmtDocItem.

What VDM layer is I_PersSettlmtDocItem?

I_PersSettlmtDocItem is classified as a Basic (interface) view providing a 1:1 representation of a database table.

I_PersSettlmtDocItem

DDL: I_PERSSETTLMTDOCITEM Type: view BASIC

89 Fields 1 Data Sources 8 Associations

Personnel Settlement Document Item

I_PersSettlmtDocItem (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Sales

I_PersSettlmtDocItem is a Basic CDS View that provides data about "Personnel Settlement Document Item" in SAP S/4HANA. It reads from 1 data source (R_PersSettlmtDocItem) and exposes 89 fields with key fields PersonnelSettlementDocument, PersSettlmtDocItem. It has 8 associations to related views.

SAP Help Documentation

Category	Personnel Settlement Document

Purpose
This CDS view provides information about personnel settlement document items. This CDS view provides the data to answer the following business questions: What is the net amount of each item? What is the quantity that is allocated to each item? To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .

Prerequisites
Authorizations Users who want to run reports using this CDS view must have the authorization to display the following data: Authorization Object: W_WBRK_FKA Authorization required for Settlement Document Type ( LFART ) Authorization Object: W_WBRK_ORG Authorization required for the following: Company Code ( BUKRS ) Sales Organization ( VKORG ) Distribution Channel ( VTWEG ) Division ( SPART ) Authorization Object: W_WBRK_PER Authorization required for the following: Company Code ( BUKRS ) Personnel Cost Center ( KOSTL ) Authorization Object: B_BUPA_GRP Authorization group needs to be maintained for the following: Person Work Agreement ( Personnel Number )

Structure
Further Important Fields Important fields in this view include the following: Field Name Description PersonnelSettlementDocument Personnel Settlement Document Number PersSettlmtDocItem Personnel Settlement Document Item Number Product Product Plant Plant ItemNetAmount Item Net Amount SettlmtQuantity Settlement Quantity SettlmtQuantityUnit Unit of Measure of Settlement Quantity

View on SAP Help Portal →

SAP API Hub

State	C1
Line of Business	Sales
Application Component	LO-AB
Capabilities	Data Source in SQL Select, Association Target for Defining CDS Entities, Data Source for Defining CDS Entities
Package	Sales for SAP S/4HANA Cloud Private Edition
Description	<p>This CDS view provides information about personnel settlement document items.</p> <p>This CDS view provides the data to answer the following business questions:</p> <ul> <li><p>What is the net amount of each item?</p></li> <li><p>What is the quantity that is allocated to each item?</p></li> </ul> <p>To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views.</p>

Documentation

Analytics with CDS Views — Build Analytics for S/4HANA Cloud Private Edition ABAP CDS views replicated to SAP Cloud Platform
CDS Views on SAP Business Accelerator Hub — Explore SAP S/4HANA Cloud Private Edition Private Edition CDS Views on SAP Business Accelerator Hub
Create CDS View as API — Create CDS views in SAP S/4HANA Cloud Private Edition and consume them as APIs
Custom CDS Views — Access data using a Custom Core Data Service view (Custom CDS view)
Key User Extensibility Tools — The Key User Extensibility Tools of S/4HANA
SAP Extensibility Explorer for SAP S/4HANA Cloud Private Edition — Explore SAP S/4HANA Cloud Private Edition Extensibility options by leveraging the sample scenarios from SAP
SAP S/4HANA Extensibility — SAP S/4HANA Extensibility Tutorial
VDM View Types — The Virtual Data Model in SAP S/4HANA Cloud Private Edition
View Browser — Search, browse and tag CDS Views

Data Sources (1)

Source	Alias	Join Type
R_PersSettlmtDocItem	R_PersSettlmtDocItem	from

Associations (8)

Cardinality	Target	Alias	Condition
[1..1]	I_PersSettlmtDoc	_PersSettlmtDoc	`$projection.PersonnelSettlementDocument = _PersSettlmtDoc.PersonnelSettlementDocument`
[0..*]	I_PersSettlmtDocItmPrcgElmnt	_PersSettlmtDocItmPrcgElmnt	`$projection.PersonnelSettlementDocument = _PersSettlmtDocItmPrcgElmnt.PersonnelSettlementDocument and $projection.PersSettlmtDocItem = _PersSettlmtDocItmPrcgElmnt.PersSettlmtDocItem`
[0..*]	I_ProductText	_ProductText	`$projection.Product = _ProductText.Product`
[0..1]	I_SettlmtItmStatisticalPrpty	_SettlmtItmStatisticalPrpty	`$projection.SettlmtItmStatisticalPrpty = _SettlmtItmStatisticalPrpty.SettlmtItmStatisticalPrpty`
[0..1]	I_SettlmtActivityReasonCode	_SettlmtItemActivityReason	`$projection.SettlmtItemActivityReason = _SettlmtItemActivityReason.SettlmtActivityReason`
[0..*]	I_BusinessAreaText	_BusinessAreaText	`$projection.BusinessArea = _BusinessAreaText.BusinessArea`
[0..1]	I_ConditionContract	_SettlmtItemReltdCndnContr	`$projection.SettlmtItemReltdCndnContr = _SettlmtItemReltdCndnContr.ConditionContract`
[1..1]	E_SettlmtMgmtDocItem	_Extension	`$projection.PersonnelSettlementDocument = _Extension.SettlmtMgmtDoc and $projection.PersSettlmtDocItem = _Extension.SettlmtMgmtDocItem`

Annotations (16)

Name	Value	Level
AbapCatalog.sqlViewName	IWLFPERSMTDOCITM	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.preserveKey	true	view
EndUserText.label	Personnel Settlement Document Item	view
AccessControl.authorizationCheck	#MANDATORY	view
ObjectModel.representativeKey	PersSettlmtDocItem	view
ObjectModel.modelingPattern	#NONE	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
ObjectModel.usageType.serviceQuality	#B	view
ObjectModel.usageType.sizeCategory	#XXL	view
ClientHandling.type	#INHERITED	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
VDM.viewType	#BASIC	view
VDM.lifecycle.contract.type	#PUBLIC_LOCAL_API	view
Metadata.allowExtensions	false	view
Metadata.ignorePropagatedAnnotations	true	view

Fields (89)

Key	Field	Source Field	Description
KEY	PersonnelSettlementDocument	PersonnelSettlementDocument	Personnel Settlement Document Number
KEY	PersSettlmtDocItem	PersSettlmtDocItem	Document Item
	PersSettlmtDocCurrency	PersSettlmtDocCurrency	Currency of Settlement Document
	PricingDocument	PricingDocument	Number of the Document Condition
	Product	Product	Product Number
	ProductGroup	ProductGroup	Product Sold Group
	Plant	Plant	Valuation Area
	PricingDate	PricingDate	Date for Pricing and Exchange Rate
	SettlmtQuantity	SettlmtQuantity	Quantity of Settlement Management Document Item
	SettlmtQuantityUnit	SettlmtQuantityUnit	Unit of Measure of Settlement Management Doc Item Quantity
	NetPriceAmount	NetPriceAmount	Net Price in Document Currency
	NetPriceQuantity	NetPriceQuantity	Price Unit of Settlement Management Document Item
	NetPriceQuantityUnit	NetPriceQuantityUnit	Settlement Management Document Item Price Unit
	SettlmtToBaseQuantityNmrtr	SettlmtToBaseQuantityNmrtr	Numerator Converting Qty in Settlement Document to Base Unit
	SettlmtToBaseQuantityDnmntr	SettlmtToBaseQuantityDnmntr	Denominator Converting Qty in Settlement Doc. to Base Unit
	SettlmtToNetPriceQtyNmrtr	SettlmtToNetPriceQtyNmrtr	Numerator for Converting Settl. UoM to Settl. Price UoM
	SettlmtToNetPriceQtyDnmntr	SettlmtToNetPriceQtyDnmntr	Denominator for Converting Settl. UoM to Settl. Price UoM
	BaseUnit	BaseUnit	Base Unit of Measure
	ItemNetWeight	ItemNetWeight	Net Weight
	ItemGrossWeight	ItemGrossWeight	Gross Weight
	ItemWeightUnit	ItemWeightUnit	Unit of Weight
	ItemVolume	ItemVolume	Volume
	ItemVolumeUnit	ItemVolumeUnit	Volume Unit
	ItemNetAmount	PersSettlmtDocItemNetAmount	Net Amount of Item in Document Currency
	Subtotal1Amount	PersSettlmtDocSubtotal1Amount	Subtotal 1 Amount
	Subtotal2Amount	PersSettlmtDocSubtotal2Amount	Subtotal 2 Amount
	Subtotal3Amount	PersSettlmtDocSubtotal3Amount	Subtotal 3 Amount
	Subtotal4Amount	PersSettlmtDocSubtotal4Amount	Subtotal 4 Amount
	Subtotal5Amount	PersSettlmtDocSubtotal5Amount	Subtotal 5 Amount
	Subtotal6Amount	PersSettlmtDocSubtotal6Amount	Subtotal 6 Amount
	RebateBasisAmount	PersSettlmtDocRbteBasisAmount	Rebate Basis Amount
	SettlmtItmStatisticalPrpty	PersSettlmtDocItmStstclPrpty	Statistical Property of Settlement Management Item
	CreatedByUser	CreatedByUser	Name of User who Created the Document
	CreationDate	CreationDate	Date of Document Creation
	CreationTime	CreationTime	Time of Document Creation
	SettlmtItemActivityReason	PersSettlmtDocItmActyReason	Activity Reason for Document Creation
	PersSettlmtDocItemText	PersSettlmtDocItemText	Short Text
	BusinessArea	BusinessArea	Business Area
	ControllingArea	ControllingArea	Controlling Area
	CostCenter	CostCenter	Cost Center
	ProfitCenter	ProfitCenter	Profit Center
	WBSElementInternalID	WBSElementInternalID	Work Breakdown Structure Element (WBS Element) not converted
	SettlementOrder	PersSettlmtDocOrder	Order for Account Assignment in Settlement Management
	PrcDetnIsIncmplt	PrcDetnIsIncmplt	Price Determination Is Incomplete
	PersSettlmtDocItemCat	PersSettlmtDocItemCat	Item Category
	SettlmtItemReltdCndnContr	SettlmtItemReltdCndnContr	Related Condition Contract of a Settlement Management Item
	PersSettlmtDocItemStatus	PersSettlmtDocItemStatus	Item Status
	PersSettlmtDocItemRvsd	PersSettlmtDocItemRvsd	Item Was Canceled
	ServicesRenderedDate	ServicesRenderedDate	Date of Services Rendered
	SettlementFiscalYear	SettlementFiscalYear	Fiscal Year of Settlement
	CompanyCode	CompanyCode	Receiver Company Code
	GLAccount	GLAccount	General Ledger
	ProductHierarchy	ProductHierarchy	Product 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
	BusTransDocReferenceID	BusTransDocReferenceID	BusinessTransactionDocumentID
	BusTransDocReferenceItemID	BusTransDocReferenceItemID	BusinessTransactionDocumentItemID
	PersSettlmtDocItemChangeState	PersSettlmtDocItemChangeState	Change State of a Settlement Management Document Item
	_PersSettlmtDoc	_PersSettlmtDoc
	_PersSettlmtDocItmPrcgElmnt	_PersSettlmtDocItmPrcgElmnt
	_PersSettlmtDocCurrency	_PersSettlmtDocCurrency
	_Product	_Product
	_ProductText	_ProductText
	_Plant	_Plant
	_SettlmtQuantityUnit	_SettlmtQuantityUnit
	_NetPriceQuantityUnit	_NetPriceQuantityUnit
	_BaseUnit	_BaseUnit
	_ItemWeightUnit	_ItemWeightUnit
	_ItemVolumeUnit	_ItemVolumeUnit
	_SettlmtItmStatisticalPrpty	_SettlmtItmStatisticalPrpty
	_SettlmtItemActivityReason	_SettlmtItemActivityReason
	_BusinessArea	_BusinessArea
	_BusinessAreaText	_BusinessAreaText
	_ControllingArea	_ControllingArea
	_WBSElementBasicData	_WBSElementBasicData
	_PersSettlmtDocItemCat	_PersSettlmtDocItemCat
	_SettlmtItemReltdCndnContr	_SettlmtItemReltdCndnContr
	_PersSettlmtDocItemStatus	_PersSettlmtDocItemStatus
	_PersSettlmtDocItemRvsd	_PersSettlmtDocItemRvsd
	_CompanyCode	_CompanyCode
	_GLAccountInCompanyCode	_GLAccountInCompanyCode
	_SalesSpcfcProductGroup1	_SalesSpcfcProductGroup1
	_SalesSpcfcProductGroup2	_SalesSpcfcProductGroup2
	_SalesSpcfcProductGroup3	_SalesSpcfcProductGroup3
	_SalesSpcfcProductGroup4	_SalesSpcfcProductGroup4
	_SalesSpcfcProductGroup5	_SalesSpcfcProductGroup5

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 I_PersSettlmtDocItem.
-- 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 I_PersSettlmtDocItem AS
SELECT
  PersonnelSettlementDocument,
  PersSettlmtDocItem,
  PersSettlmtDocCurrency,
  PricingDocument,
  Product,
  ProductGroup,
  Plant,
  PricingDate,
  SettlmtQuantity,
  SettlmtQuantityUnit,
  NetPriceAmount,
  NetPriceQuantity,
  NetPriceQuantityUnit,
  SettlmtToBaseQuantityNmrtr,
  SettlmtToBaseQuantityDnmntr,
  SettlmtToNetPriceQtyNmrtr,
  SettlmtToNetPriceQtyDnmntr,
  BaseUnit,
  ItemNetWeight,
  ItemGrossWeight,
  ItemWeightUnit,
  ItemVolume,
  ItemVolumeUnit,
  PersSettlmtDocItemNetAmount AS ItemNetAmount,
  PersSettlmtDocSubtotal1Amount AS Subtotal1Amount,
  PersSettlmtDocSubtotal2Amount AS Subtotal2Amount,
  PersSettlmtDocSubtotal3Amount AS Subtotal3Amount,
  PersSettlmtDocSubtotal4Amount AS Subtotal4Amount,
  PersSettlmtDocSubtotal5Amount AS Subtotal5Amount,
  PersSettlmtDocSubtotal6Amount AS Subtotal6Amount,
  PersSettlmtDocRbteBasisAmount AS RebateBasisAmount,
  PersSettlmtDocItmStstclPrpty AS SettlmtItmStatisticalPrpty,
  CreatedByUser,
  CreationDate,
  CreationTime,
  PersSettlmtDocItmActyReason AS SettlmtItemActivityReason,
  PersSettlmtDocItemText,
  BusinessArea,
  ControllingArea,
  CostCenter,
  ProfitCenter,
  WBSElementInternalID,
  PersSettlmtDocOrder AS SettlementOrder,
  PrcDetnIsIncmplt,
  PersSettlmtDocItemCat,
  SettlmtItemReltdCndnContr,
  PersSettlmtDocItemStatus,
  PersSettlmtDocItemRvsd,
  ServicesRenderedDate,
  SettlementFiscalYear,
  CompanyCode,
  GLAccount,
  ProductHierarchy,
  SalesSpcfcProductGroup1,
  SalesSpcfcProductGroup2,
  SalesSpcfcProductGroup3,
  SalesSpcfcProductGroup4,
  SalesSpcfcProductGroup5,
  BusTransDocReferenceID,
  BusTransDocReferenceItemID,
  PersSettlmtDocItemChangeState
FROM R_PersSettlmtDocItem
LEFT OUTER JOIN I_PersSettlmtDoc AS _PersSettlmtDoc ON PersonnelSettlementDocument = _PersSettlmtDoc.PersonnelSettlementDocument  -- association [1..1]
LEFT OUTER JOIN I_PersSettlmtDocItmPrcgElmnt AS _PersSettlmtDocItmPrcgElmnt ON PersonnelSettlementDocument = _PersSettlmtDocItmPrcgElmnt.PersonnelSettlementDocument AND PersSettlmtDocItem = _PersSettlmtDocItmPrcgElmnt.PersSettlmtDocItem  -- association [0..*]
LEFT OUTER JOIN I_ProductText AS _ProductText ON Product = _ProductText.Product  -- association [0..*]
LEFT OUTER JOIN I_SettlmtItmStatisticalPrpty AS _SettlmtItmStatisticalPrpty ON SettlmtItmStatisticalPrpty = _SettlmtItmStatisticalPrpty.SettlmtItmStatisticalPrpty  -- association [0..1]
LEFT OUTER JOIN I_SettlmtActivityReasonCode AS _SettlmtItemActivityReason ON SettlmtItemActivityReason = _SettlmtItemActivityReason.SettlmtActivityReason  -- association [0..1]
LEFT OUTER JOIN I_BusinessAreaText AS _BusinessAreaText ON BusinessArea = _BusinessAreaText.BusinessArea  -- association [0..*]
LEFT OUTER JOIN I_ConditionContract AS _SettlmtItemReltdCndnContr ON SettlmtItemReltdCndnContr = _SettlmtItemReltdCndnContr.ConditionContract  -- association [0..1]
LEFT OUTER JOIN E_SettlmtMgmtDocItem AS _Extension ON PersonnelSettlementDocument = _Extension.SettlmtMgmtDoc AND PersSettlmtDocItem = _Extension.SettlmtMgmtDocItem  -- association [1..1]
;

Depth:

I_PersSettlmtDocItem view

R_PersSettlmtDocItem view