What is C_PersSettlmtDoc_F4964 in SAP S/4HANA?

C_PersSettlmtDoc_F4964 is a consumption CDS view in SAP S/4HANA. Personnel Settlement Documents for Internal Commissions It contains 111 fields.

Which tables does C_PersSettlmtDoc_F4964 read from?

C_PersSettlmtDoc_F4964 reads data from: R_PersSettlmtDocTP.

What VDM layer is C_PersSettlmtDoc_F4964?

C_PersSettlmtDoc_F4964 is classified as a Consumption view optimized for specific business scenarios and reporting.

C_PersSettlmtDoc_F4964

DDL: C_PERSSETTLMTDOC_F4964 Type: view_entity CONSUMPTION

111 Fields 1 Data Sources 1 OData Services

Personnel Settlement Documents for Internal Commissions

C_PersSettlmtDoc_F4964 is a Consumption CDS View that provides data about "Personnel Settlement Documents for Internal Commissions" in SAP S/4HANA. It reads from 1 data source (R_PersSettlmtDocTP) and exposes 111 fields with key field PersonnelSettlementDocument. It is exposed through 1 OData service (UI_LO_SETMAN_CC_SETDATES).

Data Sources (1)

Source	Alias	Join Type
R_PersSettlmtDocTP	R_PersSettlmtDocTP	projection

Annotations (10)

Name	Value	Level
EndUserText.label	Personnel Settlement Documents for Internal Commissions	view
AccessControl.authorizationCheck	#MANDATORY	view
Metadata.allowExtensions	true	view
Metadata.ignorePropagatedAnnotations	true	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.dataClass	#MIXED	view
ObjectModel.usageType.sizeCategory	#XXL	view
VDM.viewType	#CONSUMPTION	view
VDM.lifecycle.contract.type	#NONE	view
Search.searchable	true	view

OData Services (1)

Service	Binding	Version	Contract	Release
UI_LO_SETMAN_CC_SETDATES	UI_LO_SETMAN_CC_SETDATES	V4	C1	NOT_RELEASED

Fields (111)

