config/ecc/annotations/OrderToCash.yaml (238 lines of code) (raw):

name: "{{ project_id_tgt }}.{{ dataset_reporting_tgt }}.OrderToCash" description: "This view gives detailed insights on the KPIs related to the complete Order to Cash process, such as Delivered Value, Sales Order Quantities, On-Time Delivery, Fill Rate, Canceled Order, Order Cycle Time, On-Time Delivery, etc. The granularity is Client(System), delivery number, delivery item, sales order number, sales order item and language key." catalog_tags: - display_name: "line_of_business" fields: - display_name: "group" value: "Sales" - display_name: "domain" value: "Order to Cash" fields: - name: "Client_MANDT" description: "Client (Mandant), PK" - name: "Delivery_VBELN" description: "Delivery Number, PK" - name: "DeliveryItem_POSNR" description: "Delivery Item, PK" - name: "SalesDocument_VBELN" description: "Sales Document, PK" - name: "Item_POSNR" description: "Sales Document Item, PK" - name: "Language_SPRAS" description: "Material Language Key, PK" - name: "ActualQuantityDelivered_InSalesUnits_LFIMG" description: "Actual Quantity Delivered (in sales units)" - name: "BaseUoM_MEINS" description: "Base Unit of Measure" - name: "NetPrice_NETPR" description: "Net Price" - name: "NetValueInDocumentCurrency_NETWR" description: "Net Value in the Document Currency" - name: "DeliveryDocumentCurrency_WAERK" description: "Delivery Document Currency" - name: "DeliveryBlock_DocumentHeader_LIFSK" description: "Delivery Block (Document Header)" - name: "BillingBlockInSdDocument_FAKSK" description: "Billing Block in Sales and Delivery Document" - name: "Date__proofOfDelivery___PODAT" description: "Date (Proof of Delivery)" - name: "BillingDateForBillingIndexAndPrintout_FKDAT" description: "Billing Date For Billing Index And Printout" - name: "SalesOrderNumber" description: "Document Number of the Reference Document" - name: "DeliveryDate_LFDAT" description: "Delivery Date" - name: "ActualGoodsMovementDate_WADAT_IST" description: "Actual Goods Movement Date" - name: "ExchangeRateType_KURST" description: "Exchange Rate Type" - name: "Requesteddeliverydate_VDATU" description: "Requested Delivery Date" - name: "SalesOrderQty" description: "Cumulative Order Quantity in Sales Unit" - name: "BaseUnitofMeasure_MEINS" description: "Base Unit of Measure" - name: "SalesOrderNetPrice" description: "Sales Order Net Price for a unit of item" - name: "SalesOrderDocumentCurrency_WAERK" description: "Sales Order Document Currency" - name: "ShippingLocation" description: "Shipping Point/Receiving Point" - name: "SoldToParty_KUNNR" description: "Sold-To Customer" - name: "SoldToPartyItem_KUNNR" description: "Sold-to Party, Item Level" - name: "SoldToPartyItemName_KUNNR" description: "Sold-to Party Name, Item Level" - name: "ShipToPartyItem_KUNNR" description: "Ship-to Party, Item Level" - name: "ShipToPartyItemName_KUNNR" description: "Ship-to Party Name, Item Level" - name: "BillToPartyItem_KUNNR" description: "Bill-to Party, Item Level" - name: "BillToPartyItemName_KUNNR" description: "Bill-to Party Name, Item Level" - name: "PayerItem_KUNNR" description: "Payer, Item Level" - name: "PayerItemName_KUNNR" description: "Payer Name, Item Level" - name: "SoldToPartyHeader_KUNNR" description: "Sold-to Party, Header Level" - name: "SoldToPartyHeaderName_KUNNR" description: "Sold-to Party Name, Header Level" - name: "ShipToPartyHeader_KUNNR" description: "Ship-to Party, Header Level" - name: "ShipToPartyHeaderName_KUNNR" description: "Ship-to Party Name, Header Level" - name: "BillToPartyHeader_KUNNR" description: "Bill-to Party, Header Level" - name: "BillToPartyHeaderName_KUNNR" description: "Bill-to Party, Header Level" - name: "PayerHeader_KUNNR" description: "Payer, Header Level" - name: "PayerHeaderName_KUNNR" description: "Payer Name, Header Level" - name: "SalesOrganization" description: "Sales Organization" - name: "DistributionChannel" description: "Distribution Channel" - name: "DeliveryStatus" description: "Overall Delivery Status (All Items)" - name: "ListPrice" description: "Headline Price offered to the customers before any discounts, as suggested by the manufacturers" - name: "AdjustedPrice" description: "The Price of the item valuated after the costs incurred and margins included" - name: "InterCompanyPrice" description: "Inter Company Price or Transfer price is the prices charged for the items exchanged between the companies within the same company groups" - name: "Discount" description: "Discount is the reduction in the list price offered to customer, by the company" - name: "ConfirmedOrderQuantity_BMENG" description: "Confirmed Order Quantity for the item" - name: "SalesUnitMeasure" description: "Sales Unit Measure" - name: "CreationDate_ERDAT" description: "Date on which the Sales Order Record was Created" - name: "DocumentCategory_VBTYP" description: "Sales and Delivery Document Category" - name: "PrecedingDocCategory_VGTYP" description: "Document Category of Preceding Sales and Delivery Document" - name: "Documentnumberofthereferencedocument_VGBEL" description: "Document Number of the Reference Document" - name: "ReferenceItem_VGPOS" description: "Item Number of the Reference Item" - name: "RejectionReason_ABGRU" description: "Reason for Rejection of Sales Documents" - name: "CustomerNumber" description: "Customer Number" - name: "CustomerName1" description: "Customer Name 1" - name: "CustomerName2" description: "Customer Name 2" - name: "City" description: "City" - name: "Country" description: "Country Key" - name: "PostalCode" description: "Postal Code" - name: "CustomerRegion" description: "Customer Region (State, Province, Country)" - name: "CustomerAddress" description: "Customer Address" - name: "CustomerLanguage" description: "Customer Language Key" - name: "MaterialNumber" description: "Material Number" - name: "MaterialType" description: "Material Type" - name: "Division" description: "Division" - name: "ProductCategory" description: "Material Product Category" - name: "Brand" description: "Material Brand" - name: "MaterialDescription" description: "Material Description" - name: "BilledQty" description: "Actual Billed Quantity" - name: "BillingDocument_VBELN" description: "Billing Document" - name: "Rebate" description: "Rebate amount returned for the billed item" - name: "TaxAmount_MWSBK" description: "Tax amount" - name: "Volume_VOLUM" description: "Volume" - name: "GrossWeight_BRGEW" description: "Gross weight" - name: "BillingDate_FKDAT" description: "Billing Date" - name: "BillingItem_POSNR" description: "Billing Item" - name: "NetWeight_NTGEW" description: "Net weight" - name: "BillingNetValue" description: "Billing Net Value" - name: "BillingDOcumentCurrency_WAERK" description: "Billing Document Currency" - name: "SalesOrganizationName" description: "Sales Organization Name" - name: "DistributionChannelName" description: "Distribution Channel Name" - name: "RegionDescription" description: "Country Name" - name: "OneTouchOrderCount" description: "One Touch Order Count" - name: "OneTouchOrders" description: "Total number of One Touch Orders processed" - name: "DivisionDescription" description: "Division Name" - name: "OverallProcessingStatus_GBSTK" description: "Overall Processing Status (Header/All Items)" - name: "DeliveryBlockReasonDescription" description: "Delivery Block Description" - name: "BillingBlockReasonDescription" description: "Billing Block Description" - name: "ReturnOrderDescription" description: "Return Order Description" - name: "DeliveredValue" description: "Net Price of the Delivered Items in Document Currency" - name: "Value" description: "Net Value of the Delivered Order items" - name: "SalesOrderNetValue" description: "Net Value of Sales Order Items in Document Currency" - name: "DeliveredNetValue" description: "Delivered Net Value for each Delivery Document Item" - name: "LateDeliveries" description: "Describes whether the Delivery document item was delivered on-time or not" - name: "BlockedSalesOrder" description: "Describes whether the Item is Blocked for Delivery and Billing" - name: "TotalOrders" description: "Total Number of Sales Orders created" - name: "TotalOrderItems" description: "Total Number of Sales Orders Items" - name: "TotalDeliveries" description: "Total Number of Delivery document items" - name: "SalesOrderQuantity" description: "Total Sales Order Quantity for each item in a Sales Order Document" - name: "SalesOrderValue" description: "Sales Order Value for each item in a Sales Order Document" - name: "IncomingOrderNum" description: "Count of Incoming Orders" - name: "InFullDelivery" description: "Describes whether the current item of the sales order is delivered in-full (Sales order quantity is matching the delivered quantity for the given item)" - name: "OTIF" description: "Describes whether the current item of the sales order is delivered on-time as well as in-full" - name: "FillRatePercent" description: "The percentage of order that is immediately fulfilled by the available stock for a sales order item" - name: "BackOrder" description: "Describes if the item is part of back order (Supplier needs time to procure the items to complete the in-full delivery)" - name: "OpenOrder" description: "Describes if the current sales order for the item is open (Some items from the sales order are yet to be delivered)" - name: "ReturnOrder" description: "Describes whether the customer has returned certain items from the sales order" - name: "CanceledOrder" description: "Describes whether a sales order item has been rejected" - name: "OrderCycleTimeInDays" description: "The time in days taken to deliver the items measured from the date the sales order was created" - name: "OnTimeDelivery" description: "Describes whether the item was delivered without any delay from the estimated delivery schedule"