FAC_DART_Z3_COMPANYCODE

DDL: FAC_DART_Z3_COMPANYCODE SQL: FAC_DZCOCODE Type: view
39 Fields 1 Data Sources

Company Code Master Data

FAC_DART_Z3_COMPANYCODE is a CDS View that provides data about "Company Code Master Data" in SAP S/4HANA. It reads from 1 data source (I_CompanyCode) and exposes 39 fields with key field CompanyCode.

Data Sources (1)

SourceAliasJoin Type
I_CompanyCode I_CompanyCode from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName FAC_DZCOCODE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.buffering.status #NOT_ALLOWED view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Company Code Master Data view

Fields (39)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode Receiver Company Code
Company Company Owner
GlobalCoCodeName _CompanyCode bukrs_glob Global CoCde
CompanyCodeName CompanyCodeName Company Name
ChartOfAccounts ChartOfAccounts Node Class
IndProdcutiveCoCode _CompanyCode xprod Productive
Currency Currency Valuation Crcy
AddressID AddressID Ship-to address
BusinessPartnerName1 _Address BusinessPartnerName1 Name
StreetName _Address StreetName Text
HouseNumber _Address HouseNumber House Number
CityName CityName Name
District _Address District District Court
Region _Address Region Venue Region
Country Country Venue: Ctry/Reg
PostalCode _Address PostalCode Postal Code
POBox _Address POBox PO Box
POBoxPostalCode _Address POBoxPostalCode PO Box Postal Code
TaxJurisdiction _CompanyCode txjcd Tax Jurisdict.
FiscalYearVariant FiscalYearVariant FY Variant
VATRegistration VATRegistration VAT Registration No.
TaxableEntity TaxableEntity Tax Group
CountryChartOfAccounts CountryChartOfAccounts Chart of Accts
BusinessPartnerName2 _Address BusinessPartnerName2 Name 2
IndJVAActive _CompanyCode xjvaa JVA Active
ForeignCurrencyTranslation _CompanyCode txkrs Tx Crcy Transl.
DocDateIsUsedForTaxDetn DocDateIsUsedForTaxDetn Tax Determ.with Doc.Date
NonTaxableTransactionsTaxCodeI _CompanyCode mwskv Input Tax Code
NonTaxableTransactionTaxCodeO NonTaxableTransactionTaxCode Output Tax Code
ImportDataCtrlinMMPO _CompanyCode impda Imp. Data in PO
IndNegativePostings _CompanyCode xnegp Reversl Posting Type
IndCreditCtrlAreaOverwritten _CompanyCode xkkbi Enter Control Area
ExtendedWhldgTaxIsActive ExtendedWhldgTaxIsActive Extended WTax Active
CostofSalesAccountingStatus _CompanyCode xcos COS Status
DeferredTaxRule _CompanyCode dtaxr Def. Tax Rule
TaxRptgDateIsActive TaxRptgDateIsActive Tax Date
HouseNumberSupplementText _Address HouseNumberSupplementText Supplement
SystemClient _CompanyCode mandt System Client
ForeignTrade _CompanyCode impda Imp. Data in PO

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 FAC_DART_Z3_COMPANYCODE.
-- 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: FAC_DZCOCODE

CREATE VIEW FAC_DART_Z3_COMPANYCODE AS
SELECT
  CompanyCode,
  Company,
  _CompanyCode.bukrs_glob AS GlobalCoCodeName,
  CompanyCodeName,
  ChartOfAccounts,
  _CompanyCode.xprod AS IndProdcutiveCoCode,
  Currency,
  AddressID,
  _Address.BusinessPartnerName1 AS BusinessPartnerName1,
  _Address.StreetName AS StreetName,
  _Address.HouseNumber AS HouseNumber,
  CityName,
  _Address.District AS District,
  _Address.Region AS Region,
  Country,
  _Address.PostalCode AS PostalCode,
  _Address.POBox AS POBox,
  _Address.POBoxPostalCode AS POBoxPostalCode,
  _CompanyCode.txjcd AS TaxJurisdiction,
  FiscalYearVariant,
  VATRegistration,
  TaxableEntity,
  CountryChartOfAccounts,
  _Address.BusinessPartnerName2 AS BusinessPartnerName2,
  _CompanyCode.xjvaa AS IndJVAActive,
  _CompanyCode.txkrs AS ForeignCurrencyTranslation,
  DocDateIsUsedForTaxDetn,
  _CompanyCode.mwskv AS NonTaxableTransactionsTaxCodeI,
  NonTaxableTransactionTaxCode AS NonTaxableTransactionTaxCodeO,
  _CompanyCode.impda AS ImportDataCtrlinMMPO,
  _CompanyCode.xnegp AS IndNegativePostings,
  _CompanyCode.xkkbi AS IndCreditCtrlAreaOverwritten,
  ExtendedWhldgTaxIsActive,
  _CompanyCode.xcos AS CostofSalesAccountingStatus,
  _CompanyCode.dtaxr AS DeferredTaxRule,
  TaxRptgDateIsActive,
  _Address.HouseNumberSupplementText AS HouseNumberSupplementText,
  _CompanyCode.mandt AS SystemClient,
  _CompanyCode.impda AS ForeignTrade
FROM I_CompanyCode
;

Learn More