I_BPSUPPLIERCOMPANYPROCESS
BP Supplier Company Code Process Data
I_BPSUPPLIERCOMPANYPROCESS is a CDS View in S/4HANA. BP Supplier Company Code Process Data. It contains 6 fields. 4 CDS views read from this table.
CDS Views using this table (4)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_BPSuplrCompanyProcessChanges | view | from | TRANSACTIONAL | BP Supplier Company Code Process Changes |
| I_BPSuplrCompanyProcessChanges | view | union_all | TRANSACTIONAL | BP Supplier Company Code Process Changes |
| I_BPSupplierCompanyGov | view_entity | from | COMPOSITE | BP Supplier Company Data Governance |
| I_BPSupplierCompanyProcessTP | view_entity | from | TRANSACTIONAL | BP Supplier Company Code Process Data - TP |
Fields (6)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | CompanyCode | CompanyCode | 1 |
| KEY | MasterDataChangeProcess | MasterDataChangeProcess | 1 |
| KEY | MDChgProcessSrceObject | MDChgProcessSrceObject | 1 |
| KEY | MDChgProcessSrceSystem | MDChgProcessSrceSystem | 1 |
| KEY | MDChgProcessStep | MDChgProcessStep | 1 |
| MDChgProcessSourceModified | MDChgProcessSourceModified | 1 |
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'BP Supplier Company Code Process Data'
@VDM.viewType: #BASIC
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
serviceQuality: #X,
sizeCategory: #S,
dataClass: #MIXED
}
define view entity I_BPSupplierCompanyProcess
as select from lfb1_prc
// association [1..1] to I_BusinessPartnerProcessTP as _BusinessPartner on lfb1_prc.process_id = _BusinessPartner.MasterDataChangeProcess
// and lfb1_prc.process_step_no = _BusinessPartner.MDChgProcessStep
// and lfb1_prc.source_system = _BusinessPartner.MDChgProcessSrceSystem
// and lfb1_prc.source_id = _BusinessPartner.MDChgProcessSrceObject
association [1..1] to I_BPSupplierProcess as _Supplier on lfb1_prc.process_id = _Supplier.MasterDataChangeProcess
and lfb1_prc.process_step_no = _Supplier.MDChgProcessStep
and lfb1_prc.source_system = _Supplier.MDChgProcessSrceSystem
and lfb1_prc.source_id = _Supplier.MDChgProcessSrceObject
association [0..1] to I_CompanyCode as _CompanyCode on $projection.CompanyCode = _CompanyCode.CompanyCode
association [0..1] to I_PaymentBlockingReason as _PaymentBlockingReason on $projection.PaymentBlockingReason = _PaymentBlockingReason.PaymentBlockingReason
association [0..1] to I_ToleranceGroupText as _APARToleranceGroupName on $projection.CompanyCode = _APARToleranceGroupName.CompanyCode
and _APARToleranceGroupName.Language = $session.system_language
and $projection.APARToleranceGroup = _APARToleranceGroupName.APARToleranceGroup
association [0..*] to I_PaymentTermsText as _PaymentTermsText on $projection.PaymentTerms = _PaymentTermsText.PaymentTerms
association [0..*] to I_PaymentBlockingReasonText as _PaymentBlockingReasonText on $projection.PaymentTerms = _PaymentBlockingReasonText.PaymentBlockingReason
{
key process_id as MasterDataChangeProcess,
key process_step_no as MDChgProcessStep,
key source_system as MDChgProcessSrceSystem,
key source_id as MDChgProcessSrceObject,
@ObjectModel.foreignKey.association: '_CompanyCode'
key bukrs as CompanyCode,
assignment_id as BPAssignmentID,
lifnr as Supplier,
pernr as PersonnelNumber,
sperr as SupplierIsBlockedForPosting,
loevm as DeletionIndicator,
zuawa as LayoutSortingRule,
akont as ReconciliationAccount,
begru as AuthorizationGroup,
vzskz as InterestCalculationCode,
zwels as PaymentMethodsList,
xverr as ClearCustomerSupplier,
zahls as PaymentBlockingReason,
zterm as PaymentTerms,
eikto as SupplierClerkIDBySupplier,
zsabe as SupplierClerk,
kverm as SupplierAccountNote,
fdgrv as CashPlanningGroup,
busab as AccountingClerk,
lnrze as SupplierHeadOffice,
lnrzb as AlternativePayee,
zindt as InterestCalculationDate,
zinrt as IntrstCalcFrequencyInMonths,
datlz as LastInterestCalcRunDate,
xdezv as IsToBeLocallyProcessed,
// @Semantics.currencyCode: true
_CompanyCode.Currency as Currency,
@Semantics.amount.currencyCode: 'Currency'
webtr as BillOfExchLmtAmtInCoCodeCrcy,
kultg as CheckPaidDurationInDays,
reprf as IsDoubleInvoice,
togru as APARToleranceGroup,
hbkid as HouseBank,
xpore as ItemIsToBePaidSeparately,
mindk as MinorityGroup,
altkn as PreviousAccountNumber,
uzawe as PaymentMethodSupplement,
qland as WithholdingTaxCountry,
xedip as PaymentIsToBeSentByEDI,
frgrp as SupplierReleaseGroup,
togrr as SuplrInvcVerificatTolGroup,
tlfxs as AccountingClerkFaxNumber,
intad as AccountingClerkInternetAddress,
guzte as CreditMemoPaymentTerms,
cerdt as SupplierCertificationDate,
nodel as DeletionIsBlocked,
tlfns as AccountingClerkPhoneNumber,
source_modified as MDChgProcessSourceModified,
source_modification_blip as MDChgProcessSourceModifBinary,
source_recency as MDChgProcSrceLastChgdDateTime,
_CompanyCode,
// _BusinessPartner,
_Supplier
// _PaymentBlockingReason,
// _PaymentBlockingReasonText,
// _PaymentTermsText,
// _APARToleranceGroupName
}
where
assignment_id = '000000000001'
or assignment_id is initial
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_COMPANYCODE",
"LFB1_PRC"
],
"ASSOCIATED":
[
"I_BPSUPPLIERPROCESS",
"I_COMPANYCODE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/