R_PERSSETTLMTDOC

CDS View
77 Fields 6 CDS Views

Personnel Settlement Document

R_PERSSETTLMTDOC is a CDS View in S/4HANA. Personnel Settlement Document. It contains 77 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
C_MntrPersSettlmtDoc view_entity from CONSUMPTION Monitor Personnel Settlement Documents (obsolete)
C_PersSetlDocAcctgTransfStsKPI view from CONSUMPTION Pers Setl Doc Acc Transfer Status KPI
I_PersSettlmtDoc view from BASIC Personnel Settlement Document
I_PersSettlmtDocJournalEntry view from BASIC Journal Entry for Personnel Settlement Documents
P_PersSettlmtDocAmtInDC view from CONSUMPTION Pers Settlement Document Amount in DC
R_PersSettlmtDocTP view_entity from TRANSACTIONAL Personnel Settlement Document - TP

Fields (77)

KeyField CDS FieldsUsed in Views
KEY PersonnelSettlementDocument PersonnelSettlementDocument 2
_CndnContrProcessCategory _CndnContrProcessCategory 1
_CndnContrProcVar _CndnContrProcVar 1
_CndnContrType _CndnContrType 1
_CompanyCode _CompanyCode 1
_CreatedByUser _CreatedByUser 1
_DistributionChannel _DistributionChannel 1
_Division _Division 1
_ExchangeRateType _ExchangeRateType 1
_PersonnelControllingArea _PersonnelControllingArea 1
_PersonnelCostCenter _PersonnelCostCenter 1
_PersonWorkAgreement _PersonWorkAgreement 1
_PersSettlmtAcctgTransfSts _PersSettlmtAcctgTransfSts 1
_PersSettlmtDocActivityReason _PersSettlmtDocActivityReason 1
_PersSettlmtDocCurrency _PersSettlmtDocCurrency 1
_PersSettlmtDocItem _PersSettlmtDocItem 1
_PersSettlmtDocPrcgElmnt _PersSettlmtDocPrcgElmnt 1
_RvsdPersSettlmtDoc _RvsdPersSettlmtDoc 1
_SalesArea _SalesArea 1
_SalesOrganization _SalesOrganization 1
_SettlmtApplSts _SettlmtApplSts 1
_SettlmtApplStsGrp _SettlmtApplStsGrp 1
_SettlmtApplStsGrpStsAssgmt _SettlmtApplStsGrpStsAssgmt 1
_SettlmtBusProcCat _SettlmtBusProcCat 1
_SettlmtBusProcVar _SettlmtBusProcVar 1
_SettlmtCompensationReason _SettlmtCompensationReason 1
_SettlmtCompnVar _SettlmtCompnVar 1
_SettlmtDateCat _SettlmtDateCat 1
_SettlmtDocCat _SettlmtDocCat 1
_SettlmtDocType _SettlmtDocType 1
_SettlmtProcessCat _SettlmtProcessCat 1
_SettlmtProcessType _SettlmtProcessType 1
_SettlmtReltdCndnContr _SettlmtReltdCndnContr 1
ActualSettlmtDate ActualSettlmtDate 1
AssignmentReference AssignmentReference 1
CndnContrProcessCategory CndnContrProcessCategory 1
CndnContrProcVar CndnContrProcVar 1
CndnContrType CndnContrType 1
CompanyCode CompanyCode 2
CreatedByUser CreatedByUser 1
CreationDate CreationDate 1
CreationTime CreationTime 1
DistributionChannel DistributionChannel 1
Division Division 1
DocumentDate DocumentDate 1
DocumentReferenceID DocumentReferenceID 1
ExchangeRate ExchangeRate 1
ExchangeRateDate ExchangeRateDate 1
ExchangeRateIsFixed ExchangeRateIsFixed 1
ExchangeRateType ExchangeRateType 1
FiscalPeriod FiscalPeriod 1
JournalEntryCreationDate JournalEntryCreationDate 1
JournalEntryCreationTime JournalEntryCreationTime 1
LastChangeDate LastChangeDate 1
PaymentReference PaymentReference 1
PersonnelControllingArea PersonnelControllingArea 1
PersonnelCostCenter PersonnelCostCenter 1
PersonWorkAgreement PersonWorkAgreement 1
PersSettlmtAcctgTransfSts PersSettlmtAcctgTransfSts 1
PersSettlmtDocActivityReason PersSettlmtDocActivityReason 1
PersSettlmtDocCurrency PersSettlmtDocCurrency 1
PersSettlmtDocIsReversed PersSettlmtDocIsReversed 1
PostingDate PostingDate 1
RvsdPersSettlmtDoc RvsdPersSettlmtDoc 1
SalesOrganization SalesOrganization 1
SettlmtApplSts SettlmtApplSts 1
SettlmtApplStsGrp SettlmtApplStsGrp 1
SettlmtBusProcCat SettlmtBusProcCat 1
SettlmtBusProcVar SettlmtBusProcVar 1
SettlmtCompensationReason SettlmtCompensationReason 1
SettlmtCompnVar SettlmtCompnVar 1
SettlmtDate SettlmtDate 1
SettlmtDateCat SettlmtDateCat 1
SettlmtDocCat SettlmtDocCat 1
SettlmtDocType SettlmtDocType 1
SettlmtProcessCat SettlmtProcessCat 1
SettlmtProcessType SettlmtProcessType 1

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Personnel Settlement Document
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE R_PERSSETTLMTDOC (
    PERSONNELSETTLEMENTDOCUMENT,
    _CNDNCONTRPROCESSCATEGORY,
    _CNDNCONTRPROCVAR,
    _CNDNCONTRTYPE,
    _COMPANYCODE,
    _CREATEDBYUSER,
    _DISTRIBUTIONCHANNEL,
    _DIVISION,
    _EXCHANGERATETYPE,
    _PERSONNELCONTROLLINGAREA,
    _PERSONNELCOSTCENTER,
    _PERSONWORKAGREEMENT,
    _PERSSETTLMTACCTGTRANSFSTS,
    _PERSSETTLMTDOCACTIVITYREASON,
    _PERSSETTLMTDOCCURRENCY,
    _PERSSETTLMTDOCITEM,
    _PERSSETTLMTDOCPRCGELMNT,
    _RVSDPERSSETTLMTDOC,
    _SALESAREA,
    _SALESORGANIZATION,
    _SETTLMTAPPLSTS,
    _SETTLMTAPPLSTSGRP,
    _SETTLMTAPPLSTSGRPSTSASSGMT,
    _SETTLMTBUSPROCCAT,
    _SETTLMTBUSPROCVAR,
    _SETTLMTCOMPENSATIONREASON,
    _SETTLMTCOMPNVAR,
    _SETTLMTDATECAT,
    _SETTLMTDOCCAT,
    _SETTLMTDOCTYPE,
    _SETTLMTPROCESSCAT,
    _SETTLMTPROCESSTYPE,
    _SETTLMTRELTDCNDNCONTR,
    ACTUALSETTLMTDATE,
    ASSIGNMENTREFERENCE,
    CNDNCONTRPROCESSCATEGORY,
    CNDNCONTRPROCVAR,
    CNDNCONTRTYPE,
    COMPANYCODE,
    CREATEDBYUSER,
    CREATIONDATE,
    CREATIONTIME,
    DISTRIBUTIONCHANNEL,
    DIVISION,
    DOCUMENTDATE,
    DOCUMENTREFERENCEID,
    EXCHANGERATE,
    EXCHANGERATEDATE,
    EXCHANGERATEISFIXED,
    EXCHANGERATETYPE,
    FISCALPERIOD,
    JOURNALENTRYCREATIONDATE,
    JOURNALENTRYCREATIONTIME,
    LASTCHANGEDATE,
    PAYMENTREFERENCE,
    PERSONNELCONTROLLINGAREA,
    PERSONNELCOSTCENTER,
    PERSONWORKAGREEMENT,
    PERSSETTLMTACCTGTRANSFSTS,
    PERSSETTLMTDOCACTIVITYREASON,
    PERSSETTLMTDOCCURRENCY,
    PERSSETTLMTDOCISREVERSED,
    POSTINGDATE,
    RVSDPERSSETTLMTDOC,
    SALESORGANIZATION,
    SETTLMTAPPLSTS,
    SETTLMTAPPLSTSGRP,
    SETTLMTBUSPROCCAT,
    SETTLMTBUSPROCVAR,
    SETTLMTCOMPENSATIONREASON,
    SETTLMTCOMPNVAR,
    SETTLMTDATE,
    SETTLMTDATECAT,
    SETTLMTDOCCAT,
    SETTLMTDOCTYPE,
    SETTLMTPROCESSCAT,
    SETTLMTPROCESSTYPE,
    PRIMARY KEY (PERSONNELSETTLEMENTDOCUMENT)
);

Learn More