I_ProdPlantPurchaseTax

DDL: I_PRODPLANTPURCHASETAX SQL: IPRDPLNTPURCHTAX Type: view COMPOSITE

Composite View - Prod Plant Purchase Tax

I_ProdPlantPurchaseTax is a Composite CDS View that provides data about "Composite View - Prod Plant Purchase Tax" in SAP S/4HANA. It reads from 4 data sources (I_Address_2, I_Plant, I_ProductPlantBasic, I_ProductPurchaseTax) and exposes 6 fields with key fields Product, SourceLocationCountry, Plant. It has 1 association to related views.

4 data source(s) 6 fields

Data Sources (4)

SourceAliasJoin Type
I_Address_2 Address inner
I_Plant Plant inner
I_ProductPlantBasic ProductPlant inner
I_ProductPurchaseTax PurchaseTax from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_Product _Product $projection.Product = _Product.Product

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName IPRDPLNTPURCHTAX view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Composite View - Prod Plant Purchase Tax view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY Product I_ProductPurchaseTax Product
KEY SourceLocationCountry I_ProductPurchaseTax SourceLocationCountry
KEY Plant I_Plant Plant
TaxIndicator I_ProductPurchaseTax TaxIndicator
_Product _Product
_Country I_ProductPurchaseTax _Country 
@AbapCatalog.sqlViewName: 'IPRDPLNTPURCHTAX'
@VDM.viewType: #COMPOSITE
//@VDM.private: true

@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Composite View - Prod Plant Purchase Tax'
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory : #L
@ObjectModel.usageType.dataClass: #MASTER
@ClientHandling.algorithm: #SESSION_VARIABLE

define view I_ProdPlantPurchaseTax
  as select from I_ProductPurchaseTax as PurchaseTax
    inner join   I_Address_2 as Address on Address.Country = PurchaseTax.SourceLocationCountry  //BSREQ-3882

    inner join   I_Plant   as Plant   on Plant.AddressID = Address.AddressID
    inner join   I_ProductPlantBasic as ProductPlant on ProductPlant.Product = PurchaseTax.Product
                                                     and ProductPlant.Plant = Plant.Plant
  association [1..1] to I_Product as _Product on $projection.Product = _Product.Product
{
  key PurchaseTax.Product,
  key PurchaseTax.SourceLocationCountry,
  key Plant.Plant,
      //      Plant.PlantName,

      PurchaseTax.TaxIndicator,

      _Product,
      PurchaseTax._Country
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ADDRESS_2",
"I_PLANT",
"I_PRODUCTPLANTBASIC",
"I_PRODUCTPURCHASETAX"
],
"ASSOCIATED":
[
"I_COUNTRY",
"I_PRODUCT"
],
"BASE":
[
"I_PRODUCTPURCHASETAX"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More