SHSM_MMIV_TAX_CODE_TRIT

DDL: SHSM_MMIV_TAX_CODE_TRIT SQL: SHSMMIVMWSKZTAB Type: view
16 Fields 2 Data Sources

SHSM_MMIV_TAX_CODE ajusted for TRIT

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

Data Sources (2)

SourceAliasJoin Type
SHSM_MMIV_TAX_CODE_TAB_ACT SHSM_MMIV_TAX_CODE_TAB_ACT from
SHSM_MMIV_TAX_CODE_TAB_INACT SHSM_MMIV_TAX_CODE_TAB_INACT union

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName SHSMMIVMWSKZTAB 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 #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.dataCategory #VALUE_HELP view
Metadata.ignorePropagatedAnnotations true view
Search.searchable true view
Consumption.ranked true view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY bukrs bukrs Value
KEY land1 land1 Trip Ctry/Reg
KEY kalsm kalsm Search Proced.
KEY mwskz mwskz Tax Code
KEY spras spras Off. Language
mwart mwart Tax Type
text1 text1 Vertikalization Text
xinact xinact Inactive
KEY land1 land1 Trip Ctry/Reg
KEY kalsm kalsm Search Proced.
KEY mwskz mwskz Tax Code
KEY spras spras Off. Language
mwart mwart Tax Type
text1 text1 Vertikalization Text
xinact xinact Inactive
status 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_TRIT.
-- 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: SHSMMIVMWSKZTAB

CREATE VIEW SHSM_MMIV_TAX_CODE_TRIT AS
SELECT
  bukrs,
  land1,
  kalsm,
  mwskz,
  spras,
  mwart,
  text1,
  xinact,
  status
FROM SHSM_MMIV_TAX_CODE_TAB_ACT
-- UNION with additional select branch(es): SHSM_MMIV_TAX_CODE_TAB_INACT
;

Learn More