@AbapCatalog.sqlViewName: 'CCUSTOMEROP'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED
@Metadata.allowExtensions: true
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #MASTER
@Search.searchable: true
@EndUserText.label: 'Customer'
@UI.headerInfo:{
typeName: 'Customer',
typeNamePlural: 'Customers',
title: {
label: 'Name',
value: 'BPCustomerName'},
description: {
value: 'Customer'
},
typeImageUrl: '/sap/bc/ui5_ui5/sap/MD_CUSTOMEROPS1/images/customer.jpg'
}
@VDM.viewType: #CONSUMPTION
@Metadata.ignorePropagatedAnnotations: true
define view C_CustomerOP
as select from I_Customer
association [0..*] to I_CustomerContactOP as _CustomerContact on $projection.Customer = _CustomerContact.Customer
association [0..*] to C_CustomerSalesAreaOP as _CustomerSalesArea on $projection.Customer = _CustomerSalesArea.Customer
association [0..*] to C_CustomerCompanyCodeOP as _CustomerCompanyCode on $projection.Customer = _CustomerCompanyCode.Customer
association [0..*] to C_CustomerBankDetailsOP as _CustomerBankDetails on $projection.Customer = _CustomerBankDetails.Customer
// association [0..*] to C_BusinessPartnerBank as _BusinessPartnerBankDetails on $projection.businesspartner = _BusinessPartnerBankDetails.BusinessPartner
association [0..1] to I_DeliveryBlockReason as _DelivBlkRsnValueHelp on $projection.DeliveryIsBlocked = _DelivBlkRsnValueHelp.DeliveryBlockReason
association [0..1] to I_BillingBlockReason as _BillingBlockReasonValueHelp on $projection.BillingIsBlockedForCustomer = _BillingBlockReasonValueHelp.BillingBlockReason
association [0..*] to C_OrderIsBlockedTextVHTemp as _OrderIsBlockedForCustomer on $projection.OrderIsBlockedForCustomer = _OrderIsBlockedForCustomer.OrderIsBlockedForCustomer
{
key I_Customer.Customer,
@Consumption.filter.hidden: true
CustomerName,
BPCustomerName,
CustomerAccountGroup,
AuthorizationGroup,
@Consumption.filter.hidden: true
_CustomerToBusinessPartner._BusinessPartner.BusinessPartner,
// _CustomerToBusinessPartner._BusinessPartner._CurrentDefaultAddress._Address.CityName,
_CustomerToBusinessPartner._BusinessPartner._CurrentDefaultAddress._AddressDefaultRepresentation.CityName,
// concat(concat_with_space(_CustomerToBusinessPartner._BusinessPartner._CurrentDefaultAddress._Address.RoomNumber,concat_with_space(_CustomerToBusinessPartner._BusinessPartner._CurrentDefaultAddress._Address.Floor,concat_with_space(_CustomerToBusinessPartner._BusinessPartner._CurrentDefaultAddress._Address.Building,concat_with_space(_CustomerToBusinessPartner._BusinessPartner._CurrentDefaultAddress._Address.HouseNumber,concat_with_space(_CustomerToBusinessPartner._BusinessPartner._CurrentDefaultAddress._Address.StreetName,concat_with_space(_CustomerToBusinessPartner._BusinessPartner._CurrentDefaultAddress._Address.StreetPrefixName,concat_with_space(_CustomerToBusinessPartner._BusinessPartner._CurrentDefaultAddress._Address.AdditionalStreetPrefixName,concat_with_space(_CustomerToBusinessPartner._BusinessPartner._CurrentDefaultAddress._Address.StreetSuffixName, _CustomerToBusinessPartner._BusinessPartner._CurrentDefaultAddress._Address.AdditionalStreetSuffixName, 1),1),1),1),1),1),1),1),concat(',',concat(concat_with_space(_CustomerToBusinessPartner._BusinessPartner._CurrentDefaultAddress._Address.PostalCode,_CustomerToBusinessPartner._BusinessPartner._CurrentDefaultAddress._Address.CityName,1),concat(',',_CustomerToBusinessPartner._BusinessPartner._CurrentDefaultAddress._Address.Country)))) as FormattedAddress,
concat(concat_with_space(_CustomerToBusinessPartner._BusinessPartner._CurrentDefaultAddress._AddressDefaultRepresentation.RoomNumber,
concat_with_space(_CustomerToBusinessPartner._BusinessPartner._CurrentDefaultAddress._AddressDefaultRepresentation.Floor,
concat_with_space(_CustomerToBusinessPartner._BusinessPartner._CurrentDefaultAddress._AddressDefaultRepresentation.Building,
concat_with_space(_CustomerToBusinessPartner._BusinessPartner._CurrentDefaultAddress._AddressDefaultRepresentation.HouseNumber,
concat_with_space(_CustomerToBusinessPartner._BusinessPartner._CurrentDefaultAddress._AddressDefaultRepresentation.StreetName,
concat_with_space(_CustomerToBusinessPartner._BusinessPartner._CurrentDefaultAddress._AddressDefaultRepresentation.StreetPrefixName1,
concat_with_space(_CustomerToBusinessPartner._BusinessPartner._CurrentDefaultAddress._AddressDefaultRepresentation.StreetPrefixName2,
concat_with_space(_CustomerToBusinessPartner._BusinessPartner._CurrentDefaultAddress._AddressDefaultRepresentation.StreetSuffixName1,
_CustomerToBusinessPartner._BusinessPartner._CurrentDefaultAddress._AddressDefaultRepresentation.StreetSuffixName2, 1),1),1),1),1),1),1),1),
concat_with_space(',',concat(concat_with_space(_CustomerToBusinessPartner._BusinessPartner._CurrentDefaultAddress._AddressDefaultRepresentation.PostalCode,
_CustomerToBusinessPartner._BusinessPartner._CurrentDefaultAddress._AddressDefaultRepresentation.CityName,1),
concat_with_space(',',_CustomerToBusinessPartner._BusinessPartner._CurrentDefaultAddress._AddressDefaultRepresentation.Country,1)),1)) as FormattedAddress,
Industry,
@Consumption.filter.hidden: true
InternationalLocationNumber1,
cast(concat_with_space(concat_with_space(I_Customer.InternationalLocationNumber1, I_Customer.InternationalLocationNumber2, 1), I_Customer.InternationalLocationNumber3, 1) as mm_pur_supplier_iln) as InternationalLocationNumber,
TaxNumber1,
VATRegistration,
// coalesce(_CustomerToBusinessPartner._BusinessPartner._CurrentDefaultAddress._Address._DefaultCorporatePhoneNumber.InternationalPhoneNumber, _CustomerToBusinessPartner._BusinessPartner._CurrentDefaultAddress._Address._DefaultPrivatePhoneNumber.InternationalPhoneNumber) as InternationalPhoneNumber,
// coalesce(_CustomerToBusinessPartner._BusinessPartner._CurrentDefaultAddress._Address._DefaultCorpMobilePhoneNumber.InternationalPhoneNumber, _CustomerToBusinessPartner._BusinessPartner._CurrentDefaultAddress._Address._DefaultPvtMobilePhoneNumber.InternationalPhoneNumber) as InternationalMobilePhoneNumber,
// coalesce(_CustomerToBusinessPartner._BusinessPartner._CurrentDefaultAddress._Address._DefaultCorpFaxNumber.InternationalFaxNumber, _CustomerToBusinessPartner._BusinessPartner._CurrentDefaultAddress._Address._DefaultPrivateFaxNumber.InternationalFaxNumber) as InternationalFaxNumber,
// coalesce(_CustomerToBusinessPartner._BusinessPartner._CurrentDefaultAddress._Address._DefaultCorpEmailAddress.EmailAddress, _CustomerToBusinessPartner._BusinessPartner._CurrentDefaultAddress._Address._DefaultPvtEmailAddress.EmailAddress) as EmailAddress,
_CustomerToBusinessPartner._BusinessPartner._CurrentDefaultAddress._AddressDefaultRepresentation._CurrentDfltLandlinePhoneNmbr.InternationalPhoneNumber as InternationalPhoneNumber,
_CustomerToBusinessPartner._BusinessPartner._CurrentDefaultAddress._AddressDefaultRepresentation._CurrentDfltMobilePhoneNumber.InternationalPhoneNumber as InternationalMobilePhoneNumber,
_CustomerToBusinessPartner._BusinessPartner._CurrentDefaultAddress._AddressDefaultRepresentation._CurrentDfltFaxNumber.InternationalFaxNumber as InternationalFaxNumber,
_CustomerToBusinessPartner._BusinessPartner._CurrentDefaultAddress._AddressDefaultRepresentation._CurrentDfltEmailAddress.EmailAddress as EmailAddress,
@ObjectModel.text.association: '_OrderIsBlockedForCustomer'
OrderIsBlockedForCustomer,
@ObjectModel.foreignKey.association: '_BillingBlockReasonValueHelp'
BillingIsBlockedForCustomer,
@ObjectModel.foreignKey.association: '_DelivBlkRsnValueHelp'
DeliveryIsBlocked,
PostingIsBlocked,
@Consumption.hidden:true
@UI.hidden:true
I_Customer.DataControllerSet ,
@Consumption.hidden:true
@UI.hidden:true
I_Customer.DataController1 ,
@Consumption.hidden:true
@UI.hidden:true
I_Customer.DataController2 ,
@Consumption.hidden:true
@UI.hidden:true
I_Customer.DataController3 ,
@Consumption.hidden:true
@UI.hidden:true
I_Customer.DataController4 ,
@Consumption.hidden:true
@UI.hidden:true
I_Customer.DataController5 ,
@Consumption.hidden:true
@UI.hidden:true
I_Customer.DataController6 ,
@Consumption.hidden:true
@UI.hidden:true
I_Customer.DataController7 ,
@Consumption.hidden:true
@UI.hidden:true
I_Customer.DataController8 ,
@Consumption.hidden:true
@UI.hidden:true
I_Customer.DataController9 ,
@Consumption.hidden:true
@UI.hidden:true
I_Customer.DataController10
,
@Semantics.booleanIndicator
I_Customer.IsBusinessPurposeCompleted,
// _CustomerBankDetails.SWIFTCode,
coalesce(_CustomerToBusinessPartner._BusinessPartner._CurrentDefaultAddress._Address._DefaultCorpURLAddress.URLFieldLength,
_CustomerToBusinessPartner._BusinessPartner._CurrentDefaultAddress._Address._DefaultPvtURLAddress.URLFieldLength) as URLFieldLength, //Check this
_CustomerToBusinessPartner._BusinessPartner._CurrentDefaultAddress._AddressDefaultRepresentation._MainWebsiteURL.UniformResourceIdentifier as WebsiteURL,
//_CustomerToBusinessPartner._BusinessPartner._CurrentDefaultAddress._Address._DefaultURLAddress.WebsiteURL, //check this
// coalesce(_CustomerToBusinessPartner._BusinessPartner._CurrentDefaultAddress._Address._DefaultCorpURLAddress.WebsiteURL, _CustomerToBusinessPartner._BusinessPartner._CurrentDefaultAddress._Address._DefaultPvtURLAddress.WebsiteURL) as WebsiteURL,
//Associations
_CustomerContact,
_CustomerSalesArea,
_CustomerCompanyCode,
_CustomerBankDetails,
_DelivBlkRsnValueHelp,
_BillingBlockReasonValueHelp,
_OrderIsBlockedForCustomer
// _CustomerToBusinessPartner,
// _BusinessPartnerBankDetails
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ADDRCURDEFAULTEMAILADDRESS",
"I_ADDRCURDEFAULTFAXNUMBER",
"I_ADDRCURDFLTLANDLINEPHONENMBR",
"I_ADDRCURDFLTMOBILEPHONENUMBER",
"I_ADDRESS",
"I_ADDRESSHOMEPAGEURL",
"I_ADDRESSMAINWEBSITEURL",
"I_ADDRESS_2",
"I_BPCURRENTDEFAULTADDRESS",
"I_BUSINESSPARTNER",
"I_CUSTOMER",
"I_CUSTOMERTOBUSINESSPARTNER"
],
"ASSOCIATED":
[
"C_CUSTOMERBANKDETAILSOP",
"C_CUSTOMERCOMPANYCODEOP",
"C_CUSTOMERSALESAREAOP",
"C_ORDERISBLOCKEDTEXTVHTEMP",
"I_BILLINGBLOCKREASON",
"I_CUSTOMERCONTACTOP",
"I_DELIVERYBLOCKREASON"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/