config/ecc/annotations/Billing.yaml

name: "{{ project_id_tgt }}.{{ dataset_reporting_tgt }}.Billing"
description: "This view provides billing details including the net value, tax amount and rebates provided to customers. The granularity is at Client, Billing Document, and Billing Item."
catalog_tags:
  - display_name: "line_of_business"
    fields:
      - display_name: "group"
        value: "Finance"
      - display_name: "domain"
        value: "Sales"
fields:
  - name: "Client_MANDT"
    description: "Client (Mandant), PK"
  - name: "BillingDocument_VBELN"
    description: "Billing Document, PK"
  - name: "BillingItem_POSNR"
    description: "Billing Item, PK"
  - name: "BillingType_FKART"
    description: "Billing Type"
  - name: "BillingCategory_FKTYP"
    description: "Billing Category"
  - name: "SalesOrganization_VKORG"
    description: "Sales Organization"
  - name: "DistributionChannel_VTWEG"
    description: "Distribution Channel"
  - name: "Division_SPART"
    description: "Division"
  - name: "SDDocumentCategory_VBTYP"
    description: "SD Document Category"
  - name: "SalesDistrict_BZIRK"
    description: "Sales District"
  - name: "PriceListType_PLTYP"
    description: "Price List Type"
  - name: "BillingDocumentIsCancelled_FKSTO"
    description: "Billing Document is Cancelled"
  - name: "Payer_KUNRG"
    description: "Payer"
  - name: "IncotermsPart1_INCO1"
    description: "Incoterms (Part 1)"
  - name: "IncotermsPart2_INCO2"
    description: "Incoterms (Part 2)"
  - name: "DestinationCountry_LAND1"
    description: "Destination Country"
  - name: "Region_REGIO"
    description: "Region (State, Province, Country)"
  - name: "CountryCode_COUNC"
    description: "County code"
  - name: "CityCode_CITYC"
    description: "City Code"
  - name: "TaxClassification1ForCustomer_TAXK1"
    description: "Tax Classification 1 for Customer"
  - name: "TaxClassification2ForCustomer_TAXK2"
    description: "Tax Classification 2 for Customer"
  - name: "TaxClassification3ForCustomer_TAXK3"
    description: "Tax Classification 3 for Customer"
  - name: "TaxClassification4ForCustomer_TAXK4"
    description: "Tax Classification 4 for Customer"
  - name: "TaxClassification5ForCustomer_TAXK5"
    description: "Tax Classification 5 for Customer"
  - name: "TaxDepartureCountry_LANDTX"
    description: "Tax Departure Country"
  - name: "OriginOfSalesTaxIDNumber_STCEG_H"
    description: "Origin of Sales Tax ID Number"
  - name: "CountryOfSalesTaxIDNumber_STCEG_L"
    description: "Country of Sales Tax ID Number"
  - name: "ReferenceDocumentNumber_XBLNR"
    description: "Reference Document Number"
  - name: "CustomerPriceGroup_KONDA"
    description: "Customer Price group"
  - name: "StatusForTransferToAccounting_RFBSK"
    description: "Status for Transfer to Accounting"
  - name: "BillingDate_FKDAT"
    description: "Billing Date"
  - name: "FiscalYear_GJAHR"
    description: "Fiscal Year"
  - name: "PostingPeriod_POPER"
    description: "Posting Period"
  - name: "RecordCreationDate_ERDAT"
    description: "Date in which the Record was Created"
  - name: "LastChangeDate_AEDAT"
    description: "Date of Last Change"
  - name: "CustomerGroup_KDGRP"
    description: "Customer Group"
  - name: "PaymentMethod_ZLSCH"
    description: "Payment Method"
  - name: "CompanyCode_BUKRS"
    description: "Company Code"
  - name: "DunningKey_MSCHL"
    description: "Dunning Key"
  - name: "DunningBlock_MANSP"
    description: "Dunning Block"
  - name: "SoldToParty_KUNAG"
    description: "Sold-To Party"
  - name: "AccrualBillingType_FKART"
    description: "Billing Type"
  - name: "AccountingDocumentNumber_BELNR"
    description: "Accounting Document Number"
  - name: "ShippingConditions_VSBED"
    description: "Shipping Conditions"
  - name: "SdDocumentCurrency_WAERK"
    description: "SD Document Currency"
  - name: "BusinessArea_GSBER"
    description: "Business Area"
  - name: "SalesDocumentItemCategory_PSTYV"
    description: "Sales Document Item Category"
  - name: "ItemType_POSAR"
    description: "Item Type"
  - name: "CostCenter_KOSTL"
    description: "Cost Center"
  - name: "SalesGroup_VKGRP"
    description: "Sales Group"
  - name: "SalesOffice_VKBUR"
    description: "Sales Office"
  - name: "ProfitCenter_PRCTR"
    description: "Profit Center"
  - name: "ControllingArea_KOKRS"
    description: "Controlling Area"
  - name: "DocumentCategoryOfPrecedingSDDocument_VGTYP"
    description: "Document Category of Preceding SD Document"
  - name: "MaterialNumber_MATNR"
    description: "Material Number"
  - name: "PricingReferenceMaterial_PMATN"
    description: "Pricing Reference Material"
  - name: "BatchNumber_CHARG"
    description: "Batch Number"
  - name: "MaterialGroup_MATKL"
    description: "Material Group"
  - name: "ProductHierarchy_PRODH"
    description: "Product Hierarchy"
  - name: "Plant_WERKS"
    description: "Plant"
  - name: "MaterialPriceGroup_KONDM"
    description: "Material Price Group"
  - name: "StorageLocation_LGORT"
    description: "Storage Location"
  - name: "InternationalArticleNumber_EAN11"
    description: "International Article Number (EAN/UPC)"
  - name: "MaterialGroup1_MVGR1"
    description: "Material Group 1"
  - name: "MaterialGroup2_MVGR2"
    description: "Material Group 2"
  - name: "MaterialGroup3_MVGR3"
    description: "Material Group 3"
  - name: "MaterialGroup4_MVGR4"
    description: "Material Group 4"
  - name: "MaterialGroup5_MVGR5"
    description: "Material Group 5"
  - name: "BOMExplosionNumber_SERNR"
    description: "BOM Explosion Number"
  - name: "CustomerGroup1_KVGR1"
    description: "Customer Group 1"
  - name: "CustomerGroup2_KVGR2"
    description: "Customer Group 2"
  - name: "CustomerGroup3_KVGR3"
    description: "Customer Group 3"
  - name: "CustomerGroup4_KVGR4"
    description: "Customer Group 4"
  - name: "CustomerGroup5_KVGR5"
    description: "Customer Group 5"
  - name: "TaxJurisdiction_TXJCD"
    description: "Tax Jurisdiction"
  - name: "ShippingPointReceivingPoint_VSTEL"
    description: "Shipping Point/Receiving Point"
  - name: "DocumentNumberOfTheReferenceDocument_VGBEL"
    description: "Document Number of the Reference Document"
  - name: "ItemNumberOfTheReferenceItem_VGPOS"
    description: "Item Number of the Reference Item"
  - name: "SalesDocument_AUBEL"
    description: "Sales Document"
  - name: "SalesDocumentItem_AUPOS"
    description: "Sales Document Item"
  - name: "ActualBilledQuantity_FKIMG"
    description: "Actual Billed Quantity"
  - name: "Volume_VOLUM"
    description: "Volume"
  - name: "GrossWeight_BRGEW"
    description: "Gross Weight"
  - name: "NetWeight_NTGEW"
    description: "Net Weight"
  - name: "NumberOfTheDocumentCondition_KNUMV"
    description: "Number of the Document Condition"
  - name: "ConditionItemNumber_KPOSN"
    description: "Condition Item Number"
  - name: "YearOfBillingDate_FKDAT"
    description: "Year of Billing Date"
  - name: "MonthOfBillingDate_FKDAT"
    description: "Month of Billing Date"
  - name: "WeekOfBillingDate_FKDAT"
    description: "Week of Billing Date"
  - name: "DayOfBillingDate_FKDAT"
    description: "Day of Billing Date"
  - name: "NetValue_NETWR"
    description: "Net Value in Document Currency"
  - name: "TaxAmount_MWSBK"
    description: "Tax Amount in Document Currency"
  - name: "TaxAmountPos_MWSBP"
    description: "Tax Amount"
  - name: "Rebate"
    description: "Rebate amount returned for the billed item"
  - name: "YearOrderCount"
    description: "Total number of billing documents and items posted in a calendar year"
  - name: "MonthOrderCount"
    description: "Total number of billing documents and items posted in a calendar month"
  - name: "WeekOrderCount"
    description: "Total number of billing documents and items posted in a calendar week"