I_BILLINGDOCPRCGELMNTBASIC
Billing Document Pricing Element Basic
I_BILLINGDOCPRCGELMNTBASIC is a CDS View in S/4HANA. Billing Document Pricing Element Basic. It contains 65 fields. 4 CDS views read from this table.
CDS Views using this table (4)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_BillingDocReqPrcgElmnt | view | from | BASIC | Billing Document Request Pricing Element |
| I_BillingDocumentPrcgElmnt | view | from | BASIC | Billing Document Pricing Element |
| I_InvoiceListPrcgElmnt | view | from | BASIC | Invoice List Pricing Element |
| I_PrelimBillingDocPrcgElmnt | view | from | BASIC | Prelim Billing Document Pricing Element |
Fields (65)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | BillingDocument | BillingDocument | 1 |
| KEY | PricingProcedureCounter | PricingProcedureCounter | 4 |
| KEY | PricingProcedureStep | PricingProcedureStep | 4 |
| _ConditionApplication | _ConditionApplication | 4 | |
| _ConditionCalculationType | _ConditionCalculationType | 4 | |
| _ConditionCategory | _ConditionCategory | 4 | |
| _ConditionClass | _ConditionClass | 4 | |
| _ConditionControl | _ConditionControl | 4 | |
| _ConditionCurrency | _ConditionCurrency | 4 | |
| _ConditionInactiveReason | _ConditionInactiveReason | 4 | |
| _ConditionOrigin | _ConditionOrigin | 4 | |
| _ConditionQuantityUnit | _ConditionQuantityUnit | 4 | |
| _Currency | _Currency | 4 | |
| _PricingConditionType | _PricingConditionType | 4 | |
| _PricingScaleBasis | _PricingScaleBasis | 4 | |
| _ScaleCurrency | _ScaleCurrency | 4 | |
| _ScaleUnitOfMeasure | _ScaleUnitOfMeasure | 4 | |
| _StructureCondition | _StructureCondition | 4 | |
| _VariantCondition | _VariantCondition | 4 | |
| CndnIsRelevantForIntcoBilling | CndnIsRelevantForIntcoBilling | 4 | |
| CndnIsRelevantForInvoiceList | CndnIsRelevantForInvoiceList | 4 | |
| CndnRoundingOffDiffAmount | CndnRoundingOffDiffAmount | 4 | |
| ConditionAmount | ConditionAmount | 4 | |
| ConditionApplication | ConditionApplication | 4 | |
| ConditionBaseAmount | ConditionBaseAmount | 3 | |
| ConditionBaseQuantity | ConditionBaseQuantity | 3 | |
| ConditionBaseValue | ConditionBaseValue | 4 | |
| ConditionCalculationType | ConditionCalculationType | 4 | |
| ConditionCategory | ConditionCategory | 4 | |
| ConditionClass | ConditionClass | 4 | |
| ConditionControl | ConditionControl | 4 | |
| ConditionCurrency | ConditionCurrency | 4 | |
| ConditionInactiveReason | ConditionInactiveReason | 4 | |
| ConditionIsForConfiguration | ConditionIsForConfiguration | 4 | |
| ConditionIsForStatistics | ConditionIsForStatistics | 4 | |
| ConditionIsManuallyChanged | ConditionIsManuallyChanged | 4 | |
| ConditionOrigin | ConditionOrigin | 4 | |
| ConditionQuantity | ConditionQuantity | 4 | |
| ConditionQuantityUnit | ConditionQuantityUnit | 4 | |
| ConditionRateAmount | ConditionRateAmount | 3 | |
| ConditionRateRatio | ConditionRateRatio | 3 | |
| ConditionRateRatioUnit | ConditionRateRatioUnit | 3 | |
| ConditionRateValue | ConditionRateValue | 4 | |
| ConditionRecord | ConditionRecord | 4 | |
| ConditionScaleBaseAmount | ConditionScaleBaseAmount | 3 | |
| ConditionScaleBaseQuantity | ConditionScaleBaseQuantity | 3 | |
| ConditionScaleBasisCurrency | ConditionScaleBasisCurrency | 4 | |
| ConditionScaleBasisUnit | ConditionScaleBasisUnit | 4 | |
| ConditionScaleBasisValue | ConditionScaleBasisValue | 4 | |
| ConditionSequentialNumber | ConditionSequentialNumber | 4 | |
| ConditionType | ConditionType | 4 | |
| FactorForConditionBasisValue | FactorForConditionBasisValue | 4 | |
| IsGroupCondition | IsGroupCondition | 4 | |
| IsRelevantForAccrual | IsRelevantForAccrual | 4 | |
| PeriodFactorForCndnBasisValue | PeriodFactorForCndnBasisValue | 4 | |
| PrcgProcedureCounterForHeader | PrcgProcedureCounterForHeader | 4 | |
| PriceConditionDeterminationDte | PriceConditionDeterminationDte | 3 | |
| PricingDateTime | PricingDateTime | 3 | |
| PricingScaleBasis | PricingScaleBasis | 4 | |
| PricingScaleType | PricingScaleType | 4 | |
| StructureCondition | StructureCondition | 4 | |
| TaxCode | TaxCode | 4 | |
| TransactionCurrency | TransactionCurrency | 4 | |
| VariantCondition | VariantCondition | 4 | |
| WithholdingTaxCode | WithholdingTaxCode | 4 |
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 Pricing Element Basic
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_BILLINGDOCPRCGELMNTBASIC (
BILLINGDOCUMENT,
PRICINGPROCEDURECOUNTER,
PRICINGPROCEDURESTEP,
_CONDITIONAPPLICATION,
_CONDITIONCALCULATIONTYPE,
_CONDITIONCATEGORY,
_CONDITIONCLASS,
_CONDITIONCONTROL,
_CONDITIONCURRENCY,
_CONDITIONINACTIVEREASON,
_CONDITIONORIGIN,
_CONDITIONQUANTITYUNIT,
_CURRENCY,
_PRICINGCONDITIONTYPE,
_PRICINGSCALEBASIS,
_SCALECURRENCY,
_SCALEUNITOFMEASURE,
_STRUCTURECONDITION,
_VARIANTCONDITION,
CNDNISRELEVANTFORINTCOBILLING,
CNDNISRELEVANTFORINVOICELIST,
CNDNROUNDINGOFFDIFFAMOUNT,
CONDITIONAMOUNT,
CONDITIONAPPLICATION,
CONDITIONBASEAMOUNT,
CONDITIONBASEQUANTITY,
CONDITIONBASEVALUE,
CONDITIONCALCULATIONTYPE,
CONDITIONCATEGORY,
CONDITIONCLASS,
CONDITIONCONTROL,
CONDITIONCURRENCY,
CONDITIONINACTIVEREASON,
CONDITIONISFORCONFIGURATION,
CONDITIONISFORSTATISTICS,
CONDITIONISMANUALLYCHANGED,
CONDITIONORIGIN,
CONDITIONQUANTITY,
CONDITIONQUANTITYUNIT,
CONDITIONRATEAMOUNT,
CONDITIONRATERATIO,
CONDITIONRATERATIOUNIT,
CONDITIONRATEVALUE,
CONDITIONRECORD,
CONDITIONSCALEBASEAMOUNT,
CONDITIONSCALEBASEQUANTITY,
CONDITIONSCALEBASISCURRENCY,
CONDITIONSCALEBASISUNIT,
CONDITIONSCALEBASISVALUE,
CONDITIONSEQUENTIALNUMBER,
CONDITIONTYPE,
FACTORFORCONDITIONBASISVALUE,
ISGROUPCONDITION,
ISRELEVANTFORACCRUAL,
PERIODFACTORFORCNDNBASISVALUE,
PRCGPROCEDURECOUNTERFORHEADER,
PRICECONDITIONDETERMINATIONDTE,
PRICINGDATETIME,
PRICINGSCALEBASIS,
PRICINGSCALETYPE,
STRUCTURECONDITION,
TAXCODE,
TRANSACTIONCURRENCY,
VARIANTCONDITION,
WITHHOLDINGTAXCODE,
PRIMARY KEY (BILLINGDOCUMENT, PRICINGPROCEDURECOUNTER, PRICINGPROCEDURESTEP)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA