P_CompanyCodeDetailsPT

DDL: P_COMPANYCODEDETAILSPT Type: view_entity COMPOSITE Package: GLO_FIN_IS_VAT_PT

Company Code details PT

P_CompanyCodeDetailsPT is a Composite CDS View that provides data about "Company Code details PT" in SAP S/4HANA. It reads from 2 data sources (I_CompanyCode, t001n) and exposes 7 fields with key fields CompanyCode, Country, Country. Part of development package GLO_FIN_IS_VAT_PT.

2 data source(s) 7 fields

Data Sources (2)

SourceAliasJoin Type
I_CompanyCode I_CompanyCode union
t001n t001n from

Annotations (5)

NameValueLevelField
VDM.private true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Company Code details PT view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode t001n bukrs
KEY Country t001n land1
VATRegistration t001n stceg
CompanyCode
KEY Country I_CompanyCode Country
VATRegistration I_CompanyCode VATRegistration
VATRegistration_wo_prefix 
@VDM.private: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #COMPOSITE
@Metadata.ignorePropagatedAnnotations : true
@EndUserText.label: 'Company Code details PT'
define view entity P_CompanyCodeDetailsPT
  as select from t001n
    join         I_CompanyCode on  I_CompanyCode.CompanyCode =  t001n.bukrs
                               and I_CompanyCode.Country     <> t001n.land1
{

  key t001n.bukrs                   as CompanyCode,
  key t001n.land1                   as Country,
      t001n.stceg                   as VATRegistration,
      substring(t001n.stceg, 3, 18) as VATRegistration_wo_prefix
}
union select from I_CompanyCode
{
  key I_CompanyCode.CompanyCode,
  key I_CompanyCode.Country,
      I_CompanyCode.VATRegistration,
      substring(I_CompanyCode.VATRegistration, 3, 18) as VATRegistration_wo_prefix

}

Learn More