P_TW_AcctgDocLeadingTaxCode

DDL: P_TW_ACCTGDOCLEADINGTAXCODE Type: view_entity COMPOSITE Package: GLO_FIN_IS_VAT_TW

Accounting Document Leading Tax Code

P_TW_AcctgDocLeadingTaxCode is a Composite CDS View that provides data about "Accounting Document Leading Tax Code" in SAP S/4HANA. It reads from 2 data sources (P_TW_TaxItemTaxCode, I_TaxItem) and exposes 6 fields with key fields CompanyCode, FiscalYear, AccountingDocument, TaxItem. Part of development package GLO_FIN_IS_VAT_TW.

2 data source(s) 6 fields

Data Sources (2)

SourceAliasJoin Type
P_TW_TaxItemTaxCode _Leading from
I_TaxItem _TaxItem inner

Annotations (5)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Accounting Document Leading Tax Code view
Metadata.ignorePropagatedAnnotations true view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode P_TW_TaxItemTaxCode CompanyCode
KEY FiscalYear P_TW_TaxItemTaxCode FiscalYear
KEY AccountingDocument P_TW_TaxItemTaxCode AccountingDocument
KEY TaxItem P_TW_TaxItemTaxCode TaxItem
TaxCodeIsLeading P_TW_TaxItemTaxCode TaxCodeIsLeading
TaxCode I_TaxItem TaxCode 
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Accounting Document Leading Tax Code'
@Metadata.ignorePropagatedAnnotations: true
@VDM.private:true
@VDM.viewType: #COMPOSITE
define view entity P_TW_AcctgDocLeadingTaxCode 
//as select from ZP_TW_TaxItemWithTaxCode as  _Leading

//inner join ZI_tw_bset as _TaxItem on _TaxItem.CompanyCode = _Leading.CompanyCode

as select from P_TW_TaxItemTaxCode  as  _Leading
inner join I_TaxItem as _TaxItem on _TaxItem.CompanyCode          = _Leading.CompanyCode 
                                 and  _TaxItem.FiscalYear         = _Leading.FiscalYear 
                                 and _TaxItem.AccountingDocument  = _Leading.AccountingDocument
                                 and _TaxItem.TaxItem             = _Leading.TaxItem
{
  key _Leading.CompanyCode        as CompanyCode,
  key _Leading.FiscalYear         as FiscalYear,
  key _Leading.AccountingDocument as AccountingDocument,
  key _Leading.TaxItem            as TaxItem,
  _Leading.TaxCodeIsLeading       as TaxCodeIsLeading,
  _TaxItem.TaxCode                as TaxCode
}

Learn More