C_PersSettlmtDocWorkItem

DDL: C_PERSSETTLMTDOCWORKITEM Type: view CONSUMPTION
24 Fields 3 Data Sources

Personnel Settlement Document Work Item

C_PersSettlmtDocWorkItem is a Consumption CDS View that provides data about "Personnel Settlement Document Work Item" in SAP S/4HANA. It reads from 3 data sources (C_PersSettlmtDocWrkflwDet, I_WorkflowTask, I_WorkflowTaskApplObject) and exposes 24 fields with key field WorkflowTaskInternalID.

Data Sources (3)

SourceAliasJoin Type
C_PersSettlmtDocWrkflwDet _PersSettlmtDocWrkflwDet inner
I_WorkflowTask _WorkflowTask from
I_WorkflowTaskApplObject _WorkflowTaskApplObject inner

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName CWLFPERSSMTDOCWI view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.representativeKey WorkflowTaskInternalID view
ClientHandling.algorithm #SESSION_VARIABLE view
ClientHandling.type #INHERITED view
VDM.viewType #CONSUMPTION view
Consumption.semanticObject WorkflowTaskInternalID view
EndUserText.label Personnel Settlement Document Work Item view

Fields (24)

KeyFieldSource TableSource FieldDescription
KEY WorkflowTaskInternalID I_WorkflowTask WorkflowTaskInternalID Work Item ID
PersonnelSettlementDocument C_PersSettlmtDocWrkflwDet PersonnelSettlementDocument Personnel Settlement Document
CreatedByUser C_PersSettlmtDocWrkflwDet CreatedByUser User Name
UserFullName C_PersSettlmtDocWrkflwDet UserFullName Full Name
PersSettlmtDocCurrency C_PersSettlmtDocWrkflwDet PersSettlmtDocCurrency Doc. Currency
TotalNetAmount C_PersSettlmtDocWrkflwDet TotalNetAmount Total Net Amount
CompanyCode C_PersSettlmtDocWrkflwDet CompanyCode Receiver Company Code
PersonWorkAgreement C_PersSettlmtDocWrkflwDet PersonWorkAgreement Personnel No.
SettlmtDate C_PersSettlmtDocWrkflwDet SettlmtDate Settlement Date
DocumentDate C_PersSettlmtDocWrkflwDet DocumentDate Journal Entry Date
PersonnelCostCenter C_PersSettlmtDocWrkflwDet PersonnelCostCenter Worker Cost Center
SettlmtCompensationReason C_PersSettlmtDocWrkflwDet SettlmtCompensationReason Compensation Reason
SettlmtCompnVar C_PersSettlmtDocWrkflwDet SettlmtCompnVar Compensation Variant
DocumentTitle C_PersSettlmtDocWrkflwDet DocumentTitle Title
SalesOrganization C_PersSettlmtDocWrkflwDet SalesOrganization Sales Organization
DistributionChannel C_PersSettlmtDocWrkflwDet DistributionChannel RefDistCh-Cust/Mat.
Division C_PersSettlmtDocWrkflwDet Division Internal Division ID
SettlmtDocType C_PersSettlmtDocWrkflwDet SettlmtDocType Settlement Document Type
_CreatedByUser C_PersSettlmtDocWrkflwDet _CreatedByUser
_PersSettlmtDocCurrency C_PersSettlmtDocWrkflwDet _PersSettlmtDocCurrency
_CompanyCode C_PersSettlmtDocWrkflwDet _CompanyCode
_PersonWorkAgreement C_PersSettlmtDocWrkflwDet _PersonWorkAgreement
_SettlmtCompnRsn C_PersSettlmtDocWrkflwDet _SettlmtCompnRsn
_SettlmtCompnVar C_PersSettlmtDocWrkflwDet _SettlmtCompnVar

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_PersSettlmtDocWorkItem.
-- 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_PersSettlmtDocWorkItem AS
SELECT
  _WorkflowTask.WorkflowTaskInternalID AS WorkflowTaskInternalID,
  _PersSettlmtDocWrkflwDet.PersonnelSettlementDocument AS PersonnelSettlementDocument,
  _PersSettlmtDocWrkflwDet.CreatedByUser AS CreatedByUser,
  _PersSettlmtDocWrkflwDet.UserFullName AS UserFullName,
  _PersSettlmtDocWrkflwDet.PersSettlmtDocCurrency AS PersSettlmtDocCurrency,
  _PersSettlmtDocWrkflwDet.TotalNetAmount AS TotalNetAmount,
  _PersSettlmtDocWrkflwDet.CompanyCode AS CompanyCode,
  _PersSettlmtDocWrkflwDet.PersonWorkAgreement AS PersonWorkAgreement,
  _PersSettlmtDocWrkflwDet.SettlmtDate AS SettlmtDate,
  _PersSettlmtDocWrkflwDet.DocumentDate AS DocumentDate,
  _PersSettlmtDocWrkflwDet.PersonnelCostCenter AS PersonnelCostCenter,
  _PersSettlmtDocWrkflwDet.SettlmtCompensationReason AS SettlmtCompensationReason,
  _PersSettlmtDocWrkflwDet.SettlmtCompnVar AS SettlmtCompnVar,
  _PersSettlmtDocWrkflwDet.DocumentTitle AS DocumentTitle,
  _PersSettlmtDocWrkflwDet.SalesOrganization AS SalesOrganization,
  _PersSettlmtDocWrkflwDet.DistributionChannel AS DistributionChannel,
  _PersSettlmtDocWrkflwDet.Division AS Division,
  _PersSettlmtDocWrkflwDet.SettlmtDocType AS SettlmtDocType,
  _PersSettlmtDocWrkflwDet._CreatedByUser AS _CreatedByUser,
  _PersSettlmtDocWrkflwDet._PersSettlmtDocCurrency AS _PersSettlmtDocCurrency,
  _PersSettlmtDocWrkflwDet._CompanyCode AS _CompanyCode,
  _PersSettlmtDocWrkflwDet._PersonWorkAgreement AS _PersonWorkAgreement,
  _PersSettlmtDocWrkflwDet._SettlmtCompnRsn AS _SettlmtCompnRsn,
  _PersSettlmtDocWrkflwDet._SettlmtCompnVar AS _SettlmtCompnVar
FROM I_WorkflowTask AS _WorkflowTask
INNER JOIN I_WorkflowTaskApplObject AS _WorkflowTaskApplObject ON /* join condition not captured in parsed metadata */
INNER JOIN C_PersSettlmtDocWrkflwDet AS _PersSettlmtDocWrkflwDet ON /* join condition not captured in parsed metadata */
;

Learn More