P_GLOBASSETASSIGNMENT
P_GLOBASSETASSIGNMENT is a CDS View in S/4HANA. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_GlobAssetAssignment | view | from | BASIC | Country/Region Specific Fixed Asset Assignment |
@AbapCatalog: { sqlViewName: 'PGFASSETASSGMT', preserveKey: true, compiler.compareFilter: true }
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #BASIC
@VDM.private:true
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true
define view P_GlobAssetAssignment
as select from glofaatmdpndnt
left outer to one join t001 on t001.bukrs = glofaatmdpndnt.bukrs
inner join P_TF_AssetRedesignSwitchStatus( P_SAPClient : $session.client ) on P_TF_AssetRedesignSwitchStatus.IsActive = ''
{
key glofaatmdpndnt.bukrs as CompanyCode,
key glofaatmdpndnt.anln1 as MasterFixedAsset,
key glofaatmdpndnt.anln2 as FixedAsset,
key glofaatmdpndnt.bdatu as ValidityEndDate,
glofaatmdpndnt.adatu as ValidityStartDate,
glofaatmdpndnt.glo_rus_shd_rsn as RU_AssetShutdownReason,
glofaatmdpndnt.glo_rus_shd_docn as RU_AssetShutdownDocument,
glofaatmdpndnt.glo_rus_pld_chck as RU_AssetIsPledged,
glofaatmdpndnt.glo_rus_pld_amnt as RU_AssetPledgeAmountInLocCrcy,
glofaatmdpndnt.glo_rus_pld_rcpn as RU_AssetPledgee,
glofaatmdpndnt.glo_rus_docnum as RU_AssetPledgeDocumentNumber,
glofaatmdpndnt.glo_rus_icnmb as RU_AssetInventoryCardNumber,
glofaatmdpndnt.glo_rus_okof16 as RU_AssetOKOF,
glofaatmdpndnt.glo_rus_depgrn as RU_AssetDepreciationGroup,
glofaatmdpndnt.glo_rus_tax_offc as RU_AssetTaxOfficeCode,
glofaatmdpndnt.glo_rus_szpk as RU_AssetSZPKIsApplied,
glofaatmdpndnt.glo_rus_prt_ptyp as RU_AssetPropertyType,
cast(glofaatmdpndnt.glo_rus_prt_oktm as firu_oktmo_int) as RU_PropertyTaxOKTMO,
glofaatmdpndnt.glo_rus_prt_scat as RU_PropertyTaxSpecialCategory,
glofaatmdpndnt.glo_rus_prt_tcrt as RU_PropertyTaxRateReduction,
glofaatmdpndnt.glo_rus_prt_tcam as RU_PropertyTaxAmtReduction,
glofaatmdpndnt.glo_rus_prt_tcex as RU_PropertyTaxExemption,
glofaatmdpndnt.glo_rus_prt_pnum as RU_PropertyTaxObjectNumber,
glofaatmdpndnt.glo_rus_prt_pncd as RU_PropertyTaxObjectNumberType,
glofaatmdpndnt.glo_rus_prt_cadv as RU_PrptyCadastrAmtInLoclCrcy,
glofaatmdpndnt.glo_rus_prt_shre as RU_AssetCommonPropertyShare,
glofaatmdpndnt.glo_rus_prt_aloc as RU_RoomFloorAreaInSquareMeter,
glofaatmdpndnt.glo_rus_prt_atot as RU_RoomBuildFloorAreaInSqMtr,
glofaatmdpndnt.glo_rus_prt_isre as RU_AssetIsRealEstate,
glofaatmdpndnt.glo_rus_txb_type as RU_TransportTaxPowerUnit,
@Semantics.quantity.unitOfMeasure: 'RU_TransportTaxPowerUnit'
glofaatmdpndnt.glo_rus_txb_unit as RU_TranspTaxBaseQtyInBaseUnit,
glofaatmdpndnt.glo_rus_trt_tcex as RU_TransportTaxExemption,
glofaatmdpndnt.glo_rus_trt_tcrt as RU_TransportTaxReduction,
glofaatmdpndnt.glo_rus_ttx_stld as RU_VehicleStolenDate,
glofaatmdpndnt.glo_rus_ttx_rtrd as RU_VehicleReturnDate,
glofaatmdpndnt.glo_rus_ttx_rgsd as RU_VehicleRegistrationDate,
glofaatmdpndnt.glo_rus_ttx_rmvd as RU_VehicleCancellationDate,
cast(glofaatmdpndnt.glo_rus_ttx_oktm as firu_oktmo_int) as RU_TransportTaxOKTMO,
glofaatmdpndnt.glo_rus_ttx_lnum as RU_VehicleLicensePlateNumber,
glofaatmdpndnt.glo_rus_trt_tcam as RU_TranspTxAmtReduction,
glofaatmdpndnt.glo_rus_ttx_vpca as RU_VehTranspTxPriceCategory,
glofaatmdpndnt.glo_rus_ttx_plat as RU_VehicleIsRegisteredInPlaton,
glofaatmdpndnt.glo_rus_ttx_shre as RU_TransptCommonOwnershipShare,
cast('' as cade_fxdast_usage) as CN_CADEFixedAssetUsage,
cast('CLASSIC' as faa_authcntxt) as AssetAuthorizationContext,
@Semantics.amount.currencyCode: 'Currency'
t001.waers as Currency,
t001.land1 as Country
}
union all select from glo_faat_md_tdd
left outer to one join t001 on t001.bukrs = glo_faat_md_tdd.comp_code
inner join P_TF_AssetRedesignSwitchStatus( P_SAPClient : $session.client ) on P_TF_AssetRedesignSwitchStatus.IsActive = 'X'
{
key glo_faat_md_tdd.comp_code as CompanyCode,
key glo_faat_md_tdd.asset_no as MasterFixedAsset,
key glo_faat_md_tdd.asset_subno as FixedAsset,
key glo_faat_md_tdd.valid_to_date as ValidityEndDate,
glo_faat_md_tdd.valid_from_date as ValidityStartDate,
glo_faat_md_tdd.glo_rus_shd_rsn as RU_AssetShutdownReason,
glo_faat_md_tdd.glo_rus_shd_docn as RU_AssetShutdownDocument,
glo_faat_md_tdd.glo_rus_pld_chck as RU_AssetIsPledged,
glo_faat_md_tdd.glo_rus_pld_amnt as RU_AssetPledgeAmountInLocCrcy,
glo_faat_md_tdd.glo_rus_pld_rcpn as RU_AssetPledgee,
glo_faat_md_tdd.glo_rus_docnum as RU_AssetPledgeDocumentNumber,
glo_faat_md_tdd.glo_rus_icnmb as RU_AssetInventoryCardNumber,
glo_faat_md_tdd.glo_rus_okof16 as RU_AssetOKOF,
glo_faat_md_tdd.glo_rus_depgrn as RU_AssetDepreciationGroup,
glo_faat_md_tdd.glo_rus_tax_offc as RU_AssetTaxOfficeCode,
glo_faat_md_tdd.glo_rus_szpk as RU_AssetSZPKIsApplied,
glo_faat_md_tdd.glo_rus_prt_ptyp as RU_AssetPropertyType,
cast(glo_faat_md_tdd.glo_rus_prt_oktm as firu_oktmo_int) as RU_PropertyTaxOKTMO,
glo_faat_md_tdd.glo_rus_prt_scat as RU_PropertyTaxSpecialCategory,
glo_faat_md_tdd.glo_rus_prt_tcrt as RU_PropertyTaxRateReduction,
glo_faat_md_tdd.glo_rus_prt_tcam as RU_PropertyTaxAmtReduction,
glo_faat_md_tdd.glo_rus_prt_tcex as RU_PropertyTaxExemption,
glo_faat_md_tdd.glo_rus_prt_pnum as RU_PropertyTaxObjectNumber,
glo_faat_md_tdd.glo_rus_prt_pncd as RU_PropertyTaxObjectNumberType,
glo_faat_md_tdd.glo_rus_prt_cadv as RU_PrptyCadastrAmtInLoclCrcy,
glo_faat_md_tdd.glo_rus_prt_shre as RU_AssetCommonPropertyShare,
glo_faat_md_tdd.glo_rus_prt_aloc as RU_RoomFloorAreaInSquareMeter,
glo_faat_md_tdd.glo_rus_prt_atot as RU_RoomBuildFloorAreaInSqmtr,
glo_faat_md_tdd.glo_rus_prt_isre as RU_AssetIsRealEstate,
glo_faat_md_tdd.glo_rus_txb_type as RU_TransportTaxPowerUnit,
@Semantics.quantity.unitOfMeasure: 'RU_TransportTaxPowerUnit'
glo_faat_md_tdd.glo_rus_txb_unit as RU_TranspTaxBaseQtyInBaseUnit,
glo_faat_md_tdd.glo_rus_trt_tcex as RU_TransportTaxExemption,
glo_faat_md_tdd.glo_rus_trt_tcrt as RU_TransportTaxReduction,
glo_faat_md_tdd.glo_rus_ttx_stld as RU_VehicleStolenDate,
glo_faat_md_tdd.glo_rus_ttx_rtrd as RU_VehicleReturnDate,
glo_faat_md_tdd.glo_rus_ttx_rgsd as RU_VehicleRegistrationDate,
glo_faat_md_tdd.glo_rus_ttx_rmvd as RU_VehicleCancellationDate,
cast(glo_faat_md_tdd.glo_rus_ttx_oktm as firu_oktmo_int) as RU_TransportTaxOKTMO,
glo_faat_md_tdd.glo_rus_ttx_lnum as RU_VehicleLicensePlateNumber,
glo_faat_md_tdd.glo_rus_trt_tcam as RU_TranspTxAmtReduction,
glo_faat_md_tdd.glo_rus_ttx_vpca as RU_VehTranspTxPriceCategory,
glo_faat_md_tdd.glo_rus_ttx_plat as RU_VehicleIsRegisteredInPlaton,
glo_faat_md_tdd.glo_rus_trt_shre as RU_TransptCommonOwnershipShare,
glo_faat_md_tdd.cade_fxdast_usage as CN_CADEFixedAssetUsage,
cast('NEW' as faa_authcntxt) as AssetAuthorizationContext,
@Semantics.amount.currencyCode: 'Currency'
t001.waers as Currency,
t001.land1 as Country
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"GLOFAATMDPNDNT",
"GLO_FAAT_MD_TDD",
"T001"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/