I_APARWorklist

DDL: I_APARWORKLIST Type: view COMPOSITE
21 Fields 1 Data Sources

Open items which are not cleared in session of Write off

I_APARWorklist is a Composite 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_OperationalAcctgDocItem) and exposes 21 fields with key fields CompanyCode, AccountingDocument, FiscalYear, AccountingDocumentItem.

Data Sources (1)

SourceAliasJoin Type
I_OperationalAcctgDocItem open_items from

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IAPARWORKLIST 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 #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #COMPOSITE view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_OperationalAcctgDocItem CompanyCode Receiver Company Code
KEY AccountingDocument I_OperationalAcctgDocItem AccountingDocument Journal Entry
KEY FiscalYear I_OperationalAcctgDocItem FiscalYear G/L Fiscal Year
KEY AccountingDocumentItem I_OperationalAcctgDocItem AccountingDocumentItem Posting View Item
DebitCreditCode I_OperationalAcctgDocItem DebitCreditCode Single-Character Flag
APARAccount I_OperationalAcctgDocItem Customer Sold-to Party
FinancialAccountType I_OperationalAcctgDocItem FinancialAccountType Fin. Account Type
Customer I_OperationalAcctgDocItem Customer Sold-to Party
CustomerBasicAuthorizationGrp
CustomerFinsAuthorizationGrp
Supplier I_OperationalAcctgDocItem Supplier Supplier
SupplierBasicAuthorizationGrp
SupplierFinsAuthorizationGrp
TotalAmountInCoCodeCrcy I_OperationalAcctgDocItem AmountInCompanyCodeCurrency Local Crcy Amt
CompanyCodeCurrency I_OperationalAcctgDocItem CompanyCodeCurrency Local Currency
CustomerName
PostingDate I_OperationalAcctgDocItem PostingDate Posting Date for GR
FollowOnDocumentType I_OperationalAcctgDocItem FollowOnDocumentType Follow-On Document Type
SpecialGLTransactionType I_OperationalAcctgDocItem SpecialGLTransactionType Transact.Type
IsUsedInPaymentTransaction I_OperationalAcctgDocItem IsUsedInPaymentTransaction Is Used In Payment Transaction
SpecialGLCode I_OperationalAcctgDocItem SpecialGLCode Special G/L Ind

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_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.

CREATE VIEW I_APARWorklist AS
SELECT
  open_items.CompanyCode AS CompanyCode,
  open_items.AccountingDocument AS AccountingDocument,
  open_items.FiscalYear AS FiscalYear,
  open_items.AccountingDocumentItem AS AccountingDocumentItem,
  open_items.DebitCreditCode AS DebitCreditCode,
  open_items.Customer AS APARAccount,
  open_items.FinancialAccountType AS FinancialAccountType,
  open_items.Customer AS Customer,
  open_items._Customer.AuthorizationGroup AS CustomerBasicAuthorizationGrp,
  open_items._CustomerCompany.AuthorizationGroup AS CustomerFinsAuthorizationGrp,
  open_items.Supplier AS Supplier,
  cast( '' as brgru) AS SupplierBasicAuthorizationGrp,
  cast( '' as brgru) AS SupplierFinsAuthorizationGrp,
  open_items.AmountInCompanyCodeCurrency AS TotalAmountInCoCodeCrcy,
  open_items.CompanyCodeCurrency AS CompanyCodeCurrency,
  open_items._CustomerText.CustomerName AS CustomerName,
  open_items.PostingDate AS PostingDate,
  open_items.FollowOnDocumentType AS FollowOnDocumentType,
  open_items.SpecialGLTransactionType AS SpecialGLTransactionType,
  open_items.IsUsedInPaymentTransaction AS IsUsedInPaymentTransaction,
  open_items.SpecialGLCode AS SpecialGLCode
FROM I_OperationalAcctgDocItem AS open_items
;

Learn More