P_APLineItem_7

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 P_APLineItem_7.
-- 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: PAPLINEITEM7

CREATE VIEW P_APLineItem_7 AS
SELECT
  bukrs AS CompanyCode,
  lifnr AS Supplier,
  umsks AS SpecialGLTransactionType,
  umskz AS SpecialGLCode,
  augdt AS ClearingDate,
  augbl AS ClearingAccountingDocument,
  zuonr AS AssignmentReference,
  gjahr AS FiscalYear,
  belnr AS AccountingDocument,
  buzei AS AccountingDocumentItem,
  budat AS PostingDate,
  bldat AS DocumentDate,
  auggj AS ClearingDocFiscalYear,
  waers AS TransactionCurrency,
  blart AS AccountingDocumentType,
  cast( cast( concat( '0', monat ) as abap.numc( 3 ) ) as fins_fiscalperiod ) AS FiscalPeriod,
  bschl AS PostingKey,
  gsber AS BusinessArea,
  prctr AS ProfitCenter,
  kostl AS CostCenter,
  hkont AS GLAccount,
  filkd AS Branch,
  bstat AS AccountingDocumentCategory,
  sgtxt AS DocumentItemText,
  xnegp AS IsNegativePosting,
  empfb AS PayableAlternativePayee,
  cpudt AS CreationDate,
  xarch AS DocumentIsArchived,
  pswsl AS BalanceTransactionCurrency,
  case shkzg when 'H' then cast(-wrbtr as abap.curr(23,2)) else cast( wrbtr as abap.curr(23,2)) end as AmountInTransactionCurrency AS curr232endasAmountInTransactionCurrency,
  case shkzg when 'H' then cast(-dmbtr as abap.curr(23,2)) else cast( dmbtr as abap.curr(23,2)) end as AmountInCompanyCodeCurrency AS curr232endasAmountInCompanyCodeCurrency,
  case shkzg when 'H' then cast(-dmbe2 as abap.curr(23,2)) else cast( dmbe2 as abap.curr(23,2)) end as AmountInAdditionalCurrency1 AS curr232endasAmountInAdditionalCurrency1,
  case shkzg when 'H' then cast(-dmbe3 as abap.curr(23,2)) else cast( dmbe3 as abap.curr(23,2)) end as AmountInAdditionalCurrency2 AS curr232endasAmountInAdditionalCurrency2,
  case shkzg when 'H' then cast(-bdiff as abap.curr(23,2)) else cast( bdiff as abap.curr(23,2)) end as ValuationDiffAmtInCoCodeCrcy AS curr232endasValuationDiffAmtInCoCodeCrcy,
  case shkzg when 'H' then cast(-bdif2 as abap.curr(23,2)) else cast( bdif2 as abap.curr(23,2)) end as ValuationDiffAmtInAddlCrcy1 AS curr232endasValuationDiffAmtInAddlCrcy1,
  case shkzg when 'H' then cast(-bdif3 as abap.curr(23,2)) else cast( bdif3 as abap.curr(23,2)) end as ValuationDiffAmtInAddlCrcy2 AS curr232endasValuationDiffAmtInAddlCrcy2,
  case shkzg when 'H' then cast(-pswbt as abap.curr(23,2)) else cast( pswbt as abap.curr(23,2)) end as AmountInBalanceTransacCrcy AS curr232endasAmountInBalanceTransacCrcy,
  xblnr AS DocumentReferenceID,
  aufnr AS OrderID,
  anln1 AS MasterFixedAsset,
  anln2 AS FixedAsset,
  rebzg AS InvoiceReference,
  samnr AS InvoiceList,
  vbund AS PartnerCompany,
  rebzt AS FollowOnDocumentType,
  lzbkz AS StateCentralBankPaymentReason,
  landl AS SupplyingCountry,
  vertt AS TreasuryContractType,
  vertn AS AssetContract,
  vbewa AS CashFlowType,
  projk AS WBSElement,
  xref1 AS Reference1IDByBusinessPartner,
  xref2 AS Reference2IDByBusinessPartner,
  xref3 AS Reference3IDByBusinessPartner,
  imkey AS RealEstateObject,
  fistl AS FundsCenter,
  bupla AS BusinessPlace,
  ebeln AS PurchasingDocument,
  ebelp AS PurchasingDocumentItem,
  mwskz AS TaxCode,
  tax_country AS TaxCountry,
  secco AS TaxSection,
  qsshb AS WithholdingTaxBaseAmount,
  qbshb AS WithholdingTaxAmount,
  qsfbt AS WithholdingTaxExemptionAmt,
  zfbdt AS DueCalculationBaseDate,
  zterm AS PaymentTerms,
  zbd1t AS CashDiscount1Days,
  zbd2t AS CashDiscount2Days,
  zbd3t AS NetPaymentDays,
  zbd1p AS CashDiscount1Percent,
  zbd2p AS CashDiscount2Percent,
  zlsch AS PaymentMethod,
  zlspr AS PaymentBlockingReason,
  zbfix AS FixedCashDiscount,
  case shkzg when 'H' then cast(-skfbt as abap.curr(23,2)) else cast( skfbt as abap.curr(23,2)) end as CashDiscountBaseAmount AS curr232endasCashDiscountBaseAmount,
  case shkzg when 'H' then cast(-sknto as abap.curr(23,2)) else cast( sknto as abap.curr(23,2)) end as CashDiscountAmtInCoCodeCrcy AS curr232endasCashDiscountAmtInCoCodeCrcy,
  case shkzg when 'H' then cast(-wskto as abap.curr(23,2)) else cast( wskto as abap.curr(23,2)) end as CashDiscountAmount AS curr232endasCashDiscountAmount,
  mansp AS DunningBlockingReason,
  mschl AS DunningKey,
  madat AS LastDunningDate,
  manst AS DunningLevel,
  maber AS DunningArea,
  xzahl AS IsUsedInPaymentTransaction,
  rstgr AS PaymentDifferenceReason,
  xragl AS ClearingIsReversed,
  uzawe AS PaymentMethodSupplement,
  dabrz AS SettlementReferenceDate,
  dtws1 AS DataExchangeInstruction1,
  dtws2 AS DataExchangeInstruction2,
  dtws3 AS DataExchangeInstruction3,
  dtws4 AS DataExchangeInstruction4,
  xpypr AS HasPaymentOrder,
  kidno AS PaymentReference,
  pycur AS PaymentCurrency,
  bvtyp AS BPBankAccountInternalID,
  case shkzg when 'H' then cast(-pyamt as abap.curr(23,2)) else cast( pyamt as abap.curr(23,2)) end as AmountInPaymentCurrency AS curr232endasAmountInPaymentCurrency,
  hbkid AS HouseBank,
  hktid AS HouseBankAccount,
  buzid AS AccountingDocumentItemType,
  cast( ' ' as fis_awtyp ) AS ReferenceDocumentType,
  cast( ' ' as fac_awkey ) AS OriginalReferenceDocument,
  cast( ' ' as fis_awsys ) AS ReferenceDocumentLogicalSystem
FROM bsak_bck
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN P_ARPCurRole AS _AdditionalCompanyCurrency ON CompanyCode = _AdditionalCompanyCurrency.CompanyCode  -- association [0..1]
;