Which tables does P_MLColl_DirectPayers1 use?

P_MLColl_DirectPayers1 reads from 10 data source(s): I_CustomerCompany, I_CustomerCompany, I_CustomerCompany, I_CustomerCompany, I_CustomerCompany, I_CustomerCompany, I_CustomerCompany, I_CustomerCompany, I_CustomerCompany, I_CustomerCompany.

How many fields does P_MLColl_DirectPayers1 have?

P_MLColl_DirectPayers1 has 42 fields. Key fields: Customer, CompanyCode, CompanyCode, CompanyCode, CompanyCode.

P_MLColl_DirectPayers1

DDL: P_MLCOLL_DIRECTPAYERS1 Type: view COMPOSITE

P_MLColl_DirectPayers1 is a Composite CDS View in SAP S/4HANA. It reads from 10 data sources and exposes 42 fields with key fields Customer, CompanyCode, CompanyCode, CompanyCode, CompanyCode.

Data Sources (10)

Source	Alias	Join Type
I_CustomerCompany	I_CustomerCompany	from
I_CustomerCompany	I_CustomerCompany	union
I_CustomerCompany	I_CustomerCompany	union
I_CustomerCompany	I_CustomerCompany	union
I_CustomerCompany	I_CustomerCompany	union
I_CustomerCompany	I_CustomerCompany	union
I_CustomerCompany	I_CustomerCompany	union
I_CustomerCompany	I_CustomerCompany	union
I_CustomerCompany	I_CustomerCompany	union
I_CustomerCompany	I_CustomerCompany	union

Annotations (7)

Name	Value	Level
AbapCatalog.sqlViewName	PMLDIRECTPAYERS1	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.preserveKey	true	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
AccessControl.authorizationCheck	#NOT_REQUIRED	view
VDM.private	true	view
VDM.viewType	#COMPOSITE	view

Fields (42)

Key	Field	Source Table	Source Field
KEY	Customer		Customer
KEY	CompanyCode		CompanyCode
	Country	_CompanyCode	Country
	PaymentMethodsList		PaymentMethodsList
	PaymentBlockingReason		PaymentBlockingReason
KEY	CompanyCode		CompanyCode
	Country	_CompanyCode	Country
	PaymentMethodsList		PaymentMethodsList
	PaymentBlockingReason		PaymentBlockingReason
KEY	CompanyCode		CompanyCode
	Country	_CompanyCode	Country
	PaymentMethodsList		PaymentMethodsList
	PaymentBlockingReason		PaymentBlockingReason
KEY	CompanyCode		CompanyCode
	Country	_CompanyCode	Country
	PaymentMethodsList		PaymentMethodsList
	PaymentBlockingReason		PaymentBlockingReason
KEY	CompanyCode		CompanyCode
	Country	_CompanyCode	Country
	PaymentMethodsList		PaymentMethodsList
	PaymentBlockingReason		PaymentBlockingReason
KEY	CompanyCode		CompanyCode
	Country	_CompanyCode	Country
	PaymentMethodsList		PaymentMethodsList
	PaymentBlockingReason		PaymentBlockingReason
KEY	CompanyCode		CompanyCode
	Country	_CompanyCode	Country
	PaymentMethodsList		PaymentMethodsList
	PaymentBlockingReason		PaymentBlockingReason
KEY	CompanyCode		CompanyCode
	Country	_CompanyCode	Country
	PaymentMethodsList		PaymentMethodsList
	PaymentBlockingReason		PaymentBlockingReason
KEY	CompanyCode		CompanyCode
	Country	_CompanyCode	Country
	PaymentMethodsList		PaymentMethodsList
	PaymentBlockingReason		PaymentBlockingReason
KEY	CompanyCode		CompanyCode
	Country	_CompanyCode	Country
	PaymentMethodsList		PaymentMethodsList
	PaymentBlockingReason		PaymentBlockingReason
	_Customer		_Customer

@AbapCatalog: { sqlViewName: 'PMLDIRECTPAYERS1',
                compiler: { compareFilter: true },
                preserveKey: true }
@ClientHandling: { algorithm: #SESSION_VARIABLE }
@AccessControl: { authorizationCheck: #NOT_REQUIRED }
@VDM: { private:  true,
        viewType: #COMPOSITE }

define view P_MLColl_DirectPayers1
  as select from I_CustomerCompany
{

       // VDM Fields

  key  Customer,
  key  CompanyCode,
       _CompanyCode.Country as Country,
       PaymentMethodsList,
       PaymentBlockingReason,

       substring( PaymentMethodsList,
                  1,
                  1 )       as PaymentMethod,

       // Exposed associations

       _Customer
}

union select from I_CustomerCompany
{

       // VDM Fields

  key  Customer,
  key  CompanyCode,
       _CompanyCode.Country as Country,
       PaymentMethodsList,
       PaymentBlockingReason,

       substring( PaymentMethodsList,
                  2,
                  1 )       as PaymentMethod,

       // Exposed associations

       _Customer
}

union select from I_CustomerCompany
{

       // VDM Fields

  key  Customer,
  key  CompanyCode,
       _CompanyCode.Country as Country,
       PaymentMethodsList,
       PaymentBlockingReason,

       substring( PaymentMethodsList,
                  3,
                  1 )       as PaymentMethod,

       // Exposed associations

       _Customer
}

union select from I_CustomerCompany
{

       // VDM Fields

  key  Customer,
  key  CompanyCode,
       _CompanyCode.Country as Country,
       PaymentMethodsList,
       PaymentBlockingReason,

       substring( PaymentMethodsList,
                  4,
                  1 )       as PaymentMethod,

       // Exposed associations

       _Customer
}

union select from I_CustomerCompany
{

       // VDM Fields

  key  Customer,
  key  CompanyCode,
       _CompanyCode.Country as Country,
       PaymentMethodsList,
       PaymentBlockingReason,

       substring( PaymentMethodsList,
                  5,
                  1 )       as PaymentMethod,

       // Exposed associations

       _Customer
}

union select from I_CustomerCompany
{

       // VDM Fields

  key  Customer,
  key  CompanyCode,
       _CompanyCode.Country as Country,
       PaymentMethodsList,
       PaymentBlockingReason,

       substring( PaymentMethodsList,
                  6,
                  1 )       as PaymentMethod,

       // Exposed associations

       _Customer
}

union select from I_CustomerCompany
{

       // VDM Fields

  key  Customer,
  key  CompanyCode,
       _CompanyCode.Country as Country,
       PaymentMethodsList,
       PaymentBlockingReason,

       substring( PaymentMethodsList,
                  7,
                  1 )       as PaymentMethod,

       // Exposed associations

       _Customer
}

union select from I_CustomerCompany
{

       // VDM Fields

  key  Customer,
  key  CompanyCode,
       _CompanyCode.Country as Country,
       PaymentMethodsList,
       PaymentBlockingReason,

       substring( PaymentMethodsList,
                  8,
                  1 )       as PaymentMethod,

       // Exposed associations

       _Customer
}

union select from I_CustomerCompany
{

       // VDM Fields

  key  Customer,
  key  CompanyCode,
       _CompanyCode.Country as Country,
       PaymentMethodsList,
       PaymentBlockingReason,

       substring( PaymentMethodsList,
                  9,
                  1 )       as PaymentMethod,

       // Exposed associations

       _Customer
}

union select from I_CustomerCompany
{

       // VDM Fields

  key  Customer,
  key  CompanyCode,
       _CompanyCode.Country as Country,
       PaymentMethodsList,
       PaymentBlockingReason,

       substring( PaymentMethodsList,
                  10,
                  1 )       as PaymentMethod,

       // Exposed associations

       _Customer
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_COMPANYCODE",
"I_CUSTOMERCOMPANY"
],
"ASSOCIATED":
[
"I_CUSTOMER"
],
"BASE":
[
"I_CUSTOMERCOMPANY"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Depth:

P_MLColl_DirectPayers1 view