I_WrntyAccountingLedgerDoc

DDL: I_WRNTYACCOUNTINGLEDGERDOC SQL: IWTYACCLDGR Type: view BASIC
19 Fields 2 Data Sources

Wrnty Accounting and Ledger Docs

I_WrntyAccountingLedgerDoc is a Basic CDS View that provides data about "Wrnty Accounting and Ledger Docs" in SAP S/4HANA. It reads from 2 data sources (I_WrntyClaimAccountingDocument, glidxa) and exposes 19 fields with key fields AccountingDocument, WrntyVersionNumber, SpecialLedgerDocumentNumber.

Data Sources (2)

SourceAliasJoin Type
I_WrntyClaimAccountingDocument I_WrntyClaimAccountingDocument from
glidxa spledger inner

Annotations (11)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName IWTYACCLDGR view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Wrnty Accounting and Ledger Docs view
VDM.viewType #BASIC view
ObjectModel.representativeKey SpecialLedgerDocumentNumber view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY AccountingDocument I_WrntyClaimAccountingDocument AccountingDocument Journal Entry
KEY WrntyVersionNumber I_WrntyClaimAccountingDocument WrntyVersionNumber Version
KEY SpecialLedgerDocumentNumber glidxa docnr Well doc.no.
CompanyCode glidxa bukrs Value
FiscalYear glidxa ryear Ref. Year1
ReferenceDocumentType glidxa awtyp Reference Document Type
DocumentReferenceID I_WrntyClaimAccountingDocument DocumentReferenceID Reference
OriginalReferenceDocument I_WrntyClaimAccountingDocument OriginalReferenceDocument Reference Key
PurchasingOrganization I_WrntyClaimAccountingDocument PurchasingOrganization Purchasing Organization
Plant I_WrntyClaimAccountingDocument Plant Valuation Area
WarrantyClaimType I_WrntyClaimAccountingDocument WarrantyClaimType WtyClmType
WarrantyClaimVersionPartner I_WrntyClaimAccountingDocument WarrantyClaimVersionPartner Partner
WrntyClaimHeaderUUID I_WrntyClaimAccountingDocument WrntyClaimHeaderUUID Internal Number
WrntySupplier I_WrntyClaimAccountingDocument WrntySupplier Partner(Suplr)
WarrantyCustomer I_WrntyClaimAccountingDocument WarrantyCustomer Partner
AccountingDocumentCategory
_WrntyClaimHeader I_WrntyClaimAccountingDocument _WrntyClaimHeader
_Supplier I_WrntyClaimAccountingDocument _Supplier
_Customer I_WrntyClaimAccountingDocument _Customer

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_WrntyAccountingLedgerDoc.
-- 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.
-- SQL view name: IWTYACCLDGR

CREATE VIEW I_WrntyAccountingLedgerDoc AS
SELECT
  I_WrntyClaimAccountingDocument.AccountingDocument AS AccountingDocument,
  I_WrntyClaimAccountingDocument.WrntyVersionNumber AS WrntyVersionNumber,
  spledger.docnr AS SpecialLedgerDocumentNumber,
  spledger.bukrs AS CompanyCode,
  spledger.ryear AS FiscalYear,
  spledger.awtyp AS ReferenceDocumentType,
  I_WrntyClaimAccountingDocument.DocumentReferenceID AS DocumentReferenceID,
  I_WrntyClaimAccountingDocument.OriginalReferenceDocument AS OriginalReferenceDocument,
  I_WrntyClaimAccountingDocument.PurchasingOrganization AS PurchasingOrganization,
  I_WrntyClaimAccountingDocument.Plant AS Plant,
  I_WrntyClaimAccountingDocument.WarrantyClaimType AS WarrantyClaimType,
  I_WrntyClaimAccountingDocument.WarrantyClaimVersionPartner AS WarrantyClaimVersionPartner,
  I_WrntyClaimAccountingDocument.WrntyClaimHeaderUUID AS WrntyClaimHeaderUUID,
  I_WrntyClaimAccountingDocument.WrntySupplier AS WrntySupplier,
  I_WrntyClaimAccountingDocument.WarrantyCustomer AS WarrantyCustomer,
  cast('1' as bstat_d) AS AccountingDocumentCategory,
  I_WrntyClaimAccountingDocument._WrntyClaimHeader AS _WrntyClaimHeader,
  I_WrntyClaimAccountingDocument._Supplier AS _Supplier,
  I_WrntyClaimAccountingDocument._Customer AS _Customer
FROM I_WrntyClaimAccountingDocument
INNER JOIN glidxa AS spledger ON /* join condition not captured in parsed metadata */
;

Learn More