I_CACompanyCode

DDL: I_CACOMPANYCODE SQL: ICACOMPANYCODE Type: view BASIC
5 Fields 1 Data Sources 1 Associations

Buchungskreise im Vertragskontokorrent

I_CACompanyCode is a Basic CDS View that provides data about "Buchungskreise im Vertragskontokorrent" in SAP S/4HANA. It reads from 1 data source (tfk001b) and exposes 5 fields with key field CompanyCode. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
tfk001b tfk001b from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_CompanyCode _CompanyCode $projection.CompanyCode = _CompanyCode.CompanyCode

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName ICACOMPANYCODE view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Buchungskreise im Vertragskontokorrent view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.representativeKey CompanyCode view
VDM.viewType #BASIC view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode bukrs Value
CompanyCodeName _CompanyCode CompanyCodeName Company Name
CADisputeCaseProcessingIsActv xdism Dispute
MchnLrngIsActvForPaytAssgmt xmlpa ML for Payt Assignmt
CACollMasterDataGroupLevel grplvl MD Grouping Lvl

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 I_CACompanyCode.
-- 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: ICACOMPANYCODE

CREATE VIEW I_CACompanyCode AS
SELECT
  bukrs AS CompanyCode,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  xdism AS CADisputeCaseProcessingIsActv,
  xmlpa AS MchnLrngIsActvForPaytAssgmt,
  grplvl AS CACollMasterDataGroupLevel
FROM tfk001b
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
;

Learn More