// This view entity returns only basich - search - Customer data.
// Originally custom entity has been used, but as custom entity does not support extensiblity yet then
// this view entity has been created.
//
// DO NOT REUSE this entity. It is used only in app Display Customer List.
//
@AbapCatalog.viewEnhancementCategory: [#PROJECTION_LIST]
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED
@ObjectModel.query.implementedBy: 'ABAP:CL_FAR_CUSTOMER_LIST_V2'
@Metadata.allowExtensions: true
@VDM.viewType: #CONSUMPTION
@EndUserText.label: 'Customer List'
@Search.searchable: true
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
serviceQuality: #C,
sizeCategory: #XL,
dataClass: #MIXED
}
@UI.headerInfo: {
typeName: 'Customer',
typeNamePlural: 'Items',
title: { type: #STANDARD, value: 'Customer' },
description: { type: #STANDARD, value: 'BusinessPartnerName' }
}
define view entity C_CustomerList_2
as select from I_Customer
{
@UI.hidden
key cast(Customer as abap.char( 20 )) as CustomerSequentialNumber,
@UI : {
lineItem : [{ position: 2}],
selectionField : [{ position: 2}],
textArrangement : #TEXT_SEPARATE
}
@Consumption.semanticObject : 'Customer'
@Consumption.valueHelpDefinition: [{ entity:{ name: 'I_Customer_VH', element:'Customer' } }]
@Search.defaultSearchElement
cast( Customer as kunnr ) as Customer,
@UI : {
lineItem : [{position: 1}],
selectionField : [{position: 1}],
textArrangement : #TEXT_SEPARATE
}
@Consumption.valueHelpDefinition: [{ entity:{ name: 'I_CompanyCodeStdVH', element: 'CompanyCode' } }]
cast( '' as bukrs) as CompanyCode,
@Consumption.valueHelpDefinition: [{ entity:{ name: 'I_SalesOrganization', element: 'SalesOrganization' } },
{ label: 'Customer Sales Area Value Help',
qualifier: 'CustomerSalesAreaValueHelp',
entity:{ name: 'I_CustomerSalesAreaStdVH', element: 'SalesOrganization' },
additionalBinding: [{ localElement: 'Customer', element: 'Customer' },
{ localElement: 'DistributionChannel', element: 'DistributionChannel' },
{ localElement: 'Division', element: 'Division' }] }]
cast( '' as vkorg) as SalesOrganization,
@Consumption.valueHelpDefinition: [{ entity:{ name: 'I_DistributionChannel', element: 'DistributionChannel' } },
{ label: 'Customer Sales Area Value Help',
qualifier: 'CustomerSalesAreaValueHelp',
entity:{ name: 'I_CustomerSalesAreaStdVH', element: 'DistributionChannel' },
additionalBinding: [{ localElement: 'Customer', element: 'Customer' },
{ localElement: 'SalesOrganization', element: 'SalesOrganization' },
{ localElement: 'Division', element: 'Division' }] }]
cast( '' as vtweg ) as DistributionChannel,
@Consumption.valueHelpDefinition: [{ entity:{ name: 'I_DivisionValueHelp', element: 'Division' } },
{ label: 'Customer Sales Area Value Help',
qualifier: 'CustomerSalesAreaValueHelp',
entity:{ name: 'I_CustomerSalesAreaStdVH', element: 'Division' },
additionalBinding: [{ localElement: 'Customer', element: 'Customer' },
{ localElement: 'SalesOrganization', element: 'SalesOrganization' },
{ localElement: 'DistributionChannel', element: 'DistributionChannel' }] }]
cast( '' as spart) as Division,
@UI.hidden: true
cast( '' as parza) as PartnerCounter,
@Consumption.filter.hidden: true
cast( '' as bu_iban) as IBAN,
@Consumption.valueHelpDefinition: [{ entity:{ name: 'C_Countryvhtemp', element: 'Country' }}]
@ObjectModel.text.element : ['CountryName']
@UI : {
textArrangement : #TEXT_LAST
}
cast( '' as bu_banks) as BankCountryKey,
@UI.hidden : true
@Semantics.text: true
cast( '' as landx50) as CountryName,
cast( '' as bu_bankk) as BankNumber,
cast( '' as fap_bankn) as BankAccount,
cast( '' as bu_bkont) as BankControlKey,
@Consumption.filter.hidden: true
cast( '' as bu_ccnum) as CardNumber,
@Consumption.valueHelpDefinition: [{ entity:{ name: 'C_PaymentCardTypeVH', element: 'PaymentCardType' } }]
cast( '' as cc_institute) as PaymentCardType,
@Consumption.filter.hidden : true
@EndUserText.label : 'In-House Contact'
@EndUserText.quickInfo : 'In-House Contact'
@ObjectModel.text.element : ['PartnerFunctionName']
@UI : {
lineItem : [{position: 7}],
textArrangement : #TEXT_ONLY
}
cast( '' as parvw_unv) as PartnerFunction,
@Consumption.hidden: true
cast( '' as boolean ) as CustomerIsWithCompanyCode,
@UI.hidden : true
@Semantics.text: true
cast( '' as farp_inhouse_contact) as PartnerFunctionName,
@UI.hidden : true
@EndUserText.label : 'In-House Contact'
@EndUserText.quickInfo : 'In-House Contact'
@ObjectModel.text.element : ['PartnerFunctionName']
@UI : {
textArrangement : #TEXT_ONLY
}
cast( '' as pernr_d) as PersonnelNumber,
@EndUserText.label : 'Clerk Abbreviation'
@EndUserText.quickInfo : 'Clerk Abbreviation'
@UI : {
lineItem : [{position: 8}],
selectionField : [{position: 4}],
textArrangement : #TEXT_SEPARATE
}
@Consumption.valueHelpDefinition: [
{ entity :{ name: 'I_AccountingClerkStdVH', element: 'AccountingClerk' },
additionalBinding : [{localElement: 'CompanyCode', element: 'CompanyCode'}]
}
]
cast( '' as busab) as AccountingClerk,
@UI.hidden: true
cast( '' as farp_sname_001s) as AccountingClerkName,
@EndUserText.label : 'Financial Payment Terms'
@EndUserText.quickInfo : 'Financial Payment Terms'
@UI : {
lineItem : [{position: 9}],
selectionField : [{position: 6}],
textArrangement : #TEXT_SEPARATE
}
@Consumption.valueHelpDefinition: [{ entity:{ name: 'I_PaymentTerms', element: 'PaymentTerms' } }]
cast( '' as farp_dzterm_fi) as PaymentTerms,
@UI : {
lineItem : [{position: 3}],
textArrangement : #TEXT_SEPARATE
}
@Consumption.valueHelpDefinition: [{ entity:{ name: 'I_BusinessPartnerVH', element: 'BusinessPartnerName' } }]
cast( '' as md_customer_name) as BusinessPartnerName,
@Search : {
defaultSearchElement : true,
fuzzinessThreshold : 0.8,
ranking : #HIGH
}
@UI : {
lineItem : [{position: 4}],
selectionField : [{position: 3}],
textArrangement : #TEXT_SEPARATE
}
cast( _StandardAddress.CityName as ad_city1 ) as CityName,
@UI : {
lineItem : [{position: 5}],
textArrangement : #TEXT_SEPARATE
}
@Consumption.filter.hidden : true
cast ( '' as farp_phone) as PhoneNumber,
@UI : {
lineItem : [{position: 6}],
textArrangement : #TEXT_SEPARATE
}
@Consumption.filter.hidden : true
cast( '' as farp_ad_smtpadr) as EmailAddress,
@UI : {
lineItem : [{position: 10}],
selectionField : [{position: 5}],
textArrangement : #TEXT_SEPARATE
}
@Consumption.valueHelpDefinition: [{ entity:{ name: 'I_DunningProcedureVH', element: 'DunningProcedure' } }]
cast( '' as mahna) as DunningProcedure,
@UI : {
lineItem : [{position: 11}],
textArrangement : #TEXT_SEPARATE
}
@Consumption.valueHelpDefinition: [{ entity:{ name: 'I_DunningBlockingReasonCode', element: 'DunningBlockingReason' } }]
cast( '' as mansp) as DunningBlock,
@ObjectModel.text.element : ['AccountGroupName']
@UI.textArrangement : #TEXT_LAST
@Consumption.valueHelpDefinition: [ {
entity : { name: 'I_CustomerAccountGroupStdVH', element: 'CustomerAccountGroup' }
} ]
cast( '' as farp_customer_account_group) as CustomerAccountGroup,
cast( '' as txt30_077t) as AccountGroupName,
@UI.hidden : true
@Search : {
defaultSearchElement : true,
fuzzinessThreshold : 0.8,
ranking : #HIGH
}
cast( _CustomerToBusinessPartner._BusinessPartner.FirstName as bu_namep_f) as FirstName,
@UI.hidden : true
@Search : {
defaultSearchElement : true,
fuzzinessThreshold : 0.8,
ranking : #HIGH
}
cast( _CustomerToBusinessPartner._BusinessPartner.LastName as bu_namep_l) as LastName,
@UI.hidden : true
@Search : {
defaultSearchElement : true,
fuzzinessThreshold : 0.8,
ranking : #HIGH
}
cast( _CustomerToBusinessPartner._BusinessPartner.OrganizationBPName1 as bu_nameor1) as OrganizationBPName1,
@UI.hidden : true
@Search : {
defaultSearchElement : true,
fuzzinessThreshold : 0.8,
ranking : #HIGH
}
cast( _CustomerToBusinessPartner._BusinessPartner.OrganizationBPName2 as bu_nameor2) as OrganizationBPName2,
@UI.hidden : true
@Search : {
defaultSearchElement : true,
fuzzinessThreshold : 0.8,
ranking : #HIGH
}
cast( _CustomerToBusinessPartner._BusinessPartner.GroupBusinessPartnerName1 as bu_namegr1) as GroupBusinessPartnerName1,
@UI.hidden : true
@Search : {
defaultSearchElement : true,
fuzzinessThreshold : 0.8,
ranking : #HIGH
}
cast( _CustomerToBusinessPartner._BusinessPartner.GroupBusinessPartnerName2 as bu_namegr2) as GroupBusinessPartnerName2,
@Consumption.filter.hidden: true
cast( '' as bu_bpkind) as BusinessPartnerType,
@Consumption.valueHelpDefinition: [{ entity:{ name: 'C_LegalFormVHTemp', element: 'LegalForm' } }]
cast( '' as farp_enty) as LegalForm,
@Consumption.valueHelpDefinition: [{ entity:{ name: 'C_BusinessPartnerLegalEntityVH', element: 'BPOrganisationLegalEntity' } }]
cast( '' as farp_legal_org) as LegalEntityOfOrganization,
@Consumption.valueHelpDefinition: [{ entity:{ name: 'I_BusinessPartnerCustomerVH', element: 'BusinessPartnerIDByExtSystem' } }]
cast( '' as bu_bpext) as BusinessPartnerIDByExtSystem,
@Consumption.valueHelpDefinition: [{ entity:{ name: 'I_Indicator', element: 'IndicatorValue' } }]
cast( '' as bu_xdele) as IsMarkedForArchiving,
@Consumption.valueHelpDefinition: [{ entity:{ name: 'I_Indicator', element: 'IndicatorValue' } }]
cast( '' as bu_xblck) as BusinessPartnerIsBlocked,
@Consumption.filter.hidden: true
cast( '' as bu_contact) as ContactPermission,
@Consumption.filter.hidden: true
cast( '' as ad_street) as StreetName,
@Consumption.filter.hidden: true
cast( '' as ad_pstcd1) as PostalCode,
@Consumption.valueHelpDefinition: [{ entity:{ name: 'I_Country', element: 'Country' } }]
cast( '' as land1) as Country,
@Consumption.valueHelpDefinition: [
{ entity :{ name: 'I_Region', element: 'Region' },
additionalBinding : [{localElement: 'Country', element: 'Country'}]
}
]
cast( '' as regio) as Region,
@Consumption.filter.hidden: true
cast( '' as farp_tzone) as AddressTimeZone,
@Consumption.filter.hidden: true
cast( '' as ad_pobx) as POBox,
@Consumption.filter.hidden: true
cast( '' as ad_pstcd2) as POBoxPostalCode,
@Consumption.filter.hidden: true
cast( '' as ad_pstcd3) as CompanyPostalCode,
//@Consumption.valueHelpDefinition: [{ entity:{ name: 'C_LangISOCodeValueHelp', element: 'Language' } }]
cast( '' as spras) as CorrespondenceLanguage,
@Consumption.filter.hidden: true
cast ( '' as farp_mobile) as MobilePhoneNumber,
@Consumption.filter.hidden: true
cast( '' as telfx) as FaxNumber,
cast( '' as ad_comm) as PrfrdCommMediumType,
cast( '' as ad_sort1) as SearchTerm1,
cast( '' as ad_sort2) as SearchTerm2,
cast( '' as ad_strspp1) as StreetPrefixName,
cast( '' as ad_strspp2) as AdditionalStreetPrefixName,
cast( '' as ad_strspp3) as StreetSuffixName,
cast( '' as ad_lctn) as AdditionalStreetSuffixName,
cast( '' as ad_city2) as BusinessPartnerDistrict,
cast( '' as ad_hsnm1) as HouseNumber,
@UI.hidden: true
cast( '' as ad_name2) as BusinessPartnerName2,
@UI.hidden: true
cast( '' as ad_name3) as BusinessPartnerName3,
@UI.hidden: true
cast( '' as ad_name4) as BusinessPartnerName4,
@Consumption.valueHelpDefinition: [{ entity:{ name: 'C_LCMSupplierValueHelp', element: 'Supplier' } }]
cast( '' as lifnr) as Supplier,
cast( '' as sperb_x) as PostingIsBlocked,
@UI.hidden: true
cast( '' as brgru) as AuthorizationGroup,
@Consumption.valueHelpDefinition: [{ entity:{ name: 'C_CustomerCreatedByValueHelp', element: 'CreatedByUser' } }]
cast( '' as farp_ernam_rf) as CreatedByUser,
cast( '' as stceg) as VATRegistration,
cast( '' as stcd1) as TaxNumber1,
cast( '' as stcd2) as TaxNumber2,
cast( '' as stcd3) as TaxNumber3,
cast( '' as stcd4) as TaxNumber4,
cast( '' as stcd5) as TaxNumber5,
cast( '' as stkzu) as VATLiability,
cast( '' as supplist_j_1atoid) as ResponsibleType,
cast( '' as farp_supplist_j_1atoid) as TaxNumberType,
@Consumption.valueHelpDefinition: [{ entity:{ name: 'I_SalesOffice', element: 'SalesOffice' } }]
cast( '' as vkbur) as SalesOffice,
@Consumption.valueHelpDefinition: [{ entity:{ name: 'I_SalesGroup', element: 'SalesGroup' } }]
cast( '' as vkgrp) as SalesGroup,
@Consumption.valueHelpDefinition: [{ entity:{ name: 'I_PaymentTerms', element: 'PaymentTerms' } }]
cast( '' as farp_dzterm_sd) as CustomerPaymentTerms,
@Consumption.filter.selectionType: #INTERVAL
cast( '' as madat) as LastDunnedOn,
@Consumption.filter.selectionType: #INTERVAL
@EndUserText.label : 'Dunning Start Date'
@EndUserText.quickInfo : 'Date of the Legal Dunning Proceedings'
cast( '' as gmvdt) as LegDunningProcedureOn,
cast( '' as mahns_d) as DunningLevel,
@EndUserText.label : 'Posting Block for Company Code'
@EndUserText.quickInfo : 'Posting Block for Company Code'
cast( '' as sperb_b) as PhysicalInventoryBlockInd,
@Consumption.valueHelpDefinition: [{ entity:{ name: 'I_PaymentTerms', element: 'PaymentTerms' } }]
cast( '' as guzte) as CreditMemoPaymentTerms,
cast( '' as dzwels) as PaymentMethodsList,
cast( '' as hbkid) as HouseBank,
@Consumption.valueHelpDefinition: [{ entity:{ name: 'I_PaymentBlockingReason', element: 'PaymentBlockingReason' } }]
cast( '' as dzahls) as PaymentBlockingReason,
@Consumption.filter.hidden : true
cast( '' as mgrup) as DunningNoticeGroup,
@Consumption.filter.hidden : true
@EndUserText.label: 'Acct At Cust.'
@EndUserText.quickInfo: 'Our Account Number at Customer'
cast( '' as farp_eikto_c) as AccountByCustomer,
@Consumption.filter.hidden : true
cast( '' as farp_dzsabe) as UserAtCustomer,
@Consumption.filter.hidden : true
@EndUserText.label: 'Acct. Clerks Tel. No.'
@EndUserText.quickInfo: 'Accounting Clerks Telephone Number at Business Partner'
cast( '' as tlfns) as AccountingClerkPhoneNumber,
@Consumption.filter.hidden : true
@EndUserText.label: 'Clerks Internet Add.'
@EndUserText.quickInfo: 'Internet Address of Partner Company Clerk'
cast( '' as intad) as AccountingClerkInternetAddress,
@Consumption.valueHelpDefinition: [
{ entity :{
name : 'C_GLAccountValueHelp',
element : 'GLAccount'
} }]
cast( '' as farp_akont) as ReconciliationAccount,
@Consumption.valueHelpDefinition: [{ entity:{ name: 'I_InterestCalculationCode', element: 'InterestCalculationCode' } }]
@EndUserText.label : 'Interest Calculation Indicator'
@EndUserText.quickInfo : 'Interest Calculation Indicator'
cast( '' as farp_vzskz_c) as InterestCalculationCode,
@Consumption.filter.hidden : true
cast( '' as knrma) as DunningRecipient,
@Consumption.valueHelpDefinition: [
{ entity :{ name: 'I_AccountingClerkStdVH', element: 'AccountingClerk' },
additionalBinding : [{localElement: 'CompanyCode', element: 'CompanyCode'}]
}
]
cast( '' as busab_ma) as DunningClerk,
@EndUserText.label : 'Interest Calculation Frequency'
@EndUserText.quickInfo : 'Interest Calculation Frequency in Months'
cast( '' as dzinrt) as IntrstCalcFrequencyInMonths,
@Consumption.filter.selectionType: #INTERVAL
cast( '' as dzindt) as InterestCalculationDate,
@Consumption.filter.selectionType: #INTERVAL
@Consumption.filter.hidden : true
cast( '' as datlz) as LastInterestCalcRunDate,
cast( '' as altkn) as BPCustomerNumber,
cast( '' as fdgrp) as CashPlanningGroup,
cast( '' as bp_vip_partner) as BusinessPartnerIsVIP,
cast( '' as bp_unw_customer) as CustomerIsUnwanted,
@Consumption.filter.hidden : true
cast( '' as bp_unw_reason) as UndesirabilityReason,
@Consumption.filter.hidden : true
cast( '' as bp_unw_remark) as UndesirabilityComment,
@Consumption.valueHelpDefinition: [{ entity:{ name: 'I_PartnerCompanyStdVH', element: 'PartnerCompany' } }]
cast( '' as rassc) as TradingPartner,
@Consumption.filter.selectionType: #INTERVAL
cast('' as farp_contact_date) as LastCustomerContactDate,
@Consumption.filter.hidden : true
cast( '' as crm_j_status) as Status,
@Consumption.filter.hidden : true
cast( '' as vdm_statusshortname) as SystemStatusShortName,
@Consumption.filter.hidden : true
cast( '' as ad_remark1) as AddressText,
@Consumption.filter.hidden : true
cast( '' as bcode) as BranchCode,
@Consumption.filter.hidden : true
cast( '' as farp_supplist_branch_descr) as TH_BranchCodeDescription,
@Consumption.filter.hidden : true
cast( '' as ad_namtext) as FullName,
// These fields are needed for DCL
@Consumption.hidden: true
@Semantics.booleanIndicator: true
IsBusinessPurposeCompleted,
@Consumption.hidden: true
DataControllerSet,
@Consumption.hidden: true
DataController1,
@Consumption.hidden: true
DataController2,
@Consumption.hidden: true
DataController3,
@Consumption.hidden: true
DataController4,
@Consumption.hidden: true
DataController5,
@Consumption.hidden: true
DataController6,
@Consumption.hidden: true
DataController7,
@Consumption.hidden: true
DataController8,
@Consumption.hidden: true
DataController9,
@Consumption.hidden: true
DataController10
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ADDRESS",
"I_BUSINESSPARTNER",
"I_CUSTOMER",
"I_CUSTOMERTOBUSINESSPARTNER"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/