config/ecc/annotations/AccountingDocuments.yaml [1:130]:
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
name: "{{ project_id_tgt }}.{{ dataset_reporting_tgt }}.AccountingDocuments"
description: "This view stores the fininacial transactions in SAP at header and item level. The granularity of this view is Client(System), company code, fiscal year, accounting document number and Number of line item within accounting document."
catalog_tags:
  - display_name: "line_of_business"
    fields:
      - display_name: "group"
        value: "Finance"
      - display_name: "domain"
        value: "Accounts Receivable"
fields:
  - name: "Client_MANDT"
    description: "Client (Mandant), PK"
  - name: "CompanyCode_BUKRS"
    description: "Company Code, PK"
  - name: "AccountingDocumentNumber_BELNR"
    description: "Accounting document number, PK"
  - name: "FiscalYear_GJAHR"
    description: "Fiscal Year, PK"
  - name: "NumberOfLineItemWithinAccountingDocument_BUZEI"
    description: "Number of line item within accounting document, PK"
  - name: "DocumentType_BLART"
    description: "Document type"
  - name: "DocumentDateInDocument_BLDAT"
    description: "Document date in document"
  - name: "PostingDateInTheDocument_BUDAT"
    description: "Posting date in the document"
  - name: "FiscalPeriod_MONAT"
    description: "Fiscal period"
  - name: "DayOnWhichAccountingDocumentWasEntered_CPUDT"
    description: "Day on which accounting document was entered"
  - name: "TimeOfEntry_CPUTM"
    description: "Time of entry"
  - name: "DateOfTheLastDocumentChangeByTransaction_AEDAT"
    description: "Date of the last document change by transaction"
  - name: "DateOfTheLastDocumentUpdate_UPDDT"
    description: "Date of the last document update"
  - name: "TranslationDate_WWERT"
    description: "Translation date"
  - name: "UserName_USNAM"
    description: "User Name"
  - name: "TransactionCode_TCODE"
    description: "Transaction code"
  - name: "NumberOfACrossCompanyCodePostingTransaction_BVORG"
    description: "Number of cross-company code posting transaction"
  - name: "ReferenceDocumentNumber_XBLNR"
    description: "Reference document number"
  - name: "RecurringEntryDocumentNumber_DBBLG"
    description: "Recurring entry document number"
  - name: "ReverseDocumentNumber_STBLG"
    description: "Reverse document number"
  - name: "ReverseDocumentFiscalYear_STJAH"
    description: "Reverse document fiscal year"
  - name: "DocumentHeaderText_BKTXT"
    description: "Document header text"
  - name: "CurrencyKey_WAERS"
    description: "Currency key"
  - name: "ExchangeRate_KURSF"
    description: "Exchange rate"
  - name: "CurrencyKeyForTheGroupCurrency_KZWRS"
    description: "Currency key for the group currency"
  - name: "GroupCurrencyExchangeRate_KZKRS"
    description: "Group Currency Exchange Rate"
  - name: "DocumentStatus_BSTAT"
    description: "Document status"
  - name: "Indicator_DocumentPostedNet_XNETB"
    description: "Indicator: Document posted net"
  - name: "UnplannedDeliveryCosts_FRATH"
    description: "Unplanned delivery costs"
  - name: "Indicator_DocumentIsPostedToAPreviousPeriod_XRUEB"
    description: "Indicator: Document is posted to a previous period"
  - name: "BusinessTransaction_GLVOR"
    description: "Business transaction"
  - name: "BatchInputSessionName_GRPID"
    description: "Batch Input Session Name"
  - name: "DocumentNameInTheArchiveSystem_DOKID"
    description: "Document name in the archive system"
  - name: "ExtractIdDocumentHeader_ARCID"
    description: "Extract ID document header"
  - name: "InternalDocumentTypeForDocumentControl_IBLAR"
    description: "Internal document type for document control"
  - name: "ReferenceProcedure_AWTYP"
    description: "Reference procedure"
  - name: "ObjectKey_AWKEY"
    description: "Object key"
  - name: "FinancialManagementArea_FIKRS"
    description: "Financial management area"
  - name: "LocalCurrency_HWAER"
    description: "Local Currency"
  - name: "CurrencyKeyOfSecondLocalCurrency_HWAE2"
    description: "Currency key of second local currency"
  - name: "CurrencyKeyOfThirdLocalCurrency_HWAE3"
    description: "Currency key of third local currency"
  - name: "ExchangeRateForTheSecondLocalCurrency_KURS2"
    description: "Exchange rate for the second local currency"
  - name: "ExchangeRateForTheThirdLocalCurrency_KURS3"
    description: "Exchange rate for the third local currency"
  - name: "SourceCurrencyForCurrencyTranslation_BASW2"
    description: "Source currency for currency translation"
  - name: "SourceCurrencyForCurrencyTranslation_BASW3"
    description: "Source currency for currency translation"
  - name: "TranslationDateTypeForSecondLocalCurrency_UMRD2"
    description: "Translation date for second local currency"
  - name: "TranslationDateTypeForThirdLocalCurrency_UMRD3"
    description: "Translation date for third local currency"
  - name: "Indicator_DocumentIsFlaggedForReversal_XSTOV"
    description: "Indicator: Document is flagged for reversal"
  - name: "PlannedDateForTheReversePosting_STODT"
    description: "Planned date for the reverse posting"
  - name: "CalculateTaxAutomatically_XMWST"
    description: "Calculate tax automatically"
  - name: "CurrencyTypeOfSecondLocalCurrency_CURT2"
    description: "Currency type of second local currency"
  - name: "CurrencyTypeOfThirdLocalCurrency_CURT3"
    description: "Currency type of third local currency"
  - name: "ExchangeRateType_KUTY2"
    description: "Exchange Rate Type"
  - name: "ExchangeRateType_KUTY3"
    description: "Exchange Rate Type"
  - name: "GlAccountAmountsEnteredExcludeTax_XSNET"
    description: "G/L account amounts entered exclude tax"
  - name: "SourceCompanyCode_AUSBK"
    description: "Source company code"
  - name: "EnterVatSalesTaxOnDetailScreen_XUSVR"
    description: "Enter VAT, use tax, sales tax on detail screen"
  - name: "StatusOfDataTransferIntoSubsequentRelease_DUEFL"
    description: "Status of data transfer into subsequent release"
  - name: "LogicalSystem_AWSYS"
    description: "Logical System"
  - name: "ExchangeRateForTaxes_TXKRS"
    description: "Exchange rate for taxes"
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -



config/s4/annotations/AccountingDocuments.yaml [1:130]:
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
name: "{{ project_id_tgt }}.{{ dataset_reporting_tgt }}.AccountingDocuments"
description: "This view stores the fininacial transactions in SAP at header and item level. The granularity of this view is Client(System), company code, fiscal year, accounting document number and Number of line item within accounting document."
catalog_tags:
  - display_name: "line_of_business"
    fields:
      - display_name: "group"
        value: "Finance"
      - display_name: "domain"
        value: "Accounts Receivable"
fields:
  - name: "Client_MANDT"
    description: "Client (Mandant), PK"
  - name: "CompanyCode_BUKRS"
    description: "Company Code, PK"
  - name: "AccountingDocumentNumber_BELNR"
    description: "Accounting document number, PK"
  - name: "FiscalYear_GJAHR"
    description: "Fiscal Year, PK"
  - name: "NumberOfLineItemWithinAccountingDocument_BUZEI"
    description: "Number of line item within accounting document, PK"
  - name: "DocumentType_BLART"
    description: "Document type"
  - name: "DocumentDateInDocument_BLDAT"
    description: "Document date in document"
  - name: "PostingDateInTheDocument_BUDAT"
    description: "Posting date in the document"
  - name: "FiscalPeriod_MONAT"
    description: "Fiscal period"
  - name: "DayOnWhichAccountingDocumentWasEntered_CPUDT"
    description: "Day on which accounting document was entered"
  - name: "TimeOfEntry_CPUTM"
    description: "Time of entry"
  - name: "DateOfTheLastDocumentChangeByTransaction_AEDAT"
    description: "Date of the last document change by transaction"
  - name: "DateOfTheLastDocumentUpdate_UPDDT"
    description: "Date of the last document update"
  - name: "TranslationDate_WWERT"
    description: "Translation date"
  - name: "UserName_USNAM"
    description: "User Name"
  - name: "TransactionCode_TCODE"
    description: "Transaction code"
  - name: "NumberOfACrossCompanyCodePostingTransaction_BVORG"
    description: "Number of cross-company code posting transaction"
  - name: "ReferenceDocumentNumber_XBLNR"
    description: "Reference document number"
  - name: "RecurringEntryDocumentNumber_DBBLG"
    description: "Recurring entry document number"
  - name: "ReverseDocumentNumber_STBLG"
    description: "Reverse document number"
  - name: "ReverseDocumentFiscalYear_STJAH"
    description: "Reverse document fiscal year"
  - name: "DocumentHeaderText_BKTXT"
    description: "Document header text"
  - name: "CurrencyKey_WAERS"
    description: "Currency key"
  - name: "ExchangeRate_KURSF"
    description: "Exchange rate"
  - name: "CurrencyKeyForTheGroupCurrency_KZWRS"
    description: "Currency key for the group currency"
  - name: "GroupCurrencyExchangeRate_KZKRS"
    description: "Group Currency Exchange Rate"
  - name: "DocumentStatus_BSTAT"
    description: "Document status"
  - name: "Indicator_DocumentPostedNet_XNETB"
    description: "Indicator: Document posted net"
  - name: "UnplannedDeliveryCosts_FRATH"
    description: "Unplanned delivery costs"
  - name: "Indicator_DocumentIsPostedToAPreviousPeriod_XRUEB"
    description: "Indicator: Document is posted to a previous period"
  - name: "BusinessTransaction_GLVOR"
    description: "Business transaction"
  - name: "BatchInputSessionName_GRPID"
    description: "Batch Input Session Name"
  - name: "DocumentNameInTheArchiveSystem_DOKID"
    description: "Document name in the archive system"
  - name: "ExtractIdDocumentHeader_ARCID"
    description: "Extract ID document header"
  - name: "InternalDocumentTypeForDocumentControl_IBLAR"
    description: "Internal document type for document control"
  - name: "ReferenceProcedure_AWTYP"
    description: "Reference procedure"
  - name: "ObjectKey_AWKEY"
    description: "Object key"
  - name: "FinancialManagementArea_FIKRS"
    description: "Financial management area"
  - name: "LocalCurrency_HWAER"
    description: "Local Currency"
  - name: "CurrencyKeyOfSecondLocalCurrency_HWAE2"
    description: "Currency key of second local currency"
  - name: "CurrencyKeyOfThirdLocalCurrency_HWAE3"
    description: "Currency key of third local currency"
  - name: "ExchangeRateForTheSecondLocalCurrency_KURS2"
    description: "Exchange rate for the second local currency"
  - name: "ExchangeRateForTheThirdLocalCurrency_KURS3"
    description: "Exchange rate for the third local currency"
  - name: "SourceCurrencyForCurrencyTranslation_BASW2"
    description: "Source currency for currency translation"
  - name: "SourceCurrencyForCurrencyTranslation_BASW3"
    description: "Source currency for currency translation"
  - name: "TranslationDateTypeForSecondLocalCurrency_UMRD2"
    description: "Translation date for second local currency"
  - name: "TranslationDateTypeForThirdLocalCurrency_UMRD3"
    description: "Translation date for third local currency"
  - name: "Indicator_DocumentIsFlaggedForReversal_XSTOV"
    description: "Indicator: Document is flagged for reversal"
  - name: "PlannedDateForTheReversePosting_STODT"
    description: "Planned date for the reverse posting"
  - name: "CalculateTaxAutomatically_XMWST"
    description: "Calculate tax automatically"
  - name: "CurrencyTypeOfSecondLocalCurrency_CURT2"
    description: "Currency type of second local currency"
  - name: "CurrencyTypeOfThirdLocalCurrency_CURT3"
    description: "Currency type of third local currency"
  - name: "ExchangeRateType_KUTY2"
    description: "Exchange Rate Type"
  - name: "ExchangeRateType_KUTY3"
    description: "Exchange Rate Type"
  - name: "GlAccountAmountsEnteredExcludeTax_XSNET"
    description: "G/L account amounts entered exclude tax"
  - name: "SourceCompanyCode_AUSBK"
    description: "Source company code"
  - name: "EnterVatSalesTaxOnDetailScreen_XUSVR"
    description: "Enter VAT, use tax, sales tax on detail screen"
  - name: "StatusOfDataTransferIntoSubsequentRelease_DUEFL"
    description: "Status of data transfer into subsequent release"
  - name: "LogicalSystem_AWSYS"
    description: "Logical System"
  - name: "ExchangeRateForTaxes_TXKRS"
    description: "Exchange rate for taxes"
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -



