config/ecc/annotations/Deliveries.yaml [1:208]:
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
name: "{{ project_id_tgt }}.{{ dataset_reporting_tgt }}.Deliveries"
description: "This view provides detailed information of deliveries like delivery number, quantities, values, number of returned items and other related fields and indicators. This view has the granularity of Client(System), delivery number and item."
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: "CreatedBy_ERNAM"
    description: "Name of Person who Created the Object"
  - name: "CreateTime_ERZET"
    description: "Entry Time"
  - name: "DateCreated_ERDAT"
    description: "Date on which the record was created"
  - 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: "OrderCombinationIndicator_KZAZU"
    description: "Order Combination Indicator"
  - name: "PlannedGoodsMovementDate_WADAT"
    description: "Planned Goods Movement Date"
  - name: "LoadingDate_LDDAT"
    description: "Loading Date"
  - name: "TransportationPlanningDate_TDDAT"
    description: "Transportation Planning Date"
  - name: "DeliveryDate_LFDAT"
    description: "Delivery Date"
  - name: "DeliveryTime_LFUHR"
    description: "Time of Delivery"
  - name: "PickingDate_KODAT"
    description: "Picking 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: "DeliveryPriority_LPRIO"
    description: "Delivery Priority"
  - 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: "NetWeightHdr_NTGEW"
    description: "Net weight, Header Level"
  - name: "WeightUnitHdr_GEWEI"
    description: "Weight Unit, Header Level"
  - name: "VolumeHdr_VOLUM"
    description: "Volume, Header Level"
  - name: "VolumeUnitHdr_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: "WeightGroupForDelivery_GRULG"
    description: "Weight Group for Delivery"
  - name: "LoadingPoint_LSTEL"
    description: "Loading Point"
  - name: "TransportationGroupHdr_TRAGR"
    description: "Transportation Group, Header Level"
  - name: "ProposedBillingTypeForADeliveryRelatedBillingDoc_FKARV"
    description: "Proposed Billing Type for a Delivery-Related Billing Document"
  - name: "BillingDateForBillingIndexAndPrintout_FKDAT"
    description: "Billing Date For Billing Index And Printout"
  - name: "InvoiceDates_PERFK"
    description: "Invoice Dates (Calendar Identification)"
  - name: "Route_ROUTA"
    description: "Route"
  - name: "UpdateGroupForStatisticsHdr_STAFO"
    description: "Update Group for Statistics update"
  - name: "PricingProcedure_KALSM"
    description: "Procedure (Pricing, Output Control, Acct. Det., Costing,...)"
  - name: "NumberOfTheDocumentCondition_KNUMV"
    description: "Number of the Document Condition"
  - name: "SdDocumentCurrency_WAERK"
    description: "Sales and Delivery Document Currency"
  - name: "SalesOfficeHdr_VKBUR"
    description: "Sales Office"
  - name: "ShippingProcessingTimeForTheEntireDocument_VBEAK"
    description: "Shipping Processing Time for the Entire Document"
  - name: "CombinationCriteriaForDelivery_ZUKRL"
    description: "Combination Criteria for Delivery"
  - name: "DistributionDelivery_VERUR"
    description: "Distribution Delivery"
  - name: "CommunicationNumberForQApiInterface_COMMN"
    description: "Communication Number for Q-API Interface"
  - name: "StatisticsCurrency_STWAE"
    description: "Statistics Currency"
  - name: "ExchangeRateForStatistics_STCUR"
    description: "Exchange Rate for Statistics"
  - name: "NumberOfForeignTradeDataInMmAndSdDocuments_EXNUM"
    description: "Number of Foreign Trade Data in Material Movement and Sales and Delivery documents"
  - name: "NameOfPersonWhoChangedObjectHdr_AENAM"
    description: "Name of the Person who Changed Object"
  - name: "DateOfLastChangeHdr_AEDAT"
    description: "Date of Last Change"
  - name: "WarehouseNumberWarehouseComplex_LGNUM"
    description: "Warehouse Number/Warehouse Complex"
  - name: "DeliveryWithinOneWarehouse_LISPL"
    description: "Delivery within One Warehouse"
  - name: "SalesOrganizationForIntercompanyBilling_VKOIV"
    description: "Sales Organization for Intercompany Billing"
  - name: "DistributionChannelForIntercompanyBilling_VTWIV"
    description: "Distribution Channel for Intercompany Billing"
  - name: "DivisionForIntercompanyBilling_SPAIV"
    description: "Billing for Intercompany Billing"
  - name: "BillingTypeForIntercompanyBilling_FKAIV"
    description: "Billing Type for Intercompany Billing"
  - name: "DateForInterCompanyBilling_PIOIV"
    description: "Date for Intercompany Billing"
  - name: "BillingDateForInterCompanyBilling_FKDIV"
    description: "Billing Date for Intercompany Billing"
  - name: "CustomerNumberForInterCompanyBilling_KUNIV"
    description: "Customer Number for Intercompany Billing"
  - name: "CreditControlArea_KKBER"
    description: "Credit Control Area"
  - name: "CreditLimitReference_KNKLI"
    description: "Customer's Account Number with Credit Limit Reference"
  - name: "CustomerCreditGroup_GRUPP"
    description: "Customer Credit Group"
  - name: "CreditRepresentativeGroupForCreditManagement_SBGRP"
    description: "Credit Representative Group for Credit Management"
  - name: "CreditManagement_RiskCategory_CTLPC"
    description: "Credit Management: Risk Category"
  - name: "CurrencyKeyOfCreditControlArea_CMWAE"
    description: "Currency Key for Credit Control Area"
  - name: "ReleasedCreditValueOfTheDocument_AMTBL"
    description: "Released Credit Value of the Document"
  - name: "BillOfLading_BOLNR"
    description: "Bill of Lading"
  - name: "VendorsAccountNumber_LIFNR"
    description: "Account Number of Vendor or Creditor"
  - name: "MeansOfTransportType_TRATY"
    description: "Means-of-Transport Type"
  - name: "MeansOfTransportId_TRAID"
    description: "Means of Transport ID"
  - name: "ReleaseDateOfTheDocumentDeterminedByCreditManagement_CMFRE"
    description: "Release Date of the Document Determined by Credit Management"
  - name: "NextDate_CMNGV"
    description: "Next Date"
  - name: "GoodsReceiptissueSlipNumber_XABLN"
    description: "Goods Receipt/Issue Slip Number"
  - name: "DocumentDateInDocument_BLDAT"
    description: "Document Date in Document"
  - name: "ActualGoodsMovementDate_WADAT_IST"
    description: "Actual Goods Movement Date"
  - name: "ShipmentBlockingReason_TRSPG"
    description: "Shipment Blocking Reason"
  - name: "IdForExternalTransportSystem_TPSID"
    description: "ID for External Transport System"
  - name: "ExternalIdentificationOfDeliveryNote_LIFEX"
    description: "External Identification of Delivery"
  - name: "OrderNumber_TERNR"
    description: "Order Number"
  - name: "SearchProcedureForBatchDetermination_KALSM_CH"
    description: "Search Procedure for Batch Determination"
  - name: "CorrectionDelivery_KLIEF"
    description: "Correction Delivery"
  - name: "Shipping_PricingProcedure_KALSP"
    description: "Shipping: Pricing Procedure"
  - name: "NumberOfDocumentConditionPricing_KNUMP"
    description: "Number of Document Condition - Pricing"
  - name: "RouteSchedule_AULWE"
    description: "Route Schedule"
  - name: "ReceivingPlantForDeliveries_WERKS"
    description: "Receiving Plant"
  - name: "FinancialDocNumber_LCNUM"
    description: "Financial Document Processing: Internal Financial Document Number"
  - name: "PaymentGuaranteeProcedure_ABSSC"
    description: "Paymt Guarantee Procedure"
  - name: "PickingTime_KOUHR"
    description: "Picking Time (Local Time, with Reference to a Plant)"
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -



config/s4/annotations/Deliveries.yaml [1:208]:
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
name: "{{ project_id_tgt }}.{{ dataset_reporting_tgt }}.Deliveries"
description: "This view provides detailed information of deliveries like delivery number, quantities, values, number of returned items and other related fields and indicators. This view has the granularity of Client(System), delivery number and item."
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: "CreatedBy_ERNAM"
    description: "Name of Person who Created the Object"
  - name: "CreateTime_ERZET"
    description: "Entry Time"
  - name: "DateCreated_ERDAT"
    description: "Date on which the record was created"
  - 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: "OrderCombinationIndicator_KZAZU"
    description: "Order Combination Indicator"
  - name: "PlannedGoodsMovementDate_WADAT"
    description: "Planned Goods Movement Date"
  - name: "LoadingDate_LDDAT"
    description: "Loading Date"
  - name: "TransportationPlanningDate_TDDAT"
    description: "Transportation Planning Date"
  - name: "DeliveryDate_LFDAT"
    description: "Delivery Date"
  - name: "DeliveryTime_LFUHR"
    description: "Time of Delivery"
  - name: "PickingDate_KODAT"
    description: "Picking 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: "DeliveryPriority_LPRIO"
    description: "Delivery Priority"
  - 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: "NetWeightHdr_NTGEW"
    description: "Net weight, Header Level"
  - name: "WeightUnitHdr_GEWEI"
    description: "Weight Unit, Header Level"
  - name: "VolumeHdr_VOLUM"
    description: "Volume, Header Level"
  - name: "VolumeUnitHdr_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: "WeightGroupForDelivery_GRULG"
    description: "Weight Group for Delivery"
  - name: "LoadingPoint_LSTEL"
    description: "Loading Point"
  - name: "TransportationGroupHdr_TRAGR"
    description: "Transportation Group, Header Level"
  - name: "ProposedBillingTypeForADeliveryRelatedBillingDoc_FKARV"
    description: "Proposed Billing Type for a Delivery-Related Billing Document"
  - name: "BillingDateForBillingIndexAndPrintout_FKDAT"
    description: "Billing Date For Billing Index And Printout"
  - name: "InvoiceDates_PERFK"
    description: "Invoice Dates (Calendar Identification)"
  - name: "Route_ROUTA"
    description: "Route"
  - name: "UpdateGroupForStatisticsHdr_STAFO"
    description: "Update Group for Statistics update"
  - name: "PricingProcedure_KALSM"
    description: "Procedure (Pricing, Output Control, Acct. Det., Costing,...)"
  - name: "NumberOfTheDocumentCondition_KNUMV"
    description: "Number of the Document Condition"
  - name: "SdDocumentCurrency_WAERK"
    description: "Sales and Delivery Document Currency"
  - name: "SalesOfficeHdr_VKBUR"
    description: "Sales Office"
  - name: "ShippingProcessingTimeForTheEntireDocument_VBEAK"
    description: "Shipping Processing Time for the Entire Document"
  - name: "CombinationCriteriaForDelivery_ZUKRL"
    description: "Combination Criteria for Delivery"
  - name: "DistributionDelivery_VERUR"
    description: "Distribution Delivery"
  - name: "CommunicationNumberForQApiInterface_COMMN"
    description: "Communication Number for Q-API Interface"
  - name: "StatisticsCurrency_STWAE"
    description: "Statistics Currency"
  - name: "ExchangeRateForStatistics_STCUR"
    description: "Exchange Rate for Statistics"
  - name: "NumberOfForeignTradeDataInMmAndSdDocuments_EXNUM"
    description: "Number of Foreign Trade Data in Material Movement and Sales and Delivery documents"
  - name: "NameOfPersonWhoChangedObjectHdr_AENAM"
    description: "Name of the Person who Changed Object"
  - name: "DateOfLastChangeHdr_AEDAT"
    description: "Date of Last Change"
  - name: "WarehouseNumberWarehouseComplex_LGNUM"
    description: "Warehouse Number/Warehouse Complex"
  - name: "DeliveryWithinOneWarehouse_LISPL"
    description: "Delivery within One Warehouse"
  - name: "SalesOrganizationForIntercompanyBilling_VKOIV"
    description: "Sales Organization for Intercompany Billing"
  - name: "DistributionChannelForIntercompanyBilling_VTWIV"
    description: "Distribution Channel for Intercompany Billing"
  - name: "DivisionForIntercompanyBilling_SPAIV"
    description: "Billing for Intercompany Billing"
  - name: "BillingTypeForIntercompanyBilling_FKAIV"
    description: "Billing Type for Intercompany Billing"
  - name: "DateForInterCompanyBilling_PIOIV"
    description: "Date for Intercompany Billing"
  - name: "BillingDateForInterCompanyBilling_FKDIV"
    description: "Billing Date for Intercompany Billing"
  - name: "CustomerNumberForInterCompanyBilling_KUNIV"
    description: "Customer Number for Intercompany Billing"
  - name: "CreditControlArea_KKBER"
    description: "Credit Control Area"
  - name: "CreditLimitReference_KNKLI"
    description: "Customer's Account Number with Credit Limit Reference"
  - name: "CustomerCreditGroup_GRUPP"
    description: "Customer Credit Group"
  - name: "CreditRepresentativeGroupForCreditManagement_SBGRP"
    description: "Credit Representative Group for Credit Management"
  - name: "CreditManagement_RiskCategory_CTLPC"
    description: "Credit Management: Risk Category"
  - name: "CurrencyKeyOfCreditControlArea_CMWAE"
    description: "Currency Key for Credit Control Area"
  - name: "ReleasedCreditValueOfTheDocument_AMTBL"
    description: "Released Credit Value of the Document"
  - name: "BillOfLading_BOLNR"
    description: "Bill of Lading"
  - name: "VendorsAccountNumber_LIFNR"
    description: "Account Number of Vendor or Creditor"
  - name: "MeansOfTransportType_TRATY"
    description: "Means-of-Transport Type"
  - name: "MeansOfTransportId_TRAID"
    description: "Means of Transport ID"
  - name: "ReleaseDateOfTheDocumentDeterminedByCreditManagement_CMFRE"
    description: "Release Date of the Document Determined by Credit Management"
  - name: "NextDate_CMNGV"
    description: "Next Date"
  - name: "GoodsReceiptissueSlipNumber_XABLN"
    description: "Goods Receipt/Issue Slip Number"
  - name: "DocumentDateInDocument_BLDAT"
    description: "Document Date in Document"
  - name: "ActualGoodsMovementDate_WADAT_IST"
    description: "Actual Goods Movement Date"
  - name: "ShipmentBlockingReason_TRSPG"
    description: "Shipment Blocking Reason"
  - name: "IdForExternalTransportSystem_TPSID"
    description: "ID for External Transport System"
  - name: "ExternalIdentificationOfDeliveryNote_LIFEX"
    description: "External Identification of Delivery"
  - name: "OrderNumber_TERNR"
    description: "Order Number"
  - name: "SearchProcedureForBatchDetermination_KALSM_CH"
    description: "Search Procedure for Batch Determination"
  - name: "CorrectionDelivery_KLIEF"
    description: "Correction Delivery"
  - name: "Shipping_PricingProcedure_KALSP"
    description: "Shipping: Pricing Procedure"
  - name: "NumberOfDocumentConditionPricing_KNUMP"
    description: "Number of Document Condition - Pricing"
  - name: "RouteSchedule_AULWE"
    description: "Route Schedule"
  - name: "ReceivingPlantForDeliveries_WERKS"
    description: "Receiving Plant"
  - name: "FinancialDocNumber_LCNUM"
    description: "Financial Document Processing: Internal Financial Document Number"
  - name: "PaymentGuaranteeProcedure_ABSSC"
    description: "Paymt Guarantee Procedure"
  - name: "PickingTime_KOUHR"
    description: "Picking Time (Local Time, with Reference to a Plant)"
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -



