FISVD_USCCWITHEXTTAX

DDL: FISVD_USCCWITHEXTTAX SQL: ETXUSCC Type: view

US Company Code

FISVD_USCCWITHEXTTAX is a CDS View that provides data about "US Company Code" in SAP S/4HANA. It reads from 3 data sources (t001, t005, ttxd) and exposes 3 fields with key field bukrs.

3 data source(s) 3 fields

Data Sources (3)

SourceAliasJoin Type
t001 cc from
t005 cy left_outer
ttxd tx left_outer

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName ETXUSCC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label US Company Code view
ObjectModel.usageType.serviceQuality #P view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY bukrs t001 bukrs
land1 t001 land1
kalsm t005 kalsm 
@AbapCatalog.sqlViewName: 'ETXUSCC'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'US Company Code'
@ObjectModel.usageType: {
  serviceQuality: #P
}
define view FISVD_USCCWITHEXTTAX as select from t001 as cc
left outer join t005 as cy
  on cc.land1 = cy.land1 
left outer join ttxd as tx
  on tx.kalsm = cy.kalsm {
  key cc.bukrs,
  cc.land1,
  cy.kalsm
} 
  where ( cc.land1 = 'US' or cc.land1 = 'USA' ) //US company code

    and tx.xextn <> '' and tx.rfcdest = 'NONE' //CPI solution

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"T001",
"T005",
"TTXD"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More