I_BILLINGDOCEXTDITEMBASIC

CDS View
76 Fields 11 CDS Views

Billing Document Item Basic Extended

I_BILLINGDOCEXTDITEMBASIC is a CDS View in S/4HANA. Billing Document Item Basic Extended. It contains 76 fields. 11 CDS views read from this table.

CDS Views using this table (11)

ViewTypeJoinVDMDescription
C_BillgDocItmPrcgElmntBscDEX view inner CONSUMPTION Data Extraction for Billing Doc Item Pricing Element Basic
C_BillgDocItmPrcgElmntBscDEX_1 view inner CONSUMPTION Data Extraction for Billing Doc Item Pricing Element Basic
C_BillingDocItemBasicDEX_1 view from CONSUMPTION Data Extraction for Billing Doc Item Basic
C_BillingDocumentItemBasicDEX view from CONSUMPTION Billing Document Item Basic Extraction Data
I_BillingDocExtdItem view from BASIC Billing Document Item Extended
P_ProfitMarginByMonth view from COMPOSITE
P_SalesVolume view from COMPOSITE
P_SI_SalesVolumeActualData view from COMPOSITE
P_SI4_TrainingData01 view from COMPOSITE
P_SPP_PredictionData01 view from COMPOSITE
P_SPP_TrainingData01 view from COMPOSITE

Fields (76)

