I_SUPPLIER
Supplier
I_SUPPLIER is a CDS View in S/4HANA. Supplier. It contains 111 fields. 135 CDS views read from this table.
CDS Views using this table (135)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| A_SeasonPurchasePeriod | view | left_outer | COMPOSITE | Season Purchase Period |
| A_Supplier | view | from | BASIC | Supplier |
| C_AR_StRpVATForm731ItemC | view | left_outer | CONSUMPTION | Argentina VAT Form 731 |
| C_AR_StRpVATForm731ItemLogC | view | left_outer | CONSUMPTION | Argentina VAT Form 731 with Rptd item log data |
| C_BankPaymentBatchItemSupplier | view_entity | from | CONSUMPTION | Bank Payment Batch Item - Supplier Info |
| C_CashFlowItemSupplier | view | from | CONSUMPTION | Supplier of Cash Flow Item |
| C_CN_TaxInvcSupplier | view | from | CONSUMPTION | China Tax Supplier |
| C_CorrespondenceSupplierVH | view | from | CONSUMPTION | Correspondence Supplier Value Help |
| C_Customersuppliercompanycode | view | union_all | CONSUMPTION | Customer/Supplier/Company Code Information |
| C_DiffntAltvPyeAllwdSuplr | view | from | CONSUMPTION | Supplier with payee in document enabled |
| C_GRC_SupplierChangeLog | view | inner | CONSUMPTION | Supplier change log |
| C_InspLotSuplrValHelp | view | from | CONSUMPTION | Supplier Value Help |
| C_JITOutbSqncSupplierVH | view_entity | from | CONSUMPTION | Supplier |
| C_JITOutbSupplierQuickView | view_entity | from | CONSUMPTION | Supplier Details |
| C_JITOutbSupplierVH | view | from | CONSUMPTION | Value Help for Supplier |
| C_LCMSupplierValueHelp | view | from | CONSUMPTION | Supplier Value Help |
| C_MassUpdtSupplierVH | view | from | CONSUMPTION | Supplier Value Help |
| C_MM_SupplierValueHelp | view | from | CONSUMPTION | Supplier |
| C_MstrProjSuplrCntctCard | view | from | CONSUMPTION | Master Project Supplier Contact Card |
| C_NoCompanyCodeSupplier | view | from | CONSUMPTION | No Company Code Assignment Supplier |
| C_PaymentRequestSupplierVH | view_entity | from | CONSUMPTION | Supplier Value Help for Payment Request |
| C_PPS_SupplierDetail | view_entity | from | CONSUMPTION | Supplier Details |
| C_ProcmtHubSuplrDeliveryAddrVH | view | from | CONSUMPTION | Supplier Delivery Addr Value Help from Connected System |
| C_PurchaseOrderWorkflowEmail | view | left_outer | CONSUMPTION | Purchase Order Details for Workflow Deadline Email |
| C_PurDocListInvoiceDetails | view | left_outer | CONSUMPTION | |
| C_PurgInfoRecdMassUpdtSuplrVH | view | from | CONSUMPTION | Supplier Value Help |
| C_PurgInfoRecordSupplierVH | view | from | CONSUMPTION | Supplier Value Help |
| C_PurOrdMaintainCtrItemValHelp | view | left_outer | CONSUMPTION | Contract Item Value Help |
| C_PurOrdMaintainOutlAIValHelp | view | left_outer | CONSUMPTION | PO Maintenance: Value Help for Outline Agreement Items |
| C_PurOrdMaintainSuplrValHelp | view | from | CONSUMPTION | PO Maintenance: Value Help for Supplier |
| C_RO_SAFTSupplier | view | inner | CONSUMPTION | Supplier Master Data for RO SAFT |
| C_RO_StRpDomesticSlsPurListC | view | left_outer | CONSUMPTION | Romania Domestic Sales and Purchase List - Cube |
| C_RO_StRpTaxItemWithEUTaxClfnC | view | left_outer | CONSUMPTION | EU Sales Tax Item View for RO |
| C_SuplrActySuplrValueHelp | view | left_outer | CONSUMPTION | Suppliers Affected by Activity |
| C_SuplrAltvPayeeVHTemp | view | from | CONSUMPTION | Supplier Alternative Payee |
| C_SupplierByPurchasingCat | view | from | CONSUMPTION | Supplier |
| C_SupplierDetails | view | from | CONSUMPTION | Consumption view for Supplier Details |
| C_SupplierFs | view | from | CONSUMPTION | Supplier |
| C_SupplierList | view_entity | from | CONSUMPTION | Display Supplier List |
| C_SupplierListSupplierVH | view | from | CONSUMPTION | Supplier on Supplier List |
| C_SupplierReturnToAddressVH | view | from | CONSUMPTION | Supplier Return-To Address |
| C_SupplierValHelp | view | from | CONSUMPTION | Supplier Value Help |
| C_SupplierValueHelp | view | from | CONSUMPTION | Supplier Value Help |
| C_SupplierVATRegistration | view_entity | from | CONSUMPTION | Supplier without VAT Registration |
| C_WrkOrdForOPg | view | left_outer | CONSUMPTION | Work Order Details for Object Page |
| C_WrntySupplierValueHelp | view | from | CONSUMPTION | Value Help for Warranty Supplier |
| CIC_SOURCE_OF_SUPPLY_JOIN | view | left_outer | Source of Supply for valid partners | |
| ESH_N_SUPPLIERS_M | view | from | ||
| FAC_DART_Z3_S_BP_ADDRESS | view | from | Business Partner Address for Supplier | |
| FAC_DART_Z3_VENDOR | view | left_outer | Vendor Master Data | |
| FAC_SUPPLIERVH | view | from | Value help for supplier | |
| FARMLVD_APAR_ACCDOC | view | left_outer | Cleared Receivable Item Information | |
| I_AR_StRpTaxItem | view | left_outer | COMPOSITE | Argentina VAT Tax Line Item Calculation |
| I_ARunSupSelRulePurOrdSuplrVH | view | from | BASIC | |
| I_AU_StRpTPARInvoiceLineItems | view | inner | COMPOSITE | Australia TPAR Invoice Line Items |
| I_BalanceAuditTrail | view | left_outer | COMPOSITE | Line Items for Balance Audit Trail |
| I_BPAdditionalSupplierTP | view | from | TRANSACTIONAL | BO view for Additional Supplier of BP |
| I_BPAddlSuplrEmailAddressTP | view | inner | TRANSACTIONAL | BO view for email for MLTAS suppliers |
| I_BPAddlSuplrFaxNumberTP | view | inner | TRANSACTIONAL | BO view for fax num for MLTAS suppliers |
| I_BPAddlSuplrMblPhNumberTP | view | inner | TRANSACTIONAL | BO view for Mobile nos of MLTAS Suppliers |
| I_BPAddlSuplrTelNmbrTP | view | inner | TRANSACTIONAL | BO view for Tel nos of MLTAS Suppliers |
| I_BPAddlSuplrWebsiteURLTP | view | inner | TRANSACTIONAL | BO view for Website URL of MLTAS Suppliers |
| I_BPSupplierGov | view_entity | union_all | COMPOSITE | BP Supplier Data Governance |
| I_BPSupplierGovernanceVH | view_entity | from | BASIC | BP Supplier Governance |
| I_BR_NFPartner_VendCust | view | from | COMPOSITE | Brazil Nota Fiscal Customer and Supplier |
| I_BusinessPartnerSupplier | view | from | BASIC | Business Partner Supplier |
| I_CacheSupplierVH | view | from | COMPOSITE | Cache Suppliers without a Master Key |
| I_CnsldtnMasterData | view | union_all | COMPOSITE | Consolidation - Combined Master Data |
| I_ElectronicDocCockpitSuplrEml | view | from | COMPOSITE | Electronic Document: Supplier and Email |
| I_EmlTmplCustSuplrCompanyCode | view | union_all | COMPOSITE | Email Template Data Provider |
| I_FldLogsSuplrItmSuplrVH | view | from | COMPOSITE | Value Help for Supplier |
| I_IN_StRpGSTRet | view | left_outer | COMPOSITE | Tax Item Details for GST Returns |
| I_IN_SubcontractorStdVH | view | from | COMPOSITE | Value Help for Subcontractor |
| I_LU_SAFTJournalItemBP | view | inner | COMPOSITE | SAFT LU Document Business Partner |
| I_MaterialSampleDetails | view | left_outer | COMPOSITE | CDS View for Material Sample Details |
| I_PartnerCompanySupplierAuthzn | view | from | BASIC | Supplier Authorization in Company |
| I_PaytReceiptSupplierVH | view | inner | COMPOSITE | Payment Receipt Supplier |
| I_PH_SuplrCustJournalCube | view | left_outer | COMPOSITE | PH CAS Supplier Customer Journal Cube |
| I_PurchasingCategorySupplier | view | inner | COMPOSITE | Purchasing Category Supplier |
| I_SAFTGeneralLedgerSupplier | view | inner | COMPOSITE | SAF-T Gen Ledger Supplier |
| I_Ssp_Suppliervh | view | from | COMPOSITE | Basic view for supplier |
| I_Supplier_VH | view | from | BASIC | Supplier |
| I_SupplierActivitySuplrParty | view | left_outer | COMPOSITE | Supplier Activity Supplier Party |
| I_SupplierActivityTaskSupplier | view | left_outer | COMPOSITE | Supplier Activity Task Supplier |
| I_SupplierChangeLog | view | inner | COMPOSITE | Supplier Change Log |
| I_SupplierEvalRespSuplrParty | view | inner | COMPOSITE | Supplier Evaluation Response Supplier Party |
| I_VisualNominations | view | left_outer | COMPOSITE | Visual Nominations |
| I_VisualSimulation | view | left_outer | COMPOSITE | IPW Simulation in Visualization |
| P_APLineItem_5 | view | from | BASIC | |
| P_APLineItemMixedAccount | view | inner | BASIC | |
| P_AR_PurchaseImportDispSuplr | view | inner | CONSUMPTION | |
| P_AR_PurchaseTaxItemDetail | view | inner | CONSUMPTION | |
| P_AR_PurchaseVATRateDetail2 | view | inner | CONSUMPTION | |
| P_AR_PurchaseVATRateSupplier | view | inner | CONSUMPTION | |
| P_AR_SupplierPayable | view | inner | CONSUMPTION | |
| P_AR_SupplierPaymentBPDetail | view_entity | inner | CONSUMPTION | |
| P_AR_VATPrintPurchaseDetail | view | inner | CONSUMPTION | |
| P_Arbsitmopenitem | view | left_outer | COMPOSITE | |
| P_AU_StRpTPARCrrtnPhseSuplrDet | view | inner | COMPOSITE | |
| P_AU_StRpTPARSupplierDetails | view | inner | COMPOSITE | |
| P_BPPartnerFunctionNumber | view | union | COMPOSITE | |
| P_CN_CADESupplier | view | inner | CONSUMPTION | |
| P_CnsldtnSupplier | view | from | COMPOSITE | |
| P_CnsldtnSupplierT | view | from | COMPOSITE | |
| P_CO_DIANMinXrefSupplier | view | from | CONSUMPTION | All Formats - Supplier XREF |
| P_DRFEWMSupplier | view | from | BASIC | |
| P_EG_StRpTaxItem | view | left_outer | COMPOSITE | |
| P_Fiarcn_Bp_Suplr | view | from | CONSUMPTION | Supplier and Business Partner |
| P_IN_SuplrGSTHlthChk | view_entity | inner | COMPOSITE | Supplier GST India Health Check |
| P_IsSupplierEUMember | view_entity | from | CONSUMPTION | |
| P_LU_SAFTJournalItemBP | view | inner | COMPOSITE | |
| P_MY_TxItmWithSlsDeductionAmt | view | left_outer | COMPOSITE | |
| P_NO_SAFTJournalCustSup | view | inner | COMPOSITE | |
| P_NO_SAFTJournalCustSupMD | view | inner | COMPOSITE | SAF-T Norway Journal Item BP Master Data |
| P_OffsettingAccount | view | from | COMPOSITE | |
| P_OffsettingAccountVH | view | union_all | COMPOSITE | |
| P_PayReqnLineItems | view | inner | COMPOSITE | |
| P_Ph_StRpTaxItemQ | view | left_outer | COMPOSITE | |
| P_ProdAllocPlngBusPartners | view | union | COMPOSITE | |
| P_PT_SAFTTAXLANDSUP | view | inner | COMPOSITE | |
| P_PurOrdMaintainHeaderActAddr | view | left_outer | CONSUMPTION | |
| P_PurOrdMaintainSupplierAddr | view | from | CONSUMPTION | |
| P_RO_SAFTSupplier | view | inner | CONSUMPTION | Supplier Data for RO SAFT |
| P_RU_SupplierData1 | view | from | COMPOSITE | |
| P_StRpTaxItmWithEUTaxClass7 | view | left_outer | COMPOSITE | |
| P_SupplierAsCustomer | view | from | COMPOSITE | |
| P_SupplierAuthorizationGroup | view | from | COMPOSITE | |
| P_SupplierBusinessPartner | view | from | CONSUMPTION | Supplier Business Partner |
| P_SupplierWithCompanyCode | view | from | COMPOSITE | |
| P_TotalNumberOfSuppliers | view | from | CONSUMPTION | Available Suppliers |
| P_TW_TaxItem | view | left_outer | COMPOSITE | |
| P_WLF_CDS_LFA1_BG | view | from | BASIC | |
| R_SuplrListBusPartnerDetails | view | from | BASIC | Business Partner Details for Suplr List |
| SHSM_M_CMLF | view | left_outer | Claims Relating to a Vendor | |
| SHSM_SHP_VIEW_ROGR | view | inner | CDS-based Value Help Selection Method SHP_VIEW_ROGR |
Fields (111)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | AddressID | AddressID | 11 |
| KEY | Supplier | ARunSupplySelRuleAttribVal,BR_NFPartner,Supplier,SupplierAccount,SupplierForEdit,SupplierName,vendor_account | 45 |
| _CorrespondingCustomer | _CorrespondingCustomer | 2 | |
| _Industry | _Industry | 2 | |
| _ProcurementBlock | _ProcurementBlock | 2 | |
| _QualityManagementSystem | _QualityManagementSystem | 2 | |
| _StandardAddress | _StandardAddress | 3 | |
| _SupplierAccountGroup | _SupplierAccountGroup | 2 | |
| _SupplierAccountGroupText | _SupplierAccountGroupText | 2 | |
| _SupplierBankDetails | _SupplierBankDetails | 3 | |
| _SupplierCompany | _SupplierCompany | 3 | |
| _SupplierIndustryText | _SupplierIndustryText | 2 | |
| _SupplierPurchasingOrg | _SupplierPurchasingOrg | 2 | |
| _SupplierToBusinessPartner | _SupplierToBusinessPartner | 2 | |
| AccountIsBlockedForPosting | AccountIsBlockedForPosting | 4 | |
| AlternativePayeeAccountNumber | AlternativePayeeAccountNumber,SupplierAlternativePayee | 5 | |
| AlternativePayeeIsAllowed | AlternativePayeeIsAllowed | 2 | |
| AuthorizationGroup | AuthorizationGroup,BEGRU,SupplierBasicAuthorizationGrp,vendor_begru | 43 | |
| BirthDate | BirthDate | 2 | |
| BPAddrCityName | BPAddrCityName | 1 | |
| BPIsEqualizationTaxSubject | BPIsEqualizationTaxSubject | 1 | |
| BPSupplierName | BPSupplierName | 9 | |
| BR_TaxIsSplit | BR_TaxIsSplit | 2 | |
| BRSpcfcTaxBasePercentageCode | BRSpcfcTaxBasePercentageCode | 1 | |
| BusinessPartnerName1 | BusinessPartnerName1,SupplierName | 3 | |
| BusinessPartnerName2 | BusinessPartnerName2 | 1 | |
| BusinessType | BusinessType | 1 | |
| CityName | CityName | 9 | |
| ConcatenatedInternationalLocNo | ConcatenatedInternationalLocNo | 2 | |
| Country | Country | 11 | |
| CreatedByUser | CreatedByUser | 9 | |
| CreationDate | CreationDate | 9 | |
| Customer | Customer,Debtor | 7 | |
| DataController1 | DataController1 | 30 | |
| DataController10 | DataController10 | 30 | |
| DataController2 | DataController2 | 30 | |
| DataController3 | DataController3 | 30 | |
| DataController4 | DataController4 | 30 | |
| DataController5 | DataController5 | 30 | |
| DataController6 | DataController6 | 30 | |
| DataController7 | DataController7 | 30 | |
| DataController8 | DataController8 | 30 | |
| DataController9 | DataController9 | 30 | |
| DataControllerSet | DataControllerSet | 28 | |
| DataExchangeInstructionKey | DataExchangeInstructionKey | 1 | |
| DataMediumExchangeIndicator | DataMediumExchangeIndicator | 1 | |
| DeletionIndicator | DeletionIndicator | 5 | |
| FactoryCalendar | FactoryCalendar | 1 | |
| FaxNumber | FaxNumber | 3 | |
| FiscalAddress | FiscalAddress | 3 | |
| FormOfAddress | FormOfAddress | 3 | |
| IN_GSTSupplierClassification | IN_GSTSupplierClassification | 2 | |
| Industry | Industry | 5 | |
| IndustryType | IndustryType | 1 | |
| InternationalLocationNumber1 | InternationalLocationNumber1 | 5 | |
| InternationalLocationNumber2 | InternationalLocationNumber2 | 5 | |
| InternationalLocationNumber3 | InternationalLocationNumber3 | 5 | |
| IsBusinessPurposeCompleted | IsBusinessPurposeCompleted | 18 | |
| IsNaturalPerson | IsNaturalPerson | 2 | |
| IsOneTimeAccount | IsOneTimeAccount | 12 | |
| IsToBeAcceptedAtOrigin | IsToBeAcceptedAtOrigin | 1 | |
| OrganizationBPName1 | OrganizationBPName1,SupplierName | 10 | |
| OrganizationBPName2 | OrganizationBPName2 | 5 | |
| PaymentIsBlockedForSupplier | PaymentIsBlockedForSupplier | 3 | |
| PaymentReason | PaymentReason | 1 | |
| PaytSlipWthRefSubscriber | PaytSlipWthRefSubscriber | 1 | |
| PhoneNumber1 | PhoneNumber,PhoneNumber1 | 7 | |
| PhoneNumber2 | PhoneNumber2 | 2 | |
| PostalCode | PostalCode | 5 | |
| PostingIsBlocked | AccountIsBlockedForPosting,PostingIsBlocked | 9 | |
| PurchasingIsBlocked | PurchasingIsBlocked | 8 | |
| ReferenceAccountGroup | ReferenceAccountGroup | 3 | |
| Region | Region | 3 | |
| ResponsibleType | ResponsibleType | 4 | |
| SortField | SearchTerm,SortField,SupplierName,SupplierSearchText | 7 | |
| StreetName | StreetName | 3 | |
| SuplrProofOfDelivRlvtCode | SuplrProofOfDelivRlvtCode | 1 | |
| SuplrQltyInProcmtCertfnValidTo | SuplrQltyInProcmtCertfnValidTo | 3 | |
| SuplrQualityManagementSystem | SuplrQualityManagementSystem | 3 | |
| SuplrTaxAuthorityAccountNumber | SuplrTaxAuthorityAccountNumber | 1 | |
| SupplierAccountGroup | ReferenceAccountGroup,SupplierAccountGroup | 31 | |
| SupplierCentralDeletionIsBlock | SupplierCentralDeletionIsBlock | 1 | |
| SupplierCorporateGroup | SupplierCorporateGroup | 6 | |
| SupplierFullName | FullName,SupplierFullName | 8 | |
| SupplierIsPlantRelevant | SupplierIsPlantRelevant | 1 | |
| SupplierIsSubRangeRelevant | SupplierIsSubRangeRelevant | 1 | |
| SupplierLanguage | SupplierLanguage | 2 | |
| SupplierName | ARunSupplySelRuleAttribValDesc,Name,supplier_name,SupplierName | 33 | |
| SupplierPlant | SupplierPlant | 1 | |
| SupplierProcurementBlock | SupplierProcurementBlock | 3 | |
| TaxInvoiceRepresentativeName | TaxInvoiceRepresentativeName | 1 | |
| TaxJurisdiction | TaxJurisdiction | 5 | |
| TaxNumber1 | SupplierTaxID1,TaxNumber1 | 8 | |
| TaxNumber2 | SupplierTaxID2,TaxNumber2 | 8 | |
| TaxNumber3 | SupplierTaxID3,TaxNumber3 | 4 | |
| TaxNumber4 | SupplierTaxID4,TaxNumber4 | 4 | |
| TaxNumber5 | SupplierTaxID5,TaxNumber5 | 4 | |
| TaxNumberResponsible | TaxNumberResponsible | 4 | |
| TaxNumberType | TaxNumberType | 3 | |
| TradingPartner | TradingPartner | 2 | |
| TrainStationName | TrainStationName | 1 | |
| TranspServiceAgentStstcGrp | TranspServiceAgentStstcGrp | 1 | |
| UK_CompanyRegistrationNumber | UK_CompanyRegistrationNumber | 2 | |
| UK_ContractorBusinessType | UK_ContractorBusinessType | 2 | |
| UK_PartnerTaxReference | UK_PartnerTaxReference | 2 | |
| UK_PartnerTradingName | UK_PartnerTradingName | 2 | |
| UK_VerificationNumber | UK_VerificationNumber | 2 | |
| UK_VerificationStatus | UK_VerificationStatus | 2 | |
| UK_VerifiedTaxStatus | UK_VerifiedTaxStatus | 2 | |
| VATLiability | VATLiability | 3 | |
| VATRegistration | VATRegistration | 6 |
@AbapCatalog.sqlViewName: 'I_SUPPLIER_CDS'
@AbapCatalog.preserveKey:true
@AccessControl.personalData.blocking: #REQUIRED
@AccessControl.personalData.blockingIndicator: 'IsBusinessPurposeCompleted'
@AccessControl.authorizationCheck: #CHECK
@AccessControl.privilegedAssociations: ['_AddressDefaultRepresentation','_AddressRepresentation']
@Analytics: {
dataCategory: #DIMENSION,
dataExtraction: {
enabled: true,
delta.changeDataCapture: {
mapping:[
{
table: 'LFA1', role: #MAIN,
viewElement: ['Supplier'],
tableElement: ['lifnr']
},
{
table: 'ADRC', role: #LEFT_OUTER_TO_ONE_JOIN,
viewElement: ['AddressID'],
tableElement: ['Addrnumber']
} ]
}
}
}
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Supplier'
@Metadata.allowExtensions: true
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.supportedCapabilities: [#SQL_DATA_SOURCE,
#CDS_MODELING_DATA_SOURCE,
#CDS_MODELING_ASSOCIATION_TARGET,
#ANALYTICAL_DIMENSION,
#EXTRACTION_DATA_SOURCE]
@ObjectModel.modelingPattern: #ANALYTICAL_DIMENSION
@ObjectModel.representativeKey: 'Supplier'
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #MASTER
@VDM.viewType: #BASIC
@ObjectModel.sapObjectNodeType.name: 'Supplier'
define view I_Supplier
as select from lfa1
//private associations
association [1..1] to I_SupplierToBusinessPartner as _SupplierToBusinessPartner on $projection.Supplier = _SupplierToBusinessPartner.Supplier
association [0..1] to bp1020 as _FiscalData on lfa1.lifnr = _FiscalData.partnr // technically wrong for lifnr<>but000.partner, but usage of $projection.BusinessPartner is not allowed. H
//public composition associations
association [0..*] to I_SupplierCompany as _SupplierCompany on $projection.Supplier = _SupplierCompany.Supplier
association [0..*] to I_SupplierPurchasingOrg as _SupplierPurchasingOrg on $projection.Supplier = _SupplierPurchasingOrg.Supplier
association [0..*] to I_SupplierBankDetails as _SupplierBankDetails on $projection.Supplier = _SupplierBankDetails.Supplier
//public value helps
association [0..1] to I_SupplierAccountGroup as _SupplierAccountGroup on $projection.SupplierAccountGroup = _SupplierAccountGroup.SupplierAccountGroup
association [0..*] to I_Industries as _Industry on $projection.Industry = _Industry.IndustrySector
//public foreign key associations
association [0..1] to I_Customer as _CorrespondingCustomer on $projection.Customer = _CorrespondingCustomer.Customer
////public texts
association [0..*] to I_SupplierAccountGroupText as _SupplierAccountGroupText on $projection.SupplierAccountGroup = _SupplierAccountGroupText.SupplierAccountGroup
association [0..*] to I_SupplierIndustryText as _SupplierIndustryText on $projection.Industry = _SupplierIndustryText.SupplierIndustry
////public foreign key associations
//quality management
association [0..1] to I_ProcurementBlock as _ProcurementBlock on $projection.SupplierProcurementBlock = _ProcurementBlock.ProcurementBlock
association [0..1] to I_QualityManagementSystem as _QualityManagementSystem on $projection.SuplrQualityManagementSystem = _QualityManagementSystem.QualityManagementSystem
association [1..1] to I_Address as _StandardAddress on $projection.AddressID = _StandardAddress.AddressID
// association [1..1] to I_BusinessPartnerAddress as _BusinessPartnerAddress on $projection.BusinessPartner = _BusinessPartnerAddress.BusinessPartner
// and $projection.AddressID = _BusinessPartnerAddress.AddressNumber
association [0..1] to E_Supplier as _SupplierExt on $projection.Supplier = _SupplierExt.Supplier
// association added for I_ADDRESS_2 adoption
association [0..1] to I_OrganizationAddress as _AddressDefaultRepresentation on $projection.AddressID = _AddressDefaultRepresentation.AddressID
and _AddressDefaultRepresentation.AddressRepresentationCode is initial
association [0..1] to I_Address_2 as _AddressRepresentation on $projection.AddressID = _AddressRepresentation.AddressID
and _AddressRepresentation.AddressRepresentationCode is initial
and _AddressRepresentation.AddressPersonID is initial
//Adoption from I_Address_2
association [0..*] to I_AddressEmailAddress_2 as _EmailAddress on _EmailAddress.AddressID = $projection.AddressID
and _EmailAddress.AddressPersonID is initial
association [0..1] to I_AddrCurDefaultEmailAddress as _CurrentDfltEmailAddress on _CurrentDfltEmailAddress.AddressID = $projection.AddressID
and _CurrentDfltEmailAddress.AddressPersonID is initial
association [0..*] to I_AddressPhoneNumber_2 as _PhoneNumber on _PhoneNumber.AddressID = $projection.AddressID
and _PhoneNumber.AddressPersonID is initial
association [0..1] to I_AddrCurDfltLandlinePhoneNmbr as _CurrentDfltLandlinePhoneNmbr on _CurrentDfltLandlinePhoneNmbr.AddressID = $projection.AddressID
and _CurrentDfltLandlinePhoneNmbr.AddressPersonID is initial
association [0..1] to I_AddrCurDfltMobilePhoneNumber as _CurrentDfltMobilePhoneNumber on _CurrentDfltMobilePhoneNumber.AddressID = $projection.AddressID
and _CurrentDfltMobilePhoneNumber.AddressPersonID is initial
association [0..*] to I_AddressFaxNumber_2 as _FaxNumber on _FaxNumber.AddressID = $projection.AddressID
and _FaxNumber.AddressPersonID is initial
association [0..1] to I_AddrCurDefaultFaxNumber as _CurrentDfltFaxNumber on _CurrentDfltFaxNumber.AddressID = $projection.AddressID
and _CurrentDfltFaxNumber.AddressPersonID is initial
association [0..*] to I_AddressURI as _UniformResourceIdentifier on _UniformResourceIdentifier.AddressID = $projection.AddressID
and _UniformResourceIdentifier.AddressPersonID is initial
association [0..1] to I_AddressMainWebsiteURL as _MainWebsiteURL on _MainWebsiteURL.AddressID = $projection.AddressID
and _MainWebsiteURL.AddressPersonID is initial
{
@ObjectModel.text.element: 'SupplierName'
@Consumption.labelElement: 'SupplierName'
key cast(lfa1.lifnr as lifnr preserving type) as Supplier,
// _SupplierToBusinessPartner._BusinessPartner.BusinessPartner as BusinessPartner,
@EndUserText.label: 'Account Group'
ktokk as SupplierAccountGroup,
@Semantics.text: true
cast(substring(rtrim(replace(concat(name1, concat(' &@', name2)), '&@', ''),' '),1,80) as md_supplier_name) as SupplierName,
cast(concat( concat( concat( concat( concat( concat_with_space( anred, name1, 1 ), name2 ), name3 ), name4 ), '/' ),
concat_with_space( pstlz, ort01 , 1 ) ) as md_supplier_full_name) as SupplierFullName,
// // For increase in field length
@Semantics.text: true
cast(substring(rtrim(replace(concat(_AddressDefaultRepresentation.AddresseeName1, concat(' &@', _AddressDefaultRepresentation.AddresseeName2)), '&@', ''),' '),1,81) as suppliername_2) as BPSupplierName,
cast(concat( concat_with_space( concat_with_space( concat_with_space(_AddressDefaultRepresentation.AddresseeName1, _AddressDefaultRepresentation.AddresseeName2,1 ), _AddressDefaultRepresentation.AddresseeName3,1 ), _AddressDefaultRepresentation.AddresseeName4,1 ), ' ' ) as supplierfullname_2) as BPSupplierFullName,
// _AddressRepresentation.OrganizationName1 as BusinessPartnerName1,
// _AddressRepresentation.OrganizationName2 as BusinessPartnerName2,
// _AddressRepresentation.OrganizationName3 as BusinessPartnerName3,
// _AddressRepresentation.OrganizationName4 as BusinessPartnerName4,
//Adoption of Name and Address fields
_AddressDefaultRepresentation.AddresseeName1 as BusinessPartnerName1,
_AddressDefaultRepresentation.AddresseeName2 as BusinessPartnerName2,
_AddressDefaultRepresentation.AddresseeName3 as BusinessPartnerName3,
_AddressDefaultRepresentation.AddresseeName4 as BusinessPartnerName4,
_AddressDefaultRepresentation.CityName as BPAddrCityName,
_AddressDefaultRepresentation.StreetName as BPAddrStreetName,
_AddressDefaultRepresentation.AddressSearchTerm1 as AddressSearchTerm1,
_AddressDefaultRepresentation.AddressSearchTerm2 as AddressSearchTerm2,
_AddressDefaultRepresentation.DistrictName as DistrictName,
_AddressDefaultRepresentation.POBoxDeviatingCityName as POBoxDeviatingCityName,
_AddressDefaultRepresentation.FormOfAddress as BusinessPartnerFormOfAddress,
lfa1.cvp_xblck as IsBusinessPurposeCompleted,
@EndUserText.label: 'Created By'
ernam as CreatedByUser,
erdat as CreationDate,
xcpdk as IsOneTimeAccount,
begru as AuthorizationGroup,
stceg as VATRegistration,
@EndUserText.label: 'Posting Block(Deprecated)'
@API.element.releaseState: #DEPRECATED
@API.element.successor: 'PostingIsBlocked'
sperr as AccountIsBlockedForPosting,
txjcd as TaxJurisdiction,
scacd as SupplierStandardCarrierAccess,
sfrgr as SupplierFwdAgentFreightGroup,
dlgrp as SupplierAgentProcedureGroup,
regss as SupplIsSocialInsuranceRegtrd,
actss as SocialInsuranceActivityCode,
@EndUserText.label: 'Group Key'
konzs as SupplierCorporateGroup, //to be used
kunnr as Customer,
brsch as Industry, // siehe Anmerkung
stcd1 as TaxNumber1, // tax number 1&2: siehe Anmerkung
stcd2 as TaxNumber2,
stcd3 as TaxNumber3,
stcd4 as TaxNumber4,
stcd5 as TaxNumber5,
stcd6 as TaxNumber6,
sperr as PostingIsBlocked,
@EndUserText.label: 'Purch. Block'
sperm as PurchasingIsBlocked,
@EndUserText.quickInfo: 'International Location Number (Part 1)'
bbbnr as InternationalLocationNumber1,
@EndUserText.quickInfo: 'International Location Number (Part 2)'
bbsnr as InternationalLocationNumber2,
@EndUserText.label: 'Check Digit'
bubkz as InternationalLocationNumber3,
adrnr as AddressID,
lfa1.regio as Region,
lfa1.name1 as OrganizationBPName1,
lfa1.name2 as OrganizationBPName2,
lfa1.ort01 as CityName,
lfa1.pstlz as PostalCode,
lfa1.stras as StreetName,
lfa1.land1 as Country,
cast((concat(concat(bbbnr,concat(' & ', bbsnr)),concat(' & ',bubkz))) as md_international_loc ) as ConcatenatedInternationalLocNo,
//quality management
sperq as SupplierProcurementBlock,
qssys as SuplrQualityManagementSystem,
qssysdat as SuplrQltyInProcmtCertfnValidTo,
//globalization
lfa1.spras as SupplierLanguage,
lfa1.lnrza as AlternativePayeeAccountNumber,
lfa1.telf1 as PhoneNumber1,
lfa1.telfx as FaxNumber,
lfa1.stkzn as IsNaturalPerson,
lfa1.stenr