I_CUSTOMER
Customer
I_CUSTOMER is a CDS View in S/4HANA. Customer. It contains 75 fields. 157 CDS views read from this table.
CDS Views using this table (157)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| A_Customer | view | from | BASIC | Customer |
| A_SeasonSalesPeriod | view | left_outer | COMPOSITE | API view for season sd periods |
| 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_ARItemCustomer | view_entity | from | CONSUMPTION | Customer Data for Customer Line Items |
| C_ATPRlvtProdAssgdSoldToPtyVH | view_entity | inner | CONSUMPTION | ATP Rlvt Product Assigned Sold to Party |
| C_BadDebtReserveCustomerVH | view | from | CONSUMPTION | BDRA- Customer Value Help |
| C_CashFlowItemCustomer | view_entity | 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_CustRetRecmdnDataset | view_entity | inner | CONSUMPTION | Dataset for Input Recommendation for Customer Return |
| C_CustRetRecmdnDataset_2 | view_entity | inner | CONSUMPTION | Customer Return Recommendation Dataset |
| C_DbtflAcctsValnCustomerVH | view | from | CONSUMPTION | DAV - Customer Value Help |
| C_DspPaytCardCustomerCard | view | from | CONSUMPTION | Payment Card - Customer Contact Card |
| C_EntProjCustomerContactCard | view_entity | inner | CONSUMPTION | Enterprise Project Customer Details |
| C_ESJICustomerQuery | view | from | CONSUMPTION | Customer |
| C_FinInvoiceBillToPartyFDP | view_entity | from | CONSUMPTION | Bill to Party for FI Invoice |
| 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_entity | inner | CONSUMPTION | PTW Profile specific BusinessPartnerData |
| C_ProjectBillingCustomerCard | view_entity | 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 Certificate Customer |
| C_RevnVarCustVH | view | from | CONSUMPTION | Value help for Customer |
| 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_SlsContrPartnerForReleaseVH | view_entity | from | CONSUMPTION | Sales Contract Releasing Partner |
| C_SoldToSalesAreaVH | view | from | CONSUMPTION | Sold-to Party |
| C_SoldToValueHelp | view | from | CONSUMPTION | Sold-to Party |
| C_SrlNmbrHistoryBPContactCard | view_entity | from | CONSUMPTION | Business Partner Contact Card |
| 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_WarrantyCustomerValueHelp | view_entity | from | CONSUMPTION | Warranty Customer |
| ESH_N_CUSTOMERS_T | view | from | Anchor view -CUSTOMERS_T | |
| 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_entity | left_outer | Cleared Receivable Item Information | |
| FARMLVD_APAR_ACCDOC_AUTH | view_entity | left_outer | Rec Item Auth Check Helper View | |
| FARMLVD_OPEN_PAYMTADV | view_entity | left_outer | Open Payment Advice Information | |
| FARMLVD_PAYMTADV | view_entity | 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 | Provides Business Partners Roles |
| 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_SAFTGenLedgerDocumentBP | view_entity | inner | COMPOSITE | Business Partner Document for SAFT LU |
| I_MaterialSampleDetails | view | left_outer | COMPOSITE | CDS View for Material Sample Details |
| I_MX_BPRelationshipRole | view_entity | inner | COMPOSITE | Provides Business Partners Roles |
| I_NO_SAFTCustomerMasterData | view_entity | inner | COMPOSITE | Master data of customers for SAFT |
| I_NO_SAFTCustomersInPeriod | view_entity | inner | COMPOSITE | List of all customers in report period |
| I_PartnerCompanyCustomerAuthzn | view_entity | 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_SAFTBillgAcctgCustomer | view_entity | inner | COMPOSITE | Customer from Accounting Document |
| I_PT_SAFTBillgPaytCust | view_entity | inner | COMPOSITE | Customer from Payment Document |
| I_PT_SAFTCustomerSalesInvoice | view_entity | inner | COMPOSITE | Customer from Billing Document |
| I_PT_SAFTDeliveryCustDetail | view | inner | COMPOSITE | Details of Portugal SAFT Customer |
| I_PT_SAFTDeliveryCustomer_2 | view_entity | inner | COMPOSITE | SAFT for Normal Customer |
| I_PT_SAFTSlsInvcBillgCust | view_entity | inner | COMPOSITE | Customer from Billing Document |
| 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_SlsDocAutomCompltnDataSet | view_entity | inner | COMPOSITE | Training Dataset for Sales Order Automatic Completion |
| I_SrlNumberHistoryCustomerVH | view_entity | from | COMPOSITE | Customer |
| P_AR_BPRelationshipRole | view_entity | inner | COMPOSITE | Argentina BP Relationship Role |
| P_AR_CustomerReceivableTotal | view | inner | CONSUMPTION | Argentina Customer Receivables Total |
| P_Arbsitmopenitem | view_entity | left_outer | COMPOSITE | Open Receivable Items |
| P_ARCustomerUnion | view | from | CONSUMPTION | AR Customer Union |
| P_ARCustomerUnion | view | union_all | CONSUMPTION | AR Customer Union |
| P_ARLineItemMixedAccount | view | inner | BASIC | Customer Accounts belonging to mixed accounts |
| P_BG_SAFTCustomer | view_entity | inner | CONSUMPTION | Customer Data for BG SAFT |
| P_BPPartnerFunctionNumber | view | from | COMPOSITE | Union view of various partner types |
| P_CN_CADECustomer | view | inner | CONSUMPTION | CADE Customer |
| P_CnsldtnCustomer | view | from | COMPOSITE | Consolidation Combined Customer |
| P_CnsldtnCustomerT | view | from | COMPOSITE | Consolidation Combined Customer Text |
| P_CO_DIANMinXrefCustomer | view | from | CONSUMPTION | All Formats - Customer XREF |
| P_CollsAcctColl | view_entity | inner | COMPOSITE | Collections Account - FI |
| P_CrExp | view | inner | COMPOSITE | FI Credit Exposure BSEG |
| P_CrExpFiMain | view | inner | COMPOSITE | FI Credit Exposure - Main Segment |
| P_CustomerAsSupplier | view | from | COMPOSITE | All customers in supplier role |
| P_CustomerByExternalID | view | from | CONSUMPTION | Customer By External ID |
| P_CustomerSupplierSH | view_entity | from | COMPOSITE | Search Help View for Customers and Suppliers for Country |
| P_CustomerWithPaymentAdvice | view | from | CONSUMPTION | Customers With Payment Advices |
| P_DRFEWMCustomer | view | from | BASIC | DRF EWM integration of customer |
| P_EngmntProjReviewData | view | left_outer | COMPOSITE | Engagement Project Plan Review Data |
| P_Fiarcn_Bp_Cust | view | from | CONSUMPTION | Customer and Business Partner |
| P_IN_CUSTOMERGSTHEALTHCHECK | view_entity | inner | COMPOSITE | Customer GST India Health Check |
| P_IN_CustomerTaxNumber | view_entity | from | COMPOSITE | Customer Tax Number |
| P_IsCustomerEUMember | view_entity | from | CONSUMPTION | Is Customer European Union Member |
| P_LU_SAFTJournalItemBP | view | inner | COMPOSITE | SAFT LU Journal Item Business Partner |
| P_NO_SAFTJournalCustSup | view | inner | COMPOSITE | SAF-T Norway Customers and Suppliers |
| P_OffsettingAccount | view_entity | union_all | COMPOSITE | Private union view for OffsettingAccount |
| P_OffsettingAccountVH | view_entity | union_all | COMPOSITE | Private view for Offsetting Account Value Help |
| P_PayReqnLineItems | view | inner | COMPOSITE | Private view for pay reqn line items |
| P_PaytReceiptCustomerVH | view | inner | COMPOSITE | Payment Receipt Customer |
| P_ProdAllocPlngBusPartners | view | from | COMPOSITE | Product Allocation Planning Business Partners |
| P_PT_SAFTTAXLAND | view | inner | COMPOSITE | Private Payment Tax Country |
| P_PurOrdMaintainItemActAddr | view | left_outer | CONSUMPTION | PO Maintenance: Purchase Order Item Address (Active) |
| P_RO_SAFTCustomer | view | inner | CONSUMPTION | Customer Data for RO SAFT |
| P_RU_CustomerData1 | view | from | COMPOSITE | RU Customer Data - 1 |
| P_SD_Sor_Cust_Identification | view_entity | from | COMPOSITE | Custemer Identification for SOR |
| P_SI4_TrainingData10 | view | left_outer | COMPOSITE | Sales Performance Prediction |
| P_SPP_PredictionData06 | view | left_outer | COMPOSITE | Prediction Data 06 |
| P_SPP_TrainingData06 | view | left_outer | COMPOSITE | Training Data 06 |
| P_StRpBillingDocumentItem | view | left_outer | COMPOSITE | Billing Document Item with Tax for Statutory Reporting |
| P_StRpSalesInvoiceItem | view | inner | CONSUMPTION | Private View for Sales Invoice List |
| P_TW_TaxItem | view | left_outer | COMPOSITE | Tax Item Information for TaiWan |
| P_WLF_CDS_KNA1_BG | view | from | BASIC | Help View: provides field BEGRU |
| SDM_GLO_RO_ROFI_BPTY_BPNUM | view_entity | inner | SDM View for ROFI_BPTY - Romania | |
| 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 (75)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | AddressID | AddressID | 16 |
| KEY | Customer | Account,BusinessPartner,ContactCardID,Customer,customer_account,CustomerForEdit,CustomerNum,Partner | 50 |
| _AddressRepresentation | _Addr,_AddressRepresentation | 4 | |
| _CustomerAccountGroupText | _CustomerAccountGroupText | 1 | |
| _CustomerClassification | _CustomerClassification | 3 | |
| _CustomerClassificationText | _CustomerClassificationText | 1 | |
| _CustomerCompany | _CustomerCompany | 2 | |
| _StandardAddress | _StandardAddress | 2 | |
| AlternativePayeeIsAllowed | AlternativePayeeIsAllowed | 3 | |
| AlternativePayerAccount | AlternativePayerAccount | 3 | |
| AuthorizationGroup | AuthorizationGroup,BEGRU,customer_begru,CustomerBasicAuthorizationGrp | 49 | |
| BillingIsBlockedForCustomer | BillingIsBlockedForCustomer | 4 | |
| BPAddrCityName | BPAddrCityName,CityName | 5 | |
| BPAddrStreetName | BPAddrStreetName,StreetName | 2 | |
| BPCustomerFullName | BPCustomerFullName,BusinessPartnerFullName,FullName | 4 | |
| BPCustomerName | BPCustomerName,CustomerName | 10 | |
| BusinessPartner | BusinessPartner | 1 | |
| BusinessPartnerName1 | BusinessPartnerName1,CustomerName | 10 | |
| BusinessPartnerName2 | BusinessPartnerName2 | 9 | |
| BusinessPartnerName3 | BusinessPartnerName3 | 1 | |
| BusinessPartnerName4 | BusinessPartnerName4 | 1 | |
| BusinessPartnerUUID | BusinessPartnerUUID | 1 | |
| CityName | CityName | 15 | |
| Country | Country,CustomerCountry,ShipToPartyCountry | 19 | |
| CreatedByUser | CreatedByUser | 7 | |
| CreationDate | CreationDate | 5 | |
| CustomerAccountGroup | CustomerAccountGroup,ReferenceAccountGroup | 43 | |
| CustomerClassification | CustomerClassification | 8 | |
| CustomerCorporateGroup | CustomerCorporateGroup | 1 | |
| CustomerFullName | CustomerFullName,FullName,PartnerFullName | 6 | |
| CustomerName | customer_name,CustomerName,Name | 30 | |
| DataController1 | DataController1 | 27 | |
| DataController10 | DataController10 | 27 | |
| DataController2 | DataController2 | 27 | |
| DataController3 | DataController3 | 27 | |
| DataController4 | DataController4 | 27 | |
| DataController5 | DataController5 | 27 | |
| DataController6 | DataController6 | 27 | |
| DataController7 | DataController7 | 27 | |
| DataController8 | DataController8 | 27 | |
| DataController9 | DataController9 | 27 | |
| DataControllerSet | DataControllerSet | 29 | |
| DataMediumExchangeIndicator | DataMediumExchangeIndicator | 1 | |
| DeletionIndicator | DeletionIndicator | 5 | |
| DeliveryDateTypeRule | DeliveryDateTypeRule | 1 | |
| DeliveryIsBlocked | DeliveryIsBlocked | 5 | |
| FaxNumber | FaxNumber | 1 | |
| Industry | Industry | 4 | |
| IsBusinessPurposeCompleted | IsBusinessPurposeCompleted | 27 | |
| IsCompetitor | IsCompetitor | 1 | |
| IsOneTimeAccount | IsOneTimeAccount | 19 | |
| Language | Language | 1 | |
| OrderIsBlockedForCustomer | OrderIsBlockedForCustomer | 4 | |
| OrganizationBPName1 | OrganizationBPName1 | 17 | |
| OrganizationBPName2 | OrganizationBPName2 | 15 | |
| PaymentReason | PaymentReason | 1 | |
| PostalCode | PostalCode | 14 | |
| PostingIsBlocked | PostingIsBlocked | 6 | |
| Region | Region | 1 | |
| ResponsibleType | ResponsibleType | 3 | |
| SortField | SortField | 1 | |
| StreetName | StreetName | 8 | |
| Supplier | Supplier | 5 | |
| TaxJurisdiction | TaxJurisdiction | 2 | |
| TaxNumber1 | TaxNumber1 | 12 | |
| TaxNumber2 | TaxNumber2 | 10 | |
| TaxNumber3 | TaxNumber3 | 2 | |
| TaxNumber4 | TaxNumber4 | 2 | |
| TaxNumber5 | TaxNumber5 | 2 | |
| TaxNumberType | TaxNumberType | 4 | |
| TelephoneNumber1 | TelephoneNumber1 | 2 | |
| TelephoneNumber2 | TelephoneNumber2 | 1 | |
| TradingPartner | PartnerCompany,TradingPartner | 3 | |
| 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: #A
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #MASTER
@VDM.viewType: #BASIC
@ObjectModel.sapObjectNodeType.name: 'Customer'
@Consumption.dbHints: [ 'USE_HEX_PLAN' ]
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
//@Semantics.text:true
@EndUserText.label: 'Business Partner - Customer Name'
cast(substring(rtrim(replace(concat(_AddressDefaultRepresentation.AddresseeName1, concat(' &@', _AddressDefaultRepresentation.AddresseeName2)), '&@', ''),' '),1,81) as customername_2) as BPCustomerName,
@EndUserText.label: 'Business Partner - Customer Full Name'
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,
@EndUserText.label: 'Business Partner Organization - Name 1'
_AddressDefaultRepresentation.AddresseeName1 as BusinessPartnerName1,
@EndUserText.label: 'Business Partner Organization - Name 2'
_AddressDefaultRepresentation.AddresseeName2 as BusinessPartnerName2,
@EndUserText.label: 'Business Partner Organization - Name 3'
_AddressDefaultRepresentation.AddresseeName3 as BusinessPartnerName3,
@EndUserText.label: 'Business Partner Organization - Name 4'
_AddressDefaultRepresentation.AddresseeName4 as BusinessPartnerName4,
@EndUserText.label: 'Business Partner Address – City'
_AddressDefaultRepresentation.CityName as BPAddrCityName,
@EndUserText.label: 'Business Partner Address – Street'
_AddressDefaultRepresentation.StreetName as BPAddrStreetName,
@EndUserText.label: 'Business Partner Address - Search Term 1'
_AddressDefaultRepresentation.AddressSearchTerm1 as AddressSearchTerm1,
@EndUserText.label: 'Business Partner Address - Search Term 2'
_AddressDefaultRepresentation.AddressSearchTerm2 as AddressSearchTerm2,
@EndUserText.label: 'Business Partner Address – District'
_AddressDefaultRepresentation.DistrictName as DistrictName,
@EndUserText.label: 'Business Partner Address - PO Box Deviating City'
_AddressDefaultRepresentation.POBoxDeviatingCityName as POBoxDeviatingCityName ,
@EndUserText.label: 'Business Partner - Form of Address'
_AddressDefaultRepresentation.FormOfAddress as BusinessPartnerFormOfAddress,
kna1.icmstaxpay as BR_ICMSTaxPayerType,
//Associations
_CustomerToBusinessPartner,
_StandardAddress,
_AddressDefaultRepresentation,
_AddressRepresentation,
_CreatedByUser,
_CorrespondingSupplier,
_CustomerClassification,
_CustomerClassificationText,
_CustomerAccountGroupText,
_CustomerCompany,
_CustomerSalesArea,
_CustomerSalesAreaTax,
_CustomerAddr,
_CustomerAddrSalesAreaTax,
_ContactPerson,
_CustomerHierarchyNode,
_GlobalCompany
// _BusinessPartnerAddress
}