C_SettlmtDocWorkItem

DDL: C_SETTLMTDOCWORKITEM Type: view CONSUMPTION
48 Fields 3 Data Sources

Settlement Document Work Item

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

Data Sources (3)

SourceAliasJoin Type
C_SettlmtDocWrkflwDet _SettlmtDocWrkflwDet inner
I_WorkflowTask _WorkflowTask from
I_WorkflowTaskApplObject _WorkflowTaskApplObject inner

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName CWLFSMTDOCWI 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 Settlement Document Work Item view

Fields (48)

KeyFieldSource TableSource FieldDescription
KEY WorkflowTaskInternalID I_WorkflowTask WorkflowTaskInternalID Work Item ID
SettlmtDoc C_SettlmtDocWrkflwDet SettlmtDoc Settlement Doc.
SettlmtDocCurrency C_SettlmtDocWrkflwDet SettlmtDocCurrency Doc. Currency
CreatedByUser C_SettlmtDocWrkflwDet CreatedByUser User Name
UserFullName C_SettlmtDocWrkflwDet UserFullName Full Name
ConditionContract C_SettlmtDocWrkflwDet ConditionContract Condition Contract
DocumentTitle C_SettlmtDocWrkflwDet DocumentTitle Title
CustSettlmtCompanyCode C_SettlmtDocWrkflwDet CustSettlmtCompanyCode Cust. Company Code
PayerParty C_SettlmtDocWrkflwDet PayerParty Payer
InvoicingParty C_SettlmtDocWrkflwDet InvoicingParty Supplier
SuplrSettlmtCompanyCode C_SettlmtDocWrkflwDet SuplrSettlmtCompanyCode Suppl. Company Code
PayeeParty C_SettlmtDocWrkflwDet PayeeParty Payee
AlternativeInvoicingParty C_SettlmtDocWrkflwDet AlternativeInvoicingParty Alternative Supplier
BillToParty C_SettlmtDocWrkflwDet BillToParty Inv. Recipient
Division C_SettlmtDocWrkflwDet Division Internal Division ID
SettlmtDocType C_SettlmtDocWrkflwDet SettlmtDocType Settlement Document Type
PurchasingOrganization C_SettlmtDocWrkflwDet PurchasingOrganization Purchasing Organization
PurchasingGroup C_SettlmtDocWrkflwDet PurchasingGroup Purchasing Group
SalesOrganization C_SettlmtDocWrkflwDet SalesOrganization Sales Organization
DistributionChannel C_SettlmtDocWrkflwDet DistributionChannel RefDistCh-Cust/Mat.
SettlmtReltdCndnContr C_SettlmtDocWrkflwDet SettlmtReltdCndnContr Related Condition Contract
SalesOffice C_SettlmtDocWrkflwDet SalesOffice Sales Office
SalesGroup C_SettlmtDocWrkflwDet SalesGroup Sales Group
SettlmtDocAuthznCat C_SettlmtDocWrkflwDet SettlmtDocAuthznCat Authorization Cat.
_BillToParty C_SettlmtDocWrkflwDet _BillToParty
_Division C_SettlmtDocWrkflwDet _Division
_DistributionChannel C_SettlmtDocWrkflwDet _DistributionChannel
_PurchasingOrganization C_SettlmtDocWrkflwDet _PurchasingOrganization
_SalesOrganization C_SettlmtDocWrkflwDet _SalesOrganization
_CreatedByUser C_SettlmtDocWrkflwDet _CreatedByUser
_PayerPartyCompany C_SettlmtDocWrkflwDet _PayerPartyCompany
_BillToPartyCompany C_SettlmtDocWrkflwDet _BillToPartyCompany
_PayerParty C_SettlmtDocWrkflwDet _PayerParty
_InvoicingParty C_SettlmtDocWrkflwDet _InvoicingParty
_InvoicingPartyCompany C_SettlmtDocWrkflwDet _InvoicingPartyCompany
_PayeeParty C_SettlmtDocWrkflwDet _PayeeParty
_PayeePartyCompany C_SettlmtDocWrkflwDet _PayeePartyCompany
_AlternativeInvoicingParty C_SettlmtDocWrkflwDet _AlternativeInvoicingParty
_AltvInvoicingPartyCompany C_SettlmtDocWrkflwDet _AltvInvoicingPartyCompany
_CustSettlmtCompanyCode C_SettlmtDocWrkflwDet _CustSettlmtCompanyCode
_SuplrSettlmtCompanyCode C_SettlmtDocWrkflwDet _SuplrSettlmtCompanyCode
_SettlmtDocType C_SettlmtDocWrkflwDet _SettlmtDocType
_PurchasingGroup C_SettlmtDocWrkflwDet _PurchasingGroup
_SettlmtReltdCndnContr C_SettlmtDocWrkflwDet _SettlmtReltdCndnContr
_ConditionContract C_SettlmtDocWrkflwDet _ConditionContract
_SettlmtDocCurrency C_SettlmtDocWrkflwDet _SettlmtDocCurrency
_SalesOffice C_SettlmtDocWrkflwDet _SalesOffice
_SalesGroup C_SettlmtDocWrkflwDet _SalesGroup

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_SettlmtDocWorkItem.
-- 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_SettlmtDocWorkItem AS
SELECT
  _WorkflowTask.WorkflowTaskInternalID AS WorkflowTaskInternalID,
  _SettlmtDocWrkflwDet.SettlmtDoc AS SettlmtDoc,
  _SettlmtDocWrkflwDet.SettlmtDocCurrency AS SettlmtDocCurrency,
  _SettlmtDocWrkflwDet.CreatedByUser AS CreatedByUser,
  _SettlmtDocWrkflwDet.UserFullName AS UserFullName,
  _SettlmtDocWrkflwDet.ConditionContract AS ConditionContract,
  _SettlmtDocWrkflwDet.DocumentTitle AS DocumentTitle,
  _SettlmtDocWrkflwDet.CustSettlmtCompanyCode AS CustSettlmtCompanyCode,
  _SettlmtDocWrkflwDet.PayerParty AS PayerParty,
  _SettlmtDocWrkflwDet.InvoicingParty AS InvoicingParty,
  _SettlmtDocWrkflwDet.SuplrSettlmtCompanyCode AS SuplrSettlmtCompanyCode,
  _SettlmtDocWrkflwDet.PayeeParty AS PayeeParty,
  _SettlmtDocWrkflwDet.AlternativeInvoicingParty AS AlternativeInvoicingParty,
  _SettlmtDocWrkflwDet.BillToParty AS BillToParty,
  _SettlmtDocWrkflwDet.Division AS Division,
  _SettlmtDocWrkflwDet.SettlmtDocType AS SettlmtDocType,
  _SettlmtDocWrkflwDet.PurchasingOrganization AS PurchasingOrganization,
  _SettlmtDocWrkflwDet.PurchasingGroup AS PurchasingGroup,
  _SettlmtDocWrkflwDet.SalesOrganization AS SalesOrganization,
  _SettlmtDocWrkflwDet.DistributionChannel AS DistributionChannel,
  _SettlmtDocWrkflwDet.SettlmtReltdCndnContr AS SettlmtReltdCndnContr,
  _SettlmtDocWrkflwDet.SalesOffice AS SalesOffice,
  _SettlmtDocWrkflwDet.SalesGroup AS SalesGroup,
  _SettlmtDocWrkflwDet.SettlmtDocAuthznCat AS SettlmtDocAuthznCat,
  _SettlmtDocWrkflwDet._BillToParty AS _BillToParty,
  _SettlmtDocWrkflwDet._Division AS _Division,
  _SettlmtDocWrkflwDet._DistributionChannel AS _DistributionChannel,
  _SettlmtDocWrkflwDet._PurchasingOrganization AS _PurchasingOrganization,
  _SettlmtDocWrkflwDet._SalesOrganization AS _SalesOrganization,
  _SettlmtDocWrkflwDet._CreatedByUser AS _CreatedByUser,
  _SettlmtDocWrkflwDet._PayerPartyCompany AS _PayerPartyCompany,
  _SettlmtDocWrkflwDet._BillToPartyCompany AS _BillToPartyCompany,
  _SettlmtDocWrkflwDet._PayerParty AS _PayerParty,
  _SettlmtDocWrkflwDet._InvoicingParty AS _InvoicingParty,
  _SettlmtDocWrkflwDet._InvoicingPartyCompany AS _InvoicingPartyCompany,
  _SettlmtDocWrkflwDet._PayeeParty AS _PayeeParty,
  _SettlmtDocWrkflwDet._PayeePartyCompany AS _PayeePartyCompany,
  _SettlmtDocWrkflwDet._AlternativeInvoicingParty AS _AlternativeInvoicingParty,
  _SettlmtDocWrkflwDet._AltvInvoicingPartyCompany AS _AltvInvoicingPartyCompany,
  _SettlmtDocWrkflwDet._CustSettlmtCompanyCode AS _CustSettlmtCompanyCode,
  _SettlmtDocWrkflwDet._SuplrSettlmtCompanyCode AS _SuplrSettlmtCompanyCode,
  _SettlmtDocWrkflwDet._SettlmtDocType AS _SettlmtDocType,
  _SettlmtDocWrkflwDet._PurchasingGroup AS _PurchasingGroup,
  _SettlmtDocWrkflwDet._SettlmtReltdCndnContr AS _SettlmtReltdCndnContr,
  _SettlmtDocWrkflwDet._ConditionContract AS _ConditionContract,
  _SettlmtDocWrkflwDet._SettlmtDocCurrency AS _SettlmtDocCurrency,
  _SettlmtDocWrkflwDet._SalesOffice AS _SalesOffice,
  _SettlmtDocWrkflwDet._SalesGroup AS _SalesGroup
FROM I_WorkflowTask AS _WorkflowTask
INNER JOIN I_WorkflowTaskApplObject AS _WorkflowTaskApplObject ON /* join condition not captured in parsed metadata */
INNER JOIN C_SettlmtDocWrkflwDet AS _SettlmtDocWrkflwDet ON /* join condition not captured in parsed metadata */
;

Learn More