C_PersSetlDocAcctgTransfStsKPI

DDL: C_PERSSETLDOCACCTGTRANSFSTSKPI Type: view CONSUMPTION
34 Fields 1 Data Sources 1 Associations

Pers Setl Doc Acc Transfer Status KPI

C_PersSetlDocAcctgTransfStsKPI is a Consumption CDS View that provides data about "Pers Setl Doc Acc Transfer Status KPI" in SAP S/4HANA. It reads from 1 data source (R_PersSettlmtDoc) and exposes 34 fields with key field PersonnelSettlementDocument. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
R_PersSettlmtDoc R_PersSettlmtDoc from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_CalendarDate _Calendar $projection.PostingDate = _Calendar.CalendarDate

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName CWLFMNTRPSDOCKPI view
AbapCatalog.compiler.compareFilter true view
ClientHandling.type #CLIENT_DEPENDENT view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Pers Setl Doc Acc Transfer Status KPI view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view
VDM.lifecycle.contract.type #NONE view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
Search.searchable true view

Fields (34)

KeyFieldSource TableSource FieldDescription
KEY PersonnelSettlementDocument PersonnelSettlementDocument Personnel Settlement Document
PersSettlmtAcctgTransfSts PersSettlmtAcctgTransfSts Posting Status
PersSettlmtAcctgTransfStsName
SettlmtDocChartCounter
CndnContrProcessCategory CndnContrProcessCategory Process Category
PersonWorkAgreement PersonWorkAgreement Personnel No.
PersonFullName
CompanyCode CompanyCode Receiver Company Code
CompanyCodeName
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
Division Division Internal Division ID
SalesOrganization SalesOrganization Sales Organization
SettlmtDocType SettlmtDocType Settlement Document Type
SettlmtDocTypeDesc
PersonnelCostCenter PersonnelCostCenter Worker Cost Center
CostCenterDescription
SettlmtDocCat SettlmtDocCat Settlement Document Category
SettlmtDocCatName
SettlmtProcessType SettlmtProcessType Settlement Process Type
SettlmtProcessTypeDesc
SettlmtProcessCat SettlmtProcessCat Settlement Process Category
SettlmtProcessCatName
DocumentReferenceID DocumentReferenceID Reference
RvsdPersSettlmtDoc RvsdPersSettlmtDoc Reversed Document
CndnContrType CndnContrType Contract Type
CndnContrTypeDesc
SettlmtReltdCndnContr SettlmtReltdCndnContr Related Condition Contract
PostingDate PostingDate Posting Date for GR
SettlmtCompensationReason SettlmtCompensationReason Compensation Reason
SettlmtCompnVar SettlmtCompnVar Compensation Variant
SettlmtApplSts SettlmtApplSts Appl. Status
CalendarYear _Calendar CalendarYear Year
CalendarQuarter _Calendar CalendarQuarter Calendar Quarter
_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_PersSetlDocAcctgTransfStsKPI.
-- 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_PersSetlDocAcctgTransfStsKPI AS
SELECT
  PersonnelSettlementDocument,
  PersSettlmtAcctgTransfSts,
  _PersSettlmtAcctgTransfSts._Text[1: Language = $session.system_language].PersSettlmtAcctgTransfStsName AS PersSettlmtAcctgTransfStsName,
  cast( 1 as wlf_setdoc_chart_counter ) AS SettlmtDocChartCounter,
  CndnContrProcessCategory,
  PersonWorkAgreement,
  R_PersSettlmtDoc._PersonWorkAgreement.PersonFullName AS PersonFullName,
  CompanyCode,
  R_PersSettlmtDoc._CompanyCode.CompanyCodeName AS CompanyCodeName,
  DistributionChannel,
  Division,
  SalesOrganization,
  SettlmtDocType,
  R_PersSettlmtDoc._SettlmtDocType._Text[1: Language = $session.system_language].SettlmtDocTypeDesc AS SettlmtDocTypeDesc,
  PersonnelCostCenter,
  R_PersSettlmtDoc._PersonnelCostCenter._Text[1: Language = $session.system_language ].CostCenterDescription AS CostCenterDescription,
  SettlmtDocCat,
  R_PersSettlmtDoc._SettlmtDocCat._Text[1: Language = $session.system_language].SettlmtDocCatName AS SettlmtDocCatName,
  SettlmtProcessType,
  R_PersSettlmtDoc._SettlmtProcessType._Text[1: Language = $session.system_language].SettlmtProcessTypeDesc AS SettlmtProcessTypeDesc,
  SettlmtProcessCat,
  R_PersSettlmtDoc._SettlmtProcessCat._Text[1: Language = $session.system_language].SettlmtProcessCatName AS SettlmtProcessCatName,
  DocumentReferenceID,
  RvsdPersSettlmtDoc,
  CndnContrType,
  R_PersSettlmtDoc._CndnContrType._Text[1: Language = $session.system_language ].CndnContrTypeDesc AS CndnContrTypeDesc,
  SettlmtReltdCndnContr,
  PostingDate,
  SettlmtCompensationReason,
  SettlmtCompnVar,
  SettlmtApplSts,
  _Calendar.CalendarYear AS CalendarYear,
  _Calendar.CalendarQuarter AS CalendarQuarter
FROM R_PersSettlmtDoc
LEFT OUTER JOIN I_CalendarDate AS _Calendar ON PostingDate = _Calendar.CalendarDate  -- association [0..1]
;

Learn More