FCO_MIG_NPLNR
Network number from routing number
FCO_MIG_NPLNR is a CDS View in S/4HANA. Network number from routing number. 2 CDS views read from this table.
CDS Views using this table (2)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| FCO_MIG_DERIV_P | view | left_outer | CO Delta Entries (COSP+COSS) - Derivation of Dep. Fields | |
| FJV_MIG_BACK | view | left_outer | JVA-Totals w/out period block (JVTO1) |
@AbapCatalog.sqlViewName: 'FCOV_MIG_NPLNR'
@EndUserText.label: 'Network number from routing number'
@ObjectModel.usageType.serviceQuality: #P
define view fco_mig_nplnr as select
afko.aufnr as nplnr,
afvc.vornr,
afvc.aufpl,
afvc.aplzl,
afvc.objnr
from afko
inner join afvc
on afko.aufpl = afvc.aufpl
where afvc.objnr <> '' and afvc.objnr not like 'OV%'