SHSM_MMIV_TAX_CODE_TAB_ACT

DDL: SHSM_MMIV_TAX_CODE_TAB_ACT SQL: SHSMMIVMWSKZTABA Type: view

SHSM_MMIV_TAX_CODE ajusted for TRIT

SHSM_MMIV_TAX_CODE_TAB_ACT is a CDS View that provides data about "SHSM_MMIV_TAX_CODE ajusted for TRIT" in SAP S/4HANA. It reads from 5 data sources (SHSM_MMIV_TAX_CODE_NO_BUK, SHSM_MMIV_TAX_CODE, fot_txa_stat, fot_txa_stat, fot_txa_registn) and exposes 17 fields with key fields bukrs, land1, kalsm, mwskz, spras.

Data Sources (5)

SourceAliasJoin Type
SHSM_MMIV_TAX_CODE_NO_BUK _Taxation_Abroad_active inner
SHSM_MMIV_TAX_CODE _Taxation_Abroad_active inner
fot_txa_stat _Taxation_abroad_customizing inner
fot_txa_stat _Taxation_abroad_customizing inner
fot_txa_registn fot_txa_registn inner

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName SHSMMIVMWSKZTABA view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
EndUserText.label SHSM_MMIV_TAX_CODE ajusted for TRIT view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.dataCategory #VALUE_HELP view
Metadata.ignorePropagatedAnnotations true view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY bukrs t001 bukrs Value
KEY land1 SHSM_MMIV_TAX_CODE land1 Trip Ctry/Reg
KEY kalsm SHSM_MMIV_TAX_CODE kalsm Search Proced.
KEY mwskz SHSM_MMIV_TAX_CODE mwskz Tax Code
KEY spras SHSM_MMIV_TAX_CODE spras Off. Language
mwart SHSM_MMIV_TAX_CODE mwart Tax Type
text1 SHSM_MMIV_TAX_CODE text1 Vertikalization Text
xinact SHSM_MMIV_TAX_CODE xinact Inactive
bukrs Value
KEY land1 SHSM_MMIV_TAX_CODE land1 Trip Ctry/Reg
KEY kalsm SHSM_MMIV_TAX_CODE kalsm Search Proced.
KEY mwskz SHSM_MMIV_TAX_CODE mwskz Tax Code
KEY spras SHSM_MMIV_TAX_CODE spras Off. Language
mwart SHSM_MMIV_TAX_CODE mwart Tax Type
text1 SHSM_MMIV_TAX_CODE text1 Vertikalization Text
xinact SHSM_MMIV_TAX_CODE xinact Inactive
status fot_txa_stat status Workflow Status

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 SHSM_MMIV_TAX_CODE_TAB_ACT.
-- 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: SHSMMIVMWSKZTABA

CREATE VIEW SHSM_MMIV_TAX_CODE_TAB_ACT AS
SELECT
  t001.bukrs AS bukrs,
  _Taxation_Abroad_active.land1 AS land1,
  _Taxation_Abroad_active.kalsm AS kalsm,
  _Taxation_Abroad_active.mwskz AS mwskz,
  _Taxation_Abroad_active.spras AS spras,
  _Taxation_Abroad_active.mwart AS mwart,
  _Taxation_Abroad_active.text1 AS text1,
  _Taxation_Abroad_active.xinact AS xinact,
  _Taxation_abroad_customizing.status AS status
INNER JOIN fot_txa_stat AS _Taxation_abroad_customizing ON /* join condition not captured in parsed metadata */
INNER JOIN fot_txa_registn ON /* join condition not captured in parsed metadata */
INNER JOIN SHSM_MMIV_TAX_CODE_NO_BUK AS _Taxation_Abroad_active ON /* join condition not captured in parsed metadata */
INNER JOIN SHSM_MMIV_TAX_CODE AS _Taxation_Abroad_active ON /* join condition not captured in parsed metadata */
;