R_IncgOutgInvoiceTP

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view R_IncgOutgInvoiceTP.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW R_IncgOutgInvoiceTP AS
SELECT
  _SupplierInvoice.outgoinginvoiceuuid AS OutgoingInvoiceUUID,
  _SupplierInvoice.accountingdocument AS AccountingDocument,
  _SupplierInvoice.companycode AS CompanyCode,
  _SupplierInvoice.invoicingparty AS InvoicingParty,
  _SupplierInvoice.customer AS Customer,
  _SupplierInvoice.documentreferenceid AS DocumentReferenceID,
  _SupplierInvoice.accountingdocumentheadertext AS AccountingDocumentHeaderText,
  _SupplierInvoice.totalamountintransactioncrcy AS TotalAmountInTransactionCrcy,
  _SupplierInvoice.transactioncurrency AS TransactionCurrency,
  _SupplierInvoice.reconciliationaccount AS ReconciliationAccount,
  _SupplierInvoice.assignmentreference AS AssignmentReference,
  _SupplierInvoice.postingdate AS PostingDate,
  _SupplierInvoice.invoicedate AS InvoiceDate,
  _SupplierInvoice.fiscalyear AS FiscalYear,
  _SupplierInvoice.supplierbanktype AS SupplierBankType,
  _SupplierInvoice.iban AS IBAN,
  _SupplierInvoice.swiftcode AS SWIFTCode,
  _SupplierInvoice.paymentterms AS PaymentTerms,
  _SupplierInvoice.paymentmethod AS PaymentMethod,
  _SupplierInvoice.paymentreference AS PaymentReference,
  _SupplierInvoice.cashdiscount1days AS CashDiscount1Days,
  _SupplierInvoice.cashdiscount1percent AS CashDiscount1Percent,
  _SupplierInvoice.cashdiscount2days AS CashDiscount2Days,
  _SupplierInvoice.cashdiscount2percent AS CashDiscount2Percent,
  _SupplierInvoice.netpaymentdays AS NetPaymentDays,
  _SupplierInvoice.housebank AS HouseBank,
  _SupplierInvoice.housebankaccount AS HouseBankAccount,
  _SupplierInvoice.manualcashdiscount AS ManualCashDiscount,
  _SupplierInvoice.paymentmethodsupplement AS PaymentMethodSupplement,
  _SupplierInvoice.suplrinvcpaymentblockingreason AS SuplrInvcPaymentBlockingReason,
  _SupplierInvoice.taxdeterminationdate AS TaxDeterminationDate,
  _SupplierInvoice.outgoinginvoicestatus AS OutgoingInvoiceStatus,
  _SupplierInvoice.supplierinvoicetransactiontype AS SupplierInvoiceTransactionType,
  _SupplierInvoice.accountingdocumenttype AS AccountingDocumentType,
  _SupplierInvoice.paymentblockingreason AS PaymentBlockingReason,
  _SupplierInvoice.duecalculationbasedate AS DueCalculationBaseDate,
  _SupplierInvoice.cashdiscountamount AS CashDiscountAmount,
  _SupplierInvoice.eligibleamountforcshdiscintc AS EligibleAmountForCshDiscInTC,
  _SupplierInvoice.invoicereference AS InvoiceReference,
  _SupplierInvoice.invoiceitemreference AS InvoiceItemReference,
  _SupplierInvoice.dataexchangeinstruction1 AS DataExchangeInstruction1,
  _SupplierInvoice.dataexchangeinstruction2 AS DataExchangeInstruction2,
  _SupplierInvoice.dataexchangeinstruction3 AS DataExchangeInstruction3,
  _SupplierInvoice.dataexchangeinstruction4 AS DataExchangeInstruction4,
  _SupplierInvoice.paymentdifferencereason AS PaymentDifferenceReason,
  _SupplierInvoice.fixedcashdiscount AS FixedCashDiscount,
  _SupplierInvoice.documentitemtext AS DocumentItemText,
  _SupplierInvoice.businessarea AS BusinessArea,
  _SupplierInvoice.partnerbusinessarea AS PartnerBusinessArea,
  _SupplierInvoice.treasurycontract AS TreasuryContract,
  _SupplierInvoice.treasurycontracttype AS TreasuryContractType,
  _SupplierInvoice.reference1idbybusinesspartner AS Reference1IDByBusinessPartner,
  _SupplierInvoice.reference2idbybusinesspartner AS Reference2IDByBusinessPartner,
  _SupplierInvoice.reference3idbybusinesspartner AS Reference3IDByBusinessPartner,
  _SupplierInvoice.statecentralbankpaymentreason AS StateCentralBankPaymentReason,
  _SupplierInvoice.supplyingcountry AS SupplyingCountry,
  _SupplierInvoice.recrrgsuplrinvcissrvcinvoice AS RecrrgSuplrInvcIsSrvcInvoice,
  _SupplierInvoice.fintransflowtype AS FinTransFlowType,
  _SupplierInvoice.creditcontrolarea AS CreditControlArea,
  _SupplierInvoice.companycodecountry AS ReportingCountry,
  _SupplierInvoice.iseutriangulardeal AS IsEUTriangularDeal,
  _SupplierInvoice.planninglevel AS PlanningLevel,
  _SupplierInvoice.planningdate AS PlanningDate,
  _SupplierInvoice.isnegativeposting AS IsNegativePosting,
  _SupplierInvoice.taxreportingdate AS TaxReportingDate,
  _SupplierInvoice.taxfulfillmentdate AS TaxFulfillmentDate,
  _SupplierInvoice.taxcountry AS TaxCountry,
  _SupplierInvoice.exchangerate AS ExchangeRate,
  _SupplierInvoice.raitemtranslationdate AS RAItemTranslationDate,
  _SupplierInvoice.createdbyuser AS CreatedByUser,
  _SupplierInvoice.username AS UserName,
  _SupplierInvoice.creationdatetime AS CreationDateTime,
  _SupplierInvoice.lastchangedbyuser AS LastChangedByUser,
  _SupplierInvoice.lastchangedatetime AS LastChangeDateTime,
  _SupplierInvoice.businessplace AS BusinessPlace,
  _SupplierInvoice.businesssectioncode AS BusinessSectionCode,
  _SupplierInvoice.invoicereferencefiscalyear AS InvoiceReferenceFiscalYear,
  _SupplierInvoice.creationdate AS CreationDate,
  _SupplierInvoice.finplanapplicationloghandle AS FinPlanApplicationLogHandle,
  _SupplierInvoice.eventhandlertypedescription AS EventHandlerTypeDescription,
  _SupplierInvoice.uploadbatchuuid AS BatchUUID,
  _SupplierInvoice.documentsequenceno AS ExtractedItemIndex,
  _SupplierInvoice.onetimeaccountbpsalutationtext AS OneTimeAccountBPSalutationText,
  _SupplierInvoice.businesspartnername1 AS BusinessPartnerName1,
  _SupplierInvoice.businesspartnername2 AS BusinessPartnerName2,
  _SupplierInvoice.businesspartnername3 AS BusinessPartnerName3,
  _SupplierInvoice.businesspartnername4 AS BusinessPartnerName4,
  _SupplierInvoice.streetname AS StreetName,
  _SupplierInvoice.cityname AS CityName,
  _SupplierInvoice.postalcode AS PostalCode,
  _SupplierInvoice.pobox AS POBox,
  _SupplierInvoice.poboxiswithoutnumber AS POBoxIsWithoutNumber,
  _SupplierInvoice.poboxpostalcode AS POBoxPostalCode,
  _SupplierInvoice.country AS Country,
  _SupplierInvoice.region AS Region,
  _SupplierInvoice.emailaddress AS EmailAddress,
  _SupplierInvoice.bankcountry AS BankCountry,
  _SupplierInvoice.bankinternalid AS BankInternalID,
  _SupplierInvoice.bankaccount AS BankAccount,
  _SupplierInvoice.bankreference AS BankReference,
  _SupplierInvoice.bankcontrolkey AS BankControlKey,
  _SupplierInvoice.paymentsystem AS PaymentSystem,
  _SupplierInvoice.aliastype AS AliasType,
  _SupplierInvoice.bpbankaccountaliasname AS BPBankAccountAliasName,
  _SupplierInvoice.isvatliable AS IsVATLiable,
  _SupplierInvoice.accounttaxtype AS AccountTaxType,
  _SupplierInvoice.taxnumbertype AS TaxNumberType,
  _SupplierInvoice.taxid1 AS TaxID1,
  _SupplierInvoice.taxid2 AS TaxID2,
  _SupplierInvoice.taxid3 AS TaxID3,
  _SupplierInvoice.taxid4 AS TaxID4,
  _SupplierInvoice.taxid5 AS TaxID5,
  _SupplierInvoice.vatregistration AS VATRegistration,
  _SupplierInvoice.isnaturalperson AS IsNaturalPerson,
  _SupplierInvoice.onetmeacctisequalizationtxsubj AS OneTmeAcctIsEqualizationTxSubj,
  _SupplierInvoice.businesstype AS BusinessType,
  _SupplierInvoice.industrytype AS IndustryType,
  _SupplierInvoice.representativename AS RepresentativeName,
  _SupplierInvoice.dataexchangeinstructionkey AS DataExchangeInstructionKey,
  _SupplierInvoice.datamediumexchangeindicator AS DataMediumExchangeIndicator,
  _SupplierInvoice.alternativepayeeisallowed AS AlternativePayeeIsAllowed,
  _SupplierInvoice.isonetimeaccount AS IsOneTimeAccount,
  _SupplierInvoice.addressandbankissetmanually AS AddressAndBankIsSetManually,
  _SupplierInvoice.applicationloghandle AS ApplicationLogHandle,
  _SupplierInvoice.sitntypedescription AS SitnTypeDescription,
  _CompanyCode.Country AS CompanyCodeCountry,
  _CustomerCompany.Customer AS CustomerNum,
  _CustomerCompany._Customer AS _Customer