Key	Field	Source Table	Source Field	Description
KEY	PersonnelSettlementDocument		PersonnelSettlementDocument	Personnel Settlement Document
	SettlmtDocType		SettlmtDocType	Settlement Document Type
	SettlmtDocTypeDesclocalized
	SettlmtDocCat		SettlmtDocCat	Settlement Document Category
	SettlmtDocCatNamelocalized
	SettlmtProcessType		SettlmtProcessType	Settlement Process Type
	SettlmtProcessTypeDesclocalized
	SettlmtProcessCat		SettlmtProcessCat	Settlement Process Category
	SettlmtProcessCatNamelocalized
	LogisticsDataEntryCat		LogisticsDataEntryCat	Entry Category
	LogisticsDataEntryCatNamelocalized
	PricingProcedure		PricingProcedure	Procedure
	PostingDate		PostingDate	Posting Date for GR
	PersSettlmtAcctgTransfSts		PersSettlmtAcctgTransfSts	Posting Status
	PersSettlmtAcctgTransfStsNamelocalized
	SalesOrganization		SalesOrganization	Sales Organization
	SalesOrganizationNamelocalized
	DistributionChannel		DistributionChannel	RefDistCh-Cust/Mat.
	Division		Division	Internal Division ID
	DivisionNameasDivisionNamelocalized
	CompanyCode		CompanyCode	Receiver Company Code
	CompanyCodeName	_CompanyCode	CompanyCodeName	Company Name
	PricingDocument		PricingDocument	Document Condition
	CreatedByUser		CreatedByUser	User Name
	CreatedByUserFullName
	DocumentDate		DocumentDate	Journal Entry Date
	DocumentReferenceID		DocumentReferenceID	Reference
	AssignmentReference		AssignmentReference	Assignment Reference
	PersSettlmtDocCurrency		PersSettlmtDocCurrency	Doc. Currency
	CurrencyNamelocalized
	PersSettlmtDocIsReversed		PersSettlmtDocIsReversed	Document Is Reversed
	RvsdPersSettlmtDoc		RvsdPersSettlmtDoc	Reversed Document
	PersSettlmtDocActivityReason		PersSettlmtDocActivityReason	Header Document Creation Activity Reason
	SettlmtActivityReasonDesclocalized
	PaymentReference		PaymentReference	Payment Reference
	SettlmtApplSts		SettlmtApplSts	Appl. Status
	SettlmtApplStsDesclocalized
	SalesOffice		SalesOffice	Sales Office
	SalesOfficeNamelocalized
	SalesGroup		SalesGroup	Sales Group
	SalesGroupNamelocalized
	SettlmtReltdCndnContr		SettlmtReltdCndnContr	Related Condition Contract
	CndnContrType		CndnContrType	Contract Type
	CndnContrTypeDesclocalized
	SettlmtDate		SettlmtDate	Settlement Date
	SettlmtDateCat		SettlmtDateCat	Settlement Date Type
	SettlmtDateCatNamelocalized
	ActualSettlmtDate		ActualSettlmtDate	Actual Settl. Date
	SettlmtDateSequentialID		SettlmtDateSequentialID	Settlement Date ID
	PersSettlmtDocIncmpltnsRsn		PersSettlmtDocIncmpltnsRsn	Incomplete Rsn
	SettlmtBusProcCat		SettlmtBusProcCat	Use Case Type
	SettlmtBusProcCatNamelocalized
	TotalSettlmtQuantityUnit		TotalSettlmtQuantityUnit	UoM Total Quantity
	TotalSettlmtWeightUnit		TotalSettlmtWeightUnit	UoW Total Weight
	TotalSettlmtVolumeUnit		TotalSettlmtVolumeUnit	Unit Total Volume
	PostingPartnerCat		PostingPartnerCat	Posting Partner
	PostingPartnerCatNamelocalized
	SettlmtPeriodStartDate		SettlmtPeriodStartDate	Start Date of Period
	SettlmtPeriodEndDate		SettlmtPeriodEndDate	End Date of Period
	CndnContrProcessCategory		CndnContrProcessCategory	Process Category
	CndnContrProcessCategoryDesclocalized
	SettlmtApplStsGrp		SettlmtApplStsGrp	Status Group
	SettlmtApplStsGrpDesclocalized
	PersonWorkAgreement		PersonWorkAgreement	Personnel No.
	PersonFullName	_PersonWorkAgreement	PersonFullName	Full Name
	PersonnelCostCenter		PersonnelCostCenter	Worker Cost Center
	CostCenterDescriptionlocalized
	PersonnelControllingArea		PersonnelControllingArea	Worker Controlling Area
	SettlmtCompensationReason		SettlmtCompensationReason	Compensation Reason
	SettlmtCompnRsnDesclocalized
	FiscalPeriod		FiscalPeriod	Tax period
	JournalEntryCreationDate		JournalEntryCreationDate	Journal Entry Creation Date
	JournalEntryCreationTime		JournalEntryCreationTime	Journal Entry Creation Time
	SettlmtCompnVar		SettlmtCompnVar	Compensation Variant
	SettlmtCompnVarDesclocalized
	ControllingArea	_CompanyCode	ControllingArea	Controlling Area
	virtualFiscalYearfis_gjahr_no_conv
	virtualJournalEntryfarp_belnr_d
	TotalNetAmount		TotalNetAmount	Total Net Amount
	_CndnContrProcessCategory		_CndnContrProcessCategory
	_CndnContrType		_CndnContrType
	_CompanyCode		_CompanyCode
	_CreatedByUser		_CreatedByUser
	_DistributionChannel		_DistributionChannel
	_Division		_Division
	_LogisticsDataEntryCat		_LogisticsDataEntryCat
	_PersonWorkAgreement		_PersonWorkAgreement
	_PersSettlmtAcctgTransfSts		_PersSettlmtAcctgTransfSts
	_PersSettlmtDocCurrency		_PersSettlmtDocCurrency
	_PersSettlmtDocIncmpltnsRsn		_PersSettlmtDocIncmpltnsRsn
	_PersSettlmtDocItem		_PersSettlmtDocItem
	_PostingPartnerCat		_PostingPartnerCat
	_RvsdPersSettlmtDoc		_RvsdPersSettlmtDoc
	_SalesArea		_SalesArea
	_SalesGroup		_SalesGroup
	_SalesOffice		_SalesOffice
	_SalesOrganization		_SalesOrganization
	_SettlmtApplSts		_SettlmtApplSts
	_SettlmtApplStsGrp		_SettlmtApplStsGrp
	_SettlmtApplStsGrpStsAssgmt		_SettlmtApplStsGrpStsAssgmt
	_SettlmtBusProcCat		_SettlmtBusProcCat
	_SettlmtCompnVar		_SettlmtCompnVar
	_SettlmtDateCat		_SettlmtDateCat
	_SettlmtDocCat		_SettlmtDocCat
	_SettlmtDocType		_SettlmtDocType
	_SettlmtProcessCat		_SettlmtProcessCat
	_SettlmtProcessType		_SettlmtProcessType
	_SettlmtReltdCndnContr		_SettlmtReltdCndnContr
	_TotalSettlmtQuantityUnit		_TotalSettlmtQuantityUnit
	_TotalSettlmtVolumeUnit		_TotalSettlmtVolumeUnit
	_TotalSettlmtWeightUnit		_TotalSettlmtWeightUnit

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_F4964.
-- 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_F4964 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,
  PricingProcedure,
  PostingDate,
  PersSettlmtAcctgTransfSts,
  _PersSettlmtAcctgTransfSts._Text.PersSettlmtAcctgTransfStsName : localized AS PersSettlmtAcctgTransfStsNamelocalized,
  SalesOrganization,
  _SalesOrganization._Text.SalesOrganizationName : localized AS SalesOrganizationNamelocalized,
  DistributionChannel,
  Division,
  _Division._Text.DivisionName as DivisionName : localized AS DivisionNameasDivisionNamelocalized,
  CompanyCode,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  PricingDocument,
  CreatedByUser,
  cast( _CreatedByUser.UserDescription as wlf_created_by_fullname preserving type ) AS CreatedByUserFullName,
  DocumentDate,
  DocumentReferenceID,
  AssignmentReference,
  PersSettlmtDocCurrency,
  _PersSettlmtDocCurrency._Text.CurrencyName : localized AS CurrencyNamelocalized,
  PersSettlmtDocIsReversed,
  RvsdPersSettlmtDoc,
  PersSettlmtDocActivityReason,
  _PersSettlmtDocActivityReason._Text.SettlmtActivityReasonDesc : localized AS SettlmtActivityReasonDesclocalized,
  PaymentReference,
  SettlmtApplSts,
  _SettlmtApplSts._Text.SettlmtApplStsDesc : localized AS SettlmtApplStsDesclocalized,
  SalesOffice,
  _SalesOffice._Text.SalesOfficeName : localized AS SalesOfficeNamelocalized,
  SalesGroup,
  _SalesGroup._Text.SalesGroupName : localized AS SalesGroupNamelocalized,
  SettlmtReltdCndnContr,
  CndnContrType,
  _CndnContrType._Text.CndnContrTypeDesc : localized AS CndnContrTypeDesclocalized,
  SettlmtDate,
  SettlmtDateCat,
  _SettlmtDateCat._Text.SettlmtDateCatName : localized AS SettlmtDateCatNamelocalized,
  ActualSettlmtDate,
  SettlmtDateSequentialID,
  PersSettlmtDocIncmpltnsRsn,
  SettlmtBusProcCat,
  _SettlmtBusProcCat._Text.SettlmtBusProcCatName : localized AS SettlmtBusProcCatNamelocalized,
  TotalSettlmtQuantityUnit,
  TotalSettlmtWeightUnit,
  TotalSettlmtVolumeUnit,
  PostingPartnerCat,
  _PostingPartnerCat._Text.PostingPartnerCatName : localized AS PostingPartnerCatNamelocalized,
  SettlmtPeriodStartDate,
  SettlmtPeriodEndDate,
  CndnContrProcessCategory,
  _CndnContrProcessCategory._Text.CndnContrProcessCategoryDesc : localized AS CndnContrProcessCategoryDesclocalized,
  SettlmtApplStsGrp,
  _SettlmtApplStsGrp._Text.SettlmtApplStsGrpDesc : localized AS SettlmtApplStsGrpDesclocalized,
  PersonWorkAgreement,
  _PersonWorkAgreement.PersonFullName AS PersonFullName,
  PersonnelCostCenter,
  _PersonnelCostCenter._Text.CostCenterDescription : localized AS CostCenterDescriptionlocalized,
  PersonnelControllingArea,
  SettlmtCompensationReason,
  _SettlmtCompensationReason._Text.SettlmtCompnRsnDesc : localized AS SettlmtCompnRsnDesclocalized,
  FiscalPeriod,
  JournalEntryCreationDate,
  JournalEntryCreationTime,
  SettlmtCompnVar,
  _SettlmtCompnVar._Text.SettlmtCompnVarDesc : localized AS SettlmtCompnVarDesclocalized,
  _CompanyCode.ControllingArea AS ControllingArea,
  virtual FiscalYear : fis_gjahr_no_conv AS virtualFiscalYearfis_gjahr_no_conv,
  virtual JournalEntry : farp_belnr_d AS virtualJournalEntryfarp_belnr_d,
  TotalNetAmount
FROM R_PersSettlmtDocTP
;

Depth:

C_PersSettlmtDoc_F4964 view_entity

R_PersSettlmtDocTP view_entity