name: "{{ project_id_tgt }}.{{ dataset_reporting_tgt }}.POOrderHistory"
description: "This view shows detailed Purchasing Document history, including order details, ordered quantities, amounts, material and plant data, etc. This view has a granularity of Client(System), purchasing document number, item, sequential number for account assignment, transaction type, material document year, number of material document and item of material document."
catalog_tags:
  - display_name: "line_of_business"
    fields:
      - display_name: "group"
        value: "Supply Chain"
      - display_name: "domain"
        value: "Procurement"
fields:
  - name: "Client_MANDT"
    description: "Client (Mandant), PK"
  - name: "PurchasingDocumentNumber_EBELN"
    description: "Purchasing Document Number, PK"
  - name: "ItemNumberOfPurchasingDocument_EBELP"
    description: "Item Number of Purchasing Document, PK"
  - name: "SequentialNumberOfAccountAssignment_ZEKKN"
    description: "Sequential Number of Account Assignment, PK"
  - name: "TransactioneventType_VGABE"
    description: "Transaction/Event Type, purchase Order History, PK"
  - name: "MaterialDocumentYear_GJAHR"
    description: "Material Document Year, PK"
  - name: "NumberOfMaterialDocument_BELNR"
    description: "Number of Material Document, PK"
  - name: "ItemInMaterialDocument_BUZEI"
    description: "Item in Material Document, PK"
  - name: "VendorAccountNumber_LIFNR"
    description: "Account Number of Vendor or Creditor"
  - name: "PurchaseOrderHistoryCategory_BEWTP"
    description: "PO History Category"
  - name: "MovementType__inventoryManagement___BWART"
    description: "Movement Type (Inventory Management)"
  - name: "PostingDateInTheDocument_BUDAT"
    description: "Posting Date in the Document"
  - name: "Quantity_MENGE"
    description: "Quantity"
  - name: "QuantityInPurchaseOrderPriceUnit_BPMNG"
    description: "Quantity in purchase Order"
  - name: "CurrencyKey_WAERS"
    description: "Currency Key"
  - name: "GoodsReceiptBlockedStockInOrderUnit_WESBS"
    description: "Goods Receipt Blocked Stock in Order Unit"
  - name: "QuantityInGrBlockedStockInOrderPriceUnit_BPWES"
    description: "Quantity in Goods Receipt Blocked Stock in Order Price Unit"
  - name: "DebitcreditIndicator_SHKZG"
    description: "Debit/Credit Indicator"
  - name: "ValuationType_BWTAR"
    description: "Valuation Type"
  - name: "deliveryCompleted_ELIKZ"
    description: "'Delivery Completed' Indicator"
  - name: "ReferenceDocumentNumber_XBLNR"
    description: "Reference Document Number"
  - name: "FiscalYearOfAReferenceDocument_LFGJA"
    description: "Fiscal Year of Reference Document"
  - name: "DocumentNoOfAReferenceDocument_LFBNR"
    description: "Document Number of a Reference Document"
  - name: "ItemOfAReferenceDocument_LFPOS"
    description: "Item of a Reference Document"
  - name: "ReasonForMovement_GRUND"
    description: "Reason for Movement"
  - name: "DayOnWhichAccountingDocumentWasEntered_CPUDT"
    description: "Day On Which Accounting Document Was Entered"
  - name: "TimeOfEntry_CPUTM"
    description: "Time of Entry"
  - name: "ComplianceWithShippingInstructions_EVERE"
    description: "Compliance with Shipping Instructions"
  - name: "InvoiceValueInForeignCurrency_REFWR"
    description: "Invoice Value in Foreign Currency"
  - name: "MaterialNumber_MATNR"
    description: "Material Number"
  - name: "Plant_WERKS"
    description: "Plant"
  - name: "ReversalOfGrAllowedForGrBasedIvDespiteInvoice_XWSBR"
    description: "Reversal of GR allowed for GR-based IV despite invoice"
  - name: "SequentialNumberOfVendorConfirmation_ETENS"
    description: "Sequential Number of Vendor Confirmation"
  - name: "NumberOfTheDocumentCondition_KNUMV"
    description: "Number of the Document Condition "
  - name: "TaxOnSalespurchasesCode_MWSKZ"
    description: "Tax on Sales/Purchases Code"
  - name: "QuantityInUnitOfMeasureFromDeliveryNote_LSMNG"
    description: "Quantity in Unit of Measure from Delivery Note"
  - name: "UnitOfMeasureFromDeliveryNote_LSMEH"
    description: "Unit of Measure from Delivery Note"
  - name: "MaterialNumber_EMATN"
    description: "Material Number"
  - name: "LocalCurrencyKey_HSWAE"
    description: "Local Currency Key"
  - name: "Quantity_BAMNG"
    description: "Quantity"
  - name: "BatchNumber_CHARG"
    description: "Batch Number"
  - name: "DocumentDateInDocument_BLDAT"
    description: "Document Date in Document"
  - name: "CalculationOfValOpen_XWOFF"
    description: "Calculation of Valu. open"
  - name: "UnplannedAccountAssignmentFromInvoiceVerification_XUNPL"
    description: "Unplanned Account Assignment from Invoice Verification"
  - name: "NameOfPersonWhoCreatedTheObject_ERNAM"
    description: "Name of Person who Created the Object"
  - name: "ServiceNumber_SRVPOS"
    description: "Service Number"
  - name: "PackageNumberOfService_PACKNO"
    description: "Package Number of Service"
  - name: "LineNumberOfService_INTROW"
    description: "Line Number of Service"
  - name: "NumberOfPoAccountAssignment_BEKKN"
    description: "Number of Purchase Order Account Assignment"
  - name: "ReturnsIndicator_LEMIN"
    description: "Returns Indicator"
  - name: "ClearingValueOnGrirAccountInPoCurrency_AREWB"
    description: "Clearing Value on Goods Receipt/Invoice Receipt Account in Purchase Order Currency"
  - name: "InvoiceAmountInPoCurrency_REWRB"
    description: "Invoice Amount in Purchase Order Currency"
  - name: "SapRelease_SAPRL"
    description: "SAP Release"
  - name: "Quantity_MENGE_POP"
    description: "Quantity"
  - name: "QuantityInPurchaseOrderPriceUnit_BPMNG_POP"
    description: "Quantity in Purchase Order Price Unit"
  - name: "AmountInLocalCurrency_DMBTR_POP"
    description: "Amount in Local Currency"
  - name: "AmountInDocumentCurrency_WRBTR_POP"
    description: "Amount in Document Currency"
  - name: "ValuatedGoodsReceiptBlockedStockInOrderUnit_WESBB"
    description: "Valuated Goods Receipt Blocked Stock in Order Unit"
  - name: "QuantityInValuatedGrBlockedStockInOrderPriceUnit_BPWEB"
    description: "Quantity in Valuated Goods Receipt Blocked Stock in Order Price Unit"
  - name: "AcceptanceAtOrigin_WEORA"
    description: "Acceptance at Origin"
  - name: "GrirAccountClearingValueInLocalCurrency_AREWR_POP"
    description: "Goods Receipt/Invoice Receipt Account Clearing Value in Local Currency"
  - name: "ExchangeRateDifferenceAmount_KUDIF"
    description: "Exchange Rate Difference Amount"
  - name: "RetentionAmountInDocumentCurrency_RETAMT_FC"
    description: "Retention Amount in Document Currency"
  - name: "RetentionAmountInCompanyCodeCurrency_RETAMT_LC"
    description: "Retention Amount in Company Code Currency"
  - name: "PostedRetentionAmountInDocumentCurrency_RETAMTP_FC"
    description: "Posted Retention Amount in Document Currency"
  - name: "PostedSecurityRetentionAmountInCompanyCodeCurrency_RETAMTP_LC"
    description: "Posted Security Retention Amount in Company Code Currency"
  - name: "MultipleAccountAssignment_XMACC"
    description: "Multiple Account Assignment"
  - name: "ExchangeRate_WKURS"
    description: "Exchange Rate"
  - name: "OriginOfAnInvoiceItem_INV_ITEM_ORIGIN"
    description: "Origin of an Invoice Item"
  - name: "Delivery_VBELN_ST"
    description: "Delivery"
  - name: "DeliveryItem_VBELP_ST"
    description: "Delivery Item"
  - name: "StockSegment_SGT_SCAT"
    description: "Stock Segment"
  - name: "ProcedureForUpdatingTheScheduleLineQuantity_ET_UPD"
    description: "Procedure for Updating the Schedule Line Quantity"
  - name: "DepreciationCompletionFlag_J_SC_DIE_COMP_F"
    description: "Depreciation Completion Flag"
  - name: "CharacteristicValue1_WRF_CHARSTC1"
    description: "Characteristic Value 1"
  - name: "CharacteristicValue2_WRF_CHARSTC2"
    description: "Characteristic Value 2"
  - name: "CharacteristicValue3_WRF_CHARSTC3"
    description: "Characteristic Value 3"
  - name: "YearOfPostingDateInTheDocument_BUDAT"
    description: "Year of Posting Date in the Document"
  - name: "MonthOfPostingDateInTheDocument_BUDAT"
    description: "Year of Posting Date in the Document"
  - name: "WeekOfPostingDateInTheDocument_BUDAT"
    description: "Week of Posting Date in the Document"
  - name: "QuarterOfPostingDateInTheDocument_BUDAT"
    description: "Quarter of Posting Date in the Document"
  - name: "YearOfDocumentDateInDocument_BLDAT"
    description: "Year of Document Date in the Document"
  - name: "MonthOfDocumentDateInDocument_BLDAT"
    description: "Month of Document Date in the Document"
  - name: "WeekOfDocumentDateInDocument_BLDAT"
    description: "Week of Document Date in the Document"
  - name: "QuarterOfDocumentDateInDocument_BLDAT"
    description: "Quarter of Document Date in the Document"
  - name: "AmountInLocalCurrency_DMBTR"
    description: "Amount in Local Currency"
  - name: "AmountInDocumentCurrency_WRBTR"
    description: "Amount in Document Currency"
  - name: "GrirAccountClearingValueInLocalCurrency_AREWR"
    description: "Goods Receipt/Invoive Receipt Account Clearing Value in Local Currency"
  - name: "InvoiceValueEntered__inLocalCurrency___REEWR"
    description: "Invoice Value Entered (in Local Currency)"
  - name: "ClearingValueOnGrirClearingAccount__transacCurrency___AREWW"
    description: "Clearing Value on Goods Receipt/Invoive Receipt Clearing Account (Transactional Currency)"