FROM farp_miv_ivinf AS _SupplierInvoice
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_CustomerCompany AS _CustomerCompany ON Customer = _CustomerCompany.Customer AND CompanyCode = _CustomerCompany.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_PaymentTerms AS _PaymentTerms ON PaymentTerms = _PaymentTerms.PaymentTerms  -- association [0..1]
LEFT OUTER JOIN I_AccountingDocumentType AS _AccountDocType ON AccountingDocumentType = _AccountDocType.AccountingDocumentType  -- association [0..1]
LEFT OUTER JOIN I_SuplrInvcTransactionTypeDesc AS _SuplrInvcTransactionTypeDesc ON SupplierInvoiceTransactionType = _SuplrInvcTransactionTypeDesc.SupplierInvoiceTransactionType AND _SuplrInvcTransactionTypeDesc.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_OutgoingInvoiceStatus AS _SupplierInvoiceStatusText ON OutgoingInvoiceStatus = _SupplierInvoiceStatusText.OutgoingInvoiceStatus  -- association [0..1]
LEFT OUTER JOIN I_BusinessAreaText AS _BusinessAreaText ON BusinessArea = _BusinessAreaText.BusinessArea AND _BusinessAreaText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_BusinessAreaText AS _PartnerBusinessAreaText ON PartnerBusinessArea = _PartnerBusinessAreaText.BusinessArea AND _PartnerBusinessAreaText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_BusinessPlaceSectionCodeName AS _BusinessPlaceSectionCodeName ON BusinessSectionCode = _BusinessPlaceSectionCodeName.BusinessSectionCode AND _BusinessPlaceSectionCodeName.Language = $session.system_language AND CompanyCode = _BusinessPlaceSectionCodeName.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_Branch AS _Branch ON BusinessPlace = _Branch.Branch AND CompanyCode = _Branch.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_CountryText AS _SupplyingCountryText ON SupplyingCountry = _SupplyingCountryText.Country AND _SupplyingCountryText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CountryText AS _CompanyCodeCountryText ON ReportingCountry = _CompanyCodeCountryText.Country AND _CompanyCodeCountryText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CountryText AS _TaxCountryText ON TaxCountry = _TaxCountryText.Country AND _TaxCountryText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_HouseBankAccountText AS _HouseBankAccountText ON CompanyCode = _HouseBankAccountText.CompanyCode AND HouseBank = _HouseBankAccountText.HouseBank AND HouseBankAccount = _HouseBankAccountText.HouseBankAccount AND _HouseBankAccountText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_PaymentMethodText AS _PaymentMethodInCountryVH ON PaymentMethod = _PaymentMethodInCountryVH.PaymentMethod AND companycodecountry = _PaymentMethodInCountryVH.Country AND _PaymentMethodInCountryVH.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_PaymentBlockingReasonText AS _PaymentBlockingReasonText ON SuplrInvcPaymentBlockingReason = _PaymentBlockingReasonText.PaymentBlockingReason AND _PaymentBlockingReasonText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_StateCentralBankPaytRsn AS _StateCentralBankPaytRsn ON StateCentralBankPaymentReason = _StateCentralBankPaytRsn.StateCentralBankPaymentReason  -- association [0..1]
LEFT OUTER JOIN I_PlanningLevelText AS _PlanningLevelText ON PlanningLevel = _PlanningLevelText.PlanningLevel AND _PlanningLevelText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_TreasuryContractTypeText AS _TreasuryContractTypeText ON TreasuryContractType = _TreasuryContractTypeText.TreasuryContractType AND _TreasuryContractTypeText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CreditControlAreaText AS _CreditControlAreaText ON CreditControlArea = _CreditControlAreaText.CreditControlArea AND _CreditControlAreaText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_PaymentDifferenceReasonT AS _PaymentDifferenceReasonT ON PaymentDifferenceReason = _PaymentDifferenceReasonT.PaymentDifferenceReason AND _PaymentDifferenceReasonT.Language = $session.system_language AND CompanyCode = _PaymentDifferenceReasonT.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_GlAccountTextInCompanycode AS _GLAccountText ON CompanyCode = _GLAccountText.CompanyCode AND ReconciliationAccount = _GLAccountText.GLAccount AND _GLAccountText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN R_IncgOutgInvoiceItemTP AS _ManageInvoicesItem ON /* condition not available in parsed metadata */  -- association [1..*]
LEFT OUTER JOIN R_IncgOutgInvoiceWhgdTaxTP AS _ManageInvoicesWhgdTax ON /* condition not available in parsed metadata */  -- association [1..*]
LEFT OUTER JOIN R_IncgOutgInvoiceTaxTP AS _ManageInvoicesTax ON /* condition not available in parsed metadata */  -- association [1..*]
;