P_STRPFXDASSETFORMCOMPANYCODE
View for using I_address_2 full name
P_STRPFXDASSETFORMCOMPANYCODE is a CDS View in S/4HANA. View for using I_address_2 full name. It contains 1 fields. 3 CDS views read from this table.
CDS Views using this table (3)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| C_StRpFxdAssetAcquisitionFormC | view | left_outer | CONSUMPTION | Fixed Asset Acquisition Form Cube |
| C_StRpFxdAssetLocTransferFormC | view | left_outer | CONSUMPTION | Fixed Asset Location Transfer Form Cube |
| C_StRpFxdAstRetirementFormCube | view | left_outer | CONSUMPTION | Fixed Asset Retirement Form Cube |
Fields (1)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| FullName | CompanyCodeName | 3 |
@AbapCatalog.sqlViewName: 'PSRFALCOMPCODE'
@AbapCatalog.compiler.compareFilter: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #CONSUMPTION
@VDM.private:true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'View for using I_address_2 full name'
define view P_STRPFxdAssetFormCompanyCode as select from I_CompanyCode as FxdCompanyCode
left outer to one join I_AddrOrgNamePostalAddress as AddrPostal
on FxdCompanyCode.AddressID = AddrPostal.AddressID
and AddrPostal.AddressRepresentationCode = ' '
{
FxdCompanyCode.CompanyCode as CompanyCode,
cast(substring(replace(concat(AddrPostal.AddresseeName1, concat(' &@', AddrPostal.AddresseeName2)), '&@', ''),1,80) as adfullname ) as FullName
}