I_SupplierCompanyByPlant

DDL: I_SUPPLIERCOMPANYBYPLANT Type: view COMPOSITE

Supplier Company by Plant

I_SupplierCompanyByPlant is a Composite CDS View that provides data about "Supplier Company by Plant" in SAP S/4HANA. It reads from 3 data sources (I_SupplierCompany, I_Plant, I_Purreqvaluationarea) and exposes 6 fields with key fields Plant, Supplier.

3 data source(s) 6 fields

Data Sources (3)

SourceAliasJoin Type
I_SupplierCompany I_SupplierCompany inner
I_Plant plant from
I_Purreqvaluationarea val inner

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName ISUPPCOMP4PLANT view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Supplier Company by Plant view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MASTER view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
VDM.viewType #COMPOSITE view
Metadata.ignorePropagatedAnnotations true view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY Plant I_Plant Plant
KEY Supplier I_SupplierCompany Supplier
ValuationArea I_Purreqvaluationarea ValuationArea
CompanyCode I_Purreqvaluationarea CompanyCode
AuthorizationGroup I_SupplierCompany AuthorizationGroup
_Supplier I_SupplierCompany _Supplier 
@AbapCatalog: {
                sqlViewName: 'ISUPPCOMP4PLANT',
                preserveKey: true,
                compiler.compareFilter: true
              }
@EndUserText.label: 'Supplier Company by Plant'
@AccessControl: {
                  authorizationCheck: #CHECK,
                  personalData.blocking: #REQUIRED
                }
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel: {
                usageType: {
                             sizeCategory: #XXL,
                             serviceQuality: #C,
                             dataClass:#MASTER
                           },
                supportedCapabilities: [#SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE, #CDS_MODELING_ASSOCIATION_TARGET]
              }
@VDM: {
        lifecycle.contract.type: #PUBLIC_LOCAL_API, 
        viewType: #COMPOSITE
      }
@Metadata.ignorePropagatedAnnotations:true
define view I_SupplierCompanyByPlant 
as select from I_Plant as plant 
inner join I_Purreqvaluationarea as val on plant.ValuationArea = val.ValuationArea -- to one JOIN
inner join I_SupplierCompany on val.CompanyCode = I_SupplierCompany.CompanyCode -- to many JOIN
{
    key plant.Plant,
    @ObjectModel.foreignKey.association: '_Supplier'
    @Consumption.valueHelpDefinition: [
      { entity:  { name:    'I_Supplier_VH',
                   element: 'Supplier' }
      }]
    key I_SupplierCompany.Supplier,
    val.ValuationArea,
    val.CompanyCode,
    I_SupplierCompany.AuthorizationGroup,
    
    -- fields and associations for authorization checks
--    @Semantics.booleanIndicator: true          removed because of P2 ATC compatibility error
    IsBusinessPurposeCompleted,
    I_SupplierCompany._Supplier
} where plant.ValuationArea <> ''

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PLANT",
"I_PURREQVALUATIONAREA",
"I_SUPPLIERCOMPANY"
],
"ASSOCIATED":
[
"I_SUPPLIER"
],
"BASE":
[
"I_SUPPLIERCOMPANY"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More