P_BillingDocumentItemBasic
Billing Document Basic Data Merge VDM Models
P_BillingDocumentItemBasic is a Basic CDS View that provides data about "Billing Document Basic Data Merge VDM Models" in SAP S/4HANA. It reads from 4 data sources (P_BillingDocumentItemBasic_1, P_BillingDocumentItemBasic_2, P_VBRP_SDM_PHASE_BADI_TF, P_VBRP_SDM_PHASE_BADI_TF) and exposes 371 fields with key fields BillingDocument, BillingDocumentItem, BillingDocumentItem. Part of development package VF_XPRA.
Data Sources (4)
| Source | Alias | Join Type |
|---|---|---|
| P_BillingDocumentItemBasic_1 | BillingDocumentItem | from |
| P_BillingDocumentItemBasic_2 | BillingDocumentItem | union_all |
| P_VBRP_SDM_PHASE_BADI_TF | SwitchState | inner |
| P_VBRP_SDM_PHASE_BADI_TF | SwitchState | inner |
Annotations (4)
| Name | Value | Level | Field |
|---|---|---|---|
| VDM.viewType | #BASIC | view | |
| VDM.private | true | view | |
| AccessControl.authorizationCheck | #NOT_REQUIRED | view | |
| Metadata.ignorePropagatedAnnotations | true | view |
Fields (371)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | BillingDocument | P_BillingDocumentItemBasic_2 | BillingDocument | |
| KEY | BillingDocumentItem | P_BillingDocumentItemBasic_2 | BillingDocumentItem | |
| SalesDocumentItemCategory | P_BillingDocumentItemBasic_2 | SalesDocumentItemCategory | ||
| SalesDocumentItemType | P_BillingDocumentItemBasic_2 | SalesDocumentItemType | ||
| ReturnItemProcessingType | P_BillingDocumentItemBasic_2 | ReturnItemProcessingType | ||
| CreatedByUser | P_BillingDocumentItemBasic_2 | CreatedByUser | ||
| CreationDate | P_BillingDocumentItemBasic_2 | CreationDate | ||
| CreationTime | P_BillingDocumentItemBasic_2 | CreationTime | ||
| ReferenceLogicalSystem | P_BillingDocumentItemBasic_2 | ReferenceLogicalSystem | ||
| OrganizationDivision | P_BillingDocumentItemBasic_2 | OrganizationDivision | ||
| Division | P_BillingDocumentItemBasic_2 | Division | ||
| SalesOffice | P_BillingDocumentItemBasic_2 | SalesOffice | ||
| Product | P_BillingDocumentItemBasic_2 | Product | ||
| OriginallyRequestedMaterial | P_BillingDocumentItemBasic_2 | OriginallyRequestedMaterial | ||
| InternationalArticleNumber | P_BillingDocumentItemBasic_2 | InternationalArticleNumber | ||
| PricingReferenceMaterial | P_BillingDocumentItemBasic_2 | PricingReferenceMaterial | ||
| Batch | P_BillingDocumentItemBasic_2 | Batch | ||
| ProductHierarchyNode | P_BillingDocumentItemBasic_2 | ProductHierarchyNode | ||
| ProductGroup | P_BillingDocumentItemBasic_2 | ProductGroup | ||
| AdditionalMaterialGroup1 | P_BillingDocumentItemBasic_2 | AdditionalMaterialGroup1 | ||
| AdditionalMaterialGroup2 | P_BillingDocumentItemBasic_2 | AdditionalMaterialGroup2 | ||
| AdditionalMaterialGroup3 | P_BillingDocumentItemBasic_2 | AdditionalMaterialGroup3 | ||
| AdditionalMaterialGroup4 | P_BillingDocumentItemBasic_2 | AdditionalMaterialGroup4 | ||
| AdditionalMaterialGroup5 | P_BillingDocumentItemBasic_2 | AdditionalMaterialGroup5 | ||
| ProductConfiguration | P_BillingDocumentItemBasic_2 | ProductConfiguration | ||
| MaterialCommissionGroup | P_BillingDocumentItemBasic_2 | MaterialCommissionGroup | ||
| Plant | P_BillingDocumentItemBasic_2 | Plant | ||
| StorageLocation | P_BillingDocumentItemBasic_2 | StorageLocation | ||
| ReplacementPartType | P_BillingDocumentItemBasic_2 | ReplacementPartType | ||
| MaterialGroupHierarchy1 | P_BillingDocumentItemBasic_2 | MaterialGroupHierarchy1 | ||
| MaterialGroupHierarchy2 | P_BillingDocumentItemBasic_2 | MaterialGroupHierarchy2 | ||
| PlantRegion | P_BillingDocumentItemBasic_2 | PlantRegion | ||
| PlantCounty | P_BillingDocumentItemBasic_2 | PlantCounty | ||
| PlantCity | P_BillingDocumentItemBasic_2 | PlantCity | ||
| TransitPlant | P_BillingDocumentItemBasic_2 | TransitPlant | ||
| ValueChainCategory | P_BillingDocumentItemBasic_2 | ValueChainCategory | ||
| BOMExplosion | P_BillingDocumentItemBasic_2 | BOMExplosion | ||
| MaterialDeterminationType | P_BillingDocumentItemBasic_2 | MaterialDeterminationType | ||
| BillingDocumentItemText | P_BillingDocumentItemBasic_2 | BillingDocumentItemText | ||
| ServicesRenderedDate | P_BillingDocumentItemBasic_2 | ServicesRenderedDate | ||
| BillingQuantity | P_BillingDocumentItemBasic_2 | BillingQuantity | ||
| BillingQuantityUnit | P_BillingDocumentItemBasic_2 | BillingQuantityUnit | ||
| BillingQuantityInBaseUnit | P_BillingDocumentItemBasic_2 | BillingQuantityInBaseUnit | ||
| BaseUnit | P_BillingDocumentItemBasic_2 | BaseUnit | ||
| MRPRequiredQuantityInBaseUnit | P_BillingDocumentItemBasic_2 | MRPRequiredQuantityInBaseUnit | ||
| BillingToBaseQuantityDnmntr | P_BillingDocumentItemBasic_2 | BillingToBaseQuantityDnmntr | ||
| BillingToBaseQuantityNmrtr | P_BillingDocumentItemBasic_2 | BillingToBaseQuantityNmrtr | ||
| ItemGrossWeight | P_BillingDocumentItemBasic_2 | ItemGrossWeight | ||
| ItemNetWeight | P_BillingDocumentItemBasic_2 | ItemNetWeight | ||
| ItemWeightUnit | P_BillingDocumentItemBasic_2 | ItemWeightUnit | ||
| ItemVolume | P_BillingDocumentItemBasic_2 | ItemVolume | ||
| ItemVolumeUnit | P_BillingDocumentItemBasic_2 | ItemVolumeUnit | ||
| BillToPartyCountry | P_BillingDocumentItemBasic_2 | BillToPartyCountry | ||
| BillToPartyRegion | P_BillingDocumentItemBasic_2 | BillToPartyRegion | ||
| BillingPlanRule | P_BillingDocumentItemBasic_2 | BillingPlanRule | ||
| BillingPlan | P_BillingDocumentItemBasic_2 | BillingPlan | ||
| BillingPlanItem | P_BillingDocumentItemBasic_2 | BillingPlanItem | ||
| DocumentBillingStatus | P_BillingDocumentItemBasic_2 | DocumentBillingStatus | ||
| NetAmount | P_BillingDocumentItemBasic_2 | NetAmount | ||
| TransactionCurrency | P_BillingDocumentItemBasic_2 | TransactionCurrency | ||
| GrossAmount | P_BillingDocumentItemBasic_2 | GrossAmount | ||
| PricingDate | P_BillingDocumentItemBasic_2 | PricingDate | ||
| PriceDetnExchangeRate | P_BillingDocumentItemBasic_2 | PriceDetnExchangeRate | ||
| PricingScaleQuantityInBaseUnit | P_BillingDocumentItemBasic_2 | PricingScaleQuantityInBaseUnit | ||
| TaxAmount | P_BillingDocumentItemBasic_2 | TaxAmount | ||
| CostAmount | P_BillingDocumentItemBasic_2 | CostAmount | ||
| Subtotal1Amount | P_BillingDocumentItemBasic_2 | Subtotal1Amount | ||
| Subtotal2Amount | P_BillingDocumentItemBasic_2 | Subtotal2Amount | ||
| Subtotal3Amount | P_BillingDocumentItemBasic_2 | Subtotal3Amount | ||
| Subtotal4Amount | P_BillingDocumentItemBasic_2 | Subtotal4Amount | ||
| Subtotal5Amount | P_BillingDocumentItemBasic_2 | Subtotal5Amount | ||
| Subtotal6Amount | P_BillingDocumentItemBasic_2 | Subtotal6Amount | ||
| StatisticalValueControl | P_BillingDocumentItemBasic_2 | StatisticalValueControl | ||
| CashDiscountIsDeductible | P_BillingDocumentItemBasic_2 | CashDiscountIsDeductible | ||
| CustomerConditionGroup1 | P_BillingDocumentItemBasic_2 | CustomerConditionGroup1 | ||
| CustomerConditionGroup2 | P_BillingDocumentItemBasic_2 | CustomerConditionGroup2 | ||
| CustomerConditionGroup3 | P_BillingDocumentItemBasic_2 | CustomerConditionGroup3 | ||
| CustomerConditionGroup4 | P_BillingDocumentItemBasic_2 | CustomerConditionGroup4 | ||
| CustomerConditionGroup5 | P_BillingDocumentItemBasic_2 | CustomerConditionGroup5 | ||
| ManualPriceChangeType | P_BillingDocumentItemBasic_2 | ManualPriceChangeType | ||
| MaterialPricingGroup | P_BillingDocumentItemBasic_2 | MaterialPricingGroup | ||
| StatisticsExchangeRate | P_BillingDocumentItemBasic_2 | StatisticsExchangeRate | ||
| MainItemPricingRefMaterial | P_BillingDocumentItemBasic_2 | MainItemPricingRefMaterial | ||
| MainItemMaterialPricingGroup | P_BillingDocumentItemBasic_2 | MainItemMaterialPricingGroup | ||
| TimeSheetOvertimeCategory | P_BillingDocumentItemBasic_2 | TimeSheetOvertimeCategory | ||
| PricingRelevance | P_BillingDocumentItemBasic_2 | PricingRelevance | ||
| DepartureCountry | P_BillingDocumentItemBasic_2 | DepartureCountry | ||
| TaxJurisdiction | P_BillingDocumentItemBasic_2 | TaxJurisdiction | ||
| ProductTaxClassification1 | P_BillingDocumentItemBasic_2 | ProductTaxClassification1 | ||
| ProductTaxClassification2 | P_BillingDocumentItemBasic_2 | ProductTaxClassification2 | ||
| ProductTaxClassification3 | P_BillingDocumentItemBasic_2 | ProductTaxClassification3 | ||
| ProductTaxClassification4 | P_BillingDocumentItemBasic_2 | ProductTaxClassification4 | ||
| ProductTaxClassification5 | P_BillingDocumentItemBasic_2 | ProductTaxClassification5 | ||
| ProductTaxClassification6 | P_BillingDocumentItemBasic_2 | ProductTaxClassification6 | ||
| ProductTaxClassification7 | P_BillingDocumentItemBasic_2 | ProductTaxClassification7 | ||
| ProductTaxClassification8 | P_BillingDocumentItemBasic_2 | ProductTaxClassification8 | ||
| ProductTaxClassification9 | P_BillingDocumentItemBasic_2 | ProductTaxClassification9 | ||
| ZeroVATRsn | P_BillingDocumentItemBasic_2 | ZeroVATRsn | ||
| TaxCode | P_BillingDocumentItemBasic_2 | TaxCode | ||
| TaxRateValidityStartDate | P_BillingDocumentItemBasic_2 | TaxRateValidityStartDate | ||
| CountryOfOrigin | P_BillingDocumentItemBasic_2 | CountryOfOrigin | ||
| RegionOfOrigin | P_BillingDocumentItemBasic_2 | RegionOfOrigin | ||
| CommodityCode | P_BillingDocumentItemBasic_2 | CommodityCode | ||
| EligibleAmountForCashDiscount | P_BillingDocumentItemBasic_2 | EligibleAmountForCashDiscount | ||
| BusinessArea | P_BillingDocumentItemBasic_2 | BusinessArea | ||
| ProfitCenter | P_BillingDocumentItemBasic_2 | ProfitCenter | ||
| WBSElementInternalID | P_BillingDocumentItemBasic_2 | WBSElementInternalID | ||
| ProviderContract | P_BillingDocumentItemBasic_2 | ProviderContract | ||
| ProviderContractItem | P_BillingDocumentItemBasic_2 | ProviderContractItem | ||
| BillingPerformancePeriodStrDte | P_BillingDocumentItemBasic_2 | BillingPerformancePeriodStrDte | ||
| BillingPerformancePeriodEndDte | P_BillingDocumentItemBasic_2 | BillingPerformancePeriodEndDte | ||
| ControllingArea | P_BillingDocumentItemBasic_2 | ControllingArea | ||
| ProfitabilitySegment_2 | P_BillingDocumentItemBasic_2 | ProfitabilitySegment_2 | ||
| OrderID | P_BillingDocumentItemBasic_2 | OrderID | ||
| CostCenter | P_BillingDocumentItemBasic_2 | CostCenter | ||
| OriginSDDocument | P_BillingDocumentItemBasic_2 | OriginSDDocument | ||
| OriginSDDocumentItem | P_BillingDocumentItemBasic_2 | OriginSDDocumentItem | ||
| PriceDetnExchangeRateDate | P_BillingDocumentItemBasic_2 | PriceDetnExchangeRateDate | ||
| MatlAccountAssignmentGroup | P_BillingDocumentItemBasic_2 | MatlAccountAssignmentGroup | ||
| ReferenceSDDocument | P_BillingDocumentItemBasic_2 | ReferenceSDDocument | ||
| ReferenceSDDocumentItem | P_BillingDocumentItemBasic_2 | ReferenceSDDocumentItem | ||
| ReferenceSDDocumentCategory | P_BillingDocumentItemBasic_2 | ReferenceSDDocumentCategory | ||
| SalesDocument | P_BillingDocumentItemBasic_2 | SalesDocument | ||
| SalesDocumentItem | P_BillingDocumentItemBasic_2 | SalesDocumentItem | ||
| SalesSDDocumentCategory | P_BillingDocumentItemBasic_2 | SalesSDDocumentCategory | ||
| HigherLevelItem | P_BillingDocumentItemBasic_2 | HigherLevelItem | ||
| HigherLvlItmOfBatSpltItm | P_BillingDocumentItemBasic_2 | HigherLvlItmOfBatSpltItm | ||
| BillingDocumentItemInPartSgmt | P_BillingDocumentItemBasic_2 | BillingDocumentItemInPartSgmt | ||
| ExternalReferenceDocument | P_BillingDocumentItemBasic_2 | ExternalReferenceDocument | ||
| BillingDocExtReferenceDocItem | P_BillingDocumentItemBasic_2 | BillingDocExtReferenceDocItem | ||
| PrelimBillingDocument | P_BillingDocumentItemBasic_2 | PrelimBillingDocument | ||
| PrelimBillingDocumentItem | P_BillingDocumentItemBasic_2 | PrelimBillingDocumentItem | ||
| SalesGroup | P_BillingDocumentItemBasic_2 | SalesGroup | ||
| AdditionalCustomerGroup1 | P_BillingDocumentItemBasic_2 | AdditionalCustomerGroup1 | ||
| AdditionalCustomerGroup2 | P_BillingDocumentItemBasic_2 | AdditionalCustomerGroup2 | ||
| AdditionalCustomerGroup3 | P_BillingDocumentItemBasic_2 | AdditionalCustomerGroup3 | ||
| AdditionalCustomerGroup4 | P_BillingDocumentItemBasic_2 | AdditionalCustomerGroup4 | ||
| AdditionalCustomerGroup5 | P_BillingDocumentItemBasic_2 | AdditionalCustomerGroup5 | ||
| SDDocumentReason | P_BillingDocumentItemBasic_2 | SDDocumentReason | ||
| RetailPromotion | P_BillingDocumentItemBasic_2 | RetailPromotion | ||
| RebateBasisAmount | P_BillingDocumentItemBasic_2 | RebateBasisAmount | ||
| VolumeRebateGroup | P_BillingDocumentItemBasic_2 | VolumeRebateGroup | ||
| ItemIsRelevantForCredit | P_BillingDocumentItemBasic_2 | ItemIsRelevantForCredit | ||
| CreditRelatedPrice | P_BillingDocumentItemBasic_2 | CreditRelatedPrice | ||
| SalesDeal | P_BillingDocumentItemBasic_2 | SalesDeal | ||
| SalesPromotion | P_BillingDocumentItemBasic_2 | SalesPromotion | ||
| SalesOrderSalesDistrict | P_BillingDocumentItemBasic_2 | SalesOrderSalesDistrict | ||
| SalesOrderCustomerGroup | P_BillingDocumentItemBasic_2 | SalesOrderCustomerGroup | ||
| SalesOrderCustomerPriceGroup | P_BillingDocumentItemBasic_2 | SalesOrderCustomerPriceGroup | ||
| SalesOrderPriceListType | P_BillingDocumentItemBasic_2 | SalesOrderPriceListType | ||
| SalesOrderSalesOrganization | P_BillingDocumentItemBasic_2 | SalesOrderSalesOrganization | ||
| SalesOrderDistributionChannel | P_BillingDocumentItemBasic_2 | SalesOrderDistributionChannel | ||
| SalesDocIsCreatedFromReference | P_BillingDocumentItemBasic_2 | SalesDocIsCreatedFromReference | ||
| ShippingPoint | P_BillingDocumentItemBasic_2 | ShippingPoint | ||
| ServiceDocumentType | P_BillingDocumentItemBasic_2 | ServiceDocumentType | ||
| ServiceDocument | P_BillingDocumentItemBasic_2 | ServiceDocument | ||
| ServiceDocumentItem | P_BillingDocumentItemBasic_2 | ServiceDocumentItem | ||
| BusinessSolutionOrder | P_BillingDocumentItemBasic_2 | BusinessSolutionOrder | ||
| BusinessSolutionOrderItem | P_BillingDocumentItemBasic_2 | BusinessSolutionOrderItem | ||
| HigherLevelItemUsage | P_BillingDocumentItemBasic_2 | HigherLevelItemUsage | ||
| BillingDocumentIsTemporary | P_BillingDocumentItemBasic_2 | BillingDocumentIsTemporary | ||
| SDDocumentCategory | P_BillingDocumentItemBasic_2 | SDDocumentCategory | ||
| BillingDocumentType | P_BillingDocumentItemBasic_2 | BillingDocumentType | ||
| SalesOrganization | P_BillingDocumentItemBasic_2 | SalesOrganization | ||
| DistributionChannel | P_BillingDocumentItemBasic_2 | DistributionChannel | ||
| CustomerPriceGroup | P_BillingDocumentItemBasic_2 | CustomerPriceGroup | ||
| CustomerGroup | P_BillingDocumentItemBasic_2 | CustomerGroup | ||
| Country | P_BillingDocumentItemBasic_2 | Country | ||
| Region | P_BillingDocumentItemBasic_2 | Region | ||
| CityCode | P_BillingDocumentItemBasic_2 | CityCode | ||
| SalesDistrict | P_BillingDocumentItemBasic_2 | SalesDistrict | ||
| OverallSDProcessStatus | P_BillingDocumentItemBasic_2 | OverallSDProcessStatus | ||
| OverallBillingStatus | P_BillingDocumentItemBasic_2 | OverallBillingStatus | ||
| SoldToParty | P_BillingDocumentItemBasic_2 | SoldToParty | ||
| PayerParty | P_BillingDocumentItemBasic_2 | PayerParty | ||
| BillingDocumentDate | P_BillingDocumentItemBasic_2 | BillingDocumentDate | ||
| CompanyCode | P_BillingDocumentItemBasic_2 | CompanyCode | ||
| County | P_BillingDocumentItemBasic_2 | County | ||
| CustomerRebateAgreement | P_BillingDocumentItemBasic_2 | CustomerRebateAgreement | ||
| BillingDocumentCategory | P_BillingDocumentItemBasic_2 | BillingDocumentCategory | ||
| ShipToParty | P_BillingDocumentItemBasic_2 | ShipToParty | ||
| BillToParty | P_BillingDocumentItemBasic_2 | BillToParty | ||
| SalesEmployee | P_BillingDocumentItemBasic_2 | SalesEmployee | ||
| ResponsibleEmployee | P_BillingDocumentItemBasic_2 | ResponsibleEmployee | ||
| PricingDocument | P_BillingDocumentItemBasic_2 | PricingDocument | ||
| BillingDocument | ||||
| KEY | BillingDocumentItem | P_BillingDocumentItemBasic_2 | BillingDocumentItem | |
| SalesDocumentItemCategory | P_BillingDocumentItemBasic_2 | SalesDocumentItemCategory | ||
| SalesDocumentItemType | P_BillingDocumentItemBasic_2 | SalesDocumentItemType | ||
| ReturnItemProcessingType | P_BillingDocumentItemBasic_2 | ReturnItemProcessingType | ||
| CreatedByUser | P_BillingDocumentItemBasic_2 | CreatedByUser | ||
| CreationDate | P_BillingDocumentItemBasic_2 | CreationDate | ||
| CreationTime | P_BillingDocumentItemBasic_2 | CreationTime | ||
| ReferenceLogicalSystem | P_BillingDocumentItemBasic_2 | ReferenceLogicalSystem | ||
| OrganizationDivision | P_BillingDocumentItemBasic_2 | OrganizationDivision | ||
| Division | P_BillingDocumentItemBasic_2 | Division | ||
| SalesOffice | P_BillingDocumentItemBasic_2 | SalesOffice | ||
| Product | P_BillingDocumentItemBasic_2 | Product | ||
| OriginallyRequestedMaterial | P_BillingDocumentItemBasic_2 | OriginallyRequestedMaterial | ||
| InternationalArticleNumber | P_BillingDocumentItemBasic_2 | InternationalArticleNumber | ||
| PricingReferenceMaterial | P_BillingDocumentItemBasic_2 | PricingReferenceMaterial | ||
| Batch | P_BillingDocumentItemBasic_2 | Batch | ||
| ProductHierarchyNode | P_BillingDocumentItemBasic_2 | ProductHierarchyNode | ||
| ProductGroup | P_BillingDocumentItemBasic_2 | ProductGroup | ||
| AdditionalMaterialGroup1 | P_BillingDocumentItemBasic_2 | AdditionalMaterialGroup1 | ||
| AdditionalMaterialGroup2 | P_BillingDocumentItemBasic_2 | AdditionalMaterialGroup2 | ||
| AdditionalMaterialGroup3 | P_BillingDocumentItemBasic_2 | AdditionalMaterialGroup3 | ||
| AdditionalMaterialGroup4 | P_BillingDocumentItemBasic_2 | AdditionalMaterialGroup4 | ||
| AdditionalMaterialGroup5 | P_BillingDocumentItemBasic_2 | AdditionalMaterialGroup5 | ||
| ProductConfiguration | P_BillingDocumentItemBasic_2 | ProductConfiguration | ||
| MaterialCommissionGroup | P_BillingDocumentItemBasic_2 | MaterialCommissionGroup | ||
| Plant | P_BillingDocumentItemBasic_2 | Plant | ||
| StorageLocation | P_BillingDocumentItemBasic_2 | StorageLocation | ||
| ReplacementPartType | P_BillingDocumentItemBasic_2 | ReplacementPartType | ||
| MaterialGroupHierarchy1 | P_BillingDocumentItemBasic_2 | MaterialGroupHierarchy1 | ||
| MaterialGroupHierarchy2 | P_BillingDocumentItemBasic_2 | MaterialGroupHierarchy2 | ||
| PlantRegion | P_BillingDocumentItemBasic_2 | PlantRegion | ||
| PlantCounty | P_BillingDocumentItemBasic_2 | PlantCounty | ||
| PlantCity | P_BillingDocumentItemBasic_2 | PlantCity | ||
| TransitPlant | P_BillingDocumentItemBasic_2 | TransitPlant | ||
| ValueChainCategory | P_BillingDocumentItemBasic_2 | ValueChainCategory | ||
| BOMExplosion | P_BillingDocumentItemBasic_2 | BOMExplosion | ||
| MaterialDeterminationType | P_BillingDocumentItemBasic_2 | MaterialDeterminationType | ||
| BillingDocumentItemText | P_BillingDocumentItemBasic_2 | BillingDocumentItemText | ||
| ServicesRenderedDate | P_BillingDocumentItemBasic_2 | ServicesRenderedDate | ||
| BillingQuantity | P_BillingDocumentItemBasic_2 | BillingQuantity | ||
| BillingQuantityUnit | P_BillingDocumentItemBasic_2 | BillingQuantityUnit | ||
| BillingQuantityInBaseUnit | P_BillingDocumentItemBasic_2 | BillingQuantityInBaseUnit | ||
| BaseUnit | P_BillingDocumentItemBasic_2 | BaseUnit | ||
| MRPRequiredQuantityInBaseUnit | P_BillingDocumentItemBasic_2 | MRPRequiredQuantityInBaseUnit | ||
| BillingToBaseQuantityDnmntr | P_BillingDocumentItemBasic_2 | BillingToBaseQuantityDnmntr | ||
| BillingToBaseQuantityNmrtr | P_BillingDocumentItemBasic_2 | BillingToBaseQuantityNmrtr | ||
| ItemGrossWeight | P_BillingDocumentItemBasic_2 | ItemGrossWeight | ||
| ItemNetWeight | P_BillingDocumentItemBasic_2 | ItemNetWeight | ||
| ItemWeightUnit | P_BillingDocumentItemBasic_2 | ItemWeightUnit | ||
| ItemVolume | P_BillingDocumentItemBasic_2 | ItemVolume | ||
| ItemVolumeUnit | P_BillingDocumentItemBasic_2 | ItemVolumeUnit | ||
| BillToPartyCountry | P_BillingDocumentItemBasic_2 | BillToPartyCountry | ||
| BillToPartyRegion | P_BillingDocumentItemBasic_2 | BillToPartyRegion | ||
| BillingPlanRule | P_BillingDocumentItemBasic_2 | BillingPlanRule | ||
| BillingPlan | P_BillingDocumentItemBasic_2 | BillingPlan | ||
| BillingPlanItem | P_BillingDocumentItemBasic_2 | BillingPlanItem | ||
| DocumentBillingStatus | P_BillingDocumentItemBasic_2 | DocumentBillingStatus | ||
| NetAmount | P_BillingDocumentItemBasic_2 | NetAmount | ||
| TransactionCurrency | P_BillingDocumentItemBasic_2 | TransactionCurrency | ||
| GrossAmount | P_BillingDocumentItemBasic_2 | GrossAmount | ||
| PricingDate | P_BillingDocumentItemBasic_2 | PricingDate | ||
| PriceDetnExchangeRate | P_BillingDocumentItemBasic_2 | PriceDetnExchangeRate | ||
| PricingScaleQuantityInBaseUnit | P_BillingDocumentItemBasic_2 | PricingScaleQuantityInBaseUnit | ||
| TaxAmount | P_BillingDocumentItemBasic_2 | TaxAmount | ||
| CostAmount | P_BillingDocumentItemBasic_2 | CostAmount | ||
| Subtotal1Amount | P_BillingDocumentItemBasic_2 | Subtotal1Amount | ||
| Subtotal2Amount | P_BillingDocumentItemBasic_2 | Subtotal2Amount | ||
| Subtotal3Amount | P_BillingDocumentItemBasic_2 | Subtotal3Amount | ||
| Subtotal4Amount | P_BillingDocumentItemBasic_2 | Subtotal4Amount | ||
| Subtotal5Amount | P_BillingDocumentItemBasic_2 | Subtotal5Amount | ||
| Subtotal6Amount | P_BillingDocumentItemBasic_2 | Subtotal6Amount | ||
| StatisticalValueControl | P_BillingDocumentItemBasic_2 | StatisticalValueControl | ||
| CashDiscountIsDeductible | P_BillingDocumentItemBasic_2 | CashDiscountIsDeductible | ||
| CustomerConditionGroup1 | P_BillingDocumentItemBasic_2 | CustomerConditionGroup1 | ||
| CustomerConditionGroup2 | P_BillingDocumentItemBasic_2 | CustomerConditionGroup2 | ||
| CustomerConditionGroup3 | P_BillingDocumentItemBasic_2 | CustomerConditionGroup3 | ||
| CustomerConditionGroup4 | P_BillingDocumentItemBasic_2 | CustomerConditionGroup4 | ||
| CustomerConditionGroup5 | P_BillingDocumentItemBasic_2 | CustomerConditionGroup5 | ||
| ManualPriceChangeType | P_BillingDocumentItemBasic_2 | ManualPriceChangeType | ||
| MaterialPricingGroup | P_BillingDocumentItemBasic_2 | MaterialPricingGroup | ||
| StatisticsExchangeRate | P_BillingDocumentItemBasic_2 | StatisticsExchangeRate | ||
| MainItemPricingRefMaterial | P_BillingDocumentItemBasic_2 | MainItemPricingRefMaterial | ||
| MainItemMaterialPricingGroup | P_BillingDocumentItemBasic_2 | MainItemMaterialPricingGroup | ||
| TimeSheetOvertimeCategory | P_BillingDocumentItemBasic_2 | TimeSheetOvertimeCategory | ||
| PricingRelevance | P_BillingDocumentItemBasic_2 | PricingRelevance | ||
| DepartureCountry | P_BillingDocumentItemBasic_2 | DepartureCountry | ||
| TaxJurisdiction | P_BillingDocumentItemBasic_2 | TaxJurisdiction | ||
| ProductTaxClassification1 | P_BillingDocumentItemBasic_2 | ProductTaxClassification1 | ||
| ProductTaxClassification2 | P_BillingDocumentItemBasic_2 | ProductTaxClassification2 | ||
| ProductTaxClassification3 | P_BillingDocumentItemBasic_2 | ProductTaxClassification3 | ||
| ProductTaxClassification4 | P_BillingDocumentItemBasic_2 | ProductTaxClassification4 | ||
| ProductTaxClassification5 | P_BillingDocumentItemBasic_2 | ProductTaxClassification5 | ||
| ProductTaxClassification6 | P_BillingDocumentItemBasic_2 | ProductTaxClassification6 | ||
| ProductTaxClassification7 | P_BillingDocumentItemBasic_2 | ProductTaxClassification7 | ||
| ProductTaxClassification8 | P_BillingDocumentItemBasic_2 | ProductTaxClassification8 | ||
| ProductTaxClassification9 | P_BillingDocumentItemBasic_2 | ProductTaxClassification9 | ||
| ZeroVATRsn | P_BillingDocumentItemBasic_2 | ZeroVATRsn | ||
| TaxCode | P_BillingDocumentItemBasic_2 | TaxCode | ||
| TaxRateValidityStartDate | P_BillingDocumentItemBasic_2 | TaxRateValidityStartDate | ||
| CountryOfOrigin | P_BillingDocumentItemBasic_2 | CountryOfOrigin | ||
| RegionOfOrigin | P_BillingDocumentItemBasic_2 | RegionOfOrigin | ||
| CommodityCode | P_BillingDocumentItemBasic_2 | CommodityCode | ||
| EligibleAmountForCashDiscount | P_BillingDocumentItemBasic_2 | EligibleAmountForCashDiscount | ||
| BusinessArea | P_BillingDocumentItemBasic_2 | BusinessArea | ||
| ProfitCenter | P_BillingDocumentItemBasic_2 | ProfitCenter | ||
| WBSElementInternalID | P_BillingDocumentItemBasic_2 | WBSElementInternalID | ||
| ProviderContract | P_BillingDocumentItemBasic_2 | ProviderContract | ||
| ProviderContractItem | P_BillingDocumentItemBasic_2 | ProviderContractItem | ||
| BillingPerformancePeriodStrDte | P_BillingDocumentItemBasic_2 | BillingPerformancePeriodStrDte | ||
| BillingPerformancePeriodEndDte | P_BillingDocumentItemBasic_2 | BillingPerformancePeriodEndDte | ||
| ControllingArea | P_BillingDocumentItemBasic_2 | ControllingArea | ||
| ProfitabilitySegment_2 | P_BillingDocumentItemBasic_2 | ProfitabilitySegment_2 | ||
| OrderID | P_BillingDocumentItemBasic_2 | OrderID | ||
| CostCenter | P_BillingDocumentItemBasic_2 | CostCenter | ||
| OriginSDDocument | P_BillingDocumentItemBasic_2 | OriginSDDocument | ||
| OriginSDDocumentItem | P_BillingDocumentItemBasic_2 | OriginSDDocumentItem | ||
| PriceDetnExchangeRateDate | P_BillingDocumentItemBasic_2 | PriceDetnExchangeRateDate | ||
| MatlAccountAssignmentGroup | P_BillingDocumentItemBasic_2 | MatlAccountAssignmentGroup | ||
| ReferenceSDDocument | P_BillingDocumentItemBasic_2 | ReferenceSDDocument | ||
| ReferenceSDDocumentItem | P_BillingDocumentItemBasic_2 | ReferenceSDDocumentItem | ||
| ReferenceSDDocumentCategory | P_BillingDocumentItemBasic_2 | ReferenceSDDocumentCategory | ||
| SalesDocument | P_BillingDocumentItemBasic_2 | SalesDocument | ||
| SalesDocumentItem | P_BillingDocumentItemBasic_2 | SalesDocumentItem | ||
| SalesSDDocumentCategory | P_BillingDocumentItemBasic_2 | SalesSDDocumentCategory | ||
| HigherLevelItem | P_BillingDocumentItemBasic_2 | HigherLevelItem | ||
| HigherLvlItmOfBatSpltItm | P_BillingDocumentItemBasic_2 | HigherLvlItmOfBatSpltItm | ||
| BillingDocumentItemInPartSgmt | P_BillingDocumentItemBasic_2 | BillingDocumentItemInPartSgmt | ||
| ExternalReferenceDocument | P_BillingDocumentItemBasic_2 | ExternalReferenceDocument | ||
| BillingDocExtReferenceDocItem | P_BillingDocumentItemBasic_2 | BillingDocExtReferenceDocItem | ||
| PrelimBillingDocument | P_BillingDocumentItemBasic_2 | PrelimBillingDocument | ||
| PrelimBillingDocumentItem | P_BillingDocumentItemBasic_2 | PrelimBillingDocumentItem | ||
| SalesGroup | P_BillingDocumentItemBasic_2 | SalesGroup | ||
| AdditionalCustomerGroup1 | P_BillingDocumentItemBasic_2 | AdditionalCustomerGroup1 | ||
| AdditionalCustomerGroup2 | P_BillingDocumentItemBasic_2 | AdditionalCustomerGroup2 | ||
| AdditionalCustomerGroup3 | P_BillingDocumentItemBasic_2 | AdditionalCustomerGroup3 | ||
| AdditionalCustomerGroup4 | P_BillingDocumentItemBasic_2 | AdditionalCustomerGroup4 | ||
| AdditionalCustomerGroup5 | P_BillingDocumentItemBasic_2 | AdditionalCustomerGroup5 | ||
| SDDocumentReason | P_BillingDocumentItemBasic_2 | SDDocumentReason | ||
| RetailPromotion | P_BillingDocumentItemBasic_2 | RetailPromotion | ||
| RebateBasisAmount | P_BillingDocumentItemBasic_2 | RebateBasisAmount | ||
| VolumeRebateGroup | P_BillingDocumentItemBasic_2 | VolumeRebateGroup | ||
| ItemIsRelevantForCredit | P_BillingDocumentItemBasic_2 | ItemIsRelevantForCredit | ||
| CreditRelatedPrice | P_BillingDocumentItemBasic_2 | CreditRelatedPrice | ||
| SalesDeal | P_BillingDocumentItemBasic_2 | SalesDeal | ||
| SalesPromotion | P_BillingDocumentItemBasic_2 | SalesPromotion | ||
| SalesOrderSalesDistrict | P_BillingDocumentItemBasic_2 | SalesOrderSalesDistrict | ||
| SalesOrderCustomerGroup | P_BillingDocumentItemBasic_2 | SalesOrderCustomerGroup | ||
| SalesOrderCustomerPriceGroup | P_BillingDocumentItemBasic_2 | SalesOrderCustomerPriceGroup | ||
| SalesOrderPriceListType | P_BillingDocumentItemBasic_2 | SalesOrderPriceListType | ||
| SalesOrderSalesOrganization | P_BillingDocumentItemBasic_2 | SalesOrderSalesOrganization | ||
| SalesOrderDistributionChannel | P_BillingDocumentItemBasic_2 | SalesOrderDistributionChannel | ||
| SalesDocIsCreatedFromReference | P_BillingDocumentItemBasic_2 | SalesDocIsCreatedFromReference | ||
| ShippingPoint | P_BillingDocumentItemBasic_2 | ShippingPoint | ||
| ServiceDocumentType | P_BillingDocumentItemBasic_2 | ServiceDocumentType | ||
| ServiceDocument | P_BillingDocumentItemBasic_2 | ServiceDocument | ||
| ServiceDocumentItem | P_BillingDocumentItemBasic_2 | ServiceDocumentItem | ||
| BusinessSolutionOrder | P_BillingDocumentItemBasic_2 | BusinessSolutionOrder | ||
| BusinessSolutionOrderItem | P_BillingDocumentItemBasic_2 | BusinessSolutionOrderItem | ||
| HigherLevelItemUsage | P_BillingDocumentItemBasic_2 | HigherLevelItemUsage | ||
| BillingDocumentIsTemporary | P_BillingDocumentItemBasic_2 | BillingDocumentIsTemporary | ||
| SDDocumentCategory | P_BillingDocumentItemBasic_2 | SDDocumentCategory | ||
| BillingDocumentType | P_BillingDocumentItemBasic_2 | BillingDocumentType | ||
| SalesOrganization | P_BillingDocumentItemBasic_2 | SalesOrganization | ||
| DistributionChannel | P_BillingDocumentItemBasic_2 | DistributionChannel | ||
| CustomerPriceGroup | P_BillingDocumentItemBasic_2 | CustomerPriceGroup | ||
| CustomerGroup | P_BillingDocumentItemBasic_2 | CustomerGroup | ||
| Country | P_BillingDocumentItemBasic_2 | Country | ||
| Region | P_BillingDocumentItemBasic_2 | Region | ||
| CityCode | P_BillingDocumentItemBasic_2 | CityCode | ||
| SalesDistrict | P_BillingDocumentItemBasic_2 | SalesDistrict | ||
| OverallSDProcessStatus | P_BillingDocumentItemBasic_2 | OverallSDProcessStatus | ||
| OverallBillingStatus | P_BillingDocumentItemBasic_2 | OverallBillingStatus | ||
| SoldToParty | P_BillingDocumentItemBasic_2 | SoldToParty | ||
| PayerParty | P_BillingDocumentItemBasic_2 | PayerParty | ||
| BillingDocumentDate | P_BillingDocumentItemBasic_2 | BillingDocumentDate | ||
| CompanyCode | P_BillingDocumentItemBasic_2 | CompanyCode | ||
| County | P_BillingDocumentItemBasic_2 | County | ||
| CustomerRebateAgreement | P_BillingDocumentItemBasic_2 | CustomerRebateAgreement | ||
| BillingDocumentCategory | P_BillingDocumentItemBasic_2 | BillingDocumentCategory | ||
| ShipToParty | P_BillingDocumentItemBasic_2 | ShipToParty | ||
| BillToParty | P_BillingDocumentItemBasic_2 | BillToParty | ||
| SalesEmployee | P_BillingDocumentItemBasic_2 | SalesEmployee | ||
| ResponsibleEmployee | P_BillingDocumentItemBasic_2 | ResponsibleEmployee | ||
| PricingDocument | P_BillingDocumentItemBasic_2 | PricingDocument | ||
| CancelledBillingDocument | P_BillingDocumentItemBasic_2 | CancelledBillingDocument |
@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
}
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA