What is VC_INTEGRATION_KNA1 in SAP S/4HANA?

VC_INTEGRATION_KNA1 is a cds CDS view in SAP S/4HANA. Extraction for KNA1 It contains 191 fields.

Which tables does VC_INTEGRATION_KNA1 read from?

VC_INTEGRATION_KNA1 reads data from: kna1.

VC_INTEGRATION_KNA1

DDL: VC_INTEGRATION_KNA1 SQL: VCIKNA1 Type: view

191 Fields 1 Data Sources

Extraction for KNA1

VC_INTEGRATION_KNA1 is a CDS View that provides data about "Extraction for KNA1" in SAP S/4HANA. It reads from 1 data source (kna1) and exposes 191 fields with key field KUNNR.

Data Sources (1)

Source	Alias	Join Type
kna1	kna1	from

Annotations (12)

Name	Value	Level
AbapCatalog.sqlViewName	VCIKNA1	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.preserveKey	true	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
AccessControl.authorizationCheck	#NOT_REQUIRED	view
AccessControl.personalData.blocking	#REQUIRED	view
ObjectModel.usageType.sizeCategory	#L	view
ObjectModel.usageType.serviceQuality	#A	view
ObjectModel.usageType.dataClass	#MASTER	view
Analytics.dataExtraction.enabled	true	view
Analytics.dataExtraction.delta.changeDataCapture.automatic	true	view
EndUserText.label	Extraction for KNA1	view

Fields (191)