KeyField CDS FieldsUsed in Views
KEY BillingDocument BillingDocument,SDDocument 2
KEY BillingDocumentItem BillingDocumentItem,SDDocumentItem 4
_DistributionChannel _DistributionChannel 1
_OrganizationDivision _OrganizationDivision 1
_ProductHierarchyNode _ProductHierarchyNode 1
_SalesGroup _SalesGroup 1
_SalesOffice _SalesOffice 1
_SalesOrganization _SalesOrganization 1
_SoldToParty _SoldToParty 1
_TransactionCurrency _TransactionCurrency 1
AdditionalCustomerGroup1 AdditionalCustomerGroup1 3
AdditionalCustomerGroup2 AdditionalCustomerGroup2 3
AdditionalCustomerGroup3 AdditionalCustomerGroup3 3
AdditionalCustomerGroup4 AdditionalCustomerGroup4 3
AdditionalCustomerGroup5 AdditionalCustomerGroup5 3
AdditionalMaterialGroup1 AdditionalMaterialGroup1 3
AdditionalMaterialGroup2 AdditionalMaterialGroup2 3
AdditionalMaterialGroup3 AdditionalMaterialGroup3 3
AdditionalMaterialGroup4 AdditionalMaterialGroup4 3
AdditionalMaterialGroup5 AdditionalMaterialGroup5 3
BillingDocumentDate BillingDocumentDate 1
BillingDocumentType BillingDocumentType 1
BillingPlanRule BillingPlanRule 2
BillingQuantity BillingQuantity 2
BillingQuantityUnit BillingQuantityUnit 2
BillToParty BillToParty 2
BillToPartyCountry BillToPartyCountry 1
BillToPartyRegion BillToPartyRegion 1
BusinessArea BusinessArea 1
CompanyCode CompanyCode 1
ControllingArea ControllingArea 3
CostCenter CostCenter 3
Country Country 1
CreationDate CreationDate 2
CreationTime CreationTime 2
CustomerGroup CustomerGroup 1
DistributionChannel DistributionChannel 2
Division Division,OrganizationDivision 3
InternationalArticleNumber InternationalArticleNumber 2
Material Material 3
MaterialCommissionGroup MaterialCommissionGroup 2
MaterialGroup MaterialGroup 3
OrganizationDivision OrganizationDivision 3
OriginallyRequestedMaterial OriginallyRequestedMaterial 2
OverallBillingStatus OverallBillingStatus 2
OverallSDProcessStatus OverallSDProcessStatus 2
Plant Plant 1
PriceDetnExchangeRate PriceDetnExchangeRate 2
PriceDetnExchangeRateDate PriceDetnExchangeRateDate 2
PricingDate PricingDate 2
Product Product 3
ProductGroup ProductGroup 3
ProductHierarchyNode ProductHierarchyNode 1
ProfitCenter ProfitCenter 1
ReferenceSDDocument ReferenceSDDocument 2
ReferenceSDDocumentCategory ReferenceSDDocumentCategory 2
ReferenceSDDocumentItem ReferenceSDDocumentItem 2
Region Region 1
ResponsibleEmployee ResponsibleEmployee 1
ReturnItemProcessingType ReturnItemProcessingType 2
SalesDistrict SalesDistrict 1
SalesDocument SalesDocument 2
SalesDocumentItem SalesDocumentItem 2
SalesDocumentItemCategory SalesDocumentItemCategory 2
SalesDocumentItemType SalesDocumentItemType 2
SalesEmployee SalesEmployee 1
SalesGroup SalesGroup 4
SalesOffice SalesOffice 4
SalesOrganization SalesOrganization 2
SDDocumentCategory SDDocumentCategory 1
ServicesRenderedDate ServicesRenderedDate 2
ShipToParty ShipToParty 2
SoldToParty Customer,SoldToParty 2
StatisticalValueControl StatisticalValueControl 2
StatisticsExchangeRate StatisticsExchangeRate 2
TransactionCurrency TransactionCurrency 2

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 Extended
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_BILLINGDOCEXTDITEMBASIC (
    BILLINGDOCUMENT,
    BILLINGDOCUMENTITEM,
    _DISTRIBUTIONCHANNEL,
    _ORGANIZATIONDIVISION,
    _PRODUCTHIERARCHYNODE,
    _SALESGROUP,
    _SALESOFFICE,
    _SALESORGANIZATION,
    _SOLDTOPARTY,
    _TRANSACTIONCURRENCY,
    ADDITIONALCUSTOMERGROUP1,
    ADDITIONALCUSTOMERGROUP2,
    ADDITIONALCUSTOMERGROUP3,
    ADDITIONALCUSTOMERGROUP4,
    ADDITIONALCUSTOMERGROUP5,
    ADDITIONALMATERIALGROUP1,
    ADDITIONALMATERIALGROUP2,
    ADDITIONALMATERIALGROUP3,
    ADDITIONALMATERIALGROUP4,
    ADDITIONALMATERIALGROUP5,
    BILLINGDOCUMENTDATE,
    BILLINGDOCUMENTTYPE,
    BILLINGPLANRULE,
    BILLINGQUANTITY,
    BILLINGQUANTITYUNIT,
    BILLTOPARTY,
    BILLTOPARTYCOUNTRY,
    BILLTOPARTYREGION,
    BUSINESSAREA,
    COMPANYCODE,
    CONTROLLINGAREA,
    COSTCENTER,
    COUNTRY,
    CREATIONDATE,
    CREATIONTIME,
    CUSTOMERGROUP,
    DISTRIBUTIONCHANNEL,
    DIVISION,
    INTERNATIONALARTICLENUMBER,
    MATERIAL,
    MATERIALCOMMISSIONGROUP,
    MATERIALGROUP,
    ORGANIZATIONDIVISION,
    ORIGINALLYREQUESTEDMATERIAL,
    OVERALLBILLINGSTATUS,
    OVERALLSDPROCESSSTATUS,
    PLANT,
    PRICEDETNEXCHANGERATE,
    PRICEDETNEXCHANGERATEDATE,
    PRICINGDATE,
    PRODUCT,
    PRODUCTGROUP,
    PRODUCTHIERARCHYNODE,
    PROFITCENTER,
    REFERENCESDDOCUMENT,
    REFERENCESDDOCUMENTCATEGORY,
    REFERENCESDDOCUMENTITEM,
    REGION,
    RESPONSIBLEEMPLOYEE,
    RETURNITEMPROCESSINGTYPE,
    SALESDISTRICT,
    SALESDOCUMENT,
    SALESDOCUMENTITEM,
    SALESDOCUMENTITEMCATEGORY,
    SALESDOCUMENTITEMTYPE,
    SALESEMPLOYEE,
    SALESGROUP,
    SALESOFFICE,
    SALESORGANIZATION,
    SDDOCUMENTCATEGORY,
    SERVICESRENDEREDDATE,
    SHIPTOPARTY,
    SOLDTOPARTY,
    STATISTICALVALUECONTROL,
    STATISTICSEXCHANGERATE,
    TRANSACTIONCURRENCY,
    PRIMARY KEY (BILLINGDOCUMENT, BILLINGDOCUMENTITEM)
);

Learn More