I_APLineItem

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 I_APLineItem.
-- 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.
-- SQL view name: IFIAPLINEITEM
-- Parameters: P_KeyDate : vdm_v_key_date, P_TodayDate : sydate, P_Language : sylangu, P_TimeRestrictionStartDate : farp_time_restrict_start_date

CREATE VIEW I_APLineItem AS
SELECT
  CompanyCode,
  cast( AccountingDocument as fis_belnr preserving type ) AS AccountingDocument,
  FiscalYear,
  AccountingDocumentItem,
  PaymentDifferenceReason,
  Supplier,
  ClearingDate,
  ClearingDocFiscalYear,
  cast( ClearingAccountingDocument as fis_augbl ) AS ClearingAccountingDocument,
  PostingKey,
  FinancialAccountType,
  FinancialAccountType AS MixedAccountType,
  SpecialGLCode,
  SpecialGLTransactionType,
  DebitCreditCode,
  BusinessArea,
  TaxCode,
  TaxCountry,
  AlternativeGLAccount,
  TaxReportingDate,
  ValueDate,
  cast( AssignmentReference as fis_zuonr ) AS AssignmentReference,
  DocumentItemText,
  cast( PartnerCompany as fis_rassc ) AS PartnerCompany,
  CostCenter,
  OrderID,
  cast( BillingDocument as farp_vbeln ) AS BillingDocument,
  SalesDocument,
  cast( SalesDocumentItem as farp_posn2 ) AS SalesDocumentItem,
  ScheduleLine,
  MasterFixedAsset,
  FixedAsset,
  IsUsedInPaymentTransaction,
  cast( GLAccount as fis_racct ) AS GLAccount,
  Branch,
  cast( DueCalculationBaseDate as farp_dzfbdt ) AS DueCalculationBaseDate,
  PaymentTerms,
  CashDiscount1Days,
  CashDiscount2Days,
  NetPaymentDays,
  cast( CashDiscount1Percent as dzbd1p_farp ) AS CashDiscount1Percent,
  cast( CashDiscount2Percent as dzbd2p_farp ) AS CashDiscount2Percent,
  PaymentMethod,
  PaymentBlockingReason,
  FixedCashDiscount,
  FollowOnDocumentType,
  StateCentralBankPaymentReason,
  SupplyingCountry,
  InvoiceList,
  BillOfExchangeUsage,
  DunningKey,
  DunningBlockingReason,
  LastDunningDate,
  cast( DunningLevel as farp_mahns ) AS DunningLevel,
  DunningArea,
  Plant,
  cast( PurchasingDocument as fis_ebeln ) AS PurchasingDocument,
  PurchasingDocumentItem,
  ProfitCenter,
  TreasuryContractType,
  AssetContract,
  CashFlowType,
  cast( WBSElement as farp_ps_psp_pnr ) AS WBSElement,
  ClearingIsReversed,
  PaymentMethodSupplement,
  Reference1IDByBusinessPartner,
  Reference2IDByBusinessPartner,
  PaymentCardItem,
  PaymentCardPaymentSettlement,
  cast( Reference3IDByBusinessPartner as farp_xref3 ) AS Reference3IDByBusinessPartner,
  DataExchangeInstruction1,
  DataExchangeInstruction2,
  DataExchangeInstruction3,
  DataExchangeInstruction4,
  HasPaymentOrder,
  PaymentReference,
  BusinessPlace,
  TaxSection,
  AccountsReceivableIsPledged,
  RealEstateObject,
  FundsCenter,
  cast( SettlementReferenceDate as farp_dabrbez) AS SettlementReferenceDate,
  IsSalesRelated,
  PostingDate,
  AccountingDocumentCategory,
  FiscalPeriod,
  DocumentDate,
  cast( AccountingDocumentType as fis_blart ) AS AccountingDocumentType,
  NetDueDate,
  CashDiscount1DueDate,
  cast( DocumentReferenceID as xblnr ) AS DocumentReferenceID,
  cast( AccountingDocumentCreationDate as farp_cpudt ) AS AccountingDocumentCreationDate,
  AccountingDocCreatedByUser,
  cast( ITEM_TYPE_BRANCH as farp_selected_item_branch ) AS SelectedItemBranch,
  cast( DueItemType as farp_due_item_category ) AS DueItemType,
  cast( SupplierIndustry as fap_brsch ) AS SupplierIndustry,
  cast( SupplierIndustryName as fap_brtxt ) AS SupplierIndustryName,
  cast( SupplierCreationDate as fap_ap_crdat ) AS SupplierCreationDate,
  cast( SupplierAccountGroup as farp_supplier_account_group) AS SupplierAccountGroup,
  cast( SupplierSearchText as farp_sortl ) AS SupplierSearchText,
  cast( SupplierTaxID1 as farp_stcd1 ) AS SupplierTaxID1,
  cast( SupplierTaxID2 as farp_stcd2 ) AS SupplierTaxID2,
  cast( SupplierTaxID3 as farp_stcd3 ) AS SupplierTaxID3,
  cast( SupplierTaxID4 as farp_stcd4 ) AS SupplierTaxID4,
  cast( SupplierTaxID5 as farp_stcd5 ) AS SupplierTaxID5,
  cast( SupplierIsOneTimeAccount as farp_xcpdk ) AS SupplierIsOneTimeAccount,
  cast( SupplierVATRegistration as farp_stceg ) AS SupplierVATRegistration,
  SupplierTaxJurisdiction,
  SupplierBasicAuthorizationGrp,
  SupplierFinsAuthorizationGrp,
  cast( AlternativePayeeIsAllowed as farp_xzemp ) AS AlternativePayeeIsAllowed,
  cast( PostingIsBlockedForSupplier as farp_sperb ) AS PostingIsBlockedForSupplier,
  cast( SupplierCorporateGroup as farp_konzs ) AS SupplierCorporateGroup,
  cast( SupplierCountry as farp_land1 ) AS SupplierCountry,
  cast( SupplierName as fap_supplier_name1_gp ) AS SupplierName,
  SupplierCityName,
  cast( SupplierPOBox as ad_pobx ) AS SupplierPOBox,
  cast( SupplierPOBoxPostalCode as ad_pstcd2 ) AS SupplierPOBoxPostalCode,
  cast( SupplierPostalCode as ad_pstcd1 ) AS SupplierPostalCode,
  cast( SupplierRegion as farp_supplier_region ) AS SupplierRegion,
  cast( SupplierRegionName as farp_supplier_region_name ) AS SupplierRegionName,
  cast( SupplierCreatedByUser as fap_ap_crusr ) AS SupplierCreatedByUser,
  cast( AccountingClerk as farp_busab ) AS AccountingClerk,
  ReconciliationAccount,
  InterestCalculationCode,
  SupplierHeadOffice,
  cast( SupplierPaymentBlockingReason as fap_dzlspr ) AS SupplierPaymentBlockingReason,
  InterestCalculationDate,
  IntrstCalcFrequencyInMonths,
  APARToleranceGroup,
  HouseBank,
  HouseBankAccount,
  ItemIsToBePaidSeparately,
  PaymentIsToBeSentByEDI,
  cast( SupplierAccountNote as farp_kverm preserving type ) AS SupplierAccountNote,
  CompanyCodeName,
  cast( IsDisputed as farp_xstrp ) AS IsDisputed,
  cast( cast( CustomerSupplierAccount as abap.char(35) ) as farp_ktonr_av ) AS CustomerSupplierAccount,
  cast( InvoiceReference as farp_rebzg ) AS InvoiceReference,
  cast( FiscalYearPeriod as farp_jamon_xpo ) AS FiscalYearPeriod,
  cast( cast( IsCleared as abap.char(2)) as farp_sym_augp ) AS IsCleared,
  cast( CreditControlArea as farp_kkber ) AS CreditControlArea,
  cast( PayableAlternativePayee as fap_empfb ) AS PayableAlternativePayee,
  cast( NetDueArrearsDays as farp_verzn ) AS NetDueArrearsDays,
  cast( CashDiscount1ArrearsDays as farp_verz1 ) AS CashDiscount1ArrearsDays,
  cast( OffsettingAccount as fis_gkont ) AS OffsettingAccount,
  cast( OffsettingAccountType as farp_gkoar ) AS OffsettingAccountType,
  cast( DocumentIsArchived as farp_xarch) AS DocumentIsArchived,
  TargetTaxCode,
  cast ( AlternativePayee as farp_lnrzb ) AS AlternativePayee,
  cast( CashDiscount1DueStatus as far_sym_due1 ) AS CashDiscount1DueStatus,
  cast( NetDueStatus as far_sym_due ) AS NetDueStatus,
  cast( KeyDate as vdm_v_key_date ) AS KeyDate,
  cast( CashDiscount1IsDue as farp_xdue1 ) AS CashDiscount1IsDue,
  cast( IsClearedAtKeyDate as farp_xaugp ) AS IsClearedAtKeyDate,
  cast( IsDueNet as farp_xduen ) AS IsDueNet,
  cast( cast(ClearingStatus as abap.char( 1 )) as augst ) AS ClearingStatus,
  cast( IsNegativePosting as farp_xnegp ) AS IsNegativePosting,
  AcctgDocTypeAuthorizationGroup,
  cast( BPBankAccountInternalID as farp_bvtyp ) AS BPBankAccountInternalID,
  _JournalEntry.SenderLogicalSystem AS SenderLogicalSystem,
  _JournalEntry.SenderCompanyCode AS SenderCompanyCode,
  _JournalEntry.SenderAccountingDocument AS SenderAccountingDocument,
  cast( _JournalEntry.SenderFiscalYear as fis_gjahr_sender ) AS SenderFiscalYear,
  cast( CompanyCodeCurrency as fis_hwaer preserving type ) AS CompanyCodeCurrency,
  TransactionCurrency,
  BalanceTransactionCurrency,
  PaymentCurrency,
  AdditionalCurrency1,
  AdditionalCurrency2,
  FunctionalCurrency,
  AmountInAdditionalCurrency1,
  AmountInAdditionalCurrency2,
  AmountInFunctionalCurrency,
  cast( AmountInBalanceTransacCrcy as pswbt_farp ) AS AmountInBalanceTransacCrcy,
  cast( AmountInCompanyCodeCurrency as dmshb_farp ) AS AmountInCompanyCodeCurrency,
  cast( AmountInPaymentCurrency as pyamt_farp ) AS AmountInPaymentCurrency,
  cast( AmountInTransactionCurrency as wrshb_farp ) AS AmountInTransactionCurrency,
  cast( CashDiscountAmount as wskto_farp ) AS CashDiscountAmount,
  cast( CashDiscountAmtInCoCodeCrcy as sknto_farp ) AS CashDiscountAmtInCoCodeCrcy,
  cast( CashDiscountBaseAmount as skfbt_farp ) AS CashDiscountBaseAmount,
  cast( HedgedAmount as absbt_farp ) AS HedgedAmount,
  cast( PlannedAmtInTransactionCrcy as fdwbt_farp ) AS PlannedAmtInTransactionCrcy,
  cast( cast( ValuatedAmtInCompanyCodeCrcy as abap.curr( 23, 2 ) ) as bwwrt_farp ) AS ValuatedAmtInCompanyCodeCrcy,
  cast( cast( ValuatedAmtInAdditionalCrcy1 as abap.curr( 23, 2 ) ) as bwwr2_farp ) AS ValuatedAmtInAdditionalCrcy1,
  cast( cast( ValuatedAmtInAdditionalCrcy2 as abap.curr( 23, 2 ) ) as bwwr3_farp ) AS ValuatedAmtInAdditionalCrcy2,
  cast( WithholdingTaxAmount as qbshb_farp ) AS WithholdingTaxAmount,
  cast( WithholdingTaxBaseAmount as qsshb_farp ) AS WithholdingTaxBaseAmount,
  cast( WithholdingTaxExemptionAmt as qsfbt_farp ) AS WithholdingTaxExemptionAmt,
  cast( InterestToBePosted as farp_dzinsz ) AS InterestToBePosted,
  cast( cast( CashDiscountAmtInTransacCrcy as abap.curr( 23, 2 ) ) as askto_farp ) AS CashDiscountAmtInTransacCrcy,
  Debtor,
  AdditionalCurrency1Role,
  AdditionalCurrency2Role,
  cast( _AdditionalCurrency1RoleText.CurrencyRoleName as fis_adl1_currole_name preserving type ) AS AdditionalCurrency1RoleName,
  cast( _AdditionalCurrency2RoleText.CurrencyRoleName as fis_adl2_currole_name preserving type ) AS AdditionalCurrency2RoleName,
  cast( BranchCode as bcode ) AS BranchCode,
  cast( _TH_SupplierBranchCodeVH.TH_BranchCodeDescription as fith_desc ) AS TH_BranchCodeDescription,
  ReferenceDocumentType,
  cast( _ReferenceDocumentTypeText.ReferenceDocumentTypeName as fac_text_typ ) AS ReferenceDocumentTypeName,
  OriginalReferenceDocument,
  ReferenceDocumentLogicalSystem,
  cast( PaymentReason as farp_payt_rsn) AS PaymentReason,
  cast( BillOfExchangeUsageDocument as fis_disbn) AS BillOfExchangeUsageDocument,
  cast( BOEUsageDocFiscalYear as fis_disbj) AS BOEUsageDocFiscalYear,
  cast( BOEUsageDocLineItem as fis_disbz) AS BOEUsageDocLineItem,
  cast( JointVenture as jv_name) AS JointVenture,
  cast( JointVentureCostRecoveryCode as jv_recind) AS JointVentureCostRecoveryCode,
  cast( JointVentureBillingType as jv_bilind_cds) AS JointVentureBillingType,
  cast( JointVentureCorporateEquityGrp as jv_egroup) AS JointVentureCorporateEquityGrp,
  P_APLineItem_0._SupplierCompany AS _SupplierCompany,
  _CustomerCompany.AuthorizationGroup AS CustomerFinsAuthorizationGrp,
  _Customer.AuthorizationGroup AS CustomerBasicAuthorizationGrp
FROM P_APLineItem_0
LEFT OUTER JOIN I_Currency AS _CompanyCodeCurrency ON CompanyCodeCurrency = _CompanyCodeCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _TransactionCurrency ON TransactionCurrency = _TransactionCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _BalanceTransactionCurrency ON BalanceTransactionCurrency = _BalanceTransactionCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _PaymentCurrency ON PaymentCurrency = _PaymentCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _AdditionalCurrency1 ON AdditionalCurrency1 = _AdditionalCurrency1.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _AdditionalCurrency2 ON AdditionalCurrency2 = _AdditionalCurrency2.Currency  -- association [0..1]
LEFT OUTER JOIN I_CurrencyRoleText AS _AdditionalCurrency1RoleText ON _AdditionalCurrency1RoleText.CurrencyRole = AdditionalCurrency1Role AND _AdditionalCurrency1RoleText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CurrencyRoleText AS _AdditionalCurrency2RoleText ON _AdditionalCurrency2RoleText.CurrencyRole = AdditionalCurrency2Role AND _AdditionalCurrency2RoleText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_OneTimeAccountSupplier AS _OneTimeAccountSupplier ON _OneTimeAccountSupplier.CompanyCode = CompanyCode AND _OneTimeAccountSupplier.FiscalYear = FiscalYear AND _OneTimeAccountSupplier.AccountingDocument = AccountingDocument AND _OneTimeAccountSupplier.AccountingDocumentItem = AccountingDocumentItem  -- association [0..1]
;