KNA1
General Data in Customer Master
KNA1 is an SAP database table in S/4HANA. General Data in Customer Master. It contains 17 fields. 70 CDS views read from this table.
CDS Views using this table (70)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| /SAPCEM/SHSM_J_3GV_J3GBV1 | view | left_outer | CDS view for search help J_3GV_J3GBV1 | |
| /SCMTMS/CV_BP_Common | view | left_outer | Common TM Node of TM BO for BP | |
| arun_i_so_reqmt | view | inner | Sales Order selection in Normal mode | |
| ARUN_I_SO_REQMT_PREV | view | inner | Sales Order selection from Preview table | |
| Arun_I_Sto_Reqmt | view | inner | STO selection for Normal mode | |
| ARUN_I_STO_REQMT_PREV | view | inner | STO selection from Preview table | |
| E_Customer | view | from | EXTENSION | Extensibility Customer Core |
| F3_Mmim_Customer_Vh | view | from | Help-View for Customer (KNA1) | |
| fac_ad_cds_account_buv | view | left_outer | Help View for Account in Trans-Key BUV | |
| fac_ad_cds_customer | view | from | Value-Help for Customers | |
| fiscds_gllit_02 | view | left_outer | GL Line Item (other Ledger) | |
| FISVD_OPNIT_01 | view | left_outer | Open Items of Manual Clearing | |
| FISVD_OPNITM_01 | view | left_outer | Open Items of Manual Clearing | |
| FNDEI_KNA1_BLOCKINGINFO | view | from | Blocking Info View for table KNA1 | |
| FNDEI_KNA1_FILTER | view | from | Filter View for table KNA1 | |
| I_ACMCustomerCounterparty | view | from | BASIC | Interface for Customer counter party |
| I_ACMCustomerCounterpartyName | view | from | BASIC | Customer Counter Party Name |
| I_ACMCustPartnerFunction | view | from | BASIC | Link Customer to Partner Function |
| I_ACMCustTxt | view | from | BASIC | Customer Counter Party Name - Text |
| I_ACMOutboundDeliveryVH | view_entity | inner | BASIC | ACM Outbound Delivery |
| I_ACMSalesCounterparty | view_entity | from | BASIC | Trading Contract Sales Counterparty |
| I_ARunMntrItemSD | view | inner | BASIC | Basic View for Item data of SD document in ARun Monitor Runs |
| I_ARunMntrItemSTO | view | left_outer | BASIC | Basic View for Stock Transport Orders in ARun Monitor Runs |
| I_ARunOvwSDItem | view | inner | BASIC | Basic View for Sales Document Item |
| I_ARunOvwSTOItem | view | left_outer | BASIC | Basic View for Stock Transport Order Item |
| I_BalanceAuditTrailCustomer | view | from | BASIC | Customers for Balance Audit Trail |
| I_BR_Customer | view | from | BASIC | Brazil Customer Data |
| I_BusinessPartnerCustomer | view | from | BASIC | Business Partner Customer |
| I_Customer | view | from | BASIC | Customer |
| I_GHONtwkObjTransporterText | view_entity | from | BASIC | Transporter Details - Text |
| I_SupDmndAllDocGdsIssdDeliv | view | inner | BASIC | View for Goods Issued Deliveries |
| I_SupDmndAllDocOpenDeliveries | view | inner | BASIC | View for Open Deliveries |
| I_SupDmndAllDocRetDeliv | view | inner | BASIC | View for Return Deliveries |
| I_SupDmndAllDocRetSlsOrd | view | inner | BASIC | View for Return Sales Orders |
| I_SupDmndOvwItemSD | view | inner | BASIC | Basic View for Sales Document Item |
| I_SupDmndOvwItemSTO | view | left_outer | BASIC | Basic View for STO Item |
| I_TrdgContrCustomer | view | from | BASIC | Trading Contract Customer Description |
| I_TripPartnerInfo | view | union_all | BASIC | Cds for partner information |
| J2G_SHSM_DEBI1 | view | from | ||
| J2G_SHSM_DEBI2 | view | from | ||
| m_v_eop_customer | view | from | EOP Check CDS View: Customer Master | |
| MDGI_Customer_BPMultiAssgn | view | from | Customer for BP Multiple Assignment | |
| P_ACMApplicationCounterparty | view_entity | from | BASIC | Counterparty in ACM Maintain Application |
| P_ACMCounterparty | view_entity | from | BASIC | ACM Counterparty Value help |
| P_ACMSalesCounterparty | view_entity | from | BASIC | Trading Contract Sales Counterparty |
| P_ACMTrdgContrCounterPty | view_entity | from | BASIC | |
| P_ARBSITMCLRITEM01 | view | left_outer | BASIC | |
| P_ARLineItem_6 | view | from | BASIC | |
| P_AUDIT_AT_KNA1 | view | from | BASIC | |
| P_Competitor | view | from | BASIC | |
| P_CustomerOrder | view | inner | BASIC | |
| P_ECMCA_CTR_01 | view | left_outer | COMPOSITE | |
| P_MDChgProcCustClAssgmtWthNmbr | view | inner | BASIC | |
| P_MDChgProcCustValnWthBusPart | view | inner | BASIC | |
| P_TradingContractCounterparty | view | from | BASIC | |
| pp_mrp_read_planned_order_comp | view | left_outer | Read Planned Order Components | |
| rfm_mm_seasons_basic_view | view | inner | RFM Stock Transport Seasons Basic View | |
| rfm_psst_assign | view | left_outer | PSST Assignment monitor view | |
| rfm_psst_sto_assign | view | left_outer | Assignment Monitor STO view | |
| RFM_SD_SEASONS_BASIC_VIEW | view | inner | RFM Sales Document Seasons Basic View | |
| SHSM_DEBIK | view | from | CDS view replacing M_DEBIK for DEBIK | |
| SHSM_FAR_CUSTOMER | view | from | Value-Help for Customers | |
| SHSM_FAR_CUSTOMER_COMPANY | view | from | Value-Help for Customers in Company Code | |
| SHSM_FAR_DBUKA | view | inner | Value-Help for Company Code with regard to customer | |
| SHSM_IAOM_CRM_AUFK | view | left_outer | Internal Orders Created from CRM Service | |
| SHSM_KNA14 | view | from | ||
| SHSM_SHP_VIEW_GDSIM_O | view | inner | CDS-based Value Help Selection Method SHP_VIEW_GDSIM_O | |
| VC_INTEGRATION_KNA1 | view | from | Extraction for KNA1 | |
| view_Kna1_name_p | view | from | Display Name of Customer | |
| WLF_VIEW_KNA1_BG | view | from | Provides field BEGRU |
Fields (17)
| Key | Field | Data Element | Description |
|---|---|---|---|
| KEY | mandt | mandt | |
| KEY | kunnr | kunnr | |
| land1 | land1_gp | ||
| name1 | name1_gp | ||
| name2 | name2_gp | ||
| ort01 | ort01_gp | ||
| pstlz | pstlz | ||
| regio | regio | ||
| sortl | sortl | ||
| stras | stras_gp | ||
| telf1 | telf1 | ||
| telfx | telfx | ||
| xcpdk | xcpdk | ||
| adrnr | adrnr | ||
| mcod1 | mcdd1 | ||
| mcod2 | mcdd2 | ||
| mcod3 | mcdd3 |