C_PL_BillingDocument

@AbapCatalog.sqlViewName: 'CPLBILLINGDOC'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Billing Documents for Poland DownPayments'

@VDM.viewType: #CONSUMPTION
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #M
define view C_PL_BillingDocument as select from I_BillingDocumentBasic

 //Association

  association [0..*] to I_BillingDocumentItem        as _Item                          on  $projection.BillingDocument = _Item.BillingDocument
  association [1..*] to I_BillingDocumentPartner     as _Partner                       on  $projection.BillingDocument = _Partner.BillingDocument
  association [0..*] to I_BillingDocumentPrcgElmnt   as _PricingElement                on  $projection.BillingDocument = _PricingElement.BillingDocument
  association [0..1] to I_BillingDocument            as _CancelledBillingDocument      on  $projection.CancelledBillingDocument = _CancelledBillingDocument.BillingDocument
  //Extensibility

  association [0..1] to E_BillingDocument            as _Extension                     on  $projection.BillingDocument = _Extension.BillingDocument
  association [1..*] to C_PL_DownPayment as _Downpayment on $projection.BillingDocument = _Downpayment.BillingDocument
  association [1..*] to C_PL_SalesPrcgCondition as _SalesOverview on $projection.BillingDocument = _SalesOverview.SubsequentDocument
  association [1..*] to C_SalesDocItemDownPayt as _SalesItems on $projection.BillingDocument = _SalesItems.SubsequentDocument
  association [1..*] to C_DownPaymentBeforeCrrtn as _PrcngBfrCorr on $projection.BillingDocument = _PrcngBfrCorr.BillingDocument
  association [1..*] to C_DownPaymentAfterCrrtn as _PrcngAftrCorr on $projection.BillingDocument  = _PrcngAftrCorr.BillingDocument
  {

    key BillingDocument,

      //category

      SDDocumentCategory,
      BillingDocumentCategory,
      BillingDocumentType,

      //admin

      CreatedByUser,

      CreationDate,
      CreationTime,

      LastChangeDate,
      LastChangeDateTime,

      LogicalSystem,

      //org

      SalesOrganization,
      DistributionChannel,
      Division,

      //billing

      BillingDocumentDate,
      BillingDocumentIsCancelled,
      //--[ GENERATED:012:GlBfhyJl7kY4ufKHo3jjFG

      @Consumption.valueHelpDefinition: [
        { entity:  { name:    'I_BillingDocumentStdVH',
                     element: 'BillingDocument' }
        }]
      // ]--GENERATED

      @ObjectModel.foreignKey.association: '_CancelledBillingDocument'
      CancelledBillingDocument,
      BillingDocCombinationCriteria,
      ManualInvoiceMaintIsRelevant,
      NmbrOfPages,
      IsIntrastatReportingRelevant,
      IsIntrastatReportingExcluded,
      BillingDocumentIsTemporary,

      //pricing

      TotalNetAmount,
      TransactionCurrency,
      StatisticsCurrency,
      TotalTaxAmount,
      CustomerPriceGroup,
      PriceListType,
      TaxDepartureCountry,
      VATRegistration,
      VATRegistrationOrigin,
      VATRegistrationCountry,
      HierarchyTypePricing,

      CustomerTaxClassification1,
      CustomerTaxClassification2,
      CustomerTaxClassification3,
      CustomerTaxClassification4,
      CustomerTaxClassification5,
      CustomerTaxClassification6,
      CustomerTaxClassification7,
      CustomerTaxClassification8,
      CustomerTaxClassification9,
      IsEUTriangularDeal,

      SDPricingProcedure,


      //shipping

      ShippingCondition,
      IncotermsVersion,
      IncotermsClassification,
      IncotermsTransferLocation,
      IncotermsLocation1,
      IncotermsLocation2,

      //payment

      PayerParty,
      ContractAccount,
      CustomerPaymentTerms,
      PaymentMethod,
      PaymentReference,
      FixedValueDate,
      AdditionalValueDays,
      SEPAMandate,

      //accounting

      CompanyCode,
      FiscalYear,

      AccountingDocument,
      FiscalPeriod,
      CustomerAccountAssignmentGroup,
      AccountingExchangeRateIsSet,
      AccountingExchangeRate,
      ExchangeRateDate,
      ExchangeRateType,
      DocumentReferenceID,
      AssignmentReference,

      DunningArea,
      DunningBlockingReason,
      DunningKey,
      InternalFinancialDocument,
      IsRelevantForAccrual,

      //sales

      SoldToParty,
      PartnerCompany,
      PurchaseOrderByCustomer,
      CustomerGroup,
      Country,
      CityCode,
      SalesDistrict,
      Region,
      County,

      CreditControlArea,
      CustomerRebateAgreement,
      PricingDocument,

      //status

      OverallSDProcessStatus,
      OverallBillingStatus,
      AccountingPostingStatus,
      AccountingTransferStatus,
      BillingIssueType,
      InvoiceListStatus,
      OvrlItmGeneralIncompletionSts,
      OverallPricingIncompletionSts,

      //billing document list

      InvoiceListType,
      InvoiceListBillingDate,

      //association

      @ObjectModel.association.type: [#TO_COMPOSITION_CHILD]
      _Item,
      @ObjectModel.association.type: [#TO_COMPOSITION_CHILD]
      _Partner,
      @ObjectModel.association.type: [#TO_COMPOSITION_CHILD]
      _PricingElement,
      _PrcngBfrCorr,
      _PrcngAftrCorr,
      _SDDocumentCategory,
      _BillingDocumentCategory,
      _BillingDocumentType,
      _CreatedByUser,
      _LogicalSystem,
      _SalesOrganization,
      _DistributionChannel,
      _Division,
      _CancelledBillingDocument,
      _TransactionCurrency,
      _StatisticsCurrency,
      _CustomerPriceGroup,
      _PriceListType,
      _TaxDepartureCountry,
      _VATRegistrationOrigin,
      _VATRegistrationCountry,
      _ShippingCondition,
      _IncotermsClassification,
      _IncotermsVersion,
      _PayerParty,
      _CustomerPaymentTerms,
      _PaymentMethod,
      _CompanyCode,
      _FiscalYear,
      _AccountingDocument,
      //_FiscalPeriod,

      _CustomerAccountAssgmtGroup,
      _ExchangeRateType,
      _DunningArea,
      _DunningBlockingReason,
      _DunningKey,
      _InvoiceListType,
      _SoldToParty,
      _CustomerGroup,
      _Country,
      _CityCode,
      _SalesDistrict,
      _Region,
      _County_2,
      _Downpayment,
      _CreditControlArea,
      _OverallSDProcessStatus,
      _OverallBillingStatus,
      _AccountingPostingStatus,
      _AccountingTransferStatus,
      _BillingIssueType,
      _InvoiceListStatus,
      _OvrlItmGeneralIncompletionSts,
      _OverallPricingIncompletionSts,
      _SalesItems,
      _SalesOverview,
       @Consumption.hidden: true
      _DunningAreaText,
      @Consumption.hidden: true
      _CreditControlAreaText
}
where
     SDDocumentCategory = 'M' // Invoice

  or SDDocumentCategory = 'N' // Invoice Canceled

  or SDDocumentCategory = 'O' // Credit Memo

  or SDDocumentCategory = 'P' // Debit Memo

  or SDDocumentCategory = 'S' // Credit Memo Canceled

  or SDDocumentCategory = 'U' // Pro Forma Invoice

  or SDDocumentCategory = '5' // Intercompany Invoice

  or SDDocumentCategory = '6' // Intercompany Credit Memo

  or SDDocumentCategory = 'ICPF' // Intercompany Pro Forma Invoice


/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BILLINGDOCUMENTBASIC"
],
"ASSOCIATED":
[
"C_DOWNPAYMENTAFTERCRRTN",
"C_DOWNPAYMENTBEFORECRRTN",
"C_PL_DOWNPAYMENT",
"C_PL_SALESPRCGCONDITION",
"C_SALESDOCITEMDOWNPAYT",
"E_BILLINGDOCUMENT",
"I_ACCOUNTINGDOCUMENT",
"I_ACCOUNTINGPOSTINGSTATUS",
"I_ACCOUNTINGTRANSFERSTATUS",
"I_BILLINGDOCUMENT",
"I_BILLINGDOCUMENTCATEGORY",
"I_BILLINGDOCUMENTITEM",
"I_BILLINGDOCUMENTPARTNER",
"I_BILLINGDOCUMENTPRCGELMNT",
"I_BILLINGDOCUMENTTYPE",
"I_BILLINGISSUETYPE",
"I_CITYCODE",
"I_COMPANYCODE",
"I_COUNTRY",
"I_CREDITCONTROLAREA",
"I_CREDITCONTROLAREATEXT",
"I_CURRENCY",
"I_CUSTOMER",
"I_CUSTOMERACCOUNTASSGMTGROUP",
"I_CUSTOMERGROUP",
"I_CUSTOMERPAYMENTTERMS",
"I_CUSTOMERPRICEGROUP",
"I_DISTRIBUTIONCHANNEL",
"I_DIVISION",
"I_DUNNINGAREA",
"I_DUNNINGAREATEXT",
"I_DUNNINGBLOCKINGREASONCODE",
"I_DUNNINGKEY",
"I_EXCHANGERATETYPE",
"I_FISCALYEARFORCOMPANYCODE",
"I_INCOTERMSCLASSIFICATION",
"I_INCOTERMSVERSION",
"I_INVOICELISTSTATUS",
"I_LOGICALSYSTEM",
"I_OVERALLBILLINGSTATUS",
"I_OVERALLPRCINCOMPLETIONSTS",
"I_OVERALLSDPROCESSSTATUS",
"I_OVRLITMGENINCOMPLETIONSTS",
"I_PAYMENTMETHOD",
"I_PRICELISTTYPE",
"I_REGION",
"I_SALESDISTRICT",
"I_SALESORGANIZATION",
"I_SDDOCUMENTCATEGORY",
"I_SHIPPINGCONDITION",
"I_TAXINGCOUNTY",
"I_USER",
"I_VATREGISTRATIONORIGIN"
],
"BASE":
[
"I_BILLINGDOCUMENTBASIC"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/