VC_INTEGRATION_T001

DDL: VC_INTEGRATION_T001 SQL: VCIT001 Type: view Package: IPS_DATA_REPLICATION
79 Fields 1 Data Sources

Extraction for T001

VC_INTEGRATION_T001 is a CDS View that provides data about "Extraction for T001" in SAP S/4HANA. It reads from 1 data source (t001) and exposes 79 fields with key field BUKRS. Part of development package IPS_DATA_REPLICATION.

Data Sources (1)

SourceAliasJoin Type
t001 t001 from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName VCIT001 view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Analytics.dataExtraction.enabled true view
Analytics.dataExtraction.delta.changeDataCapture.automatic true view
EndUserText.label Extraction for T001 view

Fields (79)

KeyFieldSource TableSource FieldDescription
KEY BUKRS bukrs Value
BUTXT butxt Posting Text
ORT01 ort01 Province
LAND1 land1 Trip Ctry/Reg
WAERS waers Transaction Currency
SPRAS spras Off. Language
KTOPL ktopl G/L Chart of Accounts
WAABW waabw Max.exch.rate dev.
PERIV periv FYear Variant
KOKFI kokfi CoCd->CO Area
RCOMP rcomp Trading Partner
ADRNR adrnr Sold-To Address
STCEG stceg VAT Reg. No.
FIKRS fikrs FM Area
XFMCO xfmco Project CM active
XFMCB xfmcb CBM Active
XFMCA xfmca Update FM
TXJCD txjcd Tax Jurisdict.
FMHRDATE fmhrdate FundsCtr in HR
XTEMPLT xtemplt Template
BUVAR buvar Screen Variant
FDBUK fdbuk Cash Mgmnt Comp.Code
XFDIS xfdis CM Payt Advice
XVALV xvalv Propose Value Date
XSKFN xskfn Net Discount Base
KKBER kkber Cred.Contr.Area
XMWSN xmwsn Net Tax Base
MREGL mregl Sample Acct Rules
XGSBE xgsbe Business Area FS
XGJRV xgjrv Propose Fiscal Year
XKDFT xkdft Post Translation
XPROD xprod Productive
XEINK xeink Purchase Acct
XJVAA xjvaa JVA Active
XVVWA xvvwa Fin.Asset.Man.Active
XSLTA xslta No Exch. Rate Diff. When Clearing in LC
XFDMM xfdmm Update MM in CMF
XFDSD xfdsd Update SD in CMF
XEXTB xextb External CoCode
EBUKR ebukr Original Key
KTOP2 ktop2 Alternative COA
UMKRS umkrs Tax Group
BUKRS_GLOB bukrs_glob Global CoCde
FSTVA fstva Fld stat.var.
OPVAR opvar Pstg Per.Var.
XCOVR xcovr HedgeReq.active
TXKRS txkrs Tx Crcy Transl.
WFVAR wfvar Workflow Var.
XBBBF xbbbf Inventory mgmt
XBBBE xbbbe PO/sched. agmt.
XBBBA xbbba Requisition
XBBKO xbbko Contract
XSTDT xstdt Tax Determ.with Doc.Date
MWSKV mwskv Input Tax Code
MWSKA mwska Output Tax Code
IMPDA impda Imp. Data in PO
XNEGP xnegp Reversl Posting Type
XKKBI xkkbi Enter Control Area
WT_NEWWT wt_newwt Extended WTax Active
PP_PDATE pp_pdate Parking Pst. Date
INFMT infmt Method
FSTVARE fstvare FldStatusVar.
KOPIM kopim Copying ctrl GR
DKWEG dkweg Import data GR
OFFSACCT offsacct Offsetting Acct
BAPOVAR bapovar BA variant
XCOS xcos COS Status
XCESSION xcession Accts Recble Pledg.
XSPLT xsplt Installment Pmt
SURCCM surccm Surcharges
DTPROV dtprov Doc. Type
DTAMTC dtamtc Doc. Type
DTTAXC dttaxc Document Type
DTTDSP dttdsp RC Doc. Type
DTAXR dtaxr Def. Tax Rule
XVATDATE xvatdate Tax Date
PST_PER_VAR pst_per_var Manage Postg Period
XBBSC xbbsc Shopping Cart
F_OBSOLETE f_obsolete Hide Entry

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_T001.
-- 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: VCIT001

CREATE VIEW VC_INTEGRATION_T001 AS
SELECT
  BUKRS,
  BUTXT,
  ORT01,
  LAND1,
  WAERS,
  SPRAS,
  KTOPL,
  WAABW,
  PERIV,
  KOKFI,
  RCOMP,
  ADRNR,
  STCEG,
  FIKRS,
  XFMCO,
  XFMCB,
  XFMCA,
  TXJCD,
  FMHRDATE,
  XTEMPLT,
  BUVAR,
  FDBUK,
  XFDIS,
  XVALV,
  XSKFN,
  KKBER,
  XMWSN,
  MREGL,
  XGSBE,
  XGJRV,
  XKDFT,
  XPROD,
  XEINK,
  XJVAA,
  XVVWA,
  XSLTA,
  XFDMM,
  XFDSD,
  XEXTB,
  EBUKR,
  KTOP2,
  UMKRS,
  BUKRS_GLOB,
  FSTVA,
  OPVAR,
  XCOVR,
  TXKRS,
  WFVAR,
  XBBBF,
  XBBBE,
  XBBBA,
  XBBKO,
  XSTDT,
  MWSKV,
  MWSKA,
  IMPDA,
  XNEGP,
  XKKBI,
  WT_NEWWT,
  PP_PDATE,
  INFMT,
  FSTVARE,
  KOPIM,
  DKWEG,
  OFFSACCT,
  BAPOVAR,
  XCOS,
  XCESSION,
  XSPLT,
  SURCCM,
  DTPROV,
  DTAMTC,
  DTTAXC,
  DTTDSP,
  DTAXR,
  XVATDATE,
  PST_PER_VAR,
  XBBSC,
  F_OBSOLETE
FROM t001
;

Learn More