C_GB_StRpAuditFileSlsDistrC

DDL: C_GB_STRPAUDITFILESLSDISTRC Type: view_entity CONSUMPTION

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.

1 data source(s) 36 fields

Data Sources (1)

SourceAliasJoin Type
I_BillingDocument I_BillingDocument from

Annotations (9)

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
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
KEY VATRegistration VATRegistration
KEY BillingDocumentType BillingDocumentType
KEY BillingDocument BillingDocument
KEY BillingDocumentItem _Item BillingDocumentItem
BillingDocumentIsCancelled BillingDocumentIsCancelled
SDDocumentCategory SDDocumentCategory
TransactionCurrency TransactionCurrency
AccountingExchangeRate AccountingExchangeRate
BillingDocumentDate BillingDocumentDate
ServicesRenderedDate _Item ServicesRenderedDate
AccountingTransferStatus AccountingTransferStatus
AccountingDocument AccountingDocument
CancelledBillingDocument CancelledBillingDocument
FiscalYear FiscalYear
FiscalPeriod FiscalPeriod
SalesOrganization SalesOrganization
DistributionChannel DistributionChannel
Division Division
SDPricingProcedure SDPricingProcedure
CustomerTaxClassification1 CustomerTaxClassification1
SoldToParty SoldToParty
Country Country
TaxDepartureCountry TaxDepartureCountry
DepartureCountry _Item DepartureCountry
Plant _Item Plant
StorageLocation _Item StorageLocation
TaxCode _Item TaxCode
Material _Item Material
ProductTaxClassification1 _Item ProductTaxClassification1
InternationalArticleNumber _Item InternationalArticleNumber
BillingQuantity _Item BillingQuantity
BillingQuantityUnit _Item BillingQuantityUnit
NetAmount _Item NetAmount
TaxAmount _Item TaxAmount
BillingDocumentItemText _Item BillingDocumentItemText 
@EndUserText.label: 'GB HRMC Audit File for SD - Cube'
@Analytics.internalName:#LOCAL
@AccessControl.authorizationCheck: #MANDATORY
@Metadata.allowExtensions:true
@VDM.viewType: #CONSUMPTION
@Analytics: { dataCategory: #CUBE }
@ObjectModel.usageType:{
  serviceQuality: #D,
  sizeCategory: #XL,
  dataClass: #MIXED
}

define view entity C_GB_StRpAuditFileSlsDistrC

  as select from I_BillingDocument
{


  key CompanyCode,                                        // company code (4)

  key VATRegistration,                                    // VAT Registration (20)

  key BillingDocumentType,                                // billing document type (4)

  key BillingDocument,                                    // billing document number (10)

  key _Item.BillingDocumentItem,                          // billing document line number (6)

      BillingDocumentIsCancelled,                         // billing document cancelled? if 'X' (1)

      SDDocumentCategory,                                 // SD document category (1)

      TransactionCurrency,                                // document currency (5)

      AccountingExchangeRate,                             // financial exchange rate (12)

      BillingDocumentDate,                                // billing date (8)

      _Item.ServicesRenderedDate as ServicesRenderedDate, // date services rendered (8)

      AccountingTransferStatus,                           // Status for transfer to accounting (1)

      AccountingDocument,                                 // accounting document (10)

      CancelledBillingDocument,                           // Cancelled billing document number (10)

      FiscalYear,                                         // fiscal year (4)

      FiscalPeriod,                                       // posting period (3)

      SalesOrganization,                                  // SALES ORGANISATION (4)

      DistributionChannel,                                // Distribution Channel (2)

      Division,                                           // Division (2)

      SDPricingProcedure,                                 // Pricing Procedure in Pricing(6)

      CustomerTaxClassification1,                         // customer tax classification (1)

      SoldToParty,                                        // Sold-To Party customer number (10)

      Country,                                            // country where goods delivered to cust (3)

      TaxDepartureCountry,                                // Tax departure country (3)

      _Item.DepartureCountry,                             // Departure country (3)

      _Item.Plant,                                        // plant (4)                    ...

      _Item.StorageLocation,                              // storage location (4)

      _Item.TaxCode,                                      // Sales Tax Code (2)

      _Item.Material,                                     // material number (18)

      _Item.ProductTaxClassification1,                    // material tax classification (1)

      _Item.InternationalArticleNumber,                   // International Article Number (EAN/UPC) (18)

      @Aggregation.default:#SUM
      @Semantics.quantity.unitOfMeasure: 'BillingQuantityUnit'
      _Item.BillingQuantity,                              // Actual billed quantity (13)

      _Item.BillingQuantityUnit,                          // Sales Unit   - NOT in the output - added here as measure unit for fkimg

      @Semantics.amount.currencyCode: 'TransactionCurrency'
      @Aggregation.default:#SUM
      _Item.NetAmount,                                    // net value in billing currency (16)

      @Aggregation.default:#SUM
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      _Item.TaxAmount,                                    // MWSBP(14) " VAT value in billing currency (14)

      _Item.BillingDocumentItemText                       // short text (40)


}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BILLINGDOCUMENT",
"I_BILLINGDOCUMENTITEM"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More