P_CompanyCodeDetailsBE

DDL: P_COMPANYCODEDETAILSBE Type: view_entity CONSUMPTION Package: GLO_FIN_IS_VAT_BE

Company Code details BE

P_CompanyCodeDetailsBE is a Consumption CDS View that provides data about "Company Code details BE" in SAP S/4HANA. It reads from 2 data sources (I_CompanyCode, I_CompanyTaxDetail) and exposes 5 fields with key fields CompanyCode, Country, Country. Part of development package GLO_FIN_IS_VAT_BE.

2 data source(s) 5 fields

Data Sources (2)

SourceAliasJoin Type
I_CompanyCode I_CompanyCode union
I_CompanyTaxDetail I_CompanyTaxDetail from

Annotations (4)

NameValueLevelField
VDM.private true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #CONSUMPTION view
Metadata.ignorePropagatedAnnotations true view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_CompanyTaxDetail CompanyCode
KEY Country I_CompanyTaxDetail Country
CompanyCode
KEY Country I_CompanyCode Country
VATRegistration I_CompanyCode VATRegistration 
@VDM.private: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #CONSUMPTION
@Metadata.ignorePropagatedAnnotations : true


define view entity  P_CompanyCodeDetailsBE
  as select from I_CompanyTaxDetail
    join         I_CompanyCode on  I_CompanyCode.CompanyCode =  I_CompanyTaxDetail.CompanyCode
                               and I_CompanyCode.Country     <> I_CompanyTaxDetail.Country
{

  key I_CompanyTaxDetail.CompanyCode,                 
  key I_CompanyTaxDetail.Country,                 
      I_CompanyTaxDetail.VATRegistration                   
      
}
union select from I_CompanyCode
{
  key I_CompanyCode.CompanyCode,
  key I_CompanyCode.Country,
      I_CompanyCode.VATRegistration
     
}

Learn More