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,
  _BusinessPlace.BranchName AS BusinessPlaceName,
  BusinessSectionCode,
  _BusinessPlaceSectionCodeName[1:Language=$session.system_language].BusinessSectionCodeName AS BusinessSectionCodeName,
  Branch,
  _Branch.BranchName AS BranchName,
  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,
  TaxCode,
  TaxAmountInTransCrcy,
  TaxReportingDate,
  TaxFulfillmentDate,
  TaxDeterminationDate,
  TaxCountry,
  _TaxCountryText.CountryName AS TaxCountryName,
  ExchangeRate,
  RAItemTranslationDate,
  CreatedByUser,
  UserName,
  CreationDateTime,
  CreationDate,
  FinPlanApplicationLogHandle,
  EventHandlerTypeDescription,
  BatchUUID,
  ExtractedItemIndex,
  CompanyCodeCountry,
  virtual UICT_Branch : abap_boolean AS virtualUICT_Branchabap_boolean,
  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]
;