I_BILLINGDOCUMENTITEMBASIC

CDS View
134 Fields 14 CDS Views

Billing Document Item Basic

I_BILLINGDOCUMENTITEMBASIC is a CDS View in S/4HANA. Billing Document Item Basic. It contains 134 fields. 14 CDS views read from this table.

CDS Views using this table (14)

ViewTypeJoinVDMDescription
C_US_SalesTaxBillingDocItm view from CONSUMPTION USA Sales Tax Specific Billing Document Item Factsheet
I_BillgDocItmBscAnlyts view from COMPOSITE Billing Document Item Basic Analytics
I_BillgDocItmBscStdVH view from COMPOSITE Billing Document Item Basic
I_BillingDocItemDownPayt view from BASIC Billing Document Down Payment Item
I_BillingDocItemPartnerBasic view inner BASIC Billing Document Item Partner Basic
I_BillingDocumentItem view from BASIC Billing Document Item
I_BillingDocumentRequestItem view from BASIC Billing Document Request Item
I_BillingDownPayment view from BASIC Billing Document Down Payment Item
I_NonFerrousMatBillgDocItmCalc view_entity inner COMPOSITE Billing Calculations
I_PrelimBillingDocumentItem view from BASIC Preliminary Billing Document Item
P_BillgProcDocItemInhtdPartner view_entity from COMPOSITE
P_GteeMBillingElmntEntrFlwDoc view from COMPOSITE
P_ReturnsReferenceDocument view_entity union_all COMPOSITE
P_StRpSalesInvoiceItem view from CONSUMPTION Private View for Sales Invoice List

Fields (134)

KeyField CDS FieldsUsed in Views
KEY BillingDocument BillingDocument 3
KEY BillingDocumentItem BillingDocumentItem,SalesDocumentItem 6
KEY ReferenceSDDocument DeliveryDocument,ReferenceSDDocument 3
KEY ReferenceSDDocumentItem DeliveryDocumentItem,ReferenceSDDocumentItem 3
_AdditionalCustomerGroup1 _AdditionalCustomerGroup1 1
_AdditionalCustomerGroup2 _AdditionalCustomerGroup2 1
_AdditionalCustomerGroup3 _AdditionalCustomerGroup3 1
_AdditionalCustomerGroup4 _AdditionalCustomerGroup4 1
_AdditionalCustomerGroup5 _AdditionalCustomerGroup5 1
_AdditionalMaterialGroup1 _AdditionalMaterialGroup1 1
_AdditionalMaterialGroup2 _AdditionalMaterialGroup2 1
_AdditionalMaterialGroup3 _AdditionalMaterialGroup3 1
_AdditionalMaterialGroup4 _AdditionalMaterialGroup4 1
_AdditionalMaterialGroup5 _AdditionalMaterialGroup5 1
_BaseUnit _BaseUnit 1
_BillingDocumentBasic _BillingDocumentBasic 1
_BillingDocumentType _BillingDocumentType 1
_BillingPlanRule _BillingPlanRule 1
_BillingQuantityUnit _BillingQuantityUnit 1
_BillToPartyCountry _BillToPartyCountry 1
_BillToPartyRegion _BillToPartyRegion 1
_BusinessArea _BusinessArea 1
_ControllingArea _ControllingArea 1
_CostCenter _CostCenter 1
_CreatedByUser _CreatedByUser 1
_Division _Division 1
_ItemVolumeUnit _ItemVolumeUnit 1
_ItemWeightUnit _ItemWeightUnit 1
_Material _Material 1
_MaterialCommissionGroup _MaterialCommissionGroup 1
_MaterialGroup _MaterialGroup 1
_OrganizationDivision _OrganizationDivision 1
_OriginallyRequestedMaterial _OriginallyRequestedMaterial 1
_OverallBillingStatus _OverallBillingStatus 1
_Plant _Plant 1
_PricingReferenceMaterial _PricingReferenceMaterial 1
_Product _Product 1
_ProductGroup _ProductGroup 1
_ProductHierarchyNode _ProductHierarchyNode 1
_ReferenceLogicalSystem _LogicalSystem 1
_ReferenceSDDocumentCategory _ReferenceSDDocumentCategory 1
_SalesDeal _SalesDeal 1
_SalesDocumentItemCategory _SalesDocumentItemCategory 1
_SalesDocumentItemType _SalesDocumentItemType 1
_SalesGroup _SalesGroup 1
_SalesOffice _SalesOffice 1
_SalesSDDocumentCategory _SalesSDDocumentCategory 1
_SDDocumentReason _SDDocumentReason 1
_ShippingPoint _ShippingPoint 1
_StatisticalValueControl _StatisticalValueControl 1
_StorageLocation _StorageLocation 1
_TransactionCurrency _TransactionCurrency 1
AdditionalCustomerGroup1 AdditionalCustomerGroup1 1
AdditionalCustomerGroup2 AdditionalCustomerGroup2 1
AdditionalCustomerGroup3 AdditionalCustomerGroup3 1
AdditionalCustomerGroup4 AdditionalCustomerGroup4 1
AdditionalCustomerGroup5 AdditionalCustomerGroup5 1
AdditionalMaterialGroup1 AdditionalMaterialGroup1 1
AdditionalMaterialGroup2 AdditionalMaterialGroup2 1
AdditionalMaterialGroup3 AdditionalMaterialGroup3 1
AdditionalMaterialGroup4 AdditionalMaterialGroup4 1
AdditionalMaterialGroup5 AdditionalMaterialGroup5 1
BaseUnit BaseUnit 2
Batch Batch 1
BillingDocumentItemInPartSgmt BillingDocumentItemInPartSgmt 1
BillingDocumentType BillingDocumentType 1
BillingPlan BillingPlan 1
BillingPlanRule BillingPlanRule 1
BillingQuantity BillingQuantity,Quantity 3
BillingQuantityInBaseUnit BillingQuantityInBaseUnit 1
BillingQuantityUnit BillingQuantityUnit 3
BillingToBaseQuantityDnmntr BillingToBaseQuantityDnmntr 1
BillingToBaseQuantityNmrtr BillingToBaseQuantityNmrtr 1
BillToPartyCountry BillToPartyCountry 1
BillToPartyRegion BillToPartyRegion 1
BusinessArea BusinessArea 1
CostAmount CostAmount 1
CostCenter CostCenter 1
CreatedByUser CreatedByUser 1
CreationDate CreationDate 1
CreditRelatedPrice CreditRelatedPrice 1
Division Division 1
EligibleAmountForCashDiscount EligibleAmountForCashDiscount 1
GrossAmount ItemGrossAmountOfBillingDoc 1
HigherLevelItem HigherLevelItem 1
InternationalArticleNumber InternationalArticleNumber 1
ItemGrossWeight ItemGrossWeight 1
ItemNetWeight ItemNetWeight 1
ItemVolume ItemVolume 1
ItemVolumeUnit ItemVolumeUnit 1
ItemWeightUnit ItemWeightUnit 1
Material Material 2
MaterialCommissionGroup MaterialCommissionGroup 1
MaterialGroup MaterialGroup 1
MRPRequiredQuantityInBaseUnit MRPRequiredQuantityInBaseUnit 1
OriginallyRequestedMaterial OriginallyRequestedMaterial 1
OriginSDDocument OriginSDDocument 2
OverallBillingStatus OverallBillingStatus 1
PayerParty PayerParty 1
Plant Plant 2
PriceDetnExchangeRate PriceDetnExchangeRate 1
PriceDetnExchangeRateDate ExchangeRateDate 1
PricingDate PricingDate 1
PricingReferenceMaterial PricingReferenceMaterial 1
PricingScaleQuantityInBaseUnit PricingScaleQuantityInBaseUnit 1
Product Product 1
ProductGroup ProductGroup 1
ProductHierarchyNode ProductHierarchyNode 1
ProfitabilitySegment ProfitabilitySegment 1
ProfitabilitySegment_2 ProfitabilitySegment_2 1
ProfitCenter ProfitCenter 1
RebateBasisAmount RebateBasisAmount 1
ReferenceLogicalSystem LogicalSystem 1
ReferenceSDDocumentCategory ReferenceSDDocumentCategory 1
ReturnItemProcessingType ReturnItemProcessingType 2
SalesDeal SalesDeal 1
SalesDocument SalesDocument 1
SalesDocumentItem SalesDocumentItem 1
SalesGroup SalesGroup 1
SalesOffice SalesOffice 1
SDDocumentCategory SDDocumentCategory 1
SDDocumentReason SDDocumentReason 1
ServicesRenderedDate ServicesRenderedDate 1
ShippingPoint ShippingPoint 2
StatisticalValueControl StatisticalValueControl 1
StorageLocation StorageLocation 1
Subtotal1Amount Subtotal1Amount 1
Subtotal2Amount Subtotal2Amount 1
Subtotal3Amount Subtotal3Amount 1
Subtotal4Amount Subtotal4Amount 1
Subtotal5Amount Subtotal5Amount 1
Subtotal6Amount Subtotal6Amount 1
TaxAmount TaxAmount 1
VolumeRebateGroup VolumeRebateGroup 1

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Billing Document Item Basic
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_BILLINGDOCUMENTITEMBASIC (
    BILLINGDOCUMENT,
    BILLINGDOCUMENTITEM,
    REFERENCESDDOCUMENT,
    REFERENCESDDOCUMENTITEM,
    _ADDITIONALCUSTOMERGROUP1,
    _ADDITIONALCUSTOMERGROUP2,
    _ADDITIONALCUSTOMERGROUP3,
    _ADDITIONALCUSTOMERGROUP4,
    _ADDITIONALCUSTOMERGROUP5,
    _ADDITIONALMATERIALGROUP1,
    _ADDITIONALMATERIALGROUP2,
    _ADDITIONALMATERIALGROUP3,
    _ADDITIONALMATERIALGROUP4,
    _ADDITIONALMATERIALGROUP5,
    _BASEUNIT,
    _BILLINGDOCUMENTBASIC,
    _BILLINGDOCUMENTTYPE,
    _BILLINGPLANRULE,
    _BILLINGQUANTITYUNIT,
    _BILLTOPARTYCOUNTRY,
    _BILLTOPARTYREGION,
    _BUSINESSAREA,
    _CONTROLLINGAREA,
    _COSTCENTER,
    _CREATEDBYUSER,
    _DIVISION,
    _ITEMVOLUMEUNIT,
    _ITEMWEIGHTUNIT,
    _MATERIAL,
    _MATERIALCOMMISSIONGROUP,
    _MATERIALGROUP,
    _ORGANIZATIONDIVISION,
    _ORIGINALLYREQUESTEDMATERIAL,
    _OVERALLBILLINGSTATUS,
    _PLANT,
    _PRICINGREFERENCEMATERIAL,
    _PRODUCT,
    _PRODUCTGROUP,
    _PRODUCTHIERARCHYNODE,
    _REFERENCELOGICALSYSTEM,
    _REFERENCESDDOCUMENTCATEGORY,
    _SALESDEAL,
    _SALESDOCUMENTITEMCATEGORY,
    _SALESDOCUMENTITEMTYPE,
    _SALESGROUP,
    _SALESOFFICE,
    _SALESSDDOCUMENTCATEGORY,
    _SDDOCUMENTREASON,
    _SHIPPINGPOINT,
    _STATISTICALVALUECONTROL,
    _STORAGELOCATION,
    _TRANSACTIONCURRENCY,
    ADDITIONALCUSTOMERGROUP1,
    ADDITIONALCUSTOMERGROUP2,
    ADDITIONALCUSTOMERGROUP3,
    ADDITIONALCUSTOMERGROUP4,
    ADDITIONALCUSTOMERGROUP5,
    ADDITIONALMATERIALGROUP1,
    ADDITIONALMATERIALGROUP2,
    ADDITIONALMATERIALGROUP3,
    ADDITIONALMATERIALGROUP4,
    ADDITIONALMATERIALGROUP5,
    BASEUNIT,
    BATCH,
    BILLINGDOCUMENTITEMINPARTSGMT,
    BILLINGDOCUMENTTYPE,
    BILLINGPLAN,
    BILLINGPLANRULE,
    BILLINGQUANTITY,
    BILLINGQUANTITYINBASEUNIT,
    BILLINGQUANTITYUNIT,
    BILLINGTOBASEQUANTITYDNMNTR,
    BILLINGTOBASEQUANTITYNMRTR,
    BILLTOPARTYCOUNTRY,
    BILLTOPARTYREGION,
    BUSINESSAREA,
    COSTAMOUNT,
    COSTCENTER,
    CREATEDBYUSER,
    CREATIONDATE,
    CREDITRELATEDPRICE,
    DIVISION,
    ELIGIBLEAMOUNTFORCASHDISCOUNT,
    GROSSAMOUNT,
    HIGHERLEVELITEM,
    INTERNATIONALARTICLENUMBER,
    ITEMGROSSWEIGHT,
    ITEMNETWEIGHT,
    ITEMVOLUME,
    ITEMVOLUMEUNIT,
    ITEMWEIGHTUNIT,
    MATERIAL,
    MATERIALCOMMISSIONGROUP,
    MATERIALGROUP,
    MRPREQUIREDQUANTITYINBASEUNIT,
    ORIGINALLYREQUESTEDMATERIAL,
    ORIGINSDDOCUMENT,
    OVERALLBILLINGSTATUS,
    PAYERPARTY,
    PLANT,
    PRICEDETNEXCHANGERATE,
    PRICEDETNEXCHANGERATEDATE,
    PRICINGDATE,
    PRICINGREFERENCEMATERIAL,
    PRICINGSCALEQUANTITYINBASEUNIT,
    PRODUCT,
    PRODUCTGROUP,
    PRODUCTHIERARCHYNODE,
    PROFITABILITYSEGMENT,
    PROFITABILITYSEGMENT_2,
    PROFITCENTER,
    REBATEBASISAMOUNT,
    REFERENCELOGICALSYSTEM,
    REFERENCESDDOCUMENTCATEGORY,
    RETURNITEMPROCESSINGTYPE,
    SALESDEAL,
    SALESDOCUMENT,
    SALESDOCUMENTITEM,
    SALESGROUP,
    SALESOFFICE,
    SDDOCUMENTCATEGORY,
    SDDOCUMENTREASON,
    SERVICESRENDEREDDATE,
    SHIPPINGPOINT,
    STATISTICALVALUECONTROL,
    STORAGELOCATION,
    SUBTOTAL1AMOUNT,
    SUBTOTAL2AMOUNT,
    SUBTOTAL3AMOUNT,
    SUBTOTAL4AMOUNT,
    SUBTOTAL5AMOUNT,
    SUBTOTAL6AMOUNT,
    TAXAMOUNT,
    VOLUMEREBATEGROUP,
    PRIMARY KEY (BILLINGDOCUMENT, BILLINGDOCUMENTITEM, REFERENCESDDOCUMENT, REFERENCESDDOCUMENTITEM)
);

Learn More