C_MntrPersSettlmtDoc
Monitor Personnel Settlement Documents (obsolete)
C_MntrPersSettlmtDoc is a Consumption CDS View that provides data about "Monitor Personnel Settlement Documents (obsolete)" in SAP S/4HANA. It reads from 1 data source (R_PersSettlmtDoc) and exposes 78 fields with key field PersonnelSettlementDocument.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| R_PersSettlmtDoc | PersSettlmtDoc | from |
Annotations (8)
| Name | Value | Level | Field |
|---|---|---|---|
| EndUserText.label | Monitor Personnel Settlement Documents (obsolete) | view | |
| AccessControl.authorizationCheck | #MANDATORY | view | |
| ObjectModel.usageType.serviceQuality | #C | view | |
| ObjectModel.usageType.dataClass | #MIXED | view | |
| ObjectModel.usageType.sizeCategory | #XXL | view | |
| VDM.viewType | #CONSUMPTION | view | |
| Metadata.allowExtensions | true | view | |
| Metadata.ignorePropagatedAnnotations | true | view |
Fields (78)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | PersonnelSettlementDocument | R_PersSettlmtDoc | PersonnelSettlementDocument | Personnel Settlement Document |
| SettlmtDocType | R_PersSettlmtDoc | SettlmtDocType | Settlement Document Type | |
| SettlmtDocCat | R_PersSettlmtDoc | SettlmtDocCat | Settlement Document Category | |
| SettlmtProcessType | R_PersSettlmtDoc | SettlmtProcessType | Settlement Process Type | |
| SettlmtProcessCat | R_PersSettlmtDoc | SettlmtProcessCat | Settlement Process Category | |
| DocumentDate | R_PersSettlmtDoc | DocumentDate | Journal Entry Date | |
| PostingDate | R_PersSettlmtDoc | PostingDate | Posting Date for GR | |
| FiscalPeriod | R_PersSettlmtDoc | FiscalPeriod | Tax period | |
| PersSettlmtAcctgTransfSts | R_PersSettlmtDoc | PersSettlmtAcctgTransfSts | Posting Status | |
| PersonWorkAgreement | R_PersSettlmtDoc | PersonWorkAgreement | Personnel No. | |
| SalesOrganization | R_PersSettlmtDoc | SalesOrganization | Sales Organization | |
| DistributionChannel | R_PersSettlmtDoc | DistributionChannel | RefDistCh-Cust/Mat. | |
| Division | R_PersSettlmtDoc | Division | Internal Division ID | |
| CompanyCode | R_PersSettlmtDoc | CompanyCode | Receiver Company Code | |
| PersonnelCostCenter | R_PersSettlmtDoc | PersonnelCostCenter | Worker Cost Center | |
| PersonnelControllingArea | R_PersSettlmtDoc | PersonnelControllingArea | Worker Controlling Area | |
| CreatedByUser | R_PersSettlmtDoc | CreatedByUser | User Name | |
| CreationDate | R_PersSettlmtDoc | CreationDate | Time Stamp | |
| CreationTime | R_PersSettlmtDoc | CreationTime | Time of Change | |
| LastChangeDate | R_PersSettlmtDoc | LastChangeDate | Time Stamp | |
| PaymentReference | R_PersSettlmtDoc | PaymentReference | Payment Reference | |
| DocumentReferenceID | R_PersSettlmtDoc | DocumentReferenceID | Reference | |
| AssignmentReference | R_PersSettlmtDoc | AssignmentReference | Assignment Reference | |
| PersSettlmtDocCurrency | R_PersSettlmtDoc | PersSettlmtDocCurrency | Doc. Currency | |
| ExchangeRate | R_PersSettlmtDoc | ExchangeRate | Exchange rate | |
| ExchangeRateType | R_PersSettlmtDoc | ExchangeRateType | Exch. Rate Type | |
| ExchangeRateIsFixed | R_PersSettlmtDoc | ExchangeRateIsFixed | Fixed Exch.Rate | |
| ExchangeRateDate | R_PersSettlmtDoc | ExchangeRateDate | Translatn Date | |
| PersSettlmtDocIsReversed | R_PersSettlmtDoc | PersSettlmtDocIsReversed | Document Is Reversed | |
| RvsdPersSettlmtDoc | R_PersSettlmtDoc | RvsdPersSettlmtDoc | Reversed Document | |
| SettlmtApplStsGrp | R_PersSettlmtDoc | SettlmtApplStsGrp | Status Group | |
| SettlmtApplSts | R_PersSettlmtDoc | SettlmtApplSts | Appl. Status | |
| PersSettlmtDocActivityReason | R_PersSettlmtDoc | PersSettlmtDocActivityReason | Header Document Creation Activity Reason | |
| SettlmtCompensationReason | R_PersSettlmtDoc | SettlmtCompensationReason | Compensation Reason | |
| SettlmtCompnVar | R_PersSettlmtDoc | SettlmtCompnVar | Compensation Variant | |
| ActualSettlmtDate | R_PersSettlmtDoc | ActualSettlmtDate | Actual Settl. Date | |
| SettlmtDate | R_PersSettlmtDoc | SettlmtDate | Settlement Date | |
| SettlmtBusProcCat | R_PersSettlmtDoc | SettlmtBusProcCat | Use Case Type | |
| JournalEntryCreationDate | R_PersSettlmtDoc | JournalEntryCreationDate | Journal Entry Creation Date | |
| JournalEntryCreationTime | R_PersSettlmtDoc | JournalEntryCreationTime | Journal Entry Creation Time | |
| SettlmtReltdCndnContr | ||||
| CndnContrType | R_PersSettlmtDoc | CndnContrType | Contract Type | |
| CndnContrProcessCategory | R_PersSettlmtDoc | CndnContrProcessCategory | Process Category | |
| SettlmtDateCat | R_PersSettlmtDoc | SettlmtDateCat | Settlement Date Type | |
| CndnContrProcVar | R_PersSettlmtDoc | CndnContrProcVar | Process Variant | |
| SettlmtBusProcVar | R_PersSettlmtDoc | SettlmtBusProcVar | Proc. Category | |
| _CompanyCode | R_PersSettlmtDoc | _CompanyCode | ||
| _CreatedByUser | R_PersSettlmtDoc | _CreatedByUser | ||
| _DistributionChannel | R_PersSettlmtDoc | _DistributionChannel | ||
| _Division | R_PersSettlmtDoc | _Division | ||
| _ExchangeRateType | R_PersSettlmtDoc | _ExchangeRateType | ||
| _PersSettlmtDocItem | R_PersSettlmtDoc | _PersSettlmtDocItem | ||
| _PersonWorkAgreement | R_PersSettlmtDoc | _PersonWorkAgreement | ||
| _PersSettlmtAcctgTransfSts | R_PersSettlmtDoc | _PersSettlmtAcctgTransfSts | ||
| _PersSettlmtDocCurrency | R_PersSettlmtDoc | _PersSettlmtDocCurrency | ||
| _PersSettlmtDocPrcgElmnt | R_PersSettlmtDoc | _PersSettlmtDocPrcgElmnt | ||
| _RvsdPersSettlmtDoc | R_PersSettlmtDoc | _RvsdPersSettlmtDoc | ||
| _SalesArea | R_PersSettlmtDoc | _SalesArea | ||
| _SalesOrganization | R_PersSettlmtDoc | _SalesOrganization | ||
| _SettlmtApplSts | R_PersSettlmtDoc | _SettlmtApplSts | ||
| _SettlmtApplStsGrp | R_PersSettlmtDoc | _SettlmtApplStsGrp | ||
| _SettlmtApplStsGrpStsAssgmt | R_PersSettlmtDoc | _SettlmtApplStsGrpStsAssgmt | ||
| _SettlmtBusProcCat | R_PersSettlmtDoc | _SettlmtBusProcCat | ||
| _SettlmtCompensationReason | R_PersSettlmtDoc | _SettlmtCompensationReason | ||
| _PersSettlmtDocActivityReason | R_PersSettlmtDoc | _PersSettlmtDocActivityReason | ||
| _SettlmtDocCat | R_PersSettlmtDoc | _SettlmtDocCat | ||
| _SettlmtDocType | R_PersSettlmtDoc | _SettlmtDocType | ||
| _SettlmtProcessCat | R_PersSettlmtDoc | _SettlmtProcessCat | ||
| _SettlmtProcessType | R_PersSettlmtDoc | _SettlmtProcessType | ||
| _SettlmtReltdCndnContr | R_PersSettlmtDoc | _SettlmtReltdCndnContr | ||
| _CndnContrType | R_PersSettlmtDoc | _CndnContrType | ||
| _CndnContrProcessCategory | R_PersSettlmtDoc | _CndnContrProcessCategory | ||
| _SettlmtCompnVar | R_PersSettlmtDoc | _SettlmtCompnVar | ||
| _SettlmtDateCat | R_PersSettlmtDoc | _SettlmtDateCat | ||
| _CndnContrProcVar | R_PersSettlmtDoc | _CndnContrProcVar | ||
| _SettlmtBusProcVar | R_PersSettlmtDoc | _SettlmtBusProcVar | ||
| _PersonnelCostCenter | R_PersSettlmtDoc | _PersonnelCostCenter | ||
| _PersonnelControllingArea | R_PersSettlmtDoc | _PersonnelControllingArea |
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_MntrPersSettlmtDoc.
-- 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_MntrPersSettlmtDoc AS
SELECT
PersSettlmtDoc.PersonnelSettlementDocument AS PersonnelSettlementDocument,
PersSettlmtDoc.SettlmtDocType AS SettlmtDocType,
PersSettlmtDoc.SettlmtDocCat AS SettlmtDocCat,
PersSettlmtDoc.SettlmtProcessType AS SettlmtProcessType,
PersSettlmtDoc.SettlmtProcessCat AS SettlmtProcessCat,
PersSettlmtDoc.DocumentDate AS DocumentDate,
PersSettlmtDoc.PostingDate AS PostingDate,
PersSettlmtDoc.FiscalPeriod AS FiscalPeriod,
PersSettlmtDoc.PersSettlmtAcctgTransfSts AS PersSettlmtAcctgTransfSts,
PersSettlmtDoc.PersonWorkAgreement AS PersonWorkAgreement,
PersSettlmtDoc.SalesOrganization AS SalesOrganization,
PersSettlmtDoc.DistributionChannel AS DistributionChannel,
PersSettlmtDoc.Division AS Division,
PersSettlmtDoc.CompanyCode AS CompanyCode,
PersSettlmtDoc.PersonnelCostCenter AS PersonnelCostCenter,
PersSettlmtDoc.PersonnelControllingArea AS PersonnelControllingArea,
PersSettlmtDoc.CreatedByUser AS CreatedByUser,
PersSettlmtDoc.CreationDate AS CreationDate,
PersSettlmtDoc.CreationTime AS CreationTime,
PersSettlmtDoc.LastChangeDate AS LastChangeDate,
PersSettlmtDoc.PaymentReference AS PaymentReference,
PersSettlmtDoc.DocumentReferenceID AS DocumentReferenceID,
PersSettlmtDoc.AssignmentReference AS AssignmentReference,
PersSettlmtDoc.PersSettlmtDocCurrency AS PersSettlmtDocCurrency,
PersSettlmtDoc.ExchangeRate AS ExchangeRate,
PersSettlmtDoc.ExchangeRateType AS ExchangeRateType,
PersSettlmtDoc.ExchangeRateIsFixed AS ExchangeRateIsFixed,
PersSettlmtDoc.ExchangeRateDate AS ExchangeRateDate,
PersSettlmtDoc.PersSettlmtDocIsReversed AS PersSettlmtDocIsReversed,
PersSettlmtDoc.RvsdPersSettlmtDoc AS RvsdPersSettlmtDoc,
PersSettlmtDoc.SettlmtApplStsGrp AS SettlmtApplStsGrp,
PersSettlmtDoc.SettlmtApplSts AS SettlmtApplSts,
PersSettlmtDoc.PersSettlmtDocActivityReason AS PersSettlmtDocActivityReason,
PersSettlmtDoc.SettlmtCompensationReason AS SettlmtCompensationReason,
PersSettlmtDoc.SettlmtCompnVar AS SettlmtCompnVar,
PersSettlmtDoc.ActualSettlmtDate AS ActualSettlmtDate,
PersSettlmtDoc.SettlmtDate AS SettlmtDate,
PersSettlmtDoc.SettlmtBusProcCat AS SettlmtBusProcCat,
PersSettlmtDoc.JournalEntryCreationDate AS JournalEntryCreationDate,
PersSettlmtDoc.JournalEntryCreationTime AS JournalEntryCreationTime,
cast( PersSettlmtDoc.SettlmtReltdCndnContr as wcb_coco_num preserving type ) AS SettlmtReltdCndnContr,
PersSettlmtDoc.CndnContrType AS CndnContrType,
PersSettlmtDoc.CndnContrProcessCategory AS CndnContrProcessCategory,
PersSettlmtDoc.SettlmtDateCat AS SettlmtDateCat,
PersSettlmtDoc.CndnContrProcVar AS CndnContrProcVar,
PersSettlmtDoc.SettlmtBusProcVar AS SettlmtBusProcVar,
PersSettlmtDoc._CompanyCode AS _CompanyCode,
PersSettlmtDoc._CreatedByUser AS _CreatedByUser,
PersSettlmtDoc._DistributionChannel AS _DistributionChannel,
PersSettlmtDoc._Division AS _Division,
PersSettlmtDoc._ExchangeRateType AS _ExchangeRateType,
PersSettlmtDoc._PersSettlmtDocItem AS _PersSettlmtDocItem,
PersSettlmtDoc._PersonWorkAgreement AS _PersonWorkAgreement,
PersSettlmtDoc._PersSettlmtAcctgTransfSts AS _PersSettlmtAcctgTransfSts,
PersSettlmtDoc._PersSettlmtDocCurrency AS _PersSettlmtDocCurrency,
PersSettlmtDoc._PersSettlmtDocPrcgElmnt AS _PersSettlmtDocPrcgElmnt,
PersSettlmtDoc._RvsdPersSettlmtDoc AS _RvsdPersSettlmtDoc,
PersSettlmtDoc._SalesArea AS _SalesArea,
PersSettlmtDoc._SalesOrganization AS _SalesOrganization,
PersSettlmtDoc._SettlmtApplSts AS _SettlmtApplSts,
PersSettlmtDoc._SettlmtApplStsGrp AS _SettlmtApplStsGrp,
PersSettlmtDoc._SettlmtApplStsGrpStsAssgmt AS _SettlmtApplStsGrpStsAssgmt,
PersSettlmtDoc._SettlmtBusProcCat AS _SettlmtBusProcCat,
PersSettlmtDoc._SettlmtCompensationReason AS _SettlmtCompensationReason,
PersSettlmtDoc._PersSettlmtDocActivityReason AS _PersSettlmtDocActivityReason,
PersSettlmtDoc._SettlmtDocCat AS _SettlmtDocCat,
PersSettlmtDoc._SettlmtDocType AS _SettlmtDocType,
PersSettlmtDoc._SettlmtProcessCat AS _SettlmtProcessCat,
PersSettlmtDoc._SettlmtProcessType AS _SettlmtProcessType,
PersSettlmtDoc._SettlmtReltdCndnContr AS _SettlmtReltdCndnContr,
PersSettlmtDoc._CndnContrType AS _CndnContrType,
PersSettlmtDoc._CndnContrProcessCategory AS _CndnContrProcessCategory,
PersSettlmtDoc._SettlmtCompnVar AS _SettlmtCompnVar,
PersSettlmtDoc._SettlmtDateCat AS _SettlmtDateCat,
PersSettlmtDoc._CndnContrProcVar AS _CndnContrProcVar,
PersSettlmtDoc._SettlmtBusProcVar AS _SettlmtBusProcVar,
PersSettlmtDoc._PersonnelCostCenter AS _PersonnelCostCenter,
PersSettlmtDoc._PersonnelControllingArea AS _PersonnelControllingArea
FROM R_PersSettlmtDoc AS PersSettlmtDoc
;Learn More
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- CDS View Annotations — A Complete Guide
- What Is a CDS View in SAP S/4HANA?
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- BW Extractor to CDS View Migration Guide
- S/4HANA CDS View Deprecation: What You Need to Know
- ABAP CDS View Tutorial — From Basics to Real-World Examples
- RAP and CDS Views — Building Transactional Apps in SAP S/4HANA
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA