@EndUserText.label: 'GB HRMC Audit File for FI - Cube'
@Analytics.internalName:#LOCAL
@AccessControl.authorizationCheck: #MANDATORY
@Metadata.allowExtensions:true
@VDM.viewType: #CONSUMPTION
@Analytics: { dataCategory: #CUBE }
@ObjectModel.usageType:{
serviceQuality: #D,
sizeCategory: #XL,
dataClass: #MIXED
}
@AccessControl.personalData.blocking: #BLOCKED_DATA_INCLUDED
define view entity C_GB_StRpAuditFinFileC
as select from I_JournalEntry {
key CompanyCode, // BUKRS BKPF-BUKRS Company Code (4)
key FiscalYear, // GJAHR BKPF-GJAHR Fiscal year Numeric 4
key AccountingDocument, // BELNR BKPF-BELNR Document number Character 10
key _OperationalAcctgDocItem.AccountingDocumentItem, // BUZEI BSEG-BUZEI Number of Line Item Within Accounting Document Numeric 3
OriginalReferenceDocument, // AWKEY BKPF-AWKEY Reference Key Character 20
// STBUK BSEG-STBUK Tax Company Code Character 4 // commented out in I_OperationalAcctgDocItem !!!
AccountingDocumentType, // BLART BKPF-BLART Document type Character 2
DocumentDate, // BLDAT BKPF-BLDAT Document date Date: YYYYMMDD 8
PostingDate, // BUDAT BKPF-BUDAT Posting date Date: YYYYMMDD 8
FiscalPeriod, // MONAT BKPF-MONAT Accounting period Numeric 2
AccountingDocumentCreationDate, // CPUDT BKPF-CPUDT Day on Which Accounting Document Was Entered Date: YYYYMMDD 8
ExchangeRateDate, // WWERT BKPF-WWERT Date for Exch. Rate Date: YYYYMMDD 8
AccountingDocCreatedByUser, // USNAM BKPF-USNAM Username Character 12
TransactionCode, // TCODE BKPF-TCODE Transaction code Character 20
ReverseDocumentFiscalYear, // STJAH BKPF-STJAH Reverse document fiscal year Numeric 4
// XRUEB BKPF-XRUEB Document is posted to a previous period Character 1 // commented out in I_AccountingDocument !!!
DocumentReferenceID, // XBLNR BKPF-XBLNR Reference Document Number Character 16
TransactionCurrency, // WAERS BKPF-WAERS Currency key Character 5
cast( ExchangeRate as abap.dec(9,5) ) as ExchangeRate, // KURSF BKPF-KURSF Exchange Rate Decimal 9 5 --> without conversion exit
IntercompanyTransaction, // BVORG BKPF-BVORG Number of Cross-Company Code Posting Transaction Character 16
ReverseDocument, // STBLG BKPF-STBLG Reverse Document Number Character 10
ReversalReason, // STGRD BKPF-STGRD Reason for Reversal Character 2
AccountingDocumentCategory, // BSTAT BKPF-BSTAT Document Status Character 1
CompanyCodeCurrency, // HWAER BKPF-HWAER Local Currency Character 5
AdditionalCurrency1, // HWAE2 BKPF-HWAE2 Currency Key of Second Local Currency Character 5
AdditionalCurrency2, // HWAE3 BKPF-HWAE3 Currency Key of Third Local Currency Character 5
TaxIsCalculatedAutomatically, // XMWST BKPF-XMWST Calculate tax automatically Character 1
TaxAbsoluteExchangeRate, // TXKRS BKPF-TXKRS Exchange Rate for Taxes Decimal 9 5
_OperationalAcctgDocItem.AccountingDocumentItemType, // BUZID BSEG-BUZID Identification of the Line Item Character 1
_OperationalAcctgDocItem.ClearingDate, // AUGDT BSEG-AUGDT Clearing date Date: YYYYMMDD 8
_OperationalAcctgDocItem.ClearingCreationDate, // AUGCP BSEG-AUGCP Clearing entry date Date: YYYYMMDD 8
_OperationalAcctgDocItem.ClearingAccountingDocument, // AUGBL BSEG-AUGBL Document Number of the Clearing Document Character 10
_OperationalAcctgDocItem.TaxJurisdiction, // TXJCD BSEG-TXJCD Tax Jurisdiction Character 15
_OperationalAcctgDocItem.CostCenter, // KOSTL BSEG-KOSTL Cost Centre Character 10
_OperationalAcctgDocItem.PostingKey, // BSCHL BSEG-BSCHL Posting Key Character 2
_OperationalAcctgDocItem.ControllingArea, // KOKRS BSEG-KOKRS Controlling area Character 4
_OperationalAcctgDocItem.FinancialAccountType, // KOART BSEG-KOART Account Type Character 1
_OperationalAcctgDocItem.BusinessArea, // GSBER BSEG-GSBER Business area Character 4
_OperationalAcctgDocItem.TaxCode, // MWSKZ BSEG-MWSKZ Tax on sales/purchases code Character 2
_OperationalAcctgDocItem.TaxType, // MWART BSEG-MWART Tax Type Character 1
@Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
abs(_OperationalAcctgDocItem.AmountInCompanyCodeCurrency) as AmountInCompanyCodeCurrency, // DMBTR BSEG-DMBTR Amount in Local Currency Decimal 13 2
// _OperationalAcctgDocItem.TransactionCurrency,
@Semantics: { amount : {currencyCode: 'TransactionCurrency'} }
abs(_OperationalAcctgDocItem.AmountInTransactionCurrency) as AmountInTransactionCurrency, // WRBTR BSEG-WRBTR Amount in document currency Decimal 13 2
_OperationalAcctgDocItem.DebitCreditCode, // SHKZG BSEG-SHKZG Debit/Credit Indicator Character 1
@Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
abs(_OperationalAcctgDocItem.TaxBaseAmountInCoCodeCrcy) as TaxBaseAmountInCoCodeCrcy, // HWBAS BSEG-HWBAS Tax Base Amount in Local Currency Decimal 13 2
@Semantics: { amount : {currencyCode: 'TransactionCurrency'} }
abs(_OperationalAcctgDocItem.TaxBaseAmountInTransCrcy) as TaxBaseAmountInTransCrcy, // FWBAS BSEG-FWBAS Tax Base Amount in Document Currency Decimal 13 2
@Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
abs(_OperationalAcctgDocItem.TaxAmountInCoCodeCrcy) as TaxAmountInCoCodeCrcy, // MWSTS BSEG-MWSTS Tax Amount in Local Currency Decimal 13 2
@Semantics: { amount : {currencyCode: 'TransactionCurrency'} }
abs(_OperationalAcctgDocItem.TaxAmount) as TaxAmount, // WMWST BSEG-WMWST Tax amount in document currency Decimal 13 2
@Semantics: { amount : {currencyCode: 'AdditionalCurrency1'} }
abs(_OperationalAcctgDocItem.AmountInAdditionalCurrency1) as AmountInAdditionalCurrency1, // DMBE2 BSEG-DMBE2 Amount in Second Local Currency Decimal 13 2
@Semantics: { amount : {currencyCode: 'AdditionalCurrency2'} }
abs(_OperationalAcctgDocItem.AmountInAdditionalCurrency2) as AmountInAdditionalCurrency2, // DMBE3 BSEG-DMBE3 Amount in Third Local Currency Decimal 13 2
@Semantics: { amount : {currencyCode: 'AdditionalCurrency1'} }
abs(_OperationalAcctgDocItem.TaxAmountInAdditionalCurrency1) as TaxAmountInAdditionalCurrency1, // MWST2 BSEG-MWST2 Tax Amount in Second Local Currency Decimal 13 abs(_OperationalAcctgDocItem.TaxAmountInAdditionalCurrency2) as TaxAmountInAdditionalCurrency2, // MWST3 BSEG-MWST3 Tax Amount in Third Local Currency Decimal 13 2
// abs(_OperationalAcctgDocItem.navhw_shl), // NAVHW BSEG-NAVHW Non-Deductible Input Tax (in Local Currency) Decimal 13 2 // commented out in I_OperationalAcctgDocItem !!!
// abs(_OperationalAcctgDocItem.navfw_shl), // NAVFW BSEG-NAVFW Non-Deductible Input Tax (in Document Currency) Decimal 13 2 // commented out in I_OperationalAcctgDocItem !!!
_OperationalAcctgDocItem.MasterFixedAsset, // ANLN1 BSEG-ANLN1 Main Asset Number Character 12
_OperationalAcctgDocItem.GLAccount, // HKONT BSEG-HKONT General Ledger Account Character 10
_OperationalAcctgDocItem.Customer, // KUNNR BSEG-KUNNR Customer number Character 10
_OperationalAcctgDocItem.Supplier, // LIFNR BSEG-LIFNR Account Number of Vendor or Creditor Character 10
_OperationalAcctgDocItem.Material, // MATNR BSEG-MATNR Material Number Character 18
_OperationalAcctgDocItem.Plant, // WERKS BSEG-WERKS Plant Character 4
@Semantics: { quantity : {unitOfMeasure: 'BaseUnit'} }
_OperationalAcctgDocItem.Quantity, // MENGE BSEG-MENGE Quantity Decimal 13 3
_OperationalAcctgDocItem.BaseUnit, // MEINS BSEG-MEINS Base Unit of Measure Character 3
_OperationalAcctgDocItem.DelivOfGoodsDestCountry, // EGBLD BSEG-EGBLD Country of Destination for Delivery of Goods Character 3
// _OperationalAcctgDocItem. // EGLLD BSEG-EGLLD Supplying Country for Delivery of Goods Character 3 // commented out in I_OperationalAcctgDocItem !!!
_OperationalAcctgDocItem.SupplyingCountry, // LANDL BSEG-LANDL Supplying Country Character 3
// _OperationalAcctgDocItem. // DIEKZ BSEG-DIEKZ Service Indicator (Foreign Payment) Character 1 // commented out in I_OperationalAcctgDocItem !!!
_OperationalAcctgDocItem.BillingDocument, // VBELN BSEG-VBELN Billing document Character 10
_OperationalAcctgDocItem.PurchasingDocument, // EBELN BSEG-EBELN Purchasing Document Number Character 10
_OperationalAcctgDocItem.PurchasingDocumentItem, // EBELP BSEG-EBELP Item Number of Purchasing Document Numeric 5
_OperationalAcctgDocItem. AccountAssignmentNumber, // ZEKKN BSEG-ZEKKN Sequential Number of Account Assignment Numeric 2
_OperationalAcctgDocItem.VATRegistration, // STCEG BSEG-STCEG VAT Registration Number Character 20
_OperationalAcctgDocItem.ProfitCenter, // PRCTR BSEG-PRCTR Profit Centre Character 10
_OperationalAcctgDocItem.CostObject, // KSTRG BSEG-KSTRG Cost object Character 12
_OperationalAcctgDocItem.WBSElementInternalID, // PROJK BSEG-PROJK Work Breakdown Structure Element Numeric 8
_OperationalAcctgDocItem.AssignmentReference, // ZUONR BSEG-ZUONR Assignment Number Character 18
AccountingDocumentHeaderText, // BKTXT BKPF-BKTXT Document Header Text Character 25
_OperationalAcctgDocItem.DocumentItemText // SGTXT BSEG-SGTXT Item Text Character 50
}