C_APARWorklist

DDL: C_APARWORKLIST Type: view CONSUMPTION
13 Fields 1 Data Sources 1 Associations

Open items which are not cleared in session of Write off

C_APARWorklist is a Consumption CDS View that provides data about "Open items which are not cleared in session of Write off" in SAP S/4HANA. It reads from 1 data source (I_APARWorklist) and exposes 13 fields with key fields CompanyCode, APARAccount. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_APARWorklist open_items from

Parameters (1)

NameTypeDefault
P_PostingDate sydate

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_CompanyCode _companycode open_items.CompanyCode = _companycode.CompanyCode

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName CAPARWORKLIST view
AbapCatalog.preserveKey true view
EndUserText.label Open items which are not cleared in session of Write off view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #CONSUMPTION view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_APARWorklist CompanyCode Receiver Company Code
KEY APARAccount I_APARWorklist APARAccount Account
FinancialAccountType I_APARWorklist FinancialAccountType Fin. Account Type
Customer
CustomerBasicAuthorizationGrp I_APARWorklist CustomerBasicAuthorizationGrp
CustomerFinsAuthorizationGrp I_APARWorklist CustomerFinsAuthorizationGrp
Supplier
SupplierBasicAuthorizationGrp I_APARWorklist SupplierBasicAuthorizationGrp
SupplierFinsAuthorizationGrp I_APARWorklist SupplierFinsAuthorizationGrp
TotalAmountInCoCodeCrcy
CompanyCodeCurrency I_APARWorklist CompanyCodeCurrency Local Currency
CustomerName I_APARWorklist CustomerName Name of Customer
CompanyCodeName _companycode CompanyCodeName Company Name

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_APARWorklist.
-- 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.
-- Parameters: P_PostingDate : sydate

CREATE VIEW C_APARWorklist AS
SELECT
  open_items.CompanyCode AS CompanyCode,
  open_items.APARAccount AS APARAccount,
  open_items.FinancialAccountType AS FinancialAccountType,
  cast ( open_items.Customer as fis_kunnr ) AS Customer,
  open_items.CustomerBasicAuthorizationGrp AS CustomerBasicAuthorizationGrp,
  open_items.CustomerFinsAuthorizationGrp AS CustomerFinsAuthorizationGrp,
  cast (open_items.Supplier as fis_lifnr ) AS Supplier,
  open_items.SupplierBasicAuthorizationGrp AS SupplierBasicAuthorizationGrp,
  open_items.SupplierFinsAuthorizationGrp AS SupplierFinsAuthorizationGrp,
  cast( sum(open_items.TotalAmountInCoCodeCrcy) as dmshb_farp ) AS TotalAmountInCoCodeCrcy,
  open_items.CompanyCodeCurrency AS CompanyCodeCurrency,
  open_items.CustomerName AS CustomerName,
  _companycode.CompanyCodeName AS CompanyCodeName
FROM I_APARWorklist AS open_items
LEFT OUTER JOIN I_CompanyCode AS _companycode ON open_items.CompanyCode = _companycode.CompanyCode  -- association [1..1]
;

Learn More