P_BILLINGDOCUMENTITEMBASIC
P_BILLINGDOCUMENTITEMBASIC 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_BillingDocumentItemBasic | view | from | BASIC | Billing Document Item Basic |
@VDM.viewType: #BASIC
@VDM.private:true
@AccessControl: {
authorizationCheck: #NOT_REQUIRED
}
@Metadata.ignorePropagatedAnnotations: true
define view entity P_BillingDocumentItemBasic
as select from P_BillingDocumentItemBasic_1 as BillingDocumentItem
inner join P_VBRP_SDM_PHASE_BADI_TF as SwitchState on SwitchState.SDMPhase = 'F'
{
key BillingDocumentItem.BillingDocument,
key BillingDocumentItem.BillingDocumentItem,
BillingDocumentItem.SalesDocumentItemCategory,
BillingDocumentItem.SalesDocumentItemType,
BillingDocumentItem.ReturnItemProcessingType,
BillingDocumentItem.CreatedByUser,
@Semantics.systemDate.createdAt: true
BillingDocumentItem.CreationDate,
@Semantics.systemTime.createdAt
BillingDocumentItem.CreationTime,
BillingDocumentItem.ReferenceLogicalSystem,
BillingDocumentItem.OrganizationDivision,
BillingDocumentItem.Division,
BillingDocumentItem.SalesOffice,
BillingDocumentItem.Product,
BillingDocumentItem.OriginallyRequestedMaterial,
BillingDocumentItem.InternationalArticleNumber,
BillingDocumentItem.PricingReferenceMaterial,
BillingDocumentItem.Batch,
BillingDocumentItem.ProductHierarchyNode,
BillingDocumentItem.ProductGroup,
BillingDocumentItem.AdditionalMaterialGroup1,
BillingDocumentItem.AdditionalMaterialGroup2,
BillingDocumentItem.AdditionalMaterialGroup3,
BillingDocumentItem.AdditionalMaterialGroup4,
BillingDocumentItem.AdditionalMaterialGroup5,
BillingDocumentItem.ProductConfiguration,
BillingDocumentItem.MaterialCommissionGroup,
BillingDocumentItem.Plant,
BillingDocumentItem.StorageLocation,
BillingDocumentItem.ReplacementPartType,
BillingDocumentItem.MaterialGroupHierarchy1,
BillingDocumentItem.MaterialGroupHierarchy2,
BillingDocumentItem.PlantRegion,
BillingDocumentItem.PlantCounty,
BillingDocumentItem.PlantCity,
BillingDocumentItem.TransitPlant,
BillingDocumentItem.ValueChainCategory,
BillingDocumentItem.BOMExplosion,
BillingDocumentItem.MaterialDeterminationType,
//Billing
@Semantics.text: true
BillingDocumentItem.BillingDocumentItemText,
BillingDocumentItem.ServicesRenderedDate,
@Semantics.quantity.unitOfMeasure: 'BillingQuantityUnit'
BillingDocumentItem.BillingQuantity,
BillingDocumentItem.BillingQuantityUnit,
@Semantics.quantity.unitOfMeasure: 'BaseUnit'
BillingDocumentItem.BillingQuantityInBaseUnit,
BillingDocumentItem.BaseUnit,
@Semantics.quantity.unitOfMeasure: 'BaseUnit'
BillingDocumentItem.MRPRequiredQuantityInBaseUnit,
BillingDocumentItem.BillingToBaseQuantityDnmntr,
BillingDocumentItem.BillingToBaseQuantityNmrtr,
@Semantics.quantity.unitOfMeasure: 'ItemWeightUnit'
BillingDocumentItem.ItemGrossWeight,
@Semantics.quantity.unitOfMeasure: 'ItemWeightUnit'
BillingDocumentItem.ItemNetWeight,
BillingDocumentItem.ItemWeightUnit,
@Semantics.quantity.unitOfMeasure: 'ItemVolumeUnit'
BillingDocumentItem.ItemVolume,
BillingDocumentItem.ItemVolumeUnit,
BillingDocumentItem.BillToPartyCountry,
BillingDocumentItem.BillToPartyRegion,
BillingDocumentItem.BillingPlanRule,
BillingDocumentItem.BillingPlan,
BillingDocumentItem.BillingPlanItem,
//Status
// foreign key association has to be defined (in next release (?)), target: I_DocBillingStatus
BillingDocumentItem.DocumentBillingStatus,
//Pricing
@Semantics.amount.currencyCode: 'TransactionCurrency'
BillingDocumentItem.NetAmount,
BillingDocumentItem.TransactionCurrency,
@Semantics.amount.currencyCode: 'TransactionCurrency'
BillingDocumentItem.GrossAmount,
BillingDocumentItem.PricingDate,
BillingDocumentItem.PriceDetnExchangeRate,
@Semantics.quantity.unitOfMeasure: 'BaseUnit'
BillingDocumentItem.PricingScaleQuantityInBaseUnit,
@Semantics.amount.currencyCode: 'TransactionCurrency'
BillingDocumentItem.TaxAmount,
@Semantics.amount.currencyCode: 'TransactionCurrency'
BillingDocumentItem.CostAmount,
@Semantics.amount.currencyCode: 'TransactionCurrency'
BillingDocumentItem.Subtotal1Amount,
@Semantics.amount.currencyCode: 'TransactionCurrency'
BillingDocumentItem.Subtotal2Amount,
@Semantics.amount.currencyCode: 'TransactionCurrency'
BillingDocumentItem.Subtotal3Amount,
@Semantics.amount.currencyCode: 'TransactionCurrency'
BillingDocumentItem.Subtotal4Amount,
@Semantics.amount.currencyCode: 'TransactionCurrency'
BillingDocumentItem.Subtotal5Amount,
@Semantics.amount.currencyCode: 'TransactionCurrency'
BillingDocumentItem.Subtotal6Amount,
BillingDocumentItem.StatisticalValueControl,
BillingDocumentItem.CashDiscountIsDeductible,
BillingDocumentItem.CustomerConditionGroup1,
BillingDocumentItem.CustomerConditionGroup2,
BillingDocumentItem.CustomerConditionGroup3,
BillingDocumentItem.CustomerConditionGroup4,
BillingDocumentItem.CustomerConditionGroup5,
BillingDocumentItem.ManualPriceChangeType,
BillingDocumentItem.MaterialPricingGroup,
BillingDocumentItem.StatisticsExchangeRate,
BillingDocumentItem.MainItemPricingRefMaterial,
BillingDocumentItem.MainItemMaterialPricingGroup,
BillingDocumentItem.TimeSheetOvertimeCategory,
BillingDocumentItem.PricingRelevance,
// Tax
BillingDocumentItem.DepartureCountry,
BillingDocumentItem.TaxJurisdiction,
BillingDocumentItem.ProductTaxClassification1,
BillingDocumentItem.ProductTaxClassification2,
BillingDocumentItem.ProductTaxClassification3,
BillingDocumentItem.ProductTaxClassification4,
BillingDocumentItem.ProductTaxClassification5,
BillingDocumentItem.ProductTaxClassification6,
BillingDocumentItem.ProductTaxClassification7,
BillingDocumentItem.ProductTaxClassification8,
BillingDocumentItem.ProductTaxClassification9,
BillingDocumentItem.ZeroVATRsn,
BillingDocumentItem.TaxCode,
BillingDocumentItem.TaxRateValidityStartDate,
// Foreign trade
BillingDocumentItem.CountryOfOrigin,
BillingDocumentItem.RegionOfOrigin,
BillingDocumentItem.CommodityCode,
//Payment
@Semantics.amount.currencyCode: 'TransactionCurrency'
BillingDocumentItem.EligibleAmountForCashDiscount,
//Accounting
BillingDocumentItem.BusinessArea,
BillingDocumentItem.ProfitCenter,
BillingDocumentItem.WBSElementInternalID,
BillingDocumentItem.ProviderContract,
BillingDocumentItem.ProviderContractItem,
BillingDocumentItem.BillingPerformancePeriodStrDte,
BillingDocumentItem.BillingPerformancePeriodEndDte,
BillingDocumentItem.ControllingArea,
BillingDocumentItem.ProfitabilitySegment_2,
BillingDocumentItem.OrderID,
BillingDocumentItem.CostCenter,
BillingDocumentItem.OriginSDDocument,
BillingDocumentItem.OriginSDDocumentItem,
BillingDocumentItem.PriceDetnExchangeRateDate,
BillingDocumentItem.MatlAccountAssignmentGroup,
//Reference
BillingDocumentItem.ReferenceSDDocument,
BillingDocumentItem.ReferenceSDDocumentItem,
BillingDocumentItem.ReferenceSDDocumentCategory,
BillingDocumentItem.SalesDocument,
BillingDocumentItem.SalesDocumentItem,
BillingDocumentItem.SalesSDDocumentCategory,
BillingDocumentItem.HigherLevelItem,
BillingDocumentItem.HigherLvlItmOfBatSpltItm,
BillingDocumentItem.BillingDocumentItemInPartSgmt,
BillingDocumentItem.ExternalReferenceDocument,
BillingDocumentItem.BillingDocExtReferenceDocItem,
BillingDocumentItem.PrelimBillingDocument,
BillingDocumentItem.PrelimBillingDocumentItem,
//Sales
BillingDocumentItem.SalesGroup,
BillingDocumentItem.AdditionalCustomerGroup1,
BillingDocumentItem.AdditionalCustomerGroup2,
BillingDocumentItem.AdditionalCustomerGroup3,
BillingDocumentItem.AdditionalCustomerGroup4,
BillingDocumentItem.AdditionalCustomerGroup5,
BillingDocumentItem.SDDocumentReason,
BillingDocumentItem.RetailPromotion,
@Semantics.amount.currencyCode: 'TransactionCurrency'
BillingDocumentItem.RebateBasisAmount,
BillingDocumentItem.VolumeRebateGroup,
BillingDocumentItem.ItemIsRelevantForCredit,
@Semantics.amount.currencyCode: 'TransactionCurrency'
BillingDocumentItem.CreditRelatedPrice,
BillingDocumentItem.SalesDeal,
BillingDocumentItem.SalesPromotion,
BillingDocumentItem.SalesOrderSalesDistrict,
BillingDocumentItem.SalesOrderCustomerGroup,
BillingDocumentItem.SalesOrderCustomerPriceGroup,
BillingDocumentItem.SalesOrderPriceListType,
BillingDocumentItem.SalesOrderSalesOrganization,
BillingDocumentItem.SalesOrderDistributionChannel,
BillingDocumentItem.SalesDocIsCreatedFromReference,
BillingDocumentItem.ShippingPoint,
// CRM
BillingDocumentItem.ServiceDocumentType,
BillingDocumentItem.ServiceDocument,
BillingDocumentItem.ServiceDocumentItem,
BillingDocumentItem.BusinessSolutionOrder,
BillingDocumentItem.BusinessSolutionOrderItem,
//Other fields
BillingDocumentItem.HigherLevelItemUsage,
BillingDocumentItem.BillingDocumentIsTemporary,
//Added Analytics fields
BillingDocumentItem.SDDocumentCategory,
BillingDocumentItem.BillingDocumentType,
BillingDocumentItem.SalesOrganization,
BillingDocumentItem.DistributionChannel,
BillingDocumentItem.CustomerPriceGroup,
BillingDocumentItem.CustomerGroup,
BillingDocumentItem.Country,
BillingDocumentItem.Region,
BillingDocumentItem.CityCode,
BillingDocumentItem.SalesDistrict,
BillingDocumentItem.OverallSDProcessStatus,
BillingDocumentItem.OverallBillingStatus,
//sales
BillingDocumentItem.SoldToParty,
//payment
BillingDocumentItem.PayerParty,
BillingDocumentItem.BillingDocumentDate,
BillingDocumentItem.CompanyCode,
BillingDocumentItem.County,
BillingDocumentItem.CustomerRebateAgreement,
BillingDocumentItem.BillingDocumentCategory,
//ship-to
BillingDocumentItem.ShipToParty,
//bill-to
BillingDocumentItem.BillToParty,
BillingDocumentItem.SalesEmployee,
BillingDocumentItem.ResponsibleEmployee,
BillingDocumentItem.PricingDocument,
BillingDocumentItem.CancelledBillingDocument
}
union all select from P_BillingDocumentItemBasic_2 as BillingDocumentItem
inner join P_VBRP_SDM_PHASE_BADI_TF as SwitchState on SwitchState.SDMPhase = 'N'
{
key BillingDocumentItem.BillingDocument,
key BillingDocumentItem.BillingDocumentItem,
BillingDocumentItem.SalesDocumentItemCategory,
BillingDocumentItem.SalesDocumentItemType,
BillingDocumentItem.ReturnItemProcessingType,
BillingDocumentItem.CreatedByUser,
BillingDocumentItem.CreationDate,
BillingDocumentItem.CreationTime,
BillingDocumentItem.ReferenceLogicalSystem,
BillingDocumentItem.OrganizationDivision,
BillingDocumentItem.Division,
BillingDocumentItem.SalesOffice,
BillingDocumentItem.Product,
BillingDocumentItem.OriginallyRequestedMaterial,
BillingDocumentItem.InternationalArticleNumber,
BillingDocumentItem.PricingReferenceMaterial,
BillingDocumentItem.Batch,
BillingDocumentItem.ProductHierarchyNode,
BillingDocumentItem.ProductGroup,
BillingDocumentItem.AdditionalMaterialGroup1,
BillingDocumentItem.AdditionalMaterialGroup2,
BillingDocumentItem.AdditionalMaterialGroup3,
BillingDocumentItem.AdditionalMaterialGroup4,
BillingDocumentItem.AdditionalMaterialGroup5,
BillingDocumentItem.ProductConfiguration,
BillingDocumentItem.MaterialCommissionGroup,
BillingDocumentItem.Plant,
BillingDocumentItem.StorageLocation,
BillingDocumentItem.ReplacementPartType,
BillingDocumentItem.MaterialGroupHierarchy1,
BillingDocumentItem.MaterialGroupHierarchy2,
BillingDocumentItem.PlantRegion,
BillingDocumentItem.PlantCounty,
BillingDocumentItem.PlantCity,
BillingDocumentItem.TransitPlant,
BillingDocumentItem.ValueChainCategory,
BillingDocumentItem.BOMExplosion,
BillingDocumentItem.MaterialDeterminationType,
//Billing
BillingDocumentItem.BillingDocumentItemText,
BillingDocumentItem.ServicesRenderedDate,
BillingDocumentItem.BillingQuantity,
BillingDocumentItem.BillingQuantityUnit,
BillingDocumentItem.BillingQuantityInBaseUnit,
BillingDocumentItem.BaseUnit,
BillingDocumentItem.MRPRequiredQuantityInBaseUnit,
BillingDocumentItem.BillingToBaseQuantityDnmntr,
BillingDocumentItem.BillingToBaseQuantityNmrtr,
BillingDocumentItem.ItemGrossWeight,
BillingDocumentItem.ItemNetWeight,
BillingDocumentItem.ItemWeightUnit,
BillingDocumentItem.ItemVolume,
BillingDocumentItem.ItemVolumeUnit,
BillingDocumentItem.BillToPartyCountry,
BillingDocumentItem.BillToPartyRegion,
BillingDocumentItem.BillingPlanRule,
BillingDocumentItem.BillingPlan,
BillingDocumentItem.BillingPlanItem,
//Status
// foreign key association has to be defined (in next release (?)), target: I_DocBillingStatus
BillingDocumentItem.DocumentBillingStatus,
//Pricing
BillingDocumentItem.NetAmount,
BillingDocumentItem.TransactionCurrency,
BillingDocumentItem.GrossAmount,
BillingDocumentItem.PricingDate,
BillingDocumentItem.PriceDetnExchangeRate,
BillingDocumentItem.PricingScaleQuantityInBaseUnit,
BillingDocumentItem.TaxAmount,
BillingDocumentItem.CostAmount,
BillingDocumentItem.Subtotal1Amount,
BillingDocumentItem.Subtotal2Amount,
BillingDocumentItem.Subtotal3Amount,
BillingDocumentItem.Subtotal4Amount,
BillingDocumentItem.Subtotal5Amount,
BillingDocumentItem.Subtotal6Amount,
BillingDocumentItem.StatisticalValueControl,
BillingDocumentItem.CashDiscountIsDeductible,
BillingDocumentItem.CustomerConditionGroup1,
BillingDocumentItem.CustomerConditionGroup2,
BillingDocumentItem.CustomerConditionGroup3,
BillingDocumentItem.CustomerConditionGroup4,
BillingDocumentItem.CustomerConditionGroup5,
BillingDocumentItem.ManualPriceChangeType,
BillingDocumentItem.MaterialPricingGroup,
BillingDocumentItem.StatisticsExchangeRate,
BillingDocumentItem.MainItemPricingRefMaterial,
BillingDocumentItem.MainItemMaterialPricingGroup,
BillingDocumentItem.TimeSheetOvertimeCategory,
BillingDocumentItem.PricingRelevance,
// Tax
BillingDocumentItem.DepartureCountry,
BillingDocumentItem.TaxJurisdiction,
BillingDocumentItem.ProductTaxClassification1,
BillingDocumentItem.ProductTaxClassification2,
BillingDocumentItem.ProductTaxClassification3,
BillingDocumentItem.ProductTaxClassification4,
BillingDocumentItem.ProductTaxClassification5,
BillingDocumentItem.ProductTaxClassification6,
BillingDocumentItem.ProductTaxClassification7,
BillingDocumentItem.ProductTaxClassification8,
BillingDocumentItem.ProductTaxClassification9,
BillingDocumentItem.ZeroVATRsn,
BillingDocumentItem.TaxCode,
BillingDocumentItem.TaxRateValidityStartDate,
// Foreign trade
BillingDocumentItem.CountryOfOrigin,
BillingDocumentItem.RegionOfOrigin,
BillingDocumentItem.CommodityCode,
//Payment
BillingDocumentItem.EligibleAmountForCashDiscount,
//Accounting
BillingDocumentItem.BusinessArea,
BillingDocumentItem.ProfitCenter,
BillingDocumentItem.WBSElementInternalID,
BillingDocumentItem.ProviderContract,
BillingDocumentItem.ProviderContractItem,
BillingDocumentItem.BillingPerformancePeriodStrDte,
BillingDocumentItem.BillingPerformancePeriodEndDte,
BillingDocumentItem.ControllingArea,
BillingDocumentItem.ProfitabilitySegment_2,
BillingDocumentItem.OrderID,
BillingDocumentItem.CostCenter,
BillingDocumentItem.OriginSDDocument,
BillingDocumentItem.OriginSDDocumentItem,
BillingDocumentItem.PriceDetnExchangeRateDate,
BillingDocumentItem.MatlAccountAssignmentGroup,
//Reference
BillingDocumentItem.ReferenceSDDocument,
BillingDocumentItem.ReferenceSDDocumentItem,
BillingDocumentItem.ReferenceSDDocumentCategory,
BillingDocumentItem.SalesDocument,
BillingDocumentItem.SalesDocumentItem,
BillingDocumentItem.SalesSDDocumentCategory,
BillingDocumentItem.HigherLevelItem,
BillingDocumentItem.HigherLvlItmOfBatSpltItm,
BillingDocumentItem.BillingDocumentItemInPartSgmt,
BillingDocumentItem.ExternalReferenceDocument,
BillingDocumentItem.BillingDocExtReferenceDocItem,
BillingDocumentItem.PrelimBillingDocument,
BillingDocumentItem.PrelimBillingDocumentItem,
//Sales
BillingDocumentItem.SalesGroup,
BillingDocumentItem.AdditionalCustomerGroup1,
BillingDocumentItem.AdditionalCustomerGroup2,
BillingDocumentItem.AdditionalCustomerGroup3,
BillingDocumentItem.AdditionalCustomerGroup4,
BillingDocumentItem.AdditionalCustomerGroup5,
BillingDocumentItem.SDDocumentReason,
BillingDocumentItem.RetailPromotion,
BillingDocumentItem.RebateBasisAmount,
BillingDocumentItem.VolumeRebateGroup,
BillingDocumentItem.ItemIsRelevantForCredit,
BillingDocumentItem.CreditRelatedPrice,
BillingDocumentItem.SalesDeal,
BillingDocumentItem.SalesPromotion,
BillingDocumentItem.SalesOrderSalesDistrict,
BillingDocumentItem.SalesOrderCustomerGroup,
BillingDocumentItem.SalesOrderCustomerPriceGroup,
BillingDocumentItem.SalesOrderPriceListType,
BillingDocumentItem.SalesOrderSalesOrganization,
BillingDocumentItem.SalesOrderDistributionChannel,
BillingDocumentItem.SalesDocIsCreatedFromReference,
BillingDocumentItem.ShippingPoint,
// CRM
BillingDocumentItem.ServiceDocumentType,
BillingDocumentItem.ServiceDocument,
BillingDocumentItem.ServiceDocumentItem,
BillingDocumentItem.BusinessSolutionOrder,
BillingDocumentItem.BusinessSolutionOrderItem,
//Other fields
BillingDocumentItem.HigherLevelItemUsage,
BillingDocumentItem.BillingDocumentIsTemporary,
//Added Analytics fields
BillingDocumentItem.SDDocumentCategory,
BillingDocumentItem.BillingDocumentType,
BillingDocumentItem.SalesOrganization,
BillingDocumentItem.DistributionChannel,
BillingDocumentItem.CustomerPriceGroup,
BillingDocumentItem.CustomerGroup,
BillingDocumentItem.Country,
BillingDocumentItem.Region,
BillingDocumentItem.CityCode,
BillingDocumentItem.SalesDistrict,
BillingDocumentItem.OverallSDProcessStatus,
BillingDocumentItem.OverallBillingStatus,
//sales
BillingDocumentItem.SoldToParty,
//payment
BillingDocumentItem.PayerParty,
BillingDocumentItem.BillingDocumentDate,
BillingDocumentItem.CompanyCode,
BillingDocumentItem.County,
BillingDocumentItem.CustomerRebateAgreement,
BillingDocumentItem.BillingDocumentCategory,
//ship-to
BillingDocumentItem.ShipToParty,
//bill-to
BillingDocumentItem.BillToParty,
BillingDocumentItem.SalesEmployee,
BillingDocumentItem.ResponsibleEmployee,
BillingDocumentItem.PricingDocument,
BillingDocumentItem.CancelledBillingDocument
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_BILLINGDOCUMENTITEMBASIC_1",
"P_BILLINGDOCUMENTITEMBASIC_2"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/