P_UA_TaxItemReasonCode

DDL: P_UA_TAXITEMREASONCODE SQL: PUATAXITMRSNCODE Type: view_entity COMPOSITE Package: GLO_FIN_IS_VAT_UA_RETURN

Private view to fetch reason codes

P_UA_TaxItemReasonCode is a Composite CDS View that provides data about "Private view to fetch reason codes" in SAP S/4HANA. It reads from 2 data sources (I_UA_TaxCodeReasonType, I_TaxItem) and exposes 6 fields with key fields CompanyCode, AccountingDocument, FiscalYear, UA_InvoiceDocumentDirection, UA_SpecialTaxCodeReason. Part of development package GLO_FIN_IS_VAT_UA_RETURN.

2 data source(s) 6 fields

Data Sources (2)

SourceAliasJoin Type
I_UA_TaxCodeReasonType _ReasonCode inner
I_TaxItem I_TaxItem from

Annotations (7)

NameValueLevelField
Analytics.technicalName PUA_TxItmRsnCode view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
VDM.private true view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_TaxItem CompanyCode
KEY AccountingDocument I_TaxItem AccountingDocument
KEY FiscalYear
KEY UA_InvoiceDocumentDirection I_UA_TaxCodeReasonType UA_InvoiceDocumentDirection
KEY UA_SpecialTaxCodeReason I_UA_TaxCodeReasonType UA_SpecialTaxCodeReason
KEY TaxCode I_UA_TaxCodeReasonType TaxCode 
//@AbapCatalog.sqlViewName: 'PUATAXITMRSNCODE'

@Analytics.technicalName: 'PUA_TxItmRsnCode'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #COMPOSITE
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass:  #MASTER
@ObjectModel.usageType.serviceQuality: #C
@VDM.private: true
//@EndUserText.label: 'Private view to fetch reason codes'



define view entity P_UA_TaxItemReasonCode
  as select from I_TaxItem

    inner join   I_UA_TaxCodeReasonType as _ReasonCode on  (
                                                      I_TaxItem.CompanyCode   = _ReasonCode.CompanyCode
                                                 or   _ReasonCode.CompanyCode       = ''
                                                     )
                                                 and I_TaxItem.TaxCode = _ReasonCode.TaxCode

{
  key I_TaxItem.CompanyCode,
  key I_TaxItem.AccountingDocument,
  key cast (I_TaxItem.FiscalYear as fis_gjahr_no_conv )                 as FiscalYear,
  key _ReasonCode.UA_InvoiceDocumentDirection as UA_InvoiceDocumentDirection,
  key _ReasonCode.UA_SpecialTaxCodeReason      as UA_SpecialTaxCodeReason,
  key _ReasonCode.TaxCode     as TaxCode
      //category as UA_SpecialTaxCodeCategory

}
  where _ReasonCode.UA_SpecialTaxCodeReason is not null

Learn More