I_TranspPurgOrgCoCodeAssgmt

DDL: I_TRANSPPURGORGCOCODEASSGMT Type: view_entity COMPOSITE Package: VDM_TM_ORG_UNIT

Purchasing Org Company Code Assignment

I_TranspPurgOrgCoCodeAssgmt is a Composite CDS View that provides data about "Purchasing Org Company Code Assignment" in SAP S/4HANA. It reads from 2 data sources (I_PlantPurchasingOrganization, I_TranspPurgOrg) and exposes 4 fields with key fields TranspPurgOrg, CompanyCode, CompanyCode. It has 1 association to related views. Part of development package VDM_TM_ORG_UNIT.

2 data source(s) 4 fields

Data Sources (2)

SourceAliasJoin Type
I_PlantPurchasingOrganization I_PlantPurchasingOrganization union
I_TranspPurgOrg I_TranspPurgOrg from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_CompanyCode _CompanyCode $projection.CompanyCode = _CompanyCode.CompanyCode

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Purchasing Org Company Code Assignment view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #ORGANIZATIONAL view
VDM.viewType #COMPOSITE view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY TranspPurgOrg TranspPurgOrg
KEY CompanyCode CompanyCode
KEY CompanyCode
_CompanyCode _CompanyCode 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Purchasing Org Company Code Assignment'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
    serviceQuality: #B,
    sizeCategory: #S,
    dataClass: #ORGANIZATIONAL
}
@ObjectModel.supportedCapabilities: [ #SQL_DATA_SOURCE,
                                      #CDS_MODELING_DATA_SOURCE,
                                      #CDS_MODELING_ASSOCIATION_TARGET ]

@VDM.viewType: #COMPOSITE
define view entity I_TranspPurgOrgCoCodeAssgmt as select from I_TranspPurgOrg
{
  key TranspPurgOrg,
  key CompanyCode,
      
      /* Associations */
      _CompanyCode
} where CompanyCode <> ''

union select from I_PlantPurchasingOrganization
  association [0..1] to I_CompanyCode as _CompanyCode on $projection.CompanyCode = _CompanyCode.CompanyCode
{
  key cast( PurchasingOrganization as /scmtms/purch_org preserving type ) as TranspPurgOrg,
  key cast( _Plant._ValuationArea.CompanyCode as /scmtms/purch_company_code preserving type ) as CompanyCode,
      
      /* Associations */
      _CompanyCode
} where _Plant._ValuationArea.CompanyCode <> ''

Learn More