Replaced in S/4HANA
This table is replaced by BUT000

Customer master replaced by Business Partner (BUT000). KNA1 exists as compatibility view. Use BP transaction instead of XD01.

View all S/4HANA migration mappings →

KNA1

Transparent Table Application Table
252 Fields 77 CDS Views

General Data in Customer Master

KNA1 is an SAP database table in S/4HANA. General Data in Customer Master. It contains 252 fields. 77 CDS views read from this table.

CDS Views using this table (77)

ViewTypeJoinVDMDescription
/SAPCEM/SHSM_J_3GV_J3GBV1 view left_outer CDS view for search help J_3GV_J3GBV1
/SCMTMS/CV_BP_Common view left_outer Obsolete: Use CDS View /SCMTMS/VE_BPCMN
/SCMTMS/VE_BPCMN view_entity left_outer BOPF: Business Partner Common TM Data
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_entity 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_BusinessPartnerCustomerDEX view_entity from BASIC Data Extraction for BP Customer
I_Customer view from BASIC Customer
I_CustomerAddress view from COMPOSITE Customer
I_CustomerDataControllerUsage view_entity inner BASIC Customer DataController Usage
I_CustSuplrDataControllerusge view_entity inner BASIC Customer and Supplier Datacntrlr Usge
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_CustNameCombinedSDMSts view_entity from COMPOSITE
P_CustomerOrder view inner BASIC
P_CustSuplrNameCombinedSDMSts view_entity from 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)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY kunnr KUNNR Customer
land1 LAND1_GP Country/Region Key
name1 NAME1_GP Name
name2 NAME2_GP Name 2
ort01 ORT01_GP City
pstlz PSTLZ Postal Code
regio REGIO Region
sortl SORTL Search term
stras STRAS_GP Street
telf1 TELF1 Telephone 1
telfx TELFX Fax Number
xcpdk XCPDK One-time acct
adrnr ADRNR Address
mcod1 MCDD1 Name
mcod2 MCDD2 Name 2
mcod3 MCDD3 City
anred ANRED Title
aufsd AUFSD_X Order block
bahne BAHNE Express station
bahns BAHNS Train station
bbbnr BBBNR Location no. 1
bbsnr BBSNR Location no. 2
begru BRGRU Authorization
brsch BRSCH Industry
bubkz BUBKZ Check digit
datlt DATLT Data line
erdat ERDAT_RF Created On
ernam ERNAM_RF Created by
exabl EXABL Unloading pts
faksd FAKSD_X Billing block
fiskn FISKN_D Fiscal address
knazk KNAZK Working times
knrza KNRZA Alternat. Payer
konzs KONZS Group
ktokd KTOKD Account group
kukla KUKLA Customer Class.
lifnr LIFNR Supplier
lifsd LIFSD_X Delivery block
locco LOCCO Location code
loevm LOEVM_X Deletion Flag
name3 NAME3_GP Name 3
name4 NAME4_GP Name 4
niels NIELS Nielsen ID
ort02 ORT02_GP District
pfach PFACH PO Box
pstl2 PSTL2 PO Box PCode
counc COUNC County Code
cityc CITYC City Code
rpmkr RPMKR Regional market
sperr SPERB_X Posting Block
spras SPRAS Language
stcd1 STCD1 Tax Number 1
stcd2 STCD2 Tax Number 2
stkza STKZA Equalizatn tax
stkzu STKZU Liable for VAT
telbx TELBX Telebox
telf2 TELF2 Telephone 2
teltx TELTX Teletex
telx1 TELX1 Telex
lzone LZONE Transport Zone
xzemp XREGU Al.payer in doc
vbund RASSC Trading Partner
stceg STCEG VAT Reg. No.
dear1 DEAR1 Competitors
dear2 DEAR2 Sales partner
dear3 DEAR3 Prospect
dear4 DEAR4 Cust.type 4
dear5 DEAR5 Default SP
gform GFORM Legal status
bran1 BRAN1_D Industry code 1
bran2 BRAN2 Industry code 2
bran3 BRAN3 Industry code 3
bran4 BRAN4 Industry code 4
bran5 BRAN5 Industry code 5
ekont EKONT Initial contact
umsat UMSAT Annual sales
umjah UMJAH Sales year
uwaer UWAER Currency
jmzah JMZAH Employee
jmjah JMJAH Year
katr1 KATR1 Attribute 1
katr2 KATR2 Attribute 2
katr3 KATR3 Attribute 3
katr4 KATR4 Attribute 4
katr5 KATR5 Attribute 5
katr6 KATR6 Attribute 6
katr7 KATR7 Attribute 7
katr8 KATR8 Attribute 8
katr9 KATR9 Attribute 9
katr10 KATR10 Attribute 10
stkzn STKZN Natural person
umsa1 UMSA1 Annual sales
txjcd TXJCD Tax Jur.
periv PERIV FY Variant
abrvw ABRVW Usage
inspbydebi QINSPBYDEB By customer
inspatdebi QINSPATDEB After delivery
ktocd KTOCD Ref.acct group
pfort PFORT_GP P.O.Box city
werks WERKS_D Plant
dtams DTAMS DME Rec. Code
dtaws DTAWS Instruction Key
duefl DUEFL_BKPF Data Transfer Status
hzuor HZUOR Hier.assignment
sperz SPERZ Payment block
etikg ETIKG Lab.cust. group
civve CIVVE Non-milit. use
milve MILVE Military use
kdkg1 KDKG1 Condition grp 1
kdkg2 KDKG2 Condition grp 2
kdkg3 KDKG3 Condition grp 3
kdkg4 KDKG4 Condition grp 4
kdkg5 KDKG5 Condition grp 5
xknza XKNZA Alt.payer(doc.)
fityp J_1AFITP_D Tax Type
stcdt J_1ATOID Tax number type
stcd3 STCD3 Tax Number 3
stcd4 STCD4 Tax Number 4
stcd5 STCD5 Tax Number 5
stcd6 STCD6 Tax Number 6
xicms J_1BTCICMS ICMS-exempt
xxipi J_1BTCIPI IPI-exempt
xsubt J_1BTCST SubTrib group
cfopc J_1BINDUS1 CFOP Category
txlw1 J_1BTAXLW1 ICMS Law
txlw2 J_1BTAXLW2 IPI Law
ccc01 CCC01 Biochem.warfare
ccc02 CCC02 Nucl.nonprolif.
ccc03 CCC03 Natl.security
ccc04 CCC04 Missile techn.
bonded_area_confirm TWVAT_BONDED_AREA_CONF BondedAreaConf.
donate_mark TWVAT_DONATE_MARK Donation Mark
consolidate_invoice TWGUI_CONSOLIDATE_INVOICE Consolidated Invoic.
allowance_type TWVAT_ALLOWANCE_TYPE Allowance Type
einvoice_mode TWVAT_EINVOICE_MODE Mode
b2c_indicator TWVAT_B2C_INDICATOR B2C Invoicing
cassd CASSD_X Sales block
knurl URL URL
j_1kfrepre REPRES Rep's Name
j_1kftbus GESTYP Type of Business
j_1kftind INDTYP Type of Industry
confs CONFS_X Confirm.status
updat UPDAT_RF Confirm.date
uptim UPTIM_RF Confirm.time
nodel NODEL_X Deletion block
dear6 DEAR6 Consumer
delivery_date_rule SD_DELIVERY_DATE_TYPE_RULE Deliv Date Rule
cvp_xblck CVP_XBLCK Purpose Completed
suframa J_1BSUFRAMA Suframa Code
rg J_1BRG RG Number
exp J_1BEXP Issued by
uf J_1BUF State
rgdate J_1BRGDATE RG Issuing Date
ric J_1BRIC RIC Number
rne J_1BRNE Foreign National Reg
rnedate J_1BRNEDATE RNE Issuing Date
cnae J_1BCNAE CNAE
legalnat J_1BLEGALNAT Legal Nature
crtn J_1BCRTN CRT Number
icmstaxpay J_1BICMSTAXPAY ICMS Taxpayer
indtyp J_1BINDTYP Industry Main Type
tdt J_1BTDT Tax Declaration Type
comsize J_1BCOMSIZE Company Size
decregpc J_1BDECREGPC Decl. Reg. PIS/COFI
ph_biz_style PH_BIZ_STYLE PH Business Style
paytrsn FARP_PAYT_RSN Payment Reason
kna1_eew_cust KNA1_EEW_CUST data element for customer
rule_exclusion CRMT_BUS_RULE_EXCLUSION Account Excluded
kna1_addr_eew_cust KNA1_ADDR_EEW_CUST Customer General addr. dep. extensibility
data_ctrlr1 BU_DATA_CONTROLLER Data Controller
data_ctrlr2 BU_DATA_CONTROLLER Data Controller
data_ctrlr3 BU_DATA_CONTROLLER Data Controller
data_ctrlr4 BU_DATA_CONTROLLER Data Controller
data_ctrlr5 BU_DATA_CONTROLLER Data Controller
data_ctrlr6 BU_DATA_CONTROLLER Data Controller
data_ctrlr7 BU_DATA_CONTROLLER Data Controller
data_ctrlr8 BU_DATA_CONTROLLER Data Controller
data_ctrlr9 BU_DATA_CONTROLLER Data Controller
data_ctrlr10 BU_DATA_CONTROLLER Data Controller
xdcset BU_XDCSET Data Ctrlr. Set
alc FMFG_ALC Agency Loc Cd
pmt_office FMFG_PMT_OFF Payment Office
fee_schedule FM_FEE_SCHED Fee Schedule
duns FMCCRDUNS DUNS Number
duns4 FMCCRDUNS4 DUNS+4
sam_ue_id FMFG_UNIQUE_ENTITY_ID SAM UE Identifier
sam_eft_ind FMFG_EFT_IND SAM EFT Indicator
psofg PSOFG Processor group
psois PSOIS SLAPrepr.Proced
pson1 NAME1_GP Name
pson2 NAME2_GP Name 2
pson3 NAME3_GP Name 3
psovn PSOVN First Name
psotl PSOTL Title
psohs PSOHS House number
psost PSOST Street
psoo1 PSOO1 Description
psoo2 PSOO1 Description
psoo3 PSOO1 Description
psoo4 PSOO1 Description
psoo5 PSOO1 Description
j_1iexcd J_1IEXCD ECC No.
j_1iexrn J_1IEXRN Excise Reg. No.
j_1iexrg J_1IEXRG Excise Range
j_1iexdi J_1IEXDI Excise Division
j_1iexco J_1IEXCO Commissionerate
j_1icstno J_1ICSTNO CST no.
j_1ilstno J_1ILSTNO LST no.
j_1ipanno J_1IPANNO PAN
j_1iexcicu J_1IEXCICU Exc.Ind.Cust.
aedat J_1IAEDAT_OBSOLETE Obsolete
usnam J_1IUSNAM_OBSOLETE Obsolete
j_1isern J_1ISERN Service Tax Regn.No.
j_1ipanref J_1IPANREF PAN Reference
gst_tds J_1IGSTTDS TDS Registration
j_3getyp J_3GETYP Recipient type
j_3greftyp J_3GREFTYP Reference type
pspnr PS_POSNR WBS Element
coaufnr AUFNR Order
j_3gagext J_3GAGEXT Ext. sold-to party
j_3gagint J_3GAGINT Cust.int.settl.
j_3gagdumi J_3GDEMPST Dummy recipient
j_3gagstdi J_3GAGSTDI Std recipient
lgort LGORT_D Location
kokrs KOKRS CO Area
kostl KOSTL Cost Center
j_3gabglg J_3GABGLG RetireDate/PBE
j_3gabgvg J_3GABGVG RetireDate/TBE
j_3gabrart J_3GABRART Settl. type
j_3gstdmon J_3GSTDMON Hours per month
j_3gstdtag J_3GSTDTAG Hours/days
j_3gtagmon J_3GTAGMON Days/month
j_3gzugtag J_3GZUGTAG AcqDate/PBE
j_3gmaschb J_3GMASCHB PBE document
j_3gmeinsa J_3GMEINSA Mltpl. usg. per.
j_3gkeinsa J_3GKEINSA Short op.
j_3gblsper J_3GBLSPER BlckIndDocEntry
j_3gkleivo J_3GKLEIVO PBE as TBE
j_3gcalid J_3GCALID Calendar ID
j_3gvmonat J_3GVMONAT Complete month
j_3gabrken J_3GABRKEN Settlmnt ind.
j_3glabrech J_3GLABRECH Last settlement
j_3gaabrech J_3GAABRECH Current settl.
j_3gzutvhlg J_3GZUTVHLG With acq. date
j_3gnegmen J_3GNEGMEN NegQtyAllowed
j_3gfristlo J_3GFRISTLO DlineLogic
j_3geminbe J_3GEMINBE MinUsPrd-rsctd
j_3gfmgue J_3GFMGUE RelNotAllUnrUsg
j_3gzuschue J_3GZUSCHUE SrchrgeUnrstUse
j_3gschprs J_3GSCHPRS Shift price
j_3ginvsta J_3GINVSTA Inv. status CS

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- General Data in Customer Master
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE KNA1 (
    MANDT,                -- Client [MANDT]
    KUNNR,                -- Customer [KUNNR]
    LAND1,                -- Country/Region Key [LAND1_GP]
    NAME1,                -- Name [NAME1_GP]
    NAME2,                -- Name 2 [NAME2_GP]
    ORT01,                -- City [ORT01_GP]
    PSTLZ,                -- Postal Code [PSTLZ]
    REGIO,                -- Region [REGIO]
    SORTL,                -- Search term [SORTL]
    STRAS,                -- Street [STRAS_GP]
    TELF1,                -- Telephone 1 [TELF1]
    TELFX,                -- Fax Number [TELFX]
    XCPDK,                -- One-time acct [XCPDK]
    ADRNR,                -- Address [ADRNR]
    MCOD1,                -- Name [MCDD1]
    MCOD2,                -- Name 2 [MCDD2]
    MCOD3,                -- City [MCDD3]
    ANRED,                -- Title [ANRED]
    AUFSD,                -- Order block [AUFSD_X]
    BAHNE,                -- Express station [BAHNE]
    BAHNS,                -- Train station [BAHNS]
    BBBNR,                -- Location no. 1 [BBBNR]
    BBSNR,                -- Location no. 2 [BBSNR]
    BEGRU,                -- Authorization [BRGRU]
    BRSCH,                -- Industry [BRSCH]
    BUBKZ,                -- Check digit [BUBKZ]
    DATLT,                -- Data line [DATLT]
    ERDAT,                -- Created On [ERDAT_RF]
    ERNAM,                -- Created by [ERNAM_RF]
    EXABL,                -- Unloading pts [EXABL]
    FAKSD,                -- Billing block [FAKSD_X]
    FISKN,                -- Fiscal address [FISKN_D]
    KNAZK,                -- Working times [KNAZK]
    KNRZA,                -- Alternat. Payer [KNRZA]
    KONZS,                -- Group [KONZS]
    KTOKD,                -- Account group [KTOKD]
    KUKLA,                -- Customer Class. [KUKLA]
    LIFNR,                -- Supplier [LIFNR]
    LIFSD,                -- Delivery block [LIFSD_X]
    LOCCO,                -- Location code [LOCCO]
    LOEVM,                -- Deletion Flag [LOEVM_X]
    NAME3,                -- Name 3 [NAME3_GP]
    NAME4,                -- Name 4 [NAME4_GP]
    NIELS,                -- Nielsen ID [NIELS]
    ORT02,                -- District [ORT02_GP]
    PFACH,                -- PO Box [PFACH]
    PSTL2,                -- PO Box PCode [PSTL2]
    COUNC,                -- County Code [COUNC]
    CITYC,                -- City Code [CITYC]
    RPMKR,                -- Regional market [RPMKR]
    SPERR,                -- Posting Block [SPERB_X]
    SPRAS,                -- Language [SPRAS]
    STCD1,                -- Tax Number 1 [STCD1]
    STCD2,                -- Tax Number 2 [STCD2]
    STKZA,                -- Equalizatn tax [STKZA]
    STKZU,                -- Liable for VAT [STKZU]
    TELBX,                -- Telebox [TELBX]
    TELF2,                -- Telephone 2 [TELF2]
    TELTX,                -- Teletex [TELTX]
    TELX1,                -- Telex [TELX1]
    LZONE,                -- Transport Zone [LZONE]
    XZEMP,                -- Al.payer in doc [XREGU]
    VBUND,                -- Trading Partner [RASSC]
    STCEG,                -- VAT Reg. No. [STCEG]
    DEAR1,                -- Competitors [DEAR1]
    DEAR2,                -- Sales partner [DEAR2]
    DEAR3,                -- Prospect [DEAR3]
    DEAR4,                -- Cust.type 4 [DEAR4]
    DEAR5,                -- Default SP [DEAR5]
    GFORM,                -- Legal status [GFORM]
    BRAN1,                -- Industry code 1 [BRAN1_D]
    BRAN2,                -- Industry code 2 [BRAN2]
    BRAN3,                -- Industry code 3 [BRAN3]
    BRAN4,                -- Industry code 4 [BRAN4]
    BRAN5,                -- Industry code 5 [BRAN5]
    EKONT,                -- Initial contact [EKONT]
    UMSAT,                -- Annual sales [UMSAT]
    UMJAH,                -- Sales year [UMJAH]
    UWAER,                -- Currency [UWAER]
    JMZAH,                -- Employee [JMZAH]
    JMJAH,                -- Year [JMJAH]
    KATR1,                -- Attribute 1 [KATR1]
    KATR2,                -- Attribute 2 [KATR2]
    KATR3,                -- Attribute 3 [KATR3]
    KATR4,                -- Attribute 4 [KATR4]
    KATR5,                -- Attribute 5 [KATR5]
    KATR6,                -- Attribute 6 [KATR6]
    KATR7,                -- Attribute 7 [KATR7]
    KATR8,                -- Attribute 8 [KATR8]
    KATR9,                -- Attribute 9 [KATR9]
    KATR10,               -- Attribute 10 [KATR10]
    STKZN,                -- Natural person [STKZN]
    UMSA1,                -- Annual sales [UMSA1]
    TXJCD,                -- Tax Jur. [TXJCD]
    PERIV,                -- FY Variant [PERIV]
    ABRVW,                -- Usage [ABRVW]
    INSPBYDEBI,           -- By customer [QINSPBYDEB]
    INSPATDEBI,           -- After delivery [QINSPATDEB]
    KTOCD,                -- Ref.acct group [KTOCD]
    PFORT,                -- P.O.Box city [PFORT_GP]
    WERKS,                -- Plant [WERKS_D]
    DTAMS,                -- DME Rec. Code [DTAMS]
    DTAWS,                -- Instruction Key [DTAWS]
    DUEFL,                -- Data Transfer Status [DUEFL_BKPF]
    HZUOR,                -- Hier.assignment [HZUOR]
    SPERZ,                -- Payment block [SPERZ]
    ETIKG,                -- Lab.cust. group [ETIKG]
    CIVVE,                -- Non-milit. use [CIVVE]
    MILVE,                -- Military use [MILVE]
    KDKG1,                -- Condition grp 1 [KDKG1]
    KDKG2,                -- Condition grp 2 [KDKG2]
    KDKG3,                -- Condition grp 3 [KDKG3]
    KDKG4,                -- Condition grp 4 [KDKG4]
    KDKG5,                -- Condition grp 5 [KDKG5]
    XKNZA,                -- Alt.payer(doc.) [XKNZA]
    FITYP,                -- Tax Type [J_1AFITP_D]
    STCDT,                -- Tax number type [J_1ATOID]
    STCD3,                -- Tax Number 3 [STCD3]
    STCD4,                -- Tax Number 4 [STCD4]
    STCD5,                -- Tax Number 5 [STCD5]
    STCD6,                -- Tax Number 6 [STCD6]
    XICMS,                -- ICMS-exempt [J_1BTCICMS]
    XXIPI,                -- IPI-exempt [J_1BTCIPI]
    XSUBT,                -- SubTrib group [J_1BTCST]
    CFOPC,                -- CFOP Category [J_1BINDUS1]
    TXLW1,                -- ICMS Law [J_1BTAXLW1]
    TXLW2,                -- IPI Law [J_1BTAXLW2]
    CCC01,                -- Biochem.warfare [CCC01]
    CCC02,                -- Nucl.nonprolif. [CCC02]
    CCC03,                -- Natl.security [CCC03]
    CCC04,                -- Missile techn. [CCC04]
    BONDED_AREA_CONFIRM,  -- BondedAreaConf. [TWVAT_BONDED_AREA_CONF]
    DONATE_MARK,          -- Donation Mark [TWVAT_DONATE_MARK]
    CONSOLIDATE_INVOICE,  -- Consolidated Invoic. [TWGUI_CONSOLIDATE_INVOICE]
    ALLOWANCE_TYPE,       -- Allowance Type [TWVAT_ALLOWANCE_TYPE]
    EINVOICE_MODE,        -- Mode [TWVAT_EINVOICE_MODE]
    B2C_INDICATOR,        -- B2C Invoicing [TWVAT_B2C_INDICATOR]
    CASSD,                -- Sales block [CASSD_X]
    KNURL,                -- URL [URL]
    J_1KFREPRE,           -- Rep's Name [REPRES]
    J_1KFTBUS,            -- Type of Business [GESTYP]
    J_1KFTIND,            -- Type of Industry [INDTYP]
    CONFS,                -- Confirm.status [CONFS_X]
    UPDAT,                -- Confirm.date [UPDAT_RF]
    UPTIM,                -- Confirm.time [UPTIM_RF]
    NODEL,                -- Deletion block [NODEL_X]
    DEAR6,                -- Consumer [DEAR6]
    DELIVERY_DATE_RULE,   -- Deliv Date Rule [SD_DELIVERY_DATE_TYPE_RULE]
    CVP_XBLCK,            -- Purpose Completed [CVP_XBLCK]
    SUFRAMA,              -- Suframa Code [J_1BSUFRAMA]
    RG,                   -- RG Number [J_1BRG]
    EXP,                  -- Issued by [J_1BEXP]
    UF,                   -- State [J_1BUF]
    RGDATE,               -- RG Issuing Date [J_1BRGDATE]
    RIC,                  -- RIC Number [J_1BRIC]
    RNE,                  -- Foreign National Reg [J_1BRNE]
    RNEDATE,              -- RNE Issuing Date [J_1BRNEDATE]
    CNAE,                 -- CNAE [J_1BCNAE]
    LEGALNAT,             -- Legal Nature [J_1BLEGALNAT]
    CRTN,                 -- CRT Number [J_1BCRTN]
    ICMSTAXPAY,           -- ICMS Taxpayer [J_1BICMSTAXPAY]
    INDTYP,               -- Industry Main Type [J_1BINDTYP]
    TDT,                  -- Tax Declaration Type [J_1BTDT]
    COMSIZE,              -- Company Size [J_1BCOMSIZE]
    DECREGPC,             -- Decl. Reg. PIS/COFI [J_1BDECREGPC]
    PH_BIZ_STYLE,         -- PH Business Style [PH_BIZ_STYLE]
    PAYTRSN,              -- Payment Reason [FARP_PAYT_RSN]
    KNA1_EEW_CUST,        -- data element for customer [KNA1_EEW_CUST]
    RULE_EXCLUSION,       -- Account Excluded [CRMT_BUS_RULE_EXCLUSION]
    KNA1_ADDR_EEW_CUST,   -- Customer General addr. dep. extensibility [KNA1_ADDR_EEW_CUST]
    DATA_CTRLR1,          -- Data Controller [BU_DATA_CONTROLLER]
    DATA_CTRLR2,          -- Data Controller [BU_DATA_CONTROLLER]
    DATA_CTRLR3,          -- Data Controller [BU_DATA_CONTROLLER]
    DATA_CTRLR4,          -- Data Controller [BU_DATA_CONTROLLER]
    DATA_CTRLR5,          -- Data Controller [BU_DATA_CONTROLLER]
    DATA_CTRLR6,          -- Data Controller [BU_DATA_CONTROLLER]
    DATA_CTRLR7,          -- Data Controller [BU_DATA_CONTROLLER]
    DATA_CTRLR8,          -- Data Controller [BU_DATA_CONTROLLER]
    DATA_CTRLR9,          -- Data Controller [BU_DATA_CONTROLLER]
    DATA_CTRLR10,         -- Data Controller [BU_DATA_CONTROLLER]
    XDCSET,               -- Data Ctrlr. Set [BU_XDCSET]
    ALC,                  -- Agency Loc Cd [FMFG_ALC]
    PMT_OFFICE,           -- Payment Office [FMFG_PMT_OFF]
    FEE_SCHEDULE,         -- Fee Schedule [FM_FEE_SCHED]
    DUNS,                 -- DUNS Number [FMCCRDUNS]
    DUNS4,                -- DUNS+4 [FMCCRDUNS4]
    SAM_UE_ID,            -- SAM UE Identifier [FMFG_UNIQUE_ENTITY_ID]
    SAM_EFT_IND,          -- SAM EFT Indicator [FMFG_EFT_IND]
    PSOFG,                -- Processor group [PSOFG]
    PSOIS,                -- SLAPrepr.Proced [PSOIS]
    PSON1,                -- Name [NAME1_GP]
    PSON2,                -- Name 2 [NAME2_GP]
    PSON3,                -- Name 3 [NAME3_GP]
    PSOVN,                -- First Name [PSOVN]
    PSOTL,                -- Title [PSOTL]
    PSOHS,                -- House number [PSOHS]
    PSOST,                -- Street [PSOST]
    PSOO1,                -- Description [PSOO1]
    PSOO2,                -- Description [PSOO1]
    PSOO3,                -- Description [PSOO1]
    PSOO4,                -- Description [PSOO1]
    PSOO5,                -- Description [PSOO1]
    J_1IEXCD,             -- ECC No. [J_1IEXCD]
    J_1IEXRN,             -- Excise Reg. No. [J_1IEXRN]
    J_1IEXRG,             -- Excise Range [J_1IEXRG]
    J_1IEXDI,             -- Excise Division [J_1IEXDI]
    J_1IEXCO,             -- Commissionerate [J_1IEXCO]
    J_1ICSTNO,            -- CST no. [J_1ICSTNO]
    J_1ILSTNO,            -- LST no. [J_1ILSTNO]
    J_1IPANNO,            -- PAN [J_1IPANNO]
    J_1IEXCICU,           -- Exc.Ind.Cust. [J_1IEXCICU]
    AEDAT,                -- Obsolete [J_1IAEDAT_OBSOLETE]
    USNAM,                -- Obsolete [J_1IUSNAM_OBSOLETE]
    J_1ISERN,             -- Service Tax Regn.No. [J_1ISERN]
    J_1IPANREF,           -- PAN Reference [J_1IPANREF]
    GST_TDS,              -- TDS Registration [J_1IGSTTDS]
    J_3GETYP,             -- Recipient type [J_3GETYP]
    J_3GREFTYP,           -- Reference type [J_3GREFTYP]
    PSPNR,                -- WBS Element [PS_POSNR]
    COAUFNR,              -- Order [AUFNR]
    J_3GAGEXT,            -- Ext. sold-to party [J_3GAGEXT]
    J_3GAGINT,            -- Cust.int.settl. [J_3GAGINT]
    J_3GAGDUMI,           -- Dummy recipient [J_3GDEMPST]
    J_3GAGSTDI,           -- Std recipient [J_3GAGSTDI]
    LGORT,                -- Location [LGORT_D]
    KOKRS,                -- CO Area [KOKRS]
    KOSTL,                -- Cost Center [KOSTL]
    J_3GABGLG,            -- RetireDate/PBE [J_3GABGLG]
    J_3GABGVG,            -- RetireDate/TBE [J_3GABGVG]
    J_3GABRART,           -- Settl. type [J_3GABRART]
    J_3GSTDMON,           -- Hours per month [J_3GSTDMON]
    J_3GSTDTAG,           -- Hours/days [J_3GSTDTAG]
    J_3GTAGMON,           -- Days/month [J_3GTAGMON]
    J_3GZUGTAG,           -- AcqDate/PBE [J_3GZUGTAG]
    J_3GMASCHB,           -- PBE document [J_3GMASCHB]
    J_3GMEINSA,           -- Mltpl. usg. per. [J_3GMEINSA]
    J_3GKEINSA,           -- Short op. [J_3GKEINSA]
    J_3GBLSPER,           -- BlckIndDocEntry [J_3GBLSPER]
    J_3GKLEIVO,           -- PBE as TBE [J_3GKLEIVO]
    J_3GCALID,            -- Calendar ID [J_3GCALID]
    J_3GVMONAT,           -- Complete month [J_3GVMONAT]
    J_3GABRKEN,           -- Settlmnt ind. [J_3GABRKEN]
    J_3GLABRECH,          -- Last settlement [J_3GLABRECH]
    J_3GAABRECH,          -- Current settl. [J_3GAABRECH]
    J_3GZUTVHLG,          -- With acq. date [J_3GZUTVHLG]
    J_3GNEGMEN,           -- NegQtyAllowed [J_3GNEGMEN]
    J_3GFRISTLO,          -- DlineLogic [J_3GFRISTLO]
    J_3GEMINBE,           -- MinUsPrd-rsctd [J_3GEMINBE]
    J_3GFMGUE,            -- RelNotAllUnrUsg [J_3GFMGUE]
    J_3GZUSCHUE,          -- SrchrgeUnrstUse [J_3GZUSCHUE]
    J_3GSCHPRS,           -- Shift price [J_3GSCHPRS]
    J_3GINVSTA,           -- Inv. status CS [J_3GINVSTA]
    PRIMARY KEY (MANDT, KUNNR)
);

Learn More