C_OutgInvoiceTP

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 C_OutgInvoiceTP.
-- 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 C_OutgInvoiceTP AS
SELECT
  OutgoingInvoiceUUID,
  AccountingDocument,
  CompanyCode,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  SupplierInvoiceTransactionType,
  _SuplrInvcTransactionTypeDesc.SuplrInvcTransactionTypeDesc AS SuplrInvcTransactionTypeDesc,
  Customer,
  _Customer.CustomerName AS CustomerName,
  DocumentReferenceID,
  InvoiceDate,
  PostingDate,
  _AccountDocType._Text[1:Language=$session.system_language].AccountingDocumentTypeName AS AccountingDocumentTypeName,
  AccountingDocumentType,
  AccountingDocumentHeaderText,
  TransactionCurrency,
  TotalAmountInTransactionCrcy,
  BusinessPlace,
  _Branch.BranchName AS BusinessPlaceName,
  BusinessSectionCode,
  _BusinessPlaceSectionCodeName[1:Language=$session.system_language].BusinessSectionCodeName AS BusinessSectionCodeName,
  SuplrInvcPaymentBlockingReason,
  _PaymentBlockingReasonText.PaymentBlockingReasonName AS PaymentBlockingReasonName,
  DueCalculationBaseDate,
  CashDiscountAmount,
  EligibleAmountForCshDiscInTC,
  PaymentMethod,
  _PaymentMethodInCountryVH.PaymentMethodDescription AS PaymentMethodName,
  PaymentMethodSupplement,
  PaymentReference,
  InvoiceReference,
  InvoiceReferenceFiscalYear,
  InvoiceItemReference,
  OutgoingInvoiceStatus,
  _SupplierInvoiceStatusText._Text[1:Language=$session.system_language].StatusDescription AS StatusDescription,
  StatusCriticality,
  SupplierBankType,
  HouseBank,
  HouseBankAccount,
  _HouseBankAccountText.HouseBankAccountDescription AS HouseBankAccountDescription,
  DataExchangeInstruction1,
  DataExchangeInstruction2,
  DataExchangeInstruction3,
  DataExchangeInstruction4,
  PaymentDifferenceReason,
  _PaymentDifferenceReasonT.PaymentDifferenceReasonDesc AS PaymentDifferenceReasonDesc,
  PaymentTerms,
  CashDiscount1Days,
  CashDiscount1Percent,
  CashDiscount2Days,
  CashDiscount2Percent,
  NetPaymentDays,
  FixedCashDiscount,
  ReconciliationAccount,
  _GLAccountText.GLAccountLongName AS GLAccountLongName,
  AssignmentReference,
  DocumentItemText,
  BusinessArea,
  _BusinessAreaText[1:Language=$session.system_language].BusinessAreaName AS BusinessAreaText,
  PartnerBusinessArea,
  _PartnerBusinessAreaText.BusinessAreaName AS PartnerBusinessAreaName,
  TreasuryContract,
  TreasuryContractType,
  _TreasuryContractTypeText.TreasuryContractTypeName AS TreasuryContractTypeName,
  Reference1IDByBusinessPartner,
  Reference2IDByBusinessPartner,
  Reference3IDByBusinessPartner,
  StateCentralBankPaymentReason,
  _StateCentralBankPaytRsn.StateCentralBankPaytRsnDesc AS StateCentralBankPaytRsnDesc,
  SupplyingCountry,
  _SupplyingCountryText.CountryName AS CountryName,
  RecrrgSuplrInvcIsSrvcInvoice,
  FinTransFlowType,
  CreditControlArea,
  _CreditControlAreaText.CreditControlAreaName AS CreditControlAreaName,
  ReportingCountry,
  _CompanyCodeCountryText.CountryName AS CompanyCodeCountryName,
  IsEUTriangularDeal,
  PlanningLevel,
  _PlanningLevelText.PlanningLevelDescription AS PlanningLevelDescription,
  PlanningDate,
  IsNegativePosting,
  TaxReportingDate,
  TaxFulfillmentDate,
  TaxDeterminationDate,
  TaxCountry,
  _TaxCountryText.CountryName AS TaxCountryName,
  ExchangeRate,
  RAItemTranslationDate,
  CreatedByUser,
  UserName,
  CreationDateTime,
  CreationDate,
  FinPlanApplicationLogHandle,
  EventHandlerTypeDescription,
  BatchUUID,
  ExtractedItemIndex,
  CompanyCodeCountry,
  OneTimeAccountBPSalutationText,
  BusinessPartnerName1,
  BusinessPartnerName2,
  BusinessPartnerName3,
  BusinessPartnerName4,
  StreetName,
  CityName,
  PostalCode,
  POBox,
  POBoxIsWithoutNumber,
  POBoxPostalCode,
  Country,
  Region,
  EmailAddress,
  BankCountry,
  BankInternalID,
  BankAccount,
  SWIFTCode,
  BankReference,
  BankControlKey,
  IBAN,
  PaymentSystem,
  AliasType,
  BPBankAccountAliasName,
  IsVATLiable,
  AccountTaxType,
  TaxNumberType,
  TaxID1,
  TaxID2,
  TaxID3,
  TaxID4,
  TaxID5,
  VATRegistration,
  IsNaturalPerson,
  OneTmeAcctIsEqualizationTxSubj,
  BusinessType,
  IndustryType,
  RepresentativeName,
  DataExchangeInstructionKey,
  DataMediumExchangeIndicator,
  AlternativePayeeIsAllowed,
  IsOneTimeAccount,
  AddressAndBankIsSetManually,
  ApplicationLogHandle,
  SitnTypeDescription,
  AlternativePayerAccount,
  CustomerNum,
  _SupplierInvoice._PaymentTerms AS _PaymentTerms
FROM R_IncgOutgInvoiceTP
LEFT OUTER JOIN I_FixedCashDiscountType AS _FixedCashTypeText ON FixedCashDiscount = _FixedCashTypeText.FixedCashDiscount  -- association [0..1]
;