P_TaxExplainerSalesOrderHeader

DDL: P_TAXEXPLAINERSALESORDERHEADER Type: view_entity COMPOSITE Package: GLO_TAXEXPLAIN_SO

Sales order header details for Tax explainer

P_TaxExplainerSalesOrderHeader is a Composite CDS View that provides data about "Sales order header details for Tax explainer" in SAP S/4HANA. It reads from 1 data source (I_SalesDocumentBasic) and exposes 16 fields with key field SalesDocument. It has 3 associations to related views. Part of development package GLO_TAXEXPLAIN_SO.

1 data source(s) 16 fields

Data Sources (1)

SourceAliasJoin Type
I_SalesDocumentBasic TaxDocHeader from

Associations (3)

CardinalityTargetAliasCondition
[1..1] P_TaxExplainerSlsOrdHdrAmt _TaxTotals $projection.SalesDocument = _TaxTotals.SalesDocument
[1..*] P_TaxExplainerSalesOrderItem _TaxDocItem $projection.SalesDocument = _TaxDocItem.SalesDocument
[0..*] P_TaxExplainerSlsOrdTaxComp _AppliedTaxComps $projection.SalesDocument = _AppliedTaxComps.SalesDocument

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #COMPOSITE view
VDM.private true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY SalesDocument SalesDocument
TransactionCurrency TransactionCurrency
TotalNetOfItem _TaxTotals TotalNetAmount
TotalTaxOfItem _TaxTotals TotalTaxAmount
TotalGrossOfItem _TaxTotals TotalGrossAmount
TotalNetAmount TotalNetAmount
ItemCount _TaxTotals ItemCount
SalesOrganization SalesOrganization
DistributionChannel DistributionChannel
OrganizationDivision OrganizationDivision
SDPricingProcedure SDPricingProcedure
SalesDocumentCondition SalesDocumentCondition
SDDocumentCategory SDDocumentCategory
SalesDocumentType SalesDocumentType
_TaxDocItem _TaxDocItem
_AppliedTaxComps _AppliedTaxComps 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
//@EndUserText.label: 'Sales order header details for Tax explainer'

@Metadata.ignorePropagatedAnnotations: true
@VDM.viewType:#COMPOSITE
@VDM.private:true
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #S,
  dataClass: #MIXED
}
define view entity P_TaxExplainerSalesOrderHeader
  as select from I_SalesDocumentBasic as TaxDocHeader
  association [1..1] to P_TaxExplainerSlsOrdHdrAmt   as _TaxTotals       on $projection.SalesDocument = _TaxTotals.SalesDocument
  association [1..*] to P_TaxExplainerSalesOrderItem as _TaxDocItem      on $projection.SalesDocument = _TaxDocItem.SalesDocument
  association [0..*] to P_TaxExplainerSlsOrdTaxComp  as _AppliedTaxComps on $projection.SalesDocument = _AppliedTaxComps.SalesDocument
{
  key SalesDocument,
      TransactionCurrency,
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      _TaxTotals.TotalNetAmount   as TotalNetOfItem,
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      _TaxTotals.TotalTaxAmount   as TotalTaxOfItem,
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      _TaxTotals.TotalGrossAmount as TotalGrossOfItem,
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      TotalNetAmount,


      case
      when TaxDocHeader.TaxDepartureCountry is initial
      then _BillingCompanyCode.Country
      else  TaxDocHeader.TaxDepartureCountry
      end                         as TaxDepartureCountry,

      _TaxTotals.ItemCount,

      //Non-JSON Fields

      SalesOrganization,
      DistributionChannel,
      OrganizationDivision,
      SDPricingProcedure,
      SalesDocumentCondition,
      SDDocumentCategory,
      SalesDocumentType,

      //Associations


      _TaxDocItem,
      _AppliedTaxComps
}

Learn More