KNA1_PRC

Transparent Table Application Table
204 Fields 2 CDS Views

Master Data Consolidation: Process Table for KNA1

KNA1_PRC is an SAP database table in S/4HANA. Master Data Consolidation: Process Table for KNA1. It contains 204 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_BPCustomerProcess view_entity from EXTENSION Extensibility for KNA1 PRC - Extension
I_BPCustomerProcess view_entity from BASIC Business Partner Customer Process Data

Fields (204)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY process_id MDC_PROCESS_ID Process ID
KEY process_step_no MDC_PROCESS_STEP_NO Step Number
KEY source_system MDC_BUSINESS_SYSTEM Source System
KEY source_id MDC_SOURCE_ID Source ID
KEY assignment_id MDG_BP_ASSIGNMENT_ID Assignment ID
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
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
source_recency MDC_RECENCY Last Changed On
source_modified MDC_SOURCE_MODIFIED Modified
source_modification_blip MDC_MODIFICATION_BLIP Modification
source_index MDC_SOURCE_INDEX Index
target_assignment_id MDG_BP_ASSIGNMENT_ID Assignment ID
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 AEDAT Changed On
usnam J_1IUSNAMC Changed By
j_1isern J_1ISERN Service Tax Regn.No.
j_1ipanref J_1IPANREF PAN Reference
gst_tds J_1IGSTTDS TDS Registration

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.

-- Master Data Consolidation: Process Table for KNA1
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE KNA1_PRC (
    MANDT,                     -- Client [MANDT]
    PROCESS_ID,                -- Process ID [MDC_PROCESS_ID]
    PROCESS_STEP_NO,           -- Step Number [MDC_PROCESS_STEP_NO]
    SOURCE_SYSTEM,             -- Source System [MDC_BUSINESS_SYSTEM]
    SOURCE_ID,                 -- Source ID [MDC_SOURCE_ID]
    ASSIGNMENT_ID,             -- Assignment ID [MDG_BP_ASSIGNMENT_ID]
    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]
    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]
    SOURCE_RECENCY,            -- Last Changed On [MDC_RECENCY]
    SOURCE_MODIFIED,           -- Modified [MDC_SOURCE_MODIFIED]
    SOURCE_MODIFICATION_BLIP,  -- Modification [MDC_MODIFICATION_BLIP]
    SOURCE_INDEX,              -- Index [MDC_SOURCE_INDEX]
    TARGET_ASSIGNMENT_ID,      -- Assignment ID [MDG_BP_ASSIGNMENT_ID]
    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,                     -- Changed On [AEDAT]
    USNAM,                     -- Changed By [J_1IUSNAMC]
    J_1ISERN,                  -- Service Tax Regn.No. [J_1ISERN]
    J_1IPANREF,                -- PAN Reference [J_1IPANREF]
    GST_TDS,                   -- TDS Registration [J_1IGSTTDS]
    PRIMARY KEY (MANDT, PROCESS_ID, PROCESS_STEP_NO, SOURCE_SYSTEM, SOURCE_ID, ASSIGNMENT_ID)
);

Learn More