Key	Field	Source Field	Description
KEY	KUNNR	kunnr	Stock customer
	LAND1	land1	Trip Ctry/Reg
	REGIO	regio	Resident Region
	SORTL	sortl	Sort Term
	XCPDK	xcpdk	One-time acct
	ANRED	anred	Title
	AUFSD	aufsd	Order block
	BAHNE	bahne	Express station
	BAHNS	bahns	Train station
	BBBNR	bbbnr	Location no. 1
	BBSNR	bbsnr	Location no. 2
	BEGRU	begru	AuthorizGroup
	BRSCH	brsch	Industry
	BUBKZ	bubkz	Check digit
	DATLT	datlt	Data line
	ERDAT	erdat	Entered On
	EXABL	exabl	Unloading pts
	FAKSD	faksd	Billing block
	KNAZK	knazk	Working times
	KONZS	konzs	Group
	KTOKD	ktokd	DefCusAcctGr
	KUKLA	kukla	Customer Class.
	LIFSD	lifsd	Delivery block
	LOCCO	locco	Location code
	LOEVM	loevm	End Contract
	NIELS	niels	Nielsen ID
	COUNC	counc	County Code
	CITYC	cityc	City Code
	RPMKR	rpmkr	Regional market
	SPERR	sperr	Posting Block
	SPRAS	spras	Off. Language
	STKZA	stkza	Equalizatn tax
	STKZU	stkzu	Liable for VAT
	TELBX	telbx	Telebox
	TELF2	telf2	Telephone 2
	TELTX	teltx	Teletex
	TELX1	telx1	Telex
	LZONE	lzone	Zone
	XZEMP	xzemp	Payee in doc.
	VBUND	vbund	Trading Partner
	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	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
	PERIV	periv	FYear Variant
	ABRVW	abrvw	Usage
	INSPBYDEBI	inspbydebi	By customer
	INSPATDEBI	inspatdebi	After delivery
	KTOCD	ktocd	Ref.acct group
	PFORT	pfort	P.O.Box city
	WERKS	werks	Receiving Plant
	DTAMS	dtams	DME Rec. Code
	DTAWS	dtaws	Instruction Key
	DUEFL	duefl	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	fityp	Tax Type
	STCDT	stcdt	Tax number type
	STCD3	stcd3	Tax Number 3
	STCD4	stcd4	Tax Number 4
	STCD5	stcd5	Tax Number 5
	XICMS	xicms	ICMS-exempt
	XXIPI	xxipi	IPI-exempt
	XSUBT	xsubt	SubTrib group
	CFOPC	cfopc	CFOP Category
	TXLW1	txlw1	ICMS Law
	TXLW2	txlw2	IPI Law
	CCC01	ccc01	Biochem.warfare
	CCC02	ccc02	Nucl.nonprolif.
	CCC03	ccc03	Natl.security
	CCC04	ccc04	Missile techn.
	BONDED_AREA_CONFIRM	bonded_area_confirm	BondedAreaConf.
	DONATE_MARK	donate_mark	Donation Mark
	CASSD	cassd	Sales block
	J_1KFTBUS	j_1kftbus	Type of Business
	J_1KFTIND	j_1kftind	Type of Industry
	CONFS	confs	Enter
	UPDAT	updat	Confirm.date
	UPTIM	uptim	Confirm.time
	NODEL	nodel	Deletion block
	DEAR6	dear6	Consumer
	CVP_XBLCK	cvp_xblck	Purpose Completed
	SUFRAMA	suframa	Suframa Code
	RG	rg	RG Number
	EXP	exp	Issued by
	UF	uf	State
	RGDATE	rgdate	RG Issuing Date
	RIC	ric	RIC Number
	RNE	rne	Foreign National Reg
	RNEDATE	rnedate	RNE Issuing Date
	CNAE	cnae	CNAE
	LEGALNAT	legalnat	Legal Nature
	CRTN	crtn	CRT Number
	ICMSTAXPAY	icmstaxpay	ICMS Taxpayer
	INDTYP	indtyp	Type of Industry
	TDT	tdt	Tax Declaration Type
	COMSIZE	comsize	Company Size
	DECREGPC	decregpc	Decl. Reg. PIS/COFI
	KNA1_EEW_CUST	kna1_eew_cust	data element for customer
	RULE_EXCLUSION	rule_exclusion	Account Excluded
	/VSO/R_PALHGT	/vso/r_palhgt
	/VSO/R_PAL_UL	/vso/r_pal_ul
	/VSO/R_PK_MAT	/vso/r_pk_mat
	/VSO/R_MATPAL	/vso/r_matpal
	/VSO/R_I_NO_LYR	/vso/r_i_no_lyr
	/VSO/R_ONE_MAT	/vso/r_one_mat
	/VSO/R_ONE_SORT	/vso/r_one_sort
	/VSO/R_ULD_SIDE	/vso/r_uld_side
	/VSO/R_LOAD_PREF	/vso/r_load_pref
	/VSO/R_DPOINT	/vso/r_dpoint
	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	Obsolete
	USNAM	usnam	User Name
	J_1ISERN	j_1isern	Service Tax Regn.No.
	J_1IPANREF	j_1ipanref	PAN Reference
	J_3GETYP	j_3getyp	Recipient type
	J_3GREFTYP	j_3greftyp	Reference type
	PSPNR	pspnr	WBS Element
	COAUFNR	coaufnr	QM Order
	LGORT	lgort	Sublocation
	KOKRS	kokrs	Org. Value
	KOSTL	kostl	Substitute CC
	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
	/SAPCEM/DBER	/sapcem/dber
	/SAPCEM/KVMEQ	/sapcem/kvmeq

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view VC_INTEGRATION_KNA1.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: VCIKNA1

CREATE VIEW VC_INTEGRATION_KNA1 AS
SELECT
  KUNNR,
  LAND1,
  REGIO,
  SORTL,
  XCPDK,
  ANRED,
  AUFSD,
  BAHNE,
  BAHNS,
  BBBNR,
  BBSNR,
  BEGRU,
  BRSCH,
  BUBKZ,
  DATLT,
  ERDAT,
  EXABL,
  FAKSD,
  KNAZK,
  KONZS,
  KTOKD,
  KUKLA,
  LIFSD,
  LOCCO,
  LOEVM,
  NIELS,
  COUNC,
  CITYC,
  RPMKR,
  SPERR,
  SPRAS,
  STKZA,
  STKZU,
  TELBX,
  TELF2,
  TELTX,
  TELX1,
  LZONE,
  XZEMP,
  VBUND,
  DEAR1,
  DEAR2,
  DEAR3,
  DEAR4,
  DEAR5,
  GFORM,
  BRAN1,
  BRAN2,
  BRAN3,
  BRAN4,
  BRAN5,
  EKONT,
  UMSAT,
  UMJAH,
  UWAER,
  JMZAH,
  JMJAH,
  KATR1,
  KATR2,
  KATR3,
  KATR4,
  KATR5,
  KATR6,
  KATR7,
  KATR8,
  KATR9,
  KATR10,
  STKZN,
  UMSA1,
  PERIV,
  ABRVW,
  INSPBYDEBI,
  INSPATDEBI,
  KTOCD,
  PFORT,
  WERKS,
  DTAMS,
  DTAWS,
  DUEFL,
  HZUOR,
  SPERZ,
  ETIKG,
  CIVVE,
  MILVE,
  KDKG1,
  KDKG2,
  KDKG3,
  KDKG4,
  KDKG5,
  XKNZA,
  FITYP,
  STCDT,
  STCD3,
  STCD4,
  STCD5,
  XICMS,
  XXIPI,
  XSUBT,
  CFOPC,
  TXLW1,
  TXLW2,
  CCC01,
  CCC02,
  CCC03,
  CCC04,
  BONDED_AREA_CONFIRM,
  DONATE_MARK,
  CASSD,
  J_1KFTBUS,
  J_1KFTIND,
  CONFS,
  UPDAT,
  UPTIM,
  NODEL,
  DEAR6,
  CVP_XBLCK,
  SUFRAMA,
  RG,
  EXP,
  UF,
  RGDATE,
  RIC,
  RNE,
  RNEDATE,
  CNAE,
  LEGALNAT,
  CRTN,
  ICMSTAXPAY,
  INDTYP,
  TDT,
  COMSIZE,
  DECREGPC,
  KNA1_EEW_CUST,
  RULE_EXCLUSION,
  /VSO/R_PALHGT,
  /VSO/R_PAL_UL,
  /VSO/R_PK_MAT,
  /VSO/R_MATPAL,
  /VSO/R_I_NO_LYR,
  /VSO/R_ONE_MAT,
  /VSO/R_ONE_SORT,
  /VSO/R_ULD_SIDE,
  /VSO/R_LOAD_PREF,
  /VSO/R_DPOINT,
  J_1IEXCD,
  J_1IEXRN,
  J_1IEXRG,
  J_1IEXDI,
  J_1IEXCO,
  J_1ICSTNO,
  J_1ILSTNO,
  J_1IPANNO,
  J_1IEXCICU,
  AEDAT,
  USNAM,
  J_1ISERN,
  J_1IPANREF,
  J_3GETYP,
  J_3GREFTYP,
  PSPNR,
  COAUFNR,
  LGORT,
  KOKRS,
  KOSTL,
  J_3GABGLG,
  J_3GABGVG,
  J_3GABRART,
  J_3GSTDMON,
  J_3GSTDTAG,
  J_3GTAGMON,
  J_3GZUGTAG,
  J_3GMASCHB,
  J_3GMEINSA,
  J_3GKEINSA,
  J_3GBLSPER,
  J_3GKLEIVO,
  J_3GCALID,
  J_3GVMONAT,
  J_3GABRKEN,
  J_3GLABRECH,
  J_3GAABRECH,
  J_3GZUTVHLG,
  J_3GNEGMEN,
  J_3GFRISTLO,
  J_3GEMINBE,
  J_3GFMGUE,
  J_3GZUSCHUE,
  J_3GSCHPRS,
  J_3GINVSTA,
  /SAPCEM/DBER,
  /SAPCEM/KVMEQ
FROM kna1
;

Depth:

VC_INTEGRATION_KNA1 view

kna1