I_PersSettlmtDocTP

DDL: I_PERSSETTLMTDOCTP Type: view_entity TRANSACTIONAL
67 Fields 1 Data Sources

Personnel Settlement Document - TP

I_PersSettlmtDocTP is a Transactional CDS View that provides data about "Personnel Settlement Document - TP" in SAP S/4HANA. It reads from 1 data source (R_PersSettlmtDocTP) and exposes 67 fields with key field PersonnelSettlementDocument.

Data Sources (1)

SourceAliasJoin Type
R_PersSettlmtDocTP R_PersSettlmtDocTP projection

Annotations (15)

NameValueLevelField
EndUserText.label Personnel Settlement Document - TP view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.sapObjectNodeType.name PersonnelSettlementDocument view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL 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 SMH view
AbapCatalog.extensibility.quota.maximumFields 170 view
AbapCatalog.extensibility.quota.maximumBytes 3400 view

Fields (67)

KeyFieldSource TableSource FieldDescription
KEY PersonnelSettlementDocument PersonnelSettlementDocument Personnel Settlement Document
SettlmtDocType SettlmtDocType Settlement Document Type
SettlmtDocCat SettlmtDocCat Settlement Document Category
SettlmtProcessType SettlmtProcessType Settlement Process Type
SettlmtProcessCat SettlmtProcessCat Settlement Process Category
LogisticsDataEntryCat LogisticsDataEntryCat Entry Category
PostingDate PostingDate Posting Date for GR
PersSettlmtAcctgTransfSts PersSettlmtAcctgTransfSts Posting Status
DocumentDate DocumentDate Journal Entry Date
DocumentReferenceID DocumentReferenceID Reference
AssignmentReference AssignmentReference Assignment Reference
SettlmtApplSts SettlmtApplSts Appl. Status
SettlmtApplStsGrp SettlmtApplStsGrp Status Group
PricingProcedure PricingProcedure Procedure
PricingDocument PricingDocument Document Condition
PersonWorkAgreement PersonWorkAgreement Personnel No.
PersonnelCostCenter PersonnelCostCenter Worker Cost Center
PersonnelControllingArea PersonnelControllingArea Worker Controlling Area
CompanyCode CompanyCode Receiver Company Code
SalesOrganization SalesOrganization Sales Organization
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
Division Division Internal Division ID
SalesOffice SalesOffice Sales Office
SalesGroup SalesGroup Sales Group
CreatedByUser CreatedByUser User Name
CreationDate CreationDate Time Stamp
CreationTime CreationTime Time of Change
LastChangeDate LastChangeDate Time Stamp
PersSettlmtDocCurrency PersSettlmtDocCurrency Doc. Currency
ExchangeRate ExchangeRate Exchange rate
ExchangeRateType ExchangeRateType Exch. Rate Type
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
PaymentReference PaymentReference Payment Reference
CndnContrType CndnContrType Contract Type
SettlmtReltdCndnContr SettlmtReltdCndnContr Related Condition Contract
CndnContrProcVar CndnContrProcVar Process Variant
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
SettlmtBusProcVar SettlmtBusProcVar Proc. Category
SettlmtBusProcCat SettlmtBusProcCat Use Case Type
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
PostingPartnerCat PostingPartnerCat Posting Partner
JournalEntryCreationDate JournalEntryCreationDate Journal Entry Creation Date
JournalEntryCreationTime JournalEntryCreationTime Journal Entry Creation Time
SettlmtCompensationReason SettlmtCompensationReason Compensation Reason
SettlmtCompnVar SettlmtCompnVar Compensation Variant
ApplElmntBehaviorGrp ApplElmntBehaviorGrp Element Behavior Group
PersSettlmtDocChangeState PersSettlmtDocChangeState Change State
_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 I_PersSettlmtDocTP.
-- 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_PersSettlmtDocTP AS
SELECT
  PersonnelSettlementDocument,
  SettlmtDocType,
  SettlmtDocCat,
  SettlmtProcessType,
  SettlmtProcessCat,
  LogisticsDataEntryCat,
  PostingDate,
  PersSettlmtAcctgTransfSts,
  DocumentDate,
  DocumentReferenceID,
  AssignmentReference,
  SettlmtApplSts,
  SettlmtApplStsGrp,
  PricingProcedure,
  PricingDocument,
  PersonWorkAgreement,
  PersonnelCostCenter,
  PersonnelControllingArea,
  CompanyCode,
  SalesOrganization,
  DistributionChannel,
  Division,
  SalesOffice,
  SalesGroup,
  CreatedByUser,
  CreationDate,
  CreationTime,
  LastChangeDate,
  PersSettlmtDocCurrency,
  ExchangeRate,
  ExchangeRateType,
  ExchangeRateIsFixed,
  ExchangeRateDate,
  TotalNetAmount,
  PersSettlmtDocIsReversed,
  RvsdPersSettlmtDoc,
  PersSettlmtDocActivityReason,
  PaymentReference,
  CndnContrType,
  SettlmtReltdCndnContr,
  CndnContrProcVar,
  FiscalPeriod,
  SettlmtDateCat,
  ActualSettlmtDate,
  SettlmtDateSequentialID,
  SettlmtDate,
  PersSettlmtDocIncmpltnsRsn,
  SettlmtBusProcVar,
  SettlmtBusProcCat,
  TotalSettlmtQuantity,
  TotalSettlmtQuantityUnit,
  TotalSettlmtNetWeight,
  TotalSettlmtGrossWeight,
  TotalSettlmtWeightUnit,
  TotalSettlmtVolume,
  TotalSettlmtVolumeUnit,
  SettlmtPeriodStartDate,
  SettlmtPeriodEndDate,
  CndnContrProcessCategory,
  PostingPartnerCat,
  JournalEntryCreationDate,
  JournalEntryCreationTime,
  SettlmtCompensationReason,
  SettlmtCompnVar,
  ApplElmntBehaviorGrp,
  PersSettlmtDocChangeState
FROM R_PersSettlmtDocTP
;

Learn More