config/ecc/annotations/DeliveriesStatus_PerSalesOrg.yaml

name: "{{ project_id_tgt }}.{{ dataset_reporting_tgt }}.DeliveriesStatus_PerSalesOrg"
description: "This view gives a detailed information about the deliveries with respect to the sales organizations along with various indicators and metrics like delivered quantities, related dates, etc. This view has a granularity of Client(System), delivery number, delivery item and language key."
catalog_tags:
  - display_name: "line_of_business"
    fields:
      - display_name: "group"
        value: "Sales"
      - display_name: "domain"
        value: "Distribution"
fields:
  - name: "Client_MANDT"
    description: "Client (Mandant), PK"
  - name: "Delivery_VBELN"
    description: "Delivery Number, PK"
  - name: "DeliveryItem_POSNR"
    description: "Delivery Item, PK"
  - name: "Language_SPRAS"
    description: "Language Key, PK"
  - name: "SalesDistrict_BZIRK"
    description: "Sales District"
  - name: "ShippingPointreceivingPoint_VSTEL"
    description: "Shipping Point/Receiving Point"
  - name: "SalesOrganization_VKORG"
    description: "Sales Organization"
  - name: "DeliveryType_LFART"
    description: "Delivery Type"
  - name: "CompleteDeliveryDefinedForEachSalesOrder_AUTLF"
    description: "Complete Delivery defined for each Sales Order?"
  - name: "ActualQuantityDeliveredInStockkeepingUnits_LGMNG"
    description: "Actual Delivered Quantity in Stockkeeping units"
  - name: "BaseUnitOfMeasure_MEINS"
    description: "Base Unit of Measure"
  - name: "LoadingDate_LDDAT"
    description: "Loading Date"
  - name: "TransportationPlanningDate_TDDAT"
    description: "Transportation Planning Date"
  - name: "DeliveryDate_LFDAT"
    description: "Delivery Date"
  - name: "UnloadingPoint_ABLAD"
    description: "Unloading Point"
  - name: "Incoterms__part1___INCO1"
    description: "Incoterms (Part 1)"
  - name: "Incoterms__part2___INCO2"
    description: "Incoterms (Part 2)"
  - name: "ExportIndicator_EXPKZ"
    description: "Export Indicator"
  - name: "Route_ROUTE"
    description: "Route"
  - name: "BillingBlockInSdDocument_FAKSK"
    description: "Billing Block in Sales and Delivery Document"
  - name: "DeliveryBlock_documentHeader_LIFSK"
    description: "Delivery Block (Document Header)"
  - name: "SdDocumentCategory_VBTYP"
    description: "Sales and Delivery Document Category"
  - name: "CustomerFactoryCalendar_KNFAK"
    description: "Customer Factory Calendar"
  - name: "ShippingConditions_VSBED"
    description: "Shipping Conditions"
  - name: "ShipToParty_KUNNR"
    description: "Ship-To Party"
  - name: "SoldToParty_KUNAG"
    description: "Sold-To Party"
  - name: "CustomerGroup_KDGRP"
    description: "Customer Group"
  - name: "TotalWeight_BTGEW"
    description: "Total Weight"
  - name: "NetWeight_NTGEW"
    description: "Net weight, Header Level"
  - name: "WeightUnit_GEWEI"
    description: "Weight Unit, Header Level"
  - name: "VolumeUnit_VOLEH"
    description: "Volume Unit, Header Level"
  - name: "TotalNumberOfPackagesInDelivery_ANZPK"
    description: "Total Number of Packages in Delivery"
  - name: "PickedItemsLocation_BEROT"
    description: "Picked Items Location"
  - name: "TimeOfDelivery_LFUHR"
    description: "Time of Delivery"
  - name: "LoadingPoint_LSTEL"
    description: "Loading Point"
  - name: "SdDocumentCurrency_WAERK"
    description: "Sales and Delivery Document Currency"
  - name: "ShippingProcessingTimeForTheEntireDocument_VBEAK"
    description: "Shipping Processing Time for the Entire Document"
  - name: "DateOfLastChange_AEDAT"
    description: "Date of Last Change"
  - name: "DocumentDateInDocument_BLDAT"
    description: "Document Date in Document"
  - name: "ReferenceDocumentNumber_XBLNR"
    description: "Reference Document Number"
  - name: "Date__proofOfDelivery___PODAT"
    description: "Date (Proof of Delivery)"
  - name: "MaterialNumber_MATNR"
    description: "Material Number"
  - name: "MaterialGroup_MATKL"
    description: "Material Group"
  - name: "Plant_WERKS"
    description: "Plant"
  - name: "StorageLocation_LGORT"
    description: "Storage Location"
  - name: "SalesOrgCurrency_WAERS"
    description: "Sales Organization Currency Key"
  - name: "SalesOrgName_VTEXT"
    description: "Name of Sales Organization"
  - name: "Country_LAND1"
    description: "Country Key"
  - name: "Delivery_Status"
    description: "Delivery Status (Indicates whether the delivery for the sales order item is processed)"
  - name: "is_return"
    description: "Indicator: Whether the given item has been returned or not"
  - name: "Delivery_StatusItm"
    description: "Delivery Status (Indicates whether the delivery is processed or not)"