C_GB_StRpAuditFileSlsDistrC

DDL: C_GB_STRPAUDITFILESLSDISTRC Type: view_entity CONSUMPTION Package: GLO_FIN_IS_ECSL_GB
36 Fields 1 Data Sources

GB HRMC Audit File for SD - Cube

C_GB_StRpAuditFileSlsDistrC is a Consumption CDS View (Cube) that provides data about "GB HRMC Audit File for SD - Cube" in SAP S/4HANA. It reads from 1 data source (I_BillingDocument) and exposes 36 fields with key fields CompanyCode, VATRegistration, BillingDocumentType, BillingDocument, BillingDocumentItem. Part of development package GLO_FIN_IS_ECSL_GB.

Data Sources (1)

SourceAliasJoin Type
I_BillingDocument I_BillingDocument from

Annotations (10)

NameValueLevelField
EndUserText.label GB HRMC Audit File for SD - Cube view
Analytics.internalName #LOCAL view
AccessControl.authorizationCheck #MANDATORY view
Metadata.allowExtensions true view
VDM.viewType #CONSUMPTION view
AccessControl.personalData.blocking #NOT_REQUIRED view
Analytics.dataCategory #CUBE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view

Fields (36)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode Receiver Company Code
KEY VATRegistration VATRegistration VAT Registration No.
KEY BillingDocumentType BillingDocumentType Billing Type
KEY BillingDocument BillingDocument SD Document
KEY BillingDocumentItem _Item BillingDocumentItem Item
BillingDocumentIsCancelled BillingDocumentIsCancelled Canceled
SDDocumentCategory SDDocumentCategory Document Cat.
TransactionCurrency TransactionCurrency Transaction Currency
AccountingExchangeRate AccountingExchangeRate Exch.Rate Acct.
BillingDocumentDate BillingDocumentDate Billing Date
ServicesRenderedDate _Item ServicesRenderedDate Services Rendered Date
AccountingTransferStatus AccountingTransferStatus
AccountingDocument AccountingDocument Journal Entry
CancelledBillingDocument CancelledBillingDocument Canceld Bill.Dc
FiscalYear FiscalYear G/L Fiscal Year
FiscalPeriod FiscalPeriod Tax period
SalesOrganization SalesOrganization Sales Organization
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
Division Division Internal Division ID
SDPricingProcedure SDPricingProcedure Pric. Procedure
CustomerTaxClassification1 CustomerTaxClassification1
SoldToParty SoldToParty Sold-to Party
Country Country Venue: Ctry/Reg
TaxDepartureCountry TaxDepartureCountry Tx Dep Ctry/Reg
DepartureCountry _Item DepartureCountry Departure Country / Region
Plant _Item Plant Valuation Area
StorageLocation _Item StorageLocation StorageLocation
TaxCode _Item TaxCode Tax Code
Material _Item Material Vehicle Model
ProductTaxClassification1 _Item ProductTaxClassification1
InternationalArticleNumber _Item InternationalArticleNumber EAN/UPC
BillingQuantity _Item BillingQuantity Invoiced Qty
BillingQuantityUnit _Item BillingQuantityUnit Sales Unit
NetAmount _Item NetAmount Stated Amount
TaxAmount _Item TaxAmount Tax Amt in Rptg Crcy
BillingDocumentItemText _Item BillingDocumentItemText Item Descr.

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 C_GB_StRpAuditFileSlsDistrC.
-- 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.

CREATE VIEW C_GB_StRpAuditFileSlsDistrC AS
SELECT
  CompanyCode,
  VATRegistration,
  BillingDocumentType,
  BillingDocument,
  _Item.BillingDocumentItem AS BillingDocumentItem,
  BillingDocumentIsCancelled,
  SDDocumentCategory,
  TransactionCurrency,
  AccountingExchangeRate,
  BillingDocumentDate,
  _Item.ServicesRenderedDate AS ServicesRenderedDate,
  AccountingTransferStatus,
  AccountingDocument,
  CancelledBillingDocument,
  FiscalYear,
  FiscalPeriod,
  SalesOrganization,
  DistributionChannel,
  Division,
  SDPricingProcedure,
  CustomerTaxClassification1,
  SoldToParty,
  Country,
  TaxDepartureCountry,
  _Item.DepartureCountry AS DepartureCountry,
  _Item.Plant AS Plant,
  _Item.StorageLocation AS StorageLocation,
  _Item.TaxCode AS TaxCode,
  _Item.Material AS Material,
  _Item.ProductTaxClassification1 AS ProductTaxClassification1,
  _Item.InternationalArticleNumber AS InternationalArticleNumber,
  _Item.BillingQuantity AS BillingQuantity,
  _Item.BillingQuantityUnit AS BillingQuantityUnit,
  _Item.NetAmount AS NetAmount,
  _Item.TaxAmount AS TaxAmount,
  _Item.BillingDocumentItemText AS BillingDocumentItemText
FROM I_BillingDocument
;

Learn More