I_CUSTOMER
Customer
I_CUSTOMER is a CDS View in S/4HANA. Customer. It contains 72 fields. 147 CDS views read from this table.
CDS Views using this table (147)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| A_Customer | view | from | BASIC | Customer |
| A_SeasonSalesPeriod | view | left_outer | COMPOSITE | Season Sales Period |
| C_AR_StRpVATForm731ItemC | view | left_outer | CONSUMPTION | Argentina VAT Form 731 |
| C_AR_StRpVATForm731ItemLogC | view | left_outer | CONSUMPTION | Argentina VAT Form 731 with Rptd item log data |
| C_BadDebtReserveCustomerVH | view | from | CONSUMPTION | BDRA- Customer Value Help |
| C_CashFlowItemCustomer | view | from | CONSUMPTION | Customer of Cash Flow Item |
| C_CN_CustVH | view | from | CONSUMPTION | Customer Value Help |
| C_Competitoridtemp | view | from | CONSUMPTION | Competitor ID Value Help |
| C_CorrespondenceCustomerVH | view | from | CONSUMPTION | Correspondence Customer Value Help |
| C_Customer360 | view_entity | from | CONSUMPTION | Customer 360 |
| C_CustomerList_2 | view_entity | from | CONSUMPTION | Customer List |
| C_CustomerOP | view | from | CONSUMPTION | Customer |
| C_CustomerProjectDetails | view | left_outer | CONSUMPTION | Customer Project Details |
| C_Customersuppliercompanycode | view | from | CONSUMPTION | Customer/Supplier/Company Code Information |
| C_CustProjCustomerDetails | view | from | CONSUMPTION | Customer Project Customer Details |
| C_CustProjCustSrvcOrgDetails | view | from | CONSUMPTION | Customer Project Service Organisation Details For Customer |
| C_DbtflAcctsValnCustomerVH | view | from | CONSUMPTION | DAV - Customer Value Help |
| C_DspPaytCardCustomerCard | view | from | CONSUMPTION | Payment Card - Customer Contact Card |
| C_EntProjCustomerContactCard | view_entity | from | CONSUMPTION | Enterprise Project Customer Details |
| C_ESJICustomerQuery | view | from | CONSUMPTION | Customer |
| C_GRC_CustomerChangeLog | view | inner | CONSUMPTION | Customer change log |
| C_InspLotCustValHelp | view | from | CONSUMPTION | Customer Value Help |
| C_JITBusinessPartnerVH | view_entity | from | CONSUMPTION | Business Partner |
| C_JournalEntryCustomerCard | view | from | CONSUMPTION | Journal Entry Customer Contact Card |
| C_LCMContactsOrgValueHelp | view | from | CONSUMPTION | Value Help for Contact Org. of BP |
| C_MrkdDeltnNoPostgBlkCust | view | from | CONSUMPTION | Customer marked for delete without block |
| C_NoCompanyCodeCustomer | view | from | CONSUMPTION | Customer with no company code assignment |
| C_PermitToWorkPartnerValueHelp | view | inner | CONSUMPTION | PTW Profile specific BusinessPartnerData |
| C_ProjectBillingCustomerCard | view | from | CONSUMPTION | Project Billing - Customer Contact Card |
| C_PurgCustomerBPShipToAddrVH | view | inner | CONSUMPTION | Customer Ship to Addresses |
| C_PurOrdMaintainCustValHelp | view | from | CONSUMPTION | PO Maintenance: Value Help for Customer |
| C_Q2CCustomerQuickView | view_entity | from | CONSUMPTION | Customer |
| C_QltyCertCustomerVH | view | from | CONSUMPTION | Quality Cert Customer Value Help |
| C_RevnVarCustVH | view | from | CONSUMPTION | Value help for Customer |
| C_RO_SAFTCustomer | view | inner | CONSUMPTION | Customer Master Data for RO SAFT |
| C_RO_StRpDomesticSlsPurListC | view | left_outer | CONSUMPTION | Romania Domestic Sales and Purchase List - Cube |
| C_RO_StRpTaxItemWithEUTaxClfnC | view | left_outer | CONSUMPTION | EU Sales Tax Item View for RO |
| C_SalesInsightCustomerVH | view | from | CONSUMPTION | Sales Insight: Customer Value Help |
| C_SalesOrderByMonth | view | left_outer | CONSUMPTION | Sales Order by Month |
| C_SDDocumentCustomerVH | view | inner | CONSUMPTION | SD Document Ship to Party |
| C_ShipToPartyValueHelp | view | from | CONSUMPTION | Ship to Party |
| C_SoldToSalesAreaVH | view | from | CONSUMPTION | Sold-to Party |
| C_SoldToValueHelp | view | from | CONSUMPTION | Sold-to Party |
| C_SupDmndOvwTotDmndQuery | view | left_outer | CONSUMPTION | Query View for Total Demand |
| C_SupDmndTotSlsOrdQuery | view | left_outer | CONSUMPTION | Query View for Total Demand |
| C_SupDmndTotSTOQuery | view | left_outer | CONSUMPTION | Query View for Total Demand |
| C_SustCustomerAddressDEX | view_entity | from | CONSUMPTION | Customer Address data extractor |
| C_VMSVehicleB2CSoldToPartyVH | view_entity | from | CONSUMPTION | Sold To Party Search Help |
| C_VMSVehSoldToPartyQuickView | view_entity | from | CONSUMPTION | Sold to party card |
| C_WarrantyCustomerValueHelp | view | from | CONSUMPTION | Warranty Customer |
| CIC_SOURCE_OF_SUPPLY_JOIN | view | left_outer | Source of Supply for valid partners | |
| ESH_N_CUSTOMERS_T | view | from | ||
| FAC_CUSTOMERVH | view | from | Value help for customer | |
| FAC_DART_Z3_C_BP_ADDRESS | view | from | Business Partner Address for Customer | |
| FAC_DART_Z3_Customer | view | left_outer | Customer Master Data | |
| FARMLVD_APAR_ACCDOC | view | left_outer | Cleared Receivable Item Information | |
| FARMLVD_APAR_ACCDOC_AUTH | view | left_outer | Rec Item Auth Check Helper View | |
| FARMLVD_OPEN_PAYMTADV | view | left_outer | Open Payment Advice Information | |
| FARMLVD_PAYMTADV | view | left_outer | Payment Advice Information | |
| I_AR_StRpTaxItem | view | left_outer | COMPOSITE | Argentina VAT Tax Line Item Calculation |
| I_BadDebtReserveCustomer | view | from | COMPOSITE | Bad Debt Reserve Adequacy Customer |
| I_BalanceAuditTrail | view | left_outer | COMPOSITE | Line Items for Balance Audit Trail |
| I_BPAdditionalCustomerTP | view | inner | TRANSACTIONAL | BO view for Additional Customers of BP |
| I_BPAddlCustEmailAddressTP | view | inner | TRANSACTIONAL | BO view for email for MLTAS customers |
| I_BPAddlCustFaxNumberTP | view | inner | TRANSACTIONAL | BO view for Fax Numb of MLTAS Customers |
| I_BPAddlCustMblPhNumberTP | view | inner | TRANSACTIONAL | BO view for Mob Ph of MLTAS Customers |
| I_BPAddlCustTelNmbrTP | view | inner | TRANSACTIONAL | BO view for Tel nos of MLTAS Customers |
| I_BPAddlCustWebsiteURLTP | view | inner | TRANSACTIONAL | BO view for Website URL of MLTAS Customers |
| I_BPCustomerGov | view_entity | union_all | COMPOSITE | BP Customer Data Governance |
| I_BPCustomerMultiAddrVH | view | inner | COMPOSITE | Customers by Multiple Addresses |
| I_BR_NFPartner_VendCust | view | union | COMPOSITE | Brazil Nota Fiscal Customer and Supplier |
| I_CN_GoldenTaxCustomerTypeDetn | view | from | COMPOSITE | Golden Tax Customer Type Determination |
| I_CnsldtnMasterData | view | union_all | COMPOSITE | Consolidation - Combined Master Data |
| I_CO_BPRelationshipRole | view_entity | inner | COMPOSITE | |
| I_CollsCustomerVH | view | from | COMPOSITE | Customer VH |
| I_CommodityCustomer | view | from | BASIC | Customer Master for Commodities |
| I_Customer_VH | view | from | BASIC | Customer |
| I_CustomerChangeLog | view | inner | COMPOSITE | Customer change log |
| I_DbtflAcctsValnCustomer | view | from | COMPOSITE | DAV Customer Information |
| I_EmlTmplCustSuplrCompanyCode | view | from | COMPOSITE | Email Template Data Provider |
| I_EngmntProjCustInfo | view | from | BASIC | Billg Info for Engmnt Project Customer |
| I_EngmntProjCustomer | view | from | BASIC | Engagement Project Customer |
| I_IN_StRpGSTRet | view | left_outer | COMPOSITE | Tax Item Details for GST Returns |
| I_LU_SAFTJournalItemBP | view | inner | COMPOSITE | SAFT LU Document Business Partner |
| I_MaterialSampleDetails | view | left_outer | COMPOSITE | CDS View for Material Sample Details |
| I_NO_SAFTCustomersInPeriod | view_entity | inner | COMPOSITE | List of all customers in report period |
| I_PartnerCompanyCustomerAuthzn | view | from | BASIC | Customer Authorization in Company |
| I_PH_SuplrCustJournalCube | view | left_outer | COMPOSITE | PH CAS Supplier Customer Journal Cube |
| I_ProjCustSrvcOrgDetails | view | from | COMPOSITE | Customer Service Organisation Details |
| I_PT_SAFTDeliveryCustDetail | view | inner | COMPOSITE | Details of Portugal SAFT Customer |
| I_SAFTAccountingCustomer | view | inner | COMPOSITE | SAF-T Regular Accounting Customers |
| I_SAFTBillingCustomer | view | inner | COMPOSITE | SAF-T Regular Billing Customers |
| I_SAFTDeliveryCustomer | view | inner | BASIC | SAF-T Regular Billing Customers |
| I_SAFTSettlementMgmtCustomer | view | inner | COMPOSITE | SAF-T Settlement Management Customer |
| I_VisualNominations | view | left_outer | COMPOSITE | Visual Nominations |
| I_VisualSimulation | view | left_outer | COMPOSITE | IPW Simulation in Visualization |
| P_AR_BPRelationshipRole | view_entity | inner | COMPOSITE | |
| P_AR_CustomerReceivableTotal | view | inner | CONSUMPTION | |
| P_Arbsitmopenitem | view | left_outer | COMPOSITE | |
| P_ARCustomerUnion | view | from | CONSUMPTION | AR Customer Union |
| P_ARCustomerUnion | view | union_all | CONSUMPTION | AR Customer Union |
| P_ARLineItemMixedAccount | view | inner | BASIC | |
| P_BPPartnerFunctionNumber | view | from | COMPOSITE | |
| P_CN_CADECustomer | view | inner | CONSUMPTION | |
| P_CnsldtnCustomer | view | from | COMPOSITE | |
| P_CnsldtnCustomerT | view | from | COMPOSITE | |
| P_CO_DIANMinXrefCustomer | view | from | CONSUMPTION | All Formats - Customer XREF |
| P_CollsAcctColl | view_entity | inner | COMPOSITE | Collections Account - FI |
| P_CreditLimitUtilizationBseg1 | view | inner | COMPOSITE | |
| P_CrExp | view | inner | COMPOSITE | |
| P_CrExpFi | view | inner | COMPOSITE | |
| P_CrExpFiMain | view | inner | COMPOSITE | |
| P_CustomerAsSupplier | view | from | COMPOSITE | |
| P_CustomerAuthorizationGroup | view | from | COMPOSITE | |
| P_CustomerAuthznInCompany | view | from | BASIC | |
| P_CustomerByExternalID | view | from | CONSUMPTION | |
| P_CustomerWithPaymentAdvice | view | from | CONSUMPTION | Customers With Payment Advices |
| P_DRFEWMCustomer | view | from | BASIC | |
| P_EngmntProjReviewData | view | left_outer | COMPOSITE | |
| P_Fiarcn_Bp_Cust | view | from | CONSUMPTION | Customer and Business Partner |
| P_I_Customer_F2187 | view | from | CONSUMPTION | P view to get properties for Cust360 |
| P_IN_CUSTOMERGSTHEALTHCHECK | view_entity | inner | COMPOSITE | |
| P_IsCustomerEUMember | view_entity | from | CONSUMPTION | |
| P_LU_SAFTJournalItemBP | view | inner | COMPOSITE | |
| P_NO_SAFTJournalCustSup | view | inner | COMPOSITE | |
| P_NO_SAFTJournalCustSupMD | view | inner | COMPOSITE | SAF-T Norway Journal Item BP Master Data |
| P_OffsettingAccount | view | union_all | COMPOSITE | |
| P_OffsettingAccountVH | view | union_all | COMPOSITE | |
| P_PaytReceiptCustomerVH | view | inner | COMPOSITE | |
| P_ProdAllocPlngBusPartners | view | from | COMPOSITE | |
| P_PT_SAFTTAXLAND | view | inner | COMPOSITE | |
| P_PurOrdMaintainItemActAddr | view | left_outer | CONSUMPTION | |
| P_RO_SAFTCustomer | view | inner | CONSUMPTION | Customer Data for RO SAFT |
| P_RU_CustomerData1 | view | from | COMPOSITE | |
| P_SI4_TrainingData10 | view | left_outer | COMPOSITE | |
| P_SPP_PredictionData06 | view | left_outer | COMPOSITE | |
| P_SPP_TrainingData06 | view | left_outer | COMPOSITE | |
| P_StRpBillingDocumentItem | view | left_outer | COMPOSITE | |
| P_StRpSalesInvoiceItem | view | inner | CONSUMPTION | Private View for Sales Invoice List |
| P_TW_TaxItem | view | left_outer | COMPOSITE | |
| P_WLF_CDS_KNA1_BG | view | from | BASIC | |
| SHSM_M_CMKU | view | left_outer | Claims Relating to a Customer | |
| SHSM_SHP_VIEW_GDSI | view | inner | CDS-based Value Help Selection Method SHP_VIEW_GDSI | |
| SHSM_SHP_VIEW_GDSIM | view | inner | CDS-based Value Help Selection Method SHP_VIEW_GDSIM | |
| SHSM_SHP_VIEW_LIKP_OUT | view | inner | CDS-based Value Help Selection Method SHSM_SHP_VIEW_LIKP_OUT | |
| SHSM_SHP_VIEW_PICK | view | inner | CDS-based Value Help Selection Method SHP_VIEW_PICK | |
| SHSM_V_LINF_M | view | left_outer | Delivery info for the Project System |
Fields (72)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | AddressID | AddressID | 13 |
| KEY | Customer | Account,BusinessPartner,ContactCardID,Customer,customer_account,CustomerForEdit,CustomerNum,Partner | 49 |
| _AddressRepresentation | _Addr | 1 | |
| _CustomerAccountGroupText | _CustomerAccountGroupText | 1 | |
| _CustomerClassification | _CustomerClassification | 3 | |
| _CustomerClassificationText | _CustomerClassificationText | 1 | |
| _CustomerCompany | _CustomerCompany | 2 | |
| _CustomerToBusinessPartner | _CustomerToBusinessPartner | 1 | |
| _StandardAddress | _StandardAddress | 5 | |
| AlternativePayeeIsAllowed | AlternativePayeeIsAllowed | 3 | |
| AlternativePayerAccount | AlternativePayerAccount | 3 | |
| AuthorizationGroup | AuthorizationGroup,BEGRU,customer_begru,CustomerBasicAuthorizationGrp | 46 | |
| BillingIsBlockedForCustomer | BillingIsBlockedForCustomer | 4 | |
| BPAddrCityName | BPAddrCityName | 2 | |
| BPAddrStreetName | BPAddrStreetName | 1 | |
| BPCustomerFullName | BusinessPartnerFullName | 1 | |
| BPCustomerName | BPCustomerName | 4 | |
| BusinessPartnerName1 | BusinessPartnerName1 | 4 | |
| BusinessPartnerName2 | BusinessPartnerName2 | 4 | |
| CityName | CityName | 17 | |
| Country | Country,CustomerCountry,ShipToPartyCountry | 18 | |
| CreatedByUser | CreatedByUser | 7 | |
| CreationDate | CreationDate | 5 | |
| CustomerAccountGroup | CustomerAccountGroup,ReferenceAccountGroup | 37 | |
| CustomerClassification | CustomerClassification | 8 | |
| CustomerCorporateGroup | CustomerCorporateGroup | 1 | |
| CustomerFullName | CustomerFullName,FullName,PartnerFullName | 9 | |
| CustomerName | customer_name,CustomerName,Name | 32 | |
| DataController1 | DataController1 | 24 | |
| DataController10 | DataController10 | 24 | |
| DataController2 | DataController2 | 24 | |
| DataController3 | DataController3 | 24 | |
| DataController4 | DataController4 | 24 | |
| DataController5 | DataController5 | 24 | |
| DataController6 | DataController6 | 24 | |
| DataController7 | DataController7 | 24 | |
| DataController8 | DataController8 | 24 | |
| DataController9 | DataController9 | 24 | |
| DataControllerSet | DataControllerSet | 24 | |
| DataMediumExchangeIndicator | DataMediumExchangeIndicator | 1 | |
| DeletionIndicator | DeletionIndicator | 4 | |
| DeliveryDateTypeRule | DeliveryDateTypeRule | 1 | |
| DeliveryIsBlocked | DeliveryIsBlocked | 5 | |
| FaxNumber | FaxNumber | 1 | |
| Industry | Industry | 4 | |
| IsBusinessPurposeCompleted | IsBusinessPurposeCompleted | 22 | |
| IsCompetitor | IsCompetitor | 1 | |
| IsOneTimeAccount | IsOneTimeAccount | 13 | |
| Language | Language | 1 | |
| OrderIsBlockedForCustomer | OrderIsBlockedForCustomer | 4 | |
| OrganizationBPName1 | CustomerName,OrganizationBPName1 | 18 | |
| OrganizationBPName2 | OrganizationBPName2 | 17 | |
| PaymentReason | PaymentReason | 1 | |
| PostalCode | PostalCode | 11 | |
| PostingIsBlocked | PostingIsBlocked | 6 | |
| Region | Region | 1 | |
| ResponsibleType | ResponsibleType | 3 | |
| SortField | SortField | 1 | |
| StreetName | StreetName | 7 | |
| Supplier | Supplier | 4 | |
| TaxJurisdiction | TaxJurisdiction | 2 | |
| TaxNumber1 | TaxNumber1 | 11 | |
| TaxNumber2 | TaxNumber2 | 10 | |
| TaxNumber3 | TaxNumber3 | 2 | |
| TaxNumber4 | TaxNumber4 | 2 | |
| TaxNumber5 | TaxNumber5 | 2 | |
| TaxNumberType | TaxNumberType | 3 | |
| TelephoneNumber1 | TelephoneNumber1 | 2 | |
| TelephoneNumber2 | TelephoneNumber2 | 1 | |
| TradingPartner | TradingPartner | 1 | |
| VATLiability | VATLiability | 2 | |
| VATRegistration | VATRegistration | 7 |
@AbapCatalog.sqlViewName: 'I_CUSTOMER_CDS'
@AbapCatalog.preserveKey:true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED
@AccessControl.personalData.blockingIndicator: 'IsBusinessPurposeCompleted'
@AccessControl.privilegedAssociations: [ '_StandardAddress', '_AddressDefaultRepresentation','_AddressRepresentation']
@Analytics: {
dataCategory: #DIMENSION,
dataExtraction: {
enabled: true,
delta.changeDataCapture: {
mapping:[
{
table: 'KNA1', role: #MAIN,
viewElement: ['Customer'],
tableElement: ['kunnr']
},
{
table: 'ADRC', role: #LEFT_OUTER_TO_ONE_JOIN,
viewElement: ['AddressID'],
tableElement: ['Addrnumber']
}
]
}
}
}
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Customer'
@Metadata.allowExtensions: true
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.supportedCapabilities: [#SQL_DATA_SOURCE,
#CDS_MODELING_DATA_SOURCE,
#CDS_MODELING_ASSOCIATION_TARGET,
#ANALYTICAL_DIMENSION,
#EXTRACTION_DATA_SOURCE]
@ObjectModel.modelingPattern: #ANALYTICAL_DIMENSION
@ObjectModel.representativeKey: 'Customer'
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #MASTER
@VDM.viewType: #BASIC
@ObjectModel.sapObjectNodeType.name: 'Customer'
define view I_Customer
as select from kna1
association [1..1] to I_CustomerToBusinessPartner as _CustomerToBusinessPartner on $projection.Customer = _CustomerToBusinessPartner.Customer
association [0..1] to I_Supplier as _CorrespondingSupplier on _CorrespondingSupplier.Supplier = $projection.Supplier
association [0..*] to I_CustomerAccountGroupText as _CustomerAccountGroupText on $projection.CustomerAccountGroup = _CustomerAccountGroupText.CustomerAccountGroup
association [0..1] to I_CustomerClassification as _CustomerClassification on $projection.CustomerClassification = _CustomerClassification.CustomerClassification
association [0..*] to I_CustomerClassificationText as _CustomerClassificationText on $projection.CustomerClassification = _CustomerClassificationText.CustomerClassification
association [1..*] to I_CustomerCompany as _CustomerCompany on $projection.Customer = _CustomerCompany.Customer
association [1..*] to I_CustomerSalesArea as _CustomerSalesArea on $projection.Customer = _CustomerSalesArea.Customer
association [1..1] to I_User as _CreatedByUser on $projection.CreatedByUser = _CreatedByUser.UserID
association [1..1] to I_Address as _StandardAddress on $projection.AddressID = _StandardAddress.AddressID
association [1..*] to I_CustSalesAreaTax as _CustomerSalesAreaTax on $projection.Customer = _CustomerSalesAreaTax.Customer
association [0..1] to E_Customer as _CustomerExt on $projection.Customer = _CustomerExt.Customer
association [1..*] to I_CustAddrDepdntInformation as _CustomerAddr on $projection.Customer = _CustomerAddr.Customer
association [1..*] to I_CustSlsAreaAddrDepdntTaxInfo as _CustomerAddrSalesAreaTax on $projection.Customer = _CustomerAddrSalesAreaTax.Customer
association [0..*] to I_ContactPerson as _ContactPerson on $projection.Customer = _ContactPerson.Customer
association [0..*] to I_CustUnivHierarchyNode as _CustomerHierarchyNode on $projection.Customer = _CustomerHierarchyNode.Customer
association [0..1] to I_Globalcompany as _GlobalCompany on $projection.TradingPartner = _GlobalCompany.Company
// association [1..1] to I_BusinessPartnerAddress as _BusinessPartnerAddress on $projection.BusinessPartner = _BusinessPartnerAddress.BusinessPartner
// and $projection.AddressID = _BusinessPartnerAddress.AddressNumber
association [0..1] to I_OrganizationAddress as _AddressDefaultRepresentation on $projection.AddressID = _AddressDefaultRepresentation.AddressID
and _AddressDefaultRepresentation.AddressRepresentationCode is initial
association [0..1] to I_Address_2 as _AddressRepresentation on $projection.AddressID = _AddressRepresentation.AddressID
and _AddressRepresentation.AddressRepresentationCode is initial
and _AddressRepresentation.AddressPersonID is initial
{
//Key
@ObjectModel.text.element: ['CustomerName']
@ObjectModel: {
hierarchy.association: '_CustomerHierarchyNode'
}
key cast(kna1.kunnr as kunnr preserving type) as Customer,
//@VDM.deprecated:true
//Please use from association as _CustomerToBusinessPartner._BusinessPartner.BusinessPartner instead
//_cvi._BusinessPartner.BusinessPartner,
//@VDM.deprecated:true
//Please use from association as _CustomerToBusinessPartner.BusinessPartnerUUID instead
//_cvi.BusinessPartnerUUID,
// _CustomerToBusinessPartner._BusinessPartner.BusinessPartner as BusinessPartner,
@Semantics.text:true
cast(substring(rtrim(replace(concat(name1, concat(' &@', name2)), '&@', ''),' '),1,80) as md_customer_name) as CustomerName,
cast(concat( concat( concat( concat( concat( concat_with_space( anred, name1, 1 ), name2 ), name3 ), name4 ), '/' ),
concat_with_space(pstlz, ort01, 1 ) ) as md_customer_full_name) as CustomerFullName, //KF: different with S4
cast(substring(rtrim(replace(concat(_AddressDefaultRepresentation.AddresseeName1, concat(' &@', _AddressDefaultRepresentation.AddresseeName2)), '&@', ''),' '),1,81) as customername_2) as BPCustomerName,
cast(concat( concat_with_space( concat_with_space( concat_with_space(_AddressDefaultRepresentation.AddresseeName1, _AddressDefaultRepresentation.AddresseeName2,1 ), _AddressDefaultRepresentation.AddresseeName3,1 ), _AddressDefaultRepresentation.AddresseeName4,1 ), ' ' ) as md_customer_full_name) as BPCustomerFullName,
kna1.ernam as CreatedByUser,
kna1.erdat as CreationDate,
kna1.adrnr as AddressID,
@ObjectModel.foreignKey.association:'_CustomerClassification'
@ObjectModel.text.association: '_CustomerClassificationText'
kna1.kukla as CustomerClassification,
kna1.stceg as VATRegistration,
kna1.ktokd as CustomerAccountGroup,
kna1.begru as AuthorizationGroup,
kna1.lifsd as DeliveryIsBlocked,
kna1.sperr as PostingIsBlocked,
kna1.faksd as BillingIsBlockedForCustomer, // Used in CDS based Customer Object Page
kna1.aufsd as OrderIsBlockedForCustomer, //Used in CDS based Customer Object Page
@EndUserText.quickInfo: 'International Location Number (Part 1)'
kna1.bbbnr as InternationalLocationNumber1, //Used in CDS based Customer Object Page
kna1.xcpdk as IsOneTimeAccount,
kna1.txjcd as TaxJurisdiction,
kna1.brsch as Industry,
kna1.stcdt as TaxNumberType,
kna1.stcd1 as TaxNumber1, // same as kna1.stcd1 ?
kna1.stcd2 as TaxNumber2, // same as kna1.stcd2 ?
kna1.stcd3 as TaxNumber3,
kna1.stcd4 as TaxNumber4,
kna1.stcd5 as TaxNumber5,
kna1.stcd6 as TaxNumber6,
kna1.konzs as CustomerCorporateGroup,
kna1.lifnr as Supplier,
kna1.niels as NielsenRegion,
kna1.bran1 as IndustryCode1,
kna1.bran2 as IndustryCode2,
kna1.bran3 as IndustryCode3,
kna1.bran4 as IndustryCode4,
kna1.bran5 as IndustryCode5,
kna1.land1 as Country,
kna1.name1 as OrganizationBPName1,
kna1.name2 as OrganizationBPName2,
kna1.ort01 as CityName,
kna1.pstlz as PostalCode,
kna1.stras as StreetName,
kna1.sortl as SortField,
kna1.telfx as FaxNumber,
kna1.suframa as BR_SUFRAMACode,
kna1.regio as Region,
kna1.telf1 as TelephoneNumber1,
kna1.telf2 as TelephoneNumber2,
kna1.knrza as AlternativePayerAccount,
kna1.dtams as DataMediumExchangeIndicator,
kna1.stkzu as VATLiability,
kna1.cvp_xblck as IsBusinessPurposeCompleted,
kna1.fityp as ResponsibleType,
kna1.fiskn as FiscalAddress,
kna1.stkzn as NFPartnerIsNaturalPerson,
kna1.loevm as DeletionIndicator,
kna1.spras as Language,
@ObjectModel.foreignKey.association:'_GlobalCompany'
kna1.vbund as TradingPartner,
kna1.delivery_date_rule as DeliveryDateTypeRule,
kna1.bahne as ExpressTrainStationName,
kna1.bahns as TrainStationName,
@EndUserText.quickInfo: 'International Location Number (Part 2)'
kna1.bbsnr as InternationalLocationNumber2,
kna1.bubkz as InternationalLocationNumber3,
kna1.cityc as CityCode,
kna1.counc as County,
kna1.exabl as CustomerHasUnloadingPoint,
kna1.knazk as CustomerWorkingTimeCalendar,
kna1.dear1 as IsCompetitor,
j_1kfrepre as TaxInvoiceRepresentativeName,
j_1kftbus as BusinessType,
j_1kftind as IndustryType,
consolidate_invoice as TW_CollvBillingIsSupported,
xzemp as AlternativePayeeIsAllowed,
katr1 as FreeDefinedAttribute01,
katr2 as FreeDefinedAttribute02,
katr3 as FreeDefinedAttribute03,
katr4 as FreeDefinedAttribute04,
katr5 as FreeDefinedAttribute05,
katr6 as FreeDefinedAttribute06,
katr7 as FreeDefinedAttribute07,
katr8 as FreeDefinedAttribute08,
katr9 as FreeDefinedAttribute09,
katr10 as FreeDefinedAttribute10,
kna1.paytrsn as PaymentReason,
// Added Additional Fields
kna1.kdkg1 as CustomerConditionGroup1,
kna1.kdkg2 as CustomerConditionGroup2,
kna1.kdkg3 as CustomerConditionGroup3,
kna1.kdkg4 as CustomerConditionGroup4,
kna1.kdkg5 as CustomerConditionGroup5,
// kna1.anred as TitleCustomer,
// kna1.datlt as BPDataCommunicationPhoneNumber,
// kna1.locco as CityCoordinates,
// kna1.name3 as CustomerName3,
// kna1.name4 as CustomerName4,
// kna1.ort02 as CustomerDistrict,
// kna1.pfach as CustomerPostOfficeBox,
// kna1.pstl2 as PostalCodeForCustomer,
// kna1.rpmkr as CustomerRegionalMarket,
// kna1.telbx as CustomerTelephoneBoxNumber,
// kna1.teltx as CustomerTeletexNumber,
// kna1.telx1 as CustomerTelexNumber,
// kna1.lzone as CustomerTransportationZone,
// kna1.dear2 as IsSalesPartner,
@Semantics.booleanIndicator
kna1.dear3 as IsSalesProspect,
// kna1.dear5 as IsDefaultSoldToParty,
// kna1.gform as CustomerLegalStatus,
// kna1.ekont as CustomerInitialContact,
// kna1.umsat as CustomerAnnualSales,
// kna1.umjah as YearForWhichSalesGiven,
// kna1.uwaer as CurrencyOfSalesFigure,
// kna1.jmzah as CustYearlyNumberOfEmployees,
// kna1.jmjah as EmployeesNumberGivenForYear,
// kna1.umsa1 as AnnualSalesForCustomer,
// kna1.periv as CustomerFiscalYearVariant,
// kna1.abrvw as CustomerUsageIndication,
// kna1.inspbydebi as InspectionCarriedOutByCustomer,
// kna1.inspatdebi as DeliveryNoteInspectionOutBound,
// kna1.ktocd as CustomerReferenceAccountGroup,
// kna1.pfort as CustomerPostOfficeBoxCity,
// kna1.werks as CustomerPlant,
// kna1.dtaws as DataMediumExchangeKey,
// kna1.duefl as StatusOfDataTransfer,
// kna1.hzuor as HierarchyAssignment,
kna1.sperz as PaymentIsBlockedForCustomer,
// kna1.etikg as CustomerOrPlantGroupLabelling,
// kna1.civve as CustomerIsForCivilUse,
// kna1.milve as CustomerIdentityForMilitaryUse,
// kna1.xicms as CustomerExempt1,
// kna1.xxipi as CustomerExempt,
// kna1.xsubt as CustomerGroupForCalculation,
// kna1.cfopc as CustomerCategory,
// kna1.txlw1 as CustomerTaxLaw1,
// kna1.txlw2 as CustomerTaxLaw,
// kna1.cassd as CustomerCentralSalesBlock,
// kna1.knurl as UniformResourceLocatorForCust,
// kna1.confs as StatusOfChangeAuthorization,
// kna1.updat as ChangesConfirmedDate,
// kna1.uptim as LastChangeConfirmationTime,
// kna1.nodel as CustomerCentralDeletionIsBlock,
// kna1.stkza as BPSubjectToEqualizationTax,
// kna1.dear4 as CustomerType4,
// kna1.xknza as AlternativePayerUsingAccount,
// kna1.ccc01 as BioChemicalWarfareLegal,
// kna1.ccc02 as NuclearNonProliferationLegal,
// kna1.ccc03 as NationalSecurityLegalControl,
// kna1.ccc04 as MissileTechnologyLegalControl,
kna1.dear6 as IsConsumer,
//added only for DCL check
@UI.hidden: true
@Consumption.filter.hidden: true
kna1.xdcset as DataControllerSet,
//added only for DCL check
@UI.hidden: true
@Consumption.filter.hidden: true
kna1.data_ctrlr1 as DataController1,
//added only for DCL check
@UI.hidden: true
@Consumption.filter.hidden: true
kna1.data_ctrlr2 as DataController2,
//added only for DCL check
@UI.hidden: true
@Consumption.filter.hidden: true
kna1.data_ctrlr3 as DataController3,
//added only for DCL check
@UI.hidden: true
@Consumption.filter.hidden: true
kna1.data_ctrlr4 as DataController4,
//added only for DCL check
@UI.hidden: true
@Consumption.filter.hidden: true
kna1.data_ctrlr5 as DataController5,
//added only for DCL check
@UI.hidden: true
@Consumption.filter.hidden: true
kna1.data_ctrlr6 as DataController6,
//added only for DCL check
@UI.hidden: true
@Consumption.filter.hidden: true
kna1.data_ctrlr7 as DataController7,
//added only for DCL check
@UI.hidden: true
@Consumption.filter.hidden: true
kna1.data_ctrlr8 as DataController8,
//added only for DCL check
@UI.hidden: true
@Consumption.filter.hidden: true
kna1.data_ctrlr9 as DataController9,
//added only for DCL check
@UI.hidden: true
@Consumption.filter.hidden: true
kna1.data_ctrlr10 as DataController10,
_AddressDefaultRepresentation.AddresseeName1 as BusinessPartnerName1,
_AddressDefaultRepresentation.AddresseeName2 as BusinessPartnerName2,
_AddressDefaultRepresentation.AddresseeName3 as BusinessPartnerName3,
_AddressDefaultRepresentation.AddresseeName4 as BusinessPartnerName4,
_AddressDefaultRepresentation.CityName as BPAddrCityName,
_AddressDefaultRepresentation.StreetName as BPAddrStreetName,
_AddressDefaultRepresentation.AddressSearchTerm1 as AddressSearchTerm1,
_AddressDefaultRepresentation.AddressSearchTerm2 as AddressSearchTerm2,
_AddressDefaultRepresentation.DistrictName as DistrictName,
_AddressDefaultRepresentation.POBoxDeviatingCityName as POBoxDeviatingCityName ,
_AddressDefaultRepresentation.FormOfAddress as BusinessPartnerFormOfAddress,
//Associations
_CustomerToBusinessPartner,
_StandardAddress,
_AddressDefaultRepresentation,
_AddressRepresentation,
_CreatedByUser,
_CorrespondingSupplier,
_CustomerClassification,
_CustomerClassificationText,
_CustomerAccountGroupText,
_CustomerCompany,
_CustomerSalesArea,
_CustomerSalesAreaTax,
_CustomerAddr,
_CustomerAddrSalesAreaTax,
_ContactPerson,
_CustomerHierarchyNode,
_GlobalCompany
// _BusinessPartnerAddress
}