I_PersSettlmtDocItemTP

DDL: I_PERSSETTLMTDOCITEMTP Type: view_entity TRANSACTIONAL Package: WLF_API_A2A_PSDOC_BO
58 Fields 1 Data Sources

Personnel Settlement Document Item - TP

I_PersSettlmtDocItemTP is a Transactional CDS View that provides data about "Personnel Settlement Document Item - TP" in SAP S/4HANA. It reads from 1 data source (R_PersSettlmtDocItemTP) and exposes 58 fields with key fields PersonnelSettlementDocument, PersSettlmtDocItem. Part of development package WLF_API_A2A_PSDOC_BO.

Data Sources (1)

SourceAliasJoin Type
R_PersSettlmtDocItemTP R_PersSettlmtDocItemTP projection

Annotations (16)

NameValueLevelField
EndUserText.label Personnel Settlement Document Item - TP view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
ObjectModel.sapObjectNodeType.name PersSettlementDocumentItem view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.modelingPattern #TRANSACTIONAL_INTERFACE view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions false view
AbapCatalog.extensibility.extensible true view
AbapCatalog.extensibility.elementSuffix SMI view
AbapCatalog.extensibility.quota.maximumFields 170 view
AbapCatalog.extensibility.quota.maximumBytes 3400 view

Fields (58)

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
ProductGroup ProductGroup Product Sold Group
Plant Plant Valuation Area
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
CreatedByUser CreatedByUser User Name
CreationDate CreationDate Time Stamp
CreationTime CreationTime Time of Change
PersSettlmtDocItmActyReason PersSettlmtDocItmActyReason Activity Reason
PersSettlmtDocItemText PersSettlmtDocItemText Short Text
BusinessArea BusinessArea Business Area
ControllingArea ControllingArea Controlling Area
CostCenter CostCenter Cost Center
ProfitCenter ProfitCenter Profit Center
WBSElementInternalID WBSElementInternalID WBS Internal ID
PersSettlmtDocOrder PersSettlmtDocOrder Order Acct Assgmt
PrcDetnIsIncmplt PrcDetnIsIncmplt Price Determination Is Incomplete
PersSettlmtDocItemCat PersSettlmtDocItemCat Item Category
PersSettlmtDocItemStatus PersSettlmtDocItemStatus Status
PersSettlmtDocItemRvsd PersSettlmtDocItemRvsd Item Canceled
ServicesRenderedDate ServicesRenderedDate Services Rendered Date
SettlementFiscalYear SettlementFiscalYear Fiscal Year of Settlement
CompanyCode CompanyCode Receiver Company Code
GLAccount GLAccount General Ledger
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 Item Ref. Doc.
BusTransDocReferenceItemID BusTransDocReferenceItemID Item RefItemID

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_PersSettlmtDocItemTP.
-- 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_PersSettlmtDocItemTP 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,
  ItemNetAmount,
  Subtotal1Amount,
  Subtotal2Amount,
  Subtotal3Amount,
  Subtotal4Amount,
  Subtotal5Amount,
  Subtotal6Amount,
  RebateBasisAmount,
  PersSettlmtDocItmStstclPrpty,
  CreatedByUser,
  CreationDate,
  CreationTime,
  PersSettlmtDocItmActyReason,
  PersSettlmtDocItemText,
  BusinessArea,
  ControllingArea,
  CostCenter,
  ProfitCenter,
  WBSElementInternalID,
  PersSettlmtDocOrder,
  PrcDetnIsIncmplt,
  PersSettlmtDocItemCat,
  PersSettlmtDocItemStatus,
  PersSettlmtDocItemRvsd,
  ServicesRenderedDate,
  SettlementFiscalYear,
  CompanyCode,
  GLAccount,
  SalesSpcfcProductGroup1,
  SalesSpcfcProductGroup2,
  SalesSpcfcProductGroup3,
  SalesSpcfcProductGroup4,
  SalesSpcfcProductGroup5,
  BusTransDocReferenceID,
  BusTransDocReferenceItemID
FROM R_PersSettlmtDocItemTP
;

Learn More