I_WrntyAccountingControlDoc

DDL: I_WRNTYACCOUNTINGCONTROLDOC SQL: IWTYACCCONTR Type: view BASIC

Warranty accounting and Controlling Docs

I_WrntyAccountingControlDoc is a Basic CDS View that provides data about "Warranty accounting and Controlling Docs" in SAP S/4HANA. It reads from 2 data sources (cobk, I_WrntyClaimAccountingDocument) and exposes 19 fields with key fields CompanyCode, AccountingDocument.

Data Sources (2)

SourceAliasJoin Type
cobk ControlDoc inner
I_WrntyClaimAccountingDocument I_WrntyClaimAccountingDocument from

Annotations (11)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName IWTYACCCONTR view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Warranty accounting and Controlling Docs view
VDM.viewType #BASIC view
ObjectModel.representativeKey AccountingDocument view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_WrntyClaimAccountingDocument CompanyCode
KEY AccountingDocument cobk belnr
FiscalYear cobk gjahr
ReferenceDocumentType cobk awtyp
OriginalReferenceDocument cobk awkey
DocumentReferenceID I_WrntyClaimAccountingDocument DocumentReferenceID
AccountingDocumentCategory
WrntyVersionNumber I_WrntyClaimAccountingDocument WrntyVersionNumber
WarrantyClaimVersionPartner I_WrntyClaimAccountingDocument WarrantyClaimVersionPartner
PurchasingOrganization I_WrntyClaimAccountingDocument PurchasingOrganization
Plant I_WrntyClaimAccountingDocument Plant
WarrantyClaimType I_WrntyClaimAccountingDocument WarrantyClaimType
WrntySupplier I_WrntyClaimAccountingDocument WrntySupplier
WarrantyCustomer I_WrntyClaimAccountingDocument WarrantyCustomer
WrntyClaimHeaderUUID I_WrntyClaimAccountingDocument WrntyClaimHeaderUUID
_WrntyClaimHeader I_WrntyClaimAccountingDocument _WrntyClaimHeader
_CompanyCode I_WrntyClaimAccountingDocument _CompanyCode
_Supplier I_WrntyClaimAccountingDocument _Supplier
_Customer I_WrntyClaimAccountingDocument _Customer
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.sqlViewName: 'IWTYACCCONTR'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Warranty accounting and Controlling Docs'
@VDM.viewType: #BASIC
@ObjectModel:{
    representativeKey: 'AccountingDocument',
    usageType:{
        dataClass       : #TRANSACTIONAL,
        serviceQuality  : #D,
        sizeCategory    : #XL
        }
}
define view I_WrntyAccountingControlDoc
  as select from I_WrntyClaimAccountingDocument
    inner join   cobk as ControlDoc on  ControlDoc.kokrs = I_WrntyClaimAccountingDocument.CompanyCode
                                    and ControlDoc.gjahr = I_WrntyClaimAccountingDocument.FiscalYear
                                    and ControlDoc.awkey = I_WrntyClaimAccountingDocument.OriginalReferenceDocument
{
  key I_WrntyClaimAccountingDocument.CompanyCode,
  key ControlDoc.belnr                                   as AccountingDocument,
      ControlDoc.gjahr                                   as FiscalYear,
      ControlDoc.awtyp                                   as ReferenceDocumentType,
      ControlDoc.awkey                                   as OriginalReferenceDocument,
      I_WrntyClaimAccountingDocument.DocumentReferenceID as DocumentReferenceID,
      cast('P' as bstat_d)                               as AccountingDocumentCategory,
      I_WrntyClaimAccountingDocument.WrntyVersionNumber,
      //I_WrntyClaimAccountingDocument.WrntyPartNumber,

      I_WrntyClaimAccountingDocument.WarrantyClaimVersionPartner,
      I_WrntyClaimAccountingDocument.PurchasingOrganization,
      I_WrntyClaimAccountingDocument.Plant,
      I_WrntyClaimAccountingDocument.WarrantyClaimType,
      I_WrntyClaimAccountingDocument.WrntySupplier,
      I_WrntyClaimAccountingDocument.WarrantyCustomer,
      I_WrntyClaimAccountingDocument.WrntyClaimHeaderUUID,
      I_WrntyClaimAccountingDocument._WrntyClaimHeader,
      I_WrntyClaimAccountingDocument._CompanyCode,
      I_WrntyClaimAccountingDocument._Supplier,
      I_WrntyClaimAccountingDocument._Customer
}
where
  I_WrntyClaimAccountingDocument.ReferenceDocumentType = 'WTYD'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_WRNTYCLAIMACCOUNTINGDOCUMENT",
"COBK"
],
"ASSOCIATED":
[
"I_COMPANYCODE",
"I_CUSTOMER",
"I_SUPPLIER",
"I_WRNTYCLAIMHEADER"
],
"BASE":
[
"I_WRNTYCLAIMACCOUNTINGDOCUMENT"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/