P_CO_DIANMinXrefSupplier

DDL: P_CO_DIANMINXREFSUPPLIER SQL: PCOMINXREFSUPP Type: view CONSUMPTION

All Formats - Supplier XREF

P_CO_DIANMinXrefSupplier is a Consumption CDS View that provides data about "All Formats - Supplier XREF" in SAP S/4HANA. It reads from 1 data source (I_Supplier) and exposes 8 fields with key fields CompanyCode, TaxNumber1, TaxNumber2, TaxNumber3, TaxNumber4.

1 data source(s) 8 fields

Data Sources (1)

SourceAliasJoin Type
I_Supplier I_Supplier from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PCOMINXREFSUPP view
VDM.private true view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.buffering.status #NOT_ALLOWED view
Metadata.ignorePropagatedAnnotations true view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
EndUserText.label All Formats - Supplier XREF view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode _SupplierCompany CompanyCode
KEY TaxNumber1 TaxNumber1
KEY TaxNumber2 TaxNumber2
KEY TaxNumber3 TaxNumber3
KEY TaxNumber4 TaxNumber4
KEY TaxNumber5 TaxNumber5
KEY VATRegistration VATRegistration
Supplier 
@AbapCatalog.sqlViewName: 'PCOMINXREFSUPP'
@VDM.private:true
@VDM.viewType: #CONSUMPTION
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.buffering.status: #NOT_ALLOWED
@Metadata.ignorePropagatedAnnotations: true
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@EndUserText.label: 'All Formats - Supplier XREF'

-- View to get the minimum available Supplier based on a given TaxNumber1 (see view P_CO_DIANStrp1001ReptableItems)
define view P_CO_DIANMinXrefSupplier
  as select from I_Supplier
{
  key _SupplierCompany.CompanyCode,
  key TaxNumber1,
  key TaxNumber2,
  key TaxNumber3,
  key TaxNumber4,
  key TaxNumber5,
  key VATRegistration,
  
      cast(min(Supplier) as lifnr preserving type) as Supplier
}
where
      ( TaxNumber1 <> '' and TaxNumber1 is not null )
   or ( TaxNumber2 <> '' and TaxNumber2 is not null )
   or ( TaxNumber3 <> '' and TaxNumber3 is not null )
   or ( TaxNumber4 <> '' and TaxNumber4 is not null )
   or ( TaxNumber5 <> '' and TaxNumber5 is not null )
   or ( VATRegistration <> '' and VATRegistration is not null )
group by
  _SupplierCompany.CompanyCode,
  TaxNumber1,
  TaxNumber2,
  TaxNumber3,
  TaxNumber4,
  TaxNumber5,
  VATRegistration
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SUPPLIER",
"I_SUPPLIERCOMPANY"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More