KNA1
General Data in Customer Master
KNA1 is an SAP database table in S/4HANA. General Data in Customer Master. It contains 252 fields. 67 CDS views read from this table.
CDS Views using this table (67)
| 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_ACMOutboundDeliveryVH | view_entity | inner | BASIC | ACM Outbound Delivery |
| 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_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 (252)
| 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 | ||
| anred | ANRED | ||
| aufsd | AUFSD_X | ||
| bahne | BAHNE | ||
| bahns | BAHNS | ||
| bbbnr | BBBNR | ||
| bbsnr | BBSNR | ||
| begru | BRGRU | ||
| brsch | BRSCH | ||
| bubkz | BUBKZ | ||
| datlt | DATLT | ||
| erdat | ERDAT_RF | ||
| ernam | ERNAM_RF | ||
| exabl | EXABL | ||
| faksd | FAKSD_X | ||
| fiskn | FISKN_D | ||
| knazk | KNAZK | ||
| knrza | KNRZA | ||
| konzs | KONZS | ||
| ktokd | KTOKD | ||
| kukla | KUKLA | ||
| lifnr | LIFNR | ||
| lifsd | LIFSD_X | ||
| locco | LOCCO | ||
| loevm | LOEVM_X | ||
| name3 | NAME3_GP | ||
| name4 | NAME4_GP | ||
| niels | NIELS | ||
| ort02 | ORT02_GP | ||
| pfach | PFACH | ||
| pstl2 | PSTL2 | ||
| counc | COUNC | ||
| cityc | CITYC | ||
| rpmkr | RPMKR | ||
| sperr | SPERB_X | ||
| spras | SPRAS | ||
| stcd1 | STCD1 | ||
| stcd2 | STCD2 | ||
| stkza | STKZA | ||
| stkzu | STKZU | ||
| telbx | TELBX | ||
| telf2 | TELF2 | ||
| teltx | TELTX | ||
| telx1 | TELX1 | ||
| lzone | LZONE | ||
| xzemp | XREGU | ||
| vbund | RASSC | ||
| stceg | STCEG | ||
| dear1 | DEAR1 | ||
| dear2 | DEAR2 | ||
| dear3 | DEAR3 | ||
| dear4 | DEAR4 | ||
| dear5 | DEAR5 | ||
| gform | GFORM | ||
| bran1 | BRAN1_D | ||
| bran2 | BRAN2 | ||
| bran3 | BRAN3 | ||
| bran4 | BRAN4 | ||
| bran5 | BRAN5 | ||
| ekont | EKONT | ||
| umsat | UMSAT | ||
| umjah | UMJAH | ||
| uwaer | UWAER | ||
| jmzah | JMZAH | ||
| jmjah | JMJAH | ||
| katr1 | KATR1 | ||
| katr2 | KATR2 | ||
| katr3 | KATR3 | ||
| katr4 | KATR4 | ||
| katr5 | KATR5 | ||
| katr6 | KATR6 | ||
| katr7 | KATR7 | ||
| katr8 | KATR8 | ||
| katr9 | KATR9 | ||
| katr10 | KATR10 | ||
| stkzn | STKZN | ||
| umsa1 | UMSA1 | ||
| txjcd | TXJCD | ||
| periv | PERIV | ||
| abrvw | ABRVW | ||
| inspbydebi | QINSPBYDEB | ||
| inspatdebi | QINSPATDEB | ||
| ktocd | KTOCD | ||
| pfort | PFORT_GP | ||
| werks | WERKS_D | ||
| dtams | DTAMS | ||
| dtaws | DTAWS | ||
| duefl | DUEFL_BKPF | ||
| hzuor | HZUOR | ||
| sperz | SPERZ | ||
| etikg | ETIKG | ||
| civve | CIVVE | ||
| milve | MILVE | ||
| kdkg1 | KDKG1 | ||
| kdkg2 | KDKG2 | ||
| kdkg3 | KDKG3 | ||
| kdkg4 | KDKG4 | ||
| kdkg5 | KDKG5 | ||
| xknza | XKNZA | ||
| fityp | J_1AFITP_D | ||
| stcdt | J_1ATOID | ||
| stcd3 | STCD3 | ||
| stcd4 | STCD4 | ||
| stcd5 | STCD5 | ||
| stcd6 | STCD6 | ||
| xicms | J_1BTCICMS | ||
| xxipi | J_1BTCIPI | ||
| xsubt | J_1BTCST | ||
| cfopc | J_1BINDUS1 | ||
| txlw1 | J_1BTAXLW1 | ||
| txlw2 | J_1BTAXLW2 | ||
| ccc01 | CCC01 | ||
| ccc02 | CCC02 | ||
| ccc03 | CCC03 | ||
| ccc04 | CCC04 | ||
| bonded_area_confirm | TWVAT_BONDED_AREA_CONF | ||
| donate_mark | TWVAT_DONATE_MARK | ||
| consolidate_invoice | TWGUI_CONSOLIDATE_INVOICE | ||
| allowance_type | TWVAT_ALLOWANCE_TYPE | ||
| einvoice_mode | TWVAT_EINVOICE_MODE | ||
| b2c_indicator | TWVAT_B2C_INDICATOR | ||
| cassd | CASSD_X | ||
| knurl | URL | ||
| j_1kfrepre | REPRES | ||
| j_1kftbus | GESTYP | ||
| j_1kftind | INDTYP | ||
| confs | CONFS_X | ||
| updat | UPDAT_RF | ||
| uptim | UPTIM_RF | ||
| nodel | NODEL_X | ||
| dear6 | DEAR6 | ||
| delivery_date_rule | SD_DELIVERY_DATE_TYPE_RULE | ||
| cvp_xblck | CVP_XBLCK | ||
| suframa | J_1BSUFRAMA | ||
| rg | J_1BRG | ||
| exp | J_1BEXP | ||
| uf | J_1BUF | ||
| rgdate | J_1BRGDATE | ||
| ric | J_1BRIC | ||
| rne | J_1BRNE | ||
| rnedate | J_1BRNEDATE | ||
| cnae | J_1BCNAE | ||
| legalnat | J_1BLEGALNAT | ||
| crtn | J_1BCRTN | ||
| icmstaxpay | J_1BICMSTAXPAY | ||
| indtyp | J_1BINDTYP | ||
| tdt | J_1BTDT | ||
| comsize | J_1BCOMSIZE | ||
| decregpc | J_1BDECREGPC | ||
| ph_biz_style | PH_BIZ_STYLE | ||
| paytrsn | FARP_PAYT_RSN | ||
| kna1_eew_cust | KNA1_EEW_CUST | ||
| rule_exclusion | CRMT_BUS_RULE_EXCLUSION | ||
| kna1_addr_eew_cust | KNA1_ADDR_EEW_CUST | ||
| data_ctrlr1 | BU_DATA_CONTROLLER | ||
| data_ctrlr2 | BU_DATA_CONTROLLER | ||
| data_ctrlr3 | BU_DATA_CONTROLLER | ||
| data_ctrlr4 | BU_DATA_CONTROLLER | ||
| data_ctrlr5 | BU_DATA_CONTROLLER | ||
| data_ctrlr6 | BU_DATA_CONTROLLER | ||
| data_ctrlr7 | BU_DATA_CONTROLLER | ||
| data_ctrlr8 | BU_DATA_CONTROLLER | ||
| data_ctrlr9 | BU_DATA_CONTROLLER | ||
| data_ctrlr10 | BU_DATA_CONTROLLER | ||
| xdcset | BU_XDCSET | ||
| alc | FMFG_ALC | ||
| pmt_office | FMFG_PMT_OFF | ||
| fee_schedule | FM_FEE_SCHED | ||
| duns | FMCCRDUNS | ||
| duns4 | FMCCRDUNS4 | ||
| sam_ue_id | FMFG_UNIQUE_ENTITY_ID | ||
| sam_eft_ind | FMFG_EFT_IND | ||
| psofg | PSOFG | ||
| psois | PSOIS | ||
| pson1 | NAME1_GP | ||
| pson2 | NAME2_GP | ||
| pson3 | NAME3_GP | ||
| psovn | PSOVN | ||
| psotl | PSOTL | ||
| psohs | PSOHS | ||
| psost | PSOST | ||
| psoo1 | PSOO1 | ||
| psoo2 | PSOO1 | ||
| psoo3 | PSOO1 | ||
| psoo4 | PSOO1 | ||
| psoo5 | PSOO1 | ||
| j_1iexcd | J_1IEXCD | ||
| j_1iexrn | J_1IEXRN | ||
| j_1iexrg | J_1IEXRG | ||
| j_1iexdi | J_1IEXDI | ||
| j_1iexco | J_1IEXCO | ||
| j_1icstno | J_1ICSTNO | ||
| j_1ilstno | J_1ILSTNO | ||
| j_1ipanno | J_1IPANNO | ||
| j_1iexcicu | J_1IEXCICU | ||
| aedat | J_1IAEDAT_OBSOLETE | ||
| usnam | J_1IUSNAM_OBSOLETE | ||
| j_1isern | J_1ISERN | ||
| j_1ipanref | J_1IPANREF | ||
| gst_tds | J_1IGSTTDS | ||
| j_3getyp | J_3GETYP | ||
| j_3greftyp | J_3GREFTYP | ||
| pspnr | PS_POSNR | ||
| coaufnr | AUFNR | ||
| j_3gagext | J_3GAGEXT | ||
| j_3gagint | J_3GAGINT | ||
| j_3gagdumi | J_3GDEMPST | ||
| j_3gagstdi | J_3GAGSTDI | ||
| lgort | LGORT_D | ||
| kokrs | KOKRS | ||
| kostl | KOSTL | ||
| j_3gabglg | J_3GABGLG | ||
| j_3gabgvg | J_3GABGVG | ||
| j_3gabrart | J_3GABRART | ||
| j_3gstdmon | J_3GSTDMON | ||
| j_3gstdtag | J_3GSTDTAG | ||
| j_3gtagmon | J_3GTAGMON | ||
| j_3gzugtag | J_3GZUGTAG | ||
| j_3gmaschb | J_3GMASCHB | ||
| j_3gmeinsa | J_3GMEINSA | ||
| j_3gkeinsa | J_3GKEINSA | ||
| j_3gblsper | J_3GBLSPER | ||
| j_3gkleivo | J_3GKLEIVO | ||
| j_3gcalid | J_3GCALID | ||
| j_3gvmonat | J_3GVMONAT | ||
| j_3gabrken | J_3GABRKEN | ||
| j_3glabrech | J_3GLABRECH | ||
| j_3gaabrech | J_3GAABRECH | ||
| j_3gzutvhlg | J_3GZUTVHLG | ||
| j_3gnegmen | J_3GNEGMEN | ||
| j_3gfristlo | J_3GFRISTLO | ||
| j_3geminbe | J_3GEMINBE | ||
| j_3gfmgue | J_3GFMGUE | ||
| j_3gzuschue | J_3GZUSCHUE | ||
| j_3gschprs | J_3GSCHPRS | ||
| j_3ginvsta | J_3GINVSTA |