P_SupplierWithCompanyCode

@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.sqlViewName: 'PSUPPLIERCOCODE'
@Metadata.ignorePropagatedAnnotations: true
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AbapCatalog.preserveKey:true
@AccessControl.personalData.blocking: #NOT_REQUIRED
@VDM.private: true
@VDM.viewType: #COMPOSITE
@ObjectModel: {
   usageType.serviceQuality: #C,
   usageType.sizeCategory: #S,
   usageType.dataClass: #MIXED
}
define view P_SupplierWithCompanyCode
  as select from I_Supplier

{
  key Supplier                           as Supplier,
  key _SupplierCompany.CompanyCode       as CompanyCode,
      I_Supplier.SupplierAccountGroup,
      I_Supplier.SupplierName,
      I_Supplier.SupplierFullName,
      I_Supplier.IsBusinessPurposeCompleted,
      I_Supplier.CreatedByUser,
      I_Supplier.CreationDate,
      I_Supplier.IsOneTimeAccount,
      I_Supplier.AuthorizationGroup,
      I_Supplier.VATRegistration,
      I_Supplier.AccountIsBlockedForPosting,
      I_Supplier.TaxJurisdiction,
      I_Supplier.SupplierCorporateGroup,
      I_Supplier.Customer,
      I_Supplier.Industry,
      I_Supplier.TaxNumber1,
      I_Supplier.TaxNumber2,
      I_Supplier.TaxNumber3,
      I_Supplier.TaxNumber4,
      I_Supplier.TaxNumber5,
      I_Supplier.PostingIsBlocked,
      I_Supplier.PurchasingIsBlocked,
      I_Supplier.InternationalLocationNumber1,
      I_Supplier.InternationalLocationNumber2,
      I_Supplier.InternationalLocationNumber3,
      I_Supplier.AddressID,
      I_Supplier.Region,
      I_Supplier.OrganizationBPName1,
      I_Supplier.OrganizationBPName2,
      I_Supplier.CityName,
      I_Supplier.PostalCode,
      I_Supplier.StreetName,
      I_Supplier.Country,
      I_Supplier.ConcatenatedInternationalLocNo,
      I_Supplier.SupplierProcurementBlock,
      I_Supplier.SuplrQualityManagementSystem,
      I_Supplier.SuplrQltyInProcmtCertfnValidTo,
      I_Supplier.SupplierLanguage,
      I_Supplier.AlternativePayeeAccountNumber,
      I_Supplier.PhoneNumber1,
      I_Supplier.FaxNumber,
      I_Supplier.IsNaturalPerson,
      I_Supplier.TaxNumberResponsible,
      I_Supplier.UK_ContractorBusinessType,
      I_Supplier.UK_PartnerTradingName,
      I_Supplier.UK_PartnerTaxReference,
      I_Supplier.UK_VerificationStatus,
      I_Supplier.UK_VerificationNumber,
      I_Supplier.UK_CompanyRegistrationNumber,
      I_Supplier.UK_VerifiedTaxStatus,
      I_Supplier.FormOfAddress,
      I_Supplier.ReferenceAccountGroup,
      I_Supplier.VATLiability,
      I_Supplier.ResponsibleType,
      I_Supplier.TaxNumberType,
      I_Supplier.FiscalAddress,
      I_Supplier.BusinessType,
      I_Supplier.BirthDate,
      I_Supplier.PaymentIsBlockedForSupplier,
      I_Supplier.SortField,
      I_Supplier.PhoneNumber2,
      I_Supplier.DeletionIndicator,
      I_Supplier.TradingPartner,
      I_Supplier.TaxInvoiceRepresentativeName,
      I_Supplier.IndustryType,
      I_Supplier.IN_GSTSupplierClassification,
      //       I_Supplier.SuplrProofOfDelivRlvtCode,


      _SupplierCompany.LayoutSortingRule,
      _SupplierCompany.ReconciliationAccount,
      _SupplierCompany.PaymentMethodsList,
      _SupplierCompany.AccountingClerk,
      _SupplierCompany.AccountingClerkFaxNumber,
      _SupplierCompany.SupplierClerkURL,
      _SupplierCompany.AccountingClerkPhoneNumber,
      _SupplierCompany.PaymentTerms as SuplrCoCodePaymentTerms,      
      _SupplierCompany.PaymentBlockingReason,
      _SupplierCompany.DeletionIndicator as SuplrIsDeltdCoCode,
      _SupplierCompany.CashPlanningGroup,
      _SupplierCompany.IsToBeCheckedForDuplicates,
      _SupplierCompany.CompanyCodeName,
      _SupplierCompany.SupplierIsBlockedForPosting,
      _SupplierCompany.WithholdingTaxCountry,
      _SupplierCompany.PreviousAccountNumber,
      _SupplierCompany.SupplierReleaseGroup,
      _SupplierCompany.MinorityGroup,
      _SupplierCompany.AlternativePayee,
      _SupplierCompany.SupplierAccountNote,

      I_Supplier._CorrespondingCustomer,
      I_Supplier._Industry,
      I_Supplier._ProcurementBlock,
      I_Supplier._QualityManagementSystem,
      I_Supplier._StandardAddress,
      I_Supplier._SupplierAccountGroup,
      I_Supplier._SupplierAccountGroupText,
      I_Supplier._SupplierBankDetails,

      I_Supplier._SupplierIndustryText,
      //                I_Supplier._SupplierPurchasingOrg,

      I_Supplier._SupplierToBusinessPartner

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SUPPLIER",
"I_SUPPLIERCOMPANY"
],
"ASSOCIATED":
[
"I_ADDRESS",
"I_CUSTOMER",
"I_INDUSTRIES",
"I_PROCUREMENTBLOCK",
"I_QUALITYMANAGEMENTSYSTEM",
"I_SUPPLIERACCOUNTGROUP",
"I_SUPPLIERACCOUNTGROUPTEXT",
"I_SUPPLIERBANKDETAILS",
"I_SUPPLIERINDUSTRYTEXT",
"I_SUPPLIERTOBUSINESSPARTNER"
],
"BASE":
[
"I_SUPPLIER"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/