P_CcpCustLineItem

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_CcpCustLineItem.
-- 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: PCCPCSTLNITM

CREATE VIEW P_CcpCustLineItem AS
SELECT
  CompanyCode AS bukrs,
  FiscalYear AS gjahr,
  AccountingDocument AS belnr,
  AccountingDocumentItem AS buzei,
  Customer AS kunnr,
  SpecialGLTransactionType AS umsks,
  SpecialGLCode AS umskz,
  ClearingDate AS augdt,
  ClearingJournalEntry AS augbl,
  AssignmentReference AS zuonr,
  PostingDate AS budat,
  DocumentDate AS bldat,
  TransactionCurrency AS waers,
  _JournalEntry.DocumentReferenceID AS xblnr,
  AccountingDocumentType AS blart,
  FiscalPeriod AS monat,
  PostingKey AS bschl,
  DebitCreditCode AS shkzg,
  BusinessArea AS gsber,
  TaxCode AS mwskz,
  CompanyCodeCurrency AS hwaer,
  AmountInCompanyCodeCurrency AS dmbtr,
  AmountInTransactionCurrency AS wrbtr,
  TaxAmountInCoCodeCrcy AS mwsts,
  TaxAmount AS wmwst,
  ValuationDiffAmtInCoCodeCrcy AS bdiff,
  AdditionalCurrency1 AS hwae2,
  AdditionalCurrency2 AS hwae3,
  ValuationDiffAmtInAddlCrcy1 AS bdif2,
  DocumentItemText AS sgtxt,
  Project AS projn,
  OrderID AS aufnr,
  MasterFixedAsset AS anln1,
  FixedAsset AS anln2,
  OperationalGLAccount AS saknr,
  GLAccount AS hkont,
  BranchAccount AS filkd,
  DueCalculationBaseDate AS zfbdt,
  PaymentTerms AS zterm,
  CashDiscount1Days AS zbd1t,
  CashDiscount2Days AS zbd2t,
  NetPaymentDays AS zbd3t,
  CashDiscount1Percent AS zbd1p,
  CashDiscount2Percent AS zbd2p,
  CashDiscount1DueDate AS sk1dt,
  CashDiscount2DueDate AS sk2dt,
  NetDueDate AS netdt,
  CashDiscountBaseAmount AS skfbt,
  CashDiscountAmtInCoCodeCrcy AS sknto,
  CashDiscountAmount AS wskto,
  PaymentMethod AS zlsch,
  PaymentBlockingReason AS zlspr,
  FixedCashDiscount AS zbfix,
  HouseBank AS hbkid,
  BPBankAccountInternalID AS bvtyp,
  InvoiceReference AS rebzg,
  InvoiceReferenceFiscalYear AS rebzj,
  InvoiceItemReference AS rebzz,
  InvoiceList AS samnr,
  DunningBlockingReason AS mansp,
  DunningKey AS mschl,
  LastDunningDate AS madat,
  DunningLevel AS manst,
  DunningArea AS maber,
  IsUsedInPaymentTransaction AS xzahl,
  TaxDistributionCode1 AS mwsk1,
  TaxDistributionCode2 AS mwsk2,
  TaxDistributionCode3 AS mwsk3,
  AccountingDocumentCategory AS bstat,
  PartnerCompany AS vbund,
  BillingDocument AS vbeln,
  FollowOnDocumentType AS rebzt,
  VATRegistration AS stceg,
  DelivOfGoodsDestCountry AS egbld,
  PaymentDifferenceReason AS rstgr,
  TreasuryContractType AS vertt,
  AssetContract AS vertn,
  CashFlowType AS vbewa,
  BillOfExchangeUsage AS wverw,
  WBSElementInternalID AS projk,
  CommitmentItem AS fipos,
  ProjectNetwork AS nplnr,
  OrderInternalBillOfOperations AS aufpl,
  OrderIntBillOfOperationsItem AS aplzl,
  IsEUTriangularDeal AS xegdr,
  AmountInAdditionalCurrency1 AS dmbe2,
  AmountInAdditionalCurrency2 AS dmbe3,
  ValuationDiffAmtInAddlCrcy2 AS bdif3,
  ClearingIsReversed AS xragl,
  PaymentMethodSupplement AS uzawe,
  _JournalEntry.ReversalIsPlanned AS xstov,
  Reference1IDByBusinessPartner AS xref1,
  Reference2IDByBusinessPartner AS xref2,
  BalanceTransactionCurrency AS pswsl,
  AmountInBalanceTransacCrcy AS pswbt,
  StateCentralBankPaymentReason AS lzbkz,
  SupplyingCountry AS landl,
  RealEstateObject AS imkey,
  SalesDocument AS vbel2,
  SalesDocumentItem AS posn2,
  ScheduleLine AS eten2,
  FundsCenter AS fistl,
  Fund AS geber,
  SettlementReferenceDate AS dabrz,
  IsNegativePosting AS xnegp,
  CostCenter AS kostl,
  PaymentCardItem AS rfzei,
  CreditControlArea AS kkber,
  ProfitCenter AS prctr,
  Reference3IDByBusinessPartner AS xref3,
  WithholdingTaxCode AS qsskz,
  DataExchangeInstruction1 AS dtws1,
  DataExchangeInstruction2 AS dtws2,
  DataExchangeInstruction3 AS dtws3,
  DataExchangeInstruction4 AS dtws4,
  HasPaymentOrder AS xpypr,
  PaymentReference AS kidno,
  CreditControlAreaCurrency AS t014_waers,
  HedgedAmount AS absbt,
  PaymentCardPaymentSettlement AS ccbtc,
  PaymentCurrency AS pycur,
  AmountInPaymentCurrency AS pyamt,
  BusinessPlace AS bupla,
  TaxSection AS secco,
  AccountsReceivableIsPledged AS cession_kz,
  GrantID AS grant_nbr,
  CustomerIsInExecution AS gmvkz,
  PartnerProfitCenter AS pprct,
  AccountingDocumentItemType AS buzid,
  ClearingJournalEntryFiscalYear AS auggj,
  HouseBankAccount AS hktid,
  BudgetPeriod AS budget_pd,
  PaymentServiceProvider AS pays_prov,
  PaymentRefByPaytSrvcProvider AS pays_tran,
  SEPAMandate AS mndid,
  PaymentReason AS payt_rsn,
  JointVenture AS vname,
  JointVentureEquityGroup AS egrup,
  OffsettingAccount AS gkont,
  OffsettingAccountType AS gkart,
  ReferenceDocumentType AS awtyp,
  _JournalEntry.SenderCompanyCode AS bukrs_sender,
  _JournalEntry.SenderAccountingDocument AS belnr_sender,
  _JournalEntry.SenderFiscalYear AS gjahr_sender
FROM I_OperationalAcctgDocItem
;