/*  Update AccountingDocumentSegmet.InvoiceYear
    by BSEG. REBZJ
*/

TRUNCATE TABLE stg1.sap.tmp_BSEG_InvoiceYear;

INSERT INTO stg1.sap.tmp_BSEG_InvoiceYear (
    GJAHR, BUKRS, BELNR, BUZEI, REBZJ
    ) SELECT * FROM OPENQUERY(sap, '
        SELECT GJAHR, BUKRS, BELNR, BUZEI, REBZJ
        FROM sapzrp.ZFIGL_EXPORT_BUF
        with ur;
        ')
;

WITH
    cte AS (
        SELECT CONVERT(INT, b.GJAHR) AS FiscalYear
            , c.CompanyID
            , CONVERT(BIGINT, BELNR) AS DocumentNumberInt
            , CONVERT(INT, BUZEI) AS OperPosition
            , CONVERT(INT, REBZJ) AS InvoiceYear
        FROM stg1.sap.tmp_BSEG_InvoiceYear AS b
            JOIN dwh.sap.Company AS c ON b.BUKRS = c.Code
                AND c.FlagOperation != 3
        )
UPDATE ads
SET ads.InvoiceYear = cte.InvoiceYear
FROM dwh.sap.AccountingDocumentSegment AS ads
    JOIN cte ON ads.DocumentNumberInt = cte.DocumentNumberInt
        AND ads.CompanyID = cte.CompanyId
        AND ads.OperPosition = cte.OperPosition
        AND ads.FiscalYear = cte.FiscalYear
OPTION (MAXDOP 2)
;