P_IN_CustomerTaxNumber

DDL: P_IN_CUSTOMERTAXNUMBER Type: view_entity COMPOSITE Package: J1I_GST_LOG_APP

Customer Tax Number

P_IN_CustomerTaxNumber is a Composite CDS View that provides data about "Customer Tax Number" in SAP S/4HANA. It reads from 4 data sources (I_BusinessPartner, I_Businesspartnertaxnumber, I_Customer, I_CustomerToBusinessPartner) and exposes 6 fields with key fields Customer, BusinessPartner, AddressID. Part of development package J1I_GST_LOG_APP.

4 data source(s) 6 fields

Data Sources (4)

SourceAliasJoin Type
I_BusinessPartner I_BusinessPartner inner
I_Businesspartnertaxnumber I_Businesspartnertaxnumber inner
I_Customer I_Customer from
I_CustomerToBusinessPartner I_CustomerToBusinessPartner inner

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #COMPOSITE view
VDM.private true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MASTER view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY Customer I_Customer Customer
KEY BusinessPartner I_BusinessPartner BusinessPartner
KEY AddressID I_Customer AddressID
TaxNumber3 I_Businesspartnertaxnumber BPTaxNumber
Region I_Customer Region
IN_GSTLegalStateCode I_IN_GSTStateCodeMap IN_GSTLegalStateCode 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
//@EndUserText.label: 'Customer India Tax Number'

@Metadata.ignorePropagatedAnnotations: true
@VDM.viewType: #COMPOSITE
@VDM.private: true
@ObjectModel.usageType:{
  serviceQuality: #C,
  sizeCategory: #XL,
  dataClass: #MASTER
}
define view entity P_IN_CustomerTaxNumber
  as select from           I_Customer
    inner join             I_CustomerToBusinessPartner on I_CustomerToBusinessPartner.Customer = I_Customer.Customer
    inner join             I_BusinessPartner           on I_BusinessPartner.BusinessPartnerUUID = I_CustomerToBusinessPartner.BusinessPartnerUUID
    inner join             I_Businesspartnertaxnumber  on  I_Businesspartnertaxnumber.BusinessPartner = I_BusinessPartner.BusinessPartner
                                                       and I_Businesspartnertaxnumber.BPTaxType       = 'IN3'
    left outer to one join I_IN_GSTStateCodeMap        on  I_IN_GSTStateCodeMap.Country = I_Customer.Country
                                                       and I_IN_GSTStateCodeMap.Region  = I_Customer.Region

{
  key I_Customer.Customer,
  key I_BusinessPartner.BusinessPartner,
  key I_Customer.AddressID                      as AddressID,
      I_Businesspartnertaxnumber.BPTaxNumber    as TaxNumber3,
      I_Customer.Region                         as Region,
      I_IN_GSTStateCodeMap.IN_GSTLegalStateCode as IN_GSTLegalStateCode
}
where
  I_Customer.Country = 'IN'

Learn More