@AbapCatalog.sqlViewName: 'PBPPFNUMBER'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.private: true
@VDM.viewType: #COMPOSITE
@AccessControl.personalData.blocking: #REQUIRED
define view P_BPPartnerFunctionNumber
as select from I_Customer
{
key I_Customer.Customer as BusinessPartner,
key cast ( 'KU' as char2 ) as PartnerFunctionType,
I_Customer._CustomerToBusinessPartner._BusinessPartner.BusinessPartnerName as BusinessPartnerName,
I_Customer.OrganizationBPName1,
I_Customer.BusinessPartnerName1,
I_Customer.OrganizationBPName2,
I_Customer.BusinessPartnerName2,
I_Customer.IsBusinessPurposeCompleted
// @Consumption.filter.hidden: true
// @UI.hidden: true
// I_Customer._CustomerToBusinessPartner.Customer,
// I_Customer._CustomerToBusinessPartner._Customer
// //added only for DCL check
// @UI.hidden: true
// @Consumption.filter.hidden: true
// I_Customer.DataControllerSet,
// //added only for DCL check
// @UI.hidden: true
// @Consumption.filter.hidden: true
// I_Customer.DataController1,
// //added only for DCL check
// @UI.hidden: true
// @Consumption.filter.hidden: true
// I_Customer.DataController2,
// //added only for DCL check
// @UI.hidden: true
// @Consumption.filter.hidden: true
// I_Customer.DataController3,
// //added only for DCL check
// @UI.hidden: true
// @Consumption.filter.hidden: true
// I_Customer.DataController4,
// //added only for DCL check
// @UI.hidden: true
// @Consumption.filter.hidden: true
// I_Customer.DataController5,
// //added only for DCL check
// @UI.hidden: true
// @Consumption.filter.hidden: true
// I_Customer.DataController6,
// //added only for DCL check
// @UI.hidden: true
// @Consumption.filter.hidden: true
// I_Customer.DataController7,
// //added only for DCL check
// @UI.hidden: true
// @Consumption.filter.hidden: true
// I_Customer.DataController8,
// //added only for DCL check
// @UI.hidden: true
// @Consumption.filter.hidden: true
// I_Customer.DataController9,
// //added only for DCL check
// @UI.hidden: true
// @Consumption.filter.hidden: true
// I_Customer.DataController10
}
union
select from I_Supplier
{
key I_Supplier.Supplier as BusinessPartner,
key cast ( 'LI' as char2 ) as PartnerFunctionType,
I_Supplier._SupplierToBusinessPartner._BusinessPartner.BusinessPartnerName as BusinessPartnerName,
I_Supplier.OrganizationBPName1,
I_Supplier.BusinessPartnerName1,
I_Supplier.OrganizationBPName2,
I_Supplier.BusinessPartnerName2,
I_Supplier.IsBusinessPurposeCompleted
// @Consumption.filter.hidden: true
// @UI.hidden: true
// I_Supplier._SupplierToBusinessPartner.Supplier,
// I_Supplier._SupplierToBusinessPartner._Supplier
// //added only for DCL check
// @UI.hidden: true
// @Consumption.filter.hidden: true
// I_Supplier.DataControllerSet,
// //added only for DCL check
// @UI.hidden: true
// @Consumption.filter.hidden: true
// I_Supplier.DataController1,
// //added only for DCL check
// @UI.hidden: true
// @Consumption.filter.hidden: true
// I_Supplier.DataController2,
// //added only for DCL check
// @UI.hidden: true
// @Consumption.filter.hidden: true
// I_Supplier.DataController3,
// //added only for DCL check
// @UI.hidden: true
// @Consumption.filter.hidden: true
// I_Supplier.DataController4,
// //added only for DCL check
// @UI.hidden: true
// @Consumption.filter.hidden: true
// I_Supplier.DataController5,
// //added only for DCL check
// @UI.hidden: true
// @Consumption.filter.hidden: true
// I_Supplier.DataController6,
// //added only for DCL check
// @UI.hidden: true
// @Consumption.filter.hidden: true
// I_Supplier.DataController7,
// //added only for DCL check
// @UI.hidden: true
// @Consumption.filter.hidden: true
// I_Supplier.DataController8,
// //added only for DCL check
// @UI.hidden: true
// @Consumption.filter.hidden: true
// I_Supplier.DataController9,
// //added only for DCL check
// @UI.hidden: true
// @Consumption.filter.hidden: true
// I_Supplier.DataController10
}
union
select from I_PersWrkAgrmtSrchHelp_1
{
key PersonWorkAgreement as BusinessPartner,
key cast ( 'PE' as char2 ) as PartnerFunctionType,
PersonFullName as BusinessPartnerName,
FirstName as OrganizationBPName1,
FirstName as BusinessPartnerName1,
LastName as OrganizationBPName2,
LastName as BusinessPartnerName2,
IsBusinessPurposeCompleted
}
union
select from I_ContactPerson
{
key I_ContactPerson.ContactPerson as BusinessPartner,
key cast ( 'AP' as char2 ) as PartnerFunctionType,
concat_with_space( I_ContactPerson.FirstName, I_ContactPerson.LastName, 1 ) as BusinessPartnerName,
I_ContactPerson.FirstName as OrganizationBPName1,
I_ContactPerson.FirstName as BusinessPartnerName1,
I_ContactPerson.LastName as OrganizationBPName2,
I_ContactPerson.LastName as BusinessPartnerName2,
IsBusinessPurposeCompleted
// @Consumption.filter.hidden: true
// @UI.hidden: true
// I_ContactPerson.Customer,
// I_ContactPerson._Customer
//added only for DCL check
// @UI.hidden: true
// @Consumption.filter.hidden: true
// I_ContactPerson._Customer.DataControllerSet
// //added only for DCL check
// @UI.hidden: true
// @Consumption.filter.hidden: true
// I_Supplier.DataController1,
// //added only for DCL check
// @UI.hidden: true
// @Consumption.filter.hidden: true
// I_Supplier.DataController2,
// //added only for DCL check
// @UI.hidden: true
// @Consumption.filter.hidden: true
// I_Supplier.DataController3,
// //added only for DCL check
// @UI.hidden: true
// @Consumption.filter.hidden: true
// I_Supplier.DataController4,
// //added only for DCL check
// @UI.hidden: true
// @Consumption.filter.hidden: true
// I_Supplier.DataController5,
// //added only for DCL check
// @UI.hidden: true
// @Consumption.filter.hidden: true
// I_Supplier.DataController6,
// //added only for DCL check
// @UI.hidden: true
// @Consumption.filter.hidden: true
// I_Supplier.DataController7,
// //added only for DCL check
// @UI.hidden: true
// @Consumption.filter.hidden: true
// I_Supplier.DataController8,
// //added only for DCL check
// @UI.hidden: true
// @Consumption.filter.hidden: true
// I_Supplier.DataController9,
// //added only for DCL check
// @UI.hidden: true
// @Consumption.filter.hidden: true
// I_Supplier.DataController10
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BUSINESSPARTNER",
"I_CONTACTPERSON",
"I_CUSTOMER",
"I_CUSTOMERTOBUSINESSPARTNER",
"I_PERSWRKAGRMTSRCHHELP_1",
"I_SUPPLIER",
"I_SUPPLIERTOBUSINESSPARTNER"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/