C_PersSettlmtDoc_F3808
Manage Personnel Settlement Documents
C_PersSettlmtDoc_F3808 is a Consumption CDS View that provides data about "Manage Personnel Settlement Documents" in SAP S/4HANA. It reads from 1 data source (R_PersSettlmtDocTP) and exposes 124 fields with key field PersonnelSettlementDocument.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| R_PersSettlmtDocTP | R_PersSettlmtDocTP | projection |
Annotations (11)
| Name | Value | Level | Field |
|---|---|---|---|
| EndUserText.label | Manage Personnel Settlement Documents | view | |
| AccessControl.authorizationCheck | #MANDATORY | view | |
| ObjectModel.usageType.serviceQuality | #C | view | |
| ObjectModel.usageType.dataClass | #MIXED | view | |
| ObjectModel.usageType.sizeCategory | #XXL | view | |
| ObjectModel.representativeKey | PersonnelSettlementDocument | view | |
| VDM.viewType | #CONSUMPTION | view | |
| VDM.lifecycle.contract.type | #NONE | view | |
| Metadata.allowExtensions | true | view | |
| Metadata.ignorePropagatedAnnotations | true | view | |
| Search.searchable | true | view |
Fields (124)
| 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 | ||||
| PostingDate | PostingDate | Posting Date for GR | ||
| PersSettlmtAcctgTransfSts | PersSettlmtAcctgTransfSts | Posting Status | ||
| PersSettlmtAcctgTransfStsNamelocalized | ||||
| DocumentDate | DocumentDate | Journal Entry Date | ||
| DocumentReferenceID | DocumentReferenceID | Reference | ||
| AssignmentReference | AssignmentReference | Assignment Reference | ||
| SettlmtApplSts | SettlmtApplSts | Appl. Status | ||
| SettlmtApplStsForFilter | SettlmtApplSts | Appl. Status | ||
| SettlmtApplStsDesclocalized | ||||
| SettlmtApplStsGrp | SettlmtApplStsGrp | Status Group | ||
| SettlmtApplStsGrpDesclocalized | ||||
| PricingProcedure | PricingProcedure | Procedure | ||
| PricingDocument | PricingDocument | Document Condition | ||
| PersonWorkAgreement | PersonWorkAgreement | Personnel No. | ||
| PersonFullName | _PersonWorkAgreement | PersonFullName | Full Name | |
| PersonnelCostCenter | PersonnelCostCenter | Worker Cost Center | ||
| CostCenterDescriptionlocalized | ||||
| PersonnelControllingArea | PersonnelControllingArea | Worker Controlling Area | ||
| CompanyCode | CompanyCode | Receiver Company Code | ||
| CompanyCodeName | _CompanyCode | CompanyCodeName | Company Name | |
| SalesOrganization | SalesOrganization | Sales Organization | ||
| SalesOrganizationNamelocalized | ||||
| DistributionChannel | DistributionChannel | RefDistCh-Cust/Mat. | ||
| DistributionChannelNamelocalized | ||||
| Division | Division | Internal Division ID | ||
| DivisionNamelocalized | ||||
| SalesOffice | SalesOffice | Sales Office | ||
| SalesOfficeNamelocalized | ||||
| SalesGroup | SalesGroup | Sales Group | ||
| SalesGroupNamelocalized | ||||
| CreatedByUser | CreatedByUser | User Name | ||
| CreatedByUserFullName | ||||
| CreationDate | CreationDate | Time Stamp | ||
| CreationTime | CreationTime | Time of Change | ||
| LastChangeDate | LastChangeDate | Time Stamp | ||
| PersSettlmtDocCurrency | PersSettlmtDocCurrency | Doc. Currency | ||
| CurrencyNamelocalized | ||||
| ExchangeRate | ExchangeRate | Exchange rate | ||
| ExchangeRateType | ExchangeRateType | Exch. Rate Type | ||
| ExchangeRateTypeNamelocalized | ||||
| ExchangeRateIsFixed | ExchangeRateIsFixed | Fixed Exch.Rate | ||
| ExchangeRateDate | ExchangeRateDate | Translatn Date | ||
| TotalNetAmount | TotalNetAmount | Total Net Amount | ||
| PersSettlmtDocIsReversed | PersSettlmtDocIsReversed | Document Is Reversed | ||
| RvsdPersSettlmtDoc | RvsdPersSettlmtDoc | Reversed Document | ||
| PersSettlmtDocActivityReason | PersSettlmtDocActivityReason | Header Document Creation Activity Reason | ||
| SettlmtActivityReasonDesclocalized | ||||
| PaymentReference | PaymentReference | Payment Reference | ||
| CndnContrType | CndnContrType | Contract Type | ||
| CndnContrTypeDesclocalized | ||||
| SettlmtReltdCndnContr | SettlmtReltdCndnContr | Related Condition Contract | ||
| CndnContrProcVar | CndnContrProcVar | Process Variant | ||
| CndnContrProcVarDesclocalized | ||||
| CndnContrActvtnStatus | _SettlmtReltdCndnContr | CndnContrActvtnStatus | ||
| CndnContrActvtnStatusNamelocalized | ||||
| FiscalPeriod | FiscalPeriod | Tax period | ||
| SettlmtDateCat | SettlmtDateCat | Settlement Date Type | ||
| ActualSettlmtDate | ActualSettlmtDate | Actual Settl. Date | ||
| SettlmtDateSequentialID | SettlmtDateSequentialID | Settlement Date ID | ||
| SettlmtDate | SettlmtDate | Settlement Date | ||
| PersSettlmtDocIncmpltnsRsn | PersSettlmtDocIncmpltnsRsn | Incomplete Rsn | ||
| SettlmtMgmtDocIncmpltnsRsnDesclocalized | ||||
| ExternalDocumentReferenceID | _SettlmtReltdCndnContr | ExternalDocumentReferenceID | Ext. Identifier | |
| SettlmtBusProcVar | SettlmtBusProcVar | Proc. Category | ||
| SettlmtBusProcVarDesclocalized | ||||
| SettlmtBusProcCat | SettlmtBusProcCat | Use Case Type | ||
| SettlmtBusProcCatNamelocalized | ||||
| TotalSettlmtQuantity | TotalSettlmtQuantity | Total Quantity | ||
| TotalSettlmtQuantityUnit | TotalSettlmtQuantityUnit | UoM Total Quantity | ||
| TotalSettlmtNetWeight | TotalSettlmtNetWeight | Total Net Weight | ||
| TotalSettlmtGrossWeight | TotalSettlmtGrossWeight | Total Gross Weight | ||
| TotalSettlmtWeightUnit | TotalSettlmtWeightUnit | UoW Total Weight | ||
| TotalSettlmtVolume | TotalSettlmtVolume | Total Volume | ||
| TotalSettlmtVolumeUnit | TotalSettlmtVolumeUnit | Unit Total Volume | ||
| SettlmtPeriodStartDate | SettlmtPeriodStartDate | Start Date of Period | ||
| SettlmtPeriodEndDate | SettlmtPeriodEndDate | End Date of Period | ||
| CndnContrProcessCategory | CndnContrProcessCategory | Process Category | ||
| CndnContrProcessCategoryDesclocalized | ||||
| PostingPartnerCat | PostingPartnerCat | Posting Partner | ||
| PostingPartnerCatNamelocalized | ||||
| SettlmtCompensationReason | SettlmtCompensationReason | Compensation Reason | ||
| SettlmtCompnRsnDesclocalized | ||||
| SettlmtCompnVar | SettlmtCompnVar | Compensation Variant | ||
| SettlmtCompnVarDesclocalized | ||||
| ApplElmntBehaviorGrp | ApplElmntBehaviorGrp | Element Behavior Group | ||
| JournalEntryCreationDate | JournalEntryCreationDate | Journal Entry Creation Date | ||
| JournalEntryCreationTime | JournalEntryCreationTime | Journal Entry Creation Time | ||
| PersSettlmtDocChangeState | PersSettlmtDocChangeState | Change State | ||
| virtualChangeDocObjectchar90 | ||||
| virtualJournalEntryfarp_belnr_d | ||||
| virtualFiscalYearfis_gjahr_no_conv | ||||
| virtualUICT_HDR_Statusboolean | ||||
| virtualUICT_HDR_Accountingboolean | ||||
| virtualUICT_HDR_Amountboolean | ||||
| virtualUICT_COLL_GEN_INFOboolean | ||||
| virtualUICT_COLL_BASIC_DATAboolean | ||||
| virtualUICT_FLDGRP_SETTLMT_DETSboolean | ||||
| virtualUICT_FLDGRP_PROC_DETSboolean | ||||
| virtualUICT_FLDGRP_REV_INFOboolean | ||||
| virtualUICT_FLDGRP_REF_INFOboolean | ||||
| virtualUICT_COLL_CRCY_POSTGboolean | ||||
| virtualUICT_FLDGRP_CRCY_INFOboolean | ||||
| virtualUICT_FLDGRP_DATESboolean | ||||
| virtualUICT_COLL_ADMINboolean | ||||
| virtualUICT_FLDGRP_ORG_SLSboolean | ||||
| virtualUICT_FLDGRP_ADMINboolean | ||||
| virtualUICT_COLL_ACC_INFOboolean | ||||
| virtualUICT_FLDGRP_JRNL_ENTRIESboolean | ||||
| virtualUICT_COLL_CNDN_CONTRboolean | ||||
| virtualUICT_FLDGRP_CNDN_CONTRboolean | ||||
| virtualSettlmtApplStsChgdwstate | ||||
| _CreatedByUser | _CreatedByUser | |||
| _PersonWorkAgreement | _PersonWorkAgreement |
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_F3808.
-- 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_F3808 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,
PostingDate,
PersSettlmtAcctgTransfSts,
_PersSettlmtAcctgTransfSts._Text.PersSettlmtAcctgTransfStsName : localized AS PersSettlmtAcctgTransfStsNamelocalized,
DocumentDate,
DocumentReferenceID,
AssignmentReference,
SettlmtApplSts,
SettlmtApplSts AS SettlmtApplStsForFilter,
_SettlmtApplSts._Text.SettlmtApplStsDesc : localized AS SettlmtApplStsDesclocalized,
SettlmtApplStsGrp,
_SettlmtApplStsGrp._Text.SettlmtApplStsGrpDesc : localized AS SettlmtApplStsGrpDesclocalized,
PricingProcedure,
PricingDocument,
PersonWorkAgreement,
_PersonWorkAgreement.PersonFullName AS PersonFullName,
PersonnelCostCenter,
_PersonnelCostCenter._Text.CostCenterDescription : localized AS CostCenterDescriptionlocalized,
PersonnelControllingArea,
CompanyCode,
_CompanyCode.CompanyCodeName AS CompanyCodeName,
SalesOrganization,
_SalesOrganization._Text.SalesOrganizationName : localized AS SalesOrganizationNamelocalized,
DistributionChannel,
_DistributionChannel._Text.DistributionChannelName : localized AS DistributionChannelNamelocalized,
Division,
_Division._Text.DivisionName : localized AS DivisionNamelocalized,
SalesOffice,
_SalesOffice._Text.SalesOfficeName : localized AS SalesOfficeNamelocalized,
SalesGroup,
_SalesGroup._Text.SalesGroupName : localized AS SalesGroupNamelocalized,
CreatedByUser,
cast( _CreatedByUser.UserDescription as wlf_created_by_fullname preserving type ) AS CreatedByUserFullName,
CreationDate,
CreationTime,
LastChangeDate,
PersSettlmtDocCurrency,
_PersSettlmtDocCurrency._Text.CurrencyName : localized AS CurrencyNamelocalized,
ExchangeRate,
ExchangeRateType,
_ExchangeRateType._Text.ExchangeRateTypeName : localized AS ExchangeRateTypeNamelocalized,
ExchangeRateIsFixed,
ExchangeRateDate,
TotalNetAmount,
PersSettlmtDocIsReversed,
RvsdPersSettlmtDoc,
PersSettlmtDocActivityReason,
_PersSettlmtDocActivityReason._Text.SettlmtActivityReasonDesc : localized AS SettlmtActivityReasonDesclocalized,
PaymentReference,
CndnContrType,
_CndnContrType._Text.CndnContrTypeDesc : localized AS CndnContrTypeDesclocalized,
SettlmtReltdCndnContr,
CndnContrProcVar,
_CndnContrProcVar._Text.CndnContrProcVarDesc : localized AS CndnContrProcVarDesclocalized,
_SettlmtReltdCndnContr.CndnContrActvtnStatus AS CndnContrActvtnStatus,
_SettlmtReltdCndnContr._CndnContrActvtnStatus._Text.CndnContrActvtnStatusName : localized AS CndnContrActvtnStatusNamelocalized,
FiscalPeriod,
SettlmtDateCat,
ActualSettlmtDate,
SettlmtDateSequentialID,
SettlmtDate,
PersSettlmtDocIncmpltnsRsn,
_PersSettlmtDocIncmpltnsRsn._Text.SettlmtMgmtDocIncmpltnsRsnDesc : localized AS SettlmtMgmtDocIncmpltnsRsnDesclocalized,
_SettlmtReltdCndnContr.ExternalDocumentReferenceID AS ExternalDocumentReferenceID,
SettlmtBusProcVar,
_SettlmtBusProcVar._Text.SettlmtBusProcVarDesc : localized AS SettlmtBusProcVarDesclocalized,
SettlmtBusProcCat,
_SettlmtBusProcCat._Text.SettlmtBusProcCatName : localized AS SettlmtBusProcCatNamelocalized,
TotalSettlmtQuantity,
TotalSettlmtQuantityUnit,
TotalSettlmtNetWeight,
TotalSettlmtGrossWeight,
TotalSettlmtWeightUnit,
TotalSettlmtVolume,
TotalSettlmtVolumeUnit,
SettlmtPeriodStartDate,
SettlmtPeriodEndDate,
CndnContrProcessCategory,
_CndnContrProcessCategory._Text.CndnContrProcessCategoryDesc : localized AS CndnContrProcessCategoryDesclocalized,
PostingPartnerCat,
_PostingPartnerCat._Text.PostingPartnerCatName : localized AS PostingPartnerCatNamelocalized,
SettlmtCompensationReason,
_SettlmtCompensationReason._Text.SettlmtCompnRsnDesc : localized AS SettlmtCompnRsnDesclocalized,
SettlmtCompnVar,
_SettlmtCompnVar._Text.SettlmtCompnVarDesc : localized AS SettlmtCompnVarDesclocalized,
ApplElmntBehaviorGrp,
JournalEntryCreationDate,
JournalEntryCreationTime,
PersSettlmtDocChangeState,
virtual ChangeDocObject : char90 AS virtualChangeDocObjectchar90,
virtual JournalEntry : farp_belnr_d AS virtualJournalEntryfarp_belnr_d,
virtual FiscalYear : fis_gjahr_no_conv AS virtualFiscalYearfis_gjahr_no_conv,
virtual UICT_HDR_Status : boolean AS virtualUICT_HDR_Statusboolean,
virtual UICT_HDR_Accounting : boolean AS virtualUICT_HDR_Accountingboolean,
virtual UICT_HDR_Amount : boolean AS virtualUICT_HDR_Amountboolean,
virtual UICT_COLL_GEN_INFO : boolean AS virtualUICT_COLL_GEN_INFOboolean,
virtual UICT_COLL_BASIC_DATA : boolean AS virtualUICT_COLL_BASIC_DATAboolean,
virtual UICT_FLDGRP_SETTLMT_DETS : boolean AS virtualUICT_FLDGRP_SETTLMT_DETSboolean,
virtual UICT_FLDGRP_PROC_DETS : boolean AS virtualUICT_FLDGRP_PROC_DETSboolean,
virtual UICT_FLDGRP_REV_INFO : boolean AS virtualUICT_FLDGRP_REV_INFOboolean,
virtual UICT_FLDGRP_REF_INFO : boolean AS virtualUICT_FLDGRP_REF_INFOboolean,
virtual UICT_COLL_CRCY_POSTG : boolean AS virtualUICT_COLL_CRCY_POSTGboolean,
virtual UICT_FLDGRP_CRCY_INFO : boolean AS virtualUICT_FLDGRP_CRCY_INFOboolean,
virtual UICT_FLDGRP_DATES : boolean AS virtualUICT_FLDGRP_DATESboolean,
virtual UICT_COLL_ADMIN : boolean AS virtualUICT_COLL_ADMINboolean,
virtual UICT_FLDGRP_ORG_SLS : boolean AS virtualUICT_FLDGRP_ORG_SLSboolean,
virtual UICT_FLDGRP_ADMIN : boolean AS virtualUICT_FLDGRP_ADMINboolean,
virtual UICT_COLL_ACC_INFO : boolean AS virtualUICT_COLL_ACC_INFOboolean,
virtual UICT_FLDGRP_JRNL_ENTRIES : boolean AS virtualUICT_FLDGRP_JRNL_ENTRIESboolean,
virtual UICT_COLL_CNDN_CONTR : boolean AS virtualUICT_COLL_CNDN_CONTRboolean,
virtual UICT_FLDGRP_CNDN_CONTR : boolean AS virtualUICT_FLDGRP_CNDN_CONTRboolean,
virtual SettlmtApplStsChgd : wstate AS virtualSettlmtApplStsChgdwstate
FROM R_PersSettlmtDocTP
;